GridView 合并列、行

/*******************  华丽的分隔线 *******************/
        /// 根据列字段合并GridView
        ///  GridView合并行
        /// Grid控件 
        /// 列索引 
        public  void GroupRows(GridView p_GridView,int fixedCol, int[] p_ColumnsIndex)
        {
            int _Count = p_GridView.Rows.Count;
            string[] _TempText = new string[p_ColumnsIndex.Length];
            int[] _RowIndex = new int[p_ColumnsIndex.Length];
            
            for (int i = 0; i != _Count; i++)
            {
                string _CellText = p_GridView.Rows[i].Cells[fixedCol].Text;
                for (int z = 0; z != p_ColumnsIndex.Length; z++)               
                {                   
                    
                    if (_TempText[z] == _CellText)
                    {
                        p_GridView.Rows[i].Cells[p_ColumnsIndex[z]].Visible = false;
                        p_GridView.Rows[_RowIndex[z]].Cells[p_ColumnsIndex[z]].RowSpan++;
                    }
                    else
                    {                        
                        _RowIndex[z] = i;
                        _TempText[z] = _CellText;
                        p_GridView.Rows[_RowIndex[z]].Cells[p_ColumnsIndex[z]].RowSpan = 1;
                        
                    }
                }                

            }
        } 
        //调用
        GroupRows(gvwSHList,1, new int[] { 0, 2, 3,4,5,6,7,11,12,13 }); 

/*******************  华丽的分隔线 *******************/
 
         /// GridView合并行 
        /// 
        /// Grid控件 
        /// 列索引 
        public static void GroupRows(GridView p_GridView, int[] p_ColumnsIndex)
        {
            int _Count = p_GridView.Rows.Count;
            string[] _TempText = new string[p_ColumnsIndex.Length];
            int[] _RowIndex = new int[p_ColumnsIndex.Length];
            for (int i = 0; i != _Count; i++)
            {
                string _CellText = "";
                for (int z = 0; z != p_ColumnsIndex.Length; z++)
                {
                    _CellText += p_GridView.Rows[i].Cells[p_ColumnsIndex[z]].Text;
                    if (_TempText[z] == _CellText)
                    {
                        p_GridView.Rows[i].Cells[p_ColumnsIndex[z]].Visible = false;
                        p_GridView.Rows[_RowIndex[z]].Cells[p_ColumnsIndex[z]].RowSpan++;
                    }
                    else
                    {
                        _RowIndex[z] = i;
                        _TempText[z] = _CellText;
                        p_GridView.Rows[_RowIndex[z]].Cells[p_ColumnsIndex[z]].RowSpan = 1;
                    }
                }

            }
        }
        //调用 
        GroupRows(gv_GridData, new int[] { 0,1,2 });
 

/*******************  华丽的分隔线 *******************/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Web.UI.WebControls;

/// <summary>
///GridViewMergeCell 合并GridView liyang 20090916
/// </summary>
public class GridViewMergeCell
{
    public GridViewMergeCell()
    {
        //
        //TODO: 在此处添加构造函数逻辑
        //
    }
    #region 合并单元格 合并某一行的所有列
    public static void GroupRow(GridView gridView)
    {
        for (int rowIndex = gridView.Rows.Count - 2; rowIndex >= 0; rowIndex--)
        {
            GridViewRow row = gridView.Rows[rowIndex];
            GridViewRow previousRow = gridView.Rows[rowIndex + 1];

            for (int i = 0; i < row.Cells.Count; i++)
            {
                if (row.Cells[i].Text == previousRow.Cells[i].Text)
                {
                    row.Cells[i].RowSpan = previousRow.Cells[i].RowSpan < 2 ? 2 :
                                           previousRow.Cells[i].RowSpan + 1;
                    previousRow.Cells[i].Visible = false;
                }
            }
        }
    }
    ///　 <summary>　
    ///　 合并GridView中某行相同信息的行（单元格）
    ///　 </summary>　
    ///　 <param　 name="GridView1">GridView对象</param>　
    ///　 <param　 name="cellNum">需要合并的行</param>
    public static void GroupRow(GridView gridView, int rows)
    {
        TableCell oldTc = gridView.Rows[rows].Cells[0];
        for (int i = 1; i < gridView.Rows[rows].Cells.Count; i++)
        {
            TableCell tc = gridView.Rows[rows].Cells[i];　 //Cells[0]就是你要合并的列
            if (oldTc.Text == tc.Text)
            {
                tc.Visible = false;
                if (oldTc.ColumnSpan == 0)
                {
                    oldTc.ColumnSpan = 1;
                }
                oldTc.ColumnSpan++;
                oldTc.VerticalAlign = VerticalAlign.Middle;
            }
            else
            {
                oldTc = tc;
            }
        }
    }
    #endregion
    #region 合并单元格 合并一行中的几列
    /// <summary>
    /// 合并单元格 合并一行中的几列
    /// </summary>
    /// <param name="GridView1">GridView ID</param>
    /// <param name="rows">行</param>
    /// <param name="sCol">开始列</param>
    /// <param name="eCol">结束列</param>
    public static void GroupRow(GridView gridView, int rows, int sCol, int eCol)
    {
        TableCell oldTc = gridView.Rows[rows].Cells[sCol];
        for (int i = 1; i < eCol - sCol; i++)
        {
            TableCell tc = gridView.Rows[rows].Cells[i + sCol];　 //Cells[0]就是你要合并的列
            tc.Visible = false;
            if (oldTc.ColumnSpan == 0)
            {
                oldTc.ColumnSpan = 1;
            }
            oldTc.ColumnSpan++;
            oldTc.VerticalAlign = VerticalAlign.Middle;
        }
    }
    #endregion
    #region 合并单元格 合并某一列所有行
    /// <summary>
    /// 合并GridView中某列相同信息的行（单元格）
    /// </summary>
    /// <param name="GridView1"></param>
    /// <param name="cellNum"></param>
    public static void GroupCol(GridView gridView, int cols)
    {
        if (gridView.Rows.Count < 1 || cols > gridView.Rows[0].Cells.Count - 1)
        {
            return;
        }
        TableCell oldTc = gridView.Rows[0].Cells[cols];
        for (int i = 1; i < gridView.Rows.Count; i++)
        {
            TableCell tc = gridView.Rows[i].Cells[cols];
            if (oldTc.Text == tc.Text)
            {
                tc.Visible = false;
                if (oldTc.RowSpan == 0)
                {
                    oldTc.RowSpan = 1;
                }
                oldTc.RowSpan++;
                oldTc.VerticalAlign = VerticalAlign.Middle;
            }
            else
            {
                oldTc = tc;
            }
        }
    }
    #endregion
    #region 合并单元格 合并某一列中的某些行
    /// <summary>
    /// 合并单元格 合并某一列中的某些行
    /// </summary>
    /// <param name="GridView1">GridView ID</param>
    /// <param name="cellNum">列</param>
    /// <param name="sRow">开始行</param>
    /// <param name="eRow">结束列</param>
    public static void GroupCol(GridView gridView, int cols, int sRow, int eRow)
    {
        if (gridView.Rows.Count < 1 || cols > gridView.Columns.Count - 1)
        {
            return;
        }
        TableCell oldTc = gridView.Rows[sRow].Cells[cols];
        for (int i = 1; i < eRow - sRow; i++)
        {
            TableCell tc = gridView.Rows[sRow + i].Cells[cols];
            tc.Visible = false;
            if (oldTc.RowSpan == 0)
            {
                oldTc.RowSpan = 1;
            }
            oldTc.RowSpan++;
            oldTc.VerticalAlign = VerticalAlign.Middle;
        }
    }
    #endregion
}

 

转载于:https://www.cnblogs.com/linyongqin/articles/3778195.html