18
2012
10

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事件中调用即可。

« 上一篇下一篇 »

评论列表:

1.匹克篮球鞋  2012/10/19 17:58:44 回复该留言
看着代码有点晕
2.寮步婚纱摄影  2012/11/19 22:11:13 回复该留言
嘻嘻,正常嘛
3.顺丰  2012/11/23 19:34:54 回复该留言
Thanks for the share! Very useful info!

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。