GridView和DataGrid相同列合并

(一)普通列

    /// <summary>
    /// Gridview列的合并(普通列,不包含模板列)
    /// 注意:1.GridView在绑定的时候进行分组和排序,才能让相同的行放在一起
    ///       2.方法应用的时机,应该在Gridview的DataBound事件中使用
    /// </summary>
    /// <param name="gv">需要合并的GridView对象</param>
    /// <param name="columnIndex">所要合并列的索引</param>
    public static void UnitCell(GridView gv, int columnIndex)
    {
        int i = 0;                  //当前行数
        string lastType = string.Empty;        //当前判断是否合并行对应列的值
        int lastCell = 0;           //判断最后一个相同值的行的索引
        if (gv.Rows.Count > 0)
        {
            lastType = gv.Rows[0].Cells[columnIndex].Text.ToString();
            gv.Rows[0].Cells[columnIndex].RowSpan = 1;
            lastCell = 0;
        }
        for (i = 1; i < gv.Rows.Count; i++)
        {
            if (gv.Rows[i].Cells[columnIndex].Text == lastType)
            {
                gv.Rows[i].Cells[columnIndex].Visible = false;
                gv.Rows[lastCell].Cells[columnIndex].RowSpan++;
            }
            else
            {
                lastType = gv.Rows[i].Cells[columnIndex].Text.ToString();
                lastCell = i;
                gv.Rows[i].Cells[columnIndex].RowSpan = 1;
            }
        }
    }


    /// <summary>
    /// DataGrid列的合并(普通列,不包含模板列)
    /// 注意:1.DataGrid在绑定的时候进行分组和排序,才能让相同的行放在一起
    ///       2.方法应用的时机,应该在DataGrid的DataBound事件中使用
    /// </summary>
    /// <param name="dg">需要合并的DataGrid对象</param>
    /// <param name="columnIndex">所要合并列的索引</param>
    public static void UnitCell_T(DataGrid dg, int columnIndex)
    {
        int i = 0;                  //当前行数
        string lastType = string.Empty;        //当前判断是否合并行对应列的值
        int lastCell = 0;           //判断最后一个相同值的行的索引
        if (dg.Items.Count> 0)
        {
            lastType = dg.Items[0].Cells[columnIndex].Text.ToString();
            dg.Items[0].Cells[columnIndex].RowSpan = 1;
            lastCell = 0;
        }
        for (i = 1; i < dg.Items.Count; i++)
        {
            if (dg.Items[i].Cells[columnIndex].Text == lastType)
            {
                dg.Items[i].Cells[columnIndex].Visible = false;
                dg.Items[lastCell].Cells[columnIndex].RowSpan++;
            }
            else
            {
                lastType = dg.Items[i].Cells[columnIndex].Text.ToString();
                lastCell = i;
                dg.Items[i].Cells[columnIndex].RowSpan = 1;
            }
        }
    }

(二)模板列

 /// <summary>
    /// Gridview列的合并(模板列)
    /// </summary>
    /// <param name="gv">需要合并的GridView对象</param>
    /// <param name="columnIndex">所要合并列的索引</param>
    /// <param name="lblName">模板列对象的ID</param>
    public static void UnitCell(GridView gv, int columnIndex, string lblName)
    {
        int i = 0;                  //当前行数
        string lastType = string.Empty;        //当前判断是否合并行对应列的值
        int lastCell = 0;           //判断最后一个相同值的行的索引
        if (gv.Rows.Count > 0)
        {
            lastType = (gv.Rows[0].Cells[columnIndex].FindControl(lblName) as Label).Text;
            gv.Rows[0].Cells[columnIndex].RowSpan = 1;
            lastCell = 0;
        }
        for (i = 1; i < gv.Rows.Count; i++)
        {
            if ((gv.Rows[i].Cells[columnIndex].FindControl(lblName) as Label).Text == lastType)
            {
                gv.Rows[i].Cells[columnIndex].Visible = false;
                gv.Rows[lastCell].Cells[columnIndex].RowSpan++;
            }
            else
            {
                lastType = (gv.Rows[i].Cells[columnIndex].FindControl(lblName) as Label).Text.ToString();
                lastCell = i;
                gv.Rows[i].Cells[columnIndex].RowSpan = 1;
            }
        }
    }

(三)在DataBound事件中调用即可。

posted @ 2012-10-17 15:58  爱智旮旯  阅读(1387)  评论(0编辑  收藏  举报