gridview合并单元格

大家GridView都用的比较多吧..   有没遇到单元格需要合并的需求..

单元格合并原理其实很简单，就是逐行判断要合并的单元格里的值是否和上一行的相同，要是相同的话就合并，不同的话就接着判断

我们可以通过扩展方法为GridView添加单元合并

 

我为GridView 创建了个RowSpan的方法 .   有一个object 参数

为什要定义object 参数 源于ASP.NET MVC 的Routing 组件配置规则 感觉这种方式很不错..

所以使用了这种方式来进行.

 

 

   1 public static class GridViewExtensions
   2      {
   3         /// <summary>
   4         ///   GridView行合并
   5         /// </summary>
   6         /// <param name="gridView"></param>
   7         /// <param name="field">合并参数(匿名类型)
   8         /// ColumnIndex:要合并行的索引 (以0开始,必须指定)
   9         /// ColumnControlID(可选):如果该行为模板行则必须指定
10         /// PropertyName:根据ID属性 默认值为Text
11         /// Colums:(string类型)表示额外的行合并方式和ColumnIndex一样(多个使用逗号隔开,如Colums="5,6,7,8")
12         /// 例:
13         /// 合并第一行(第一行为模板行),绑定的一个Label名称为lblName   根据Text属性值合并   第6行方式和第一行相同
14         /// new {ColumnIndex=0,ColumnControlID="lblName",PropertyName="Text",Columns="5"}
15         /// </param>
16         public static GridView RowSpan(this GridView gridView, object field)
17          {
18              Dictionary<string, string> rowDictionary = ObjectLoadDictionary(field);
19             int columnIndex = int.Parse(rowDictionary["ColumnIndex"]);
20             string columnName = rowDictionary["ColumnControlID"];
21             string propertyName = rowDictionary["PropertyName"];
22             string columns = rowDictionary["Columns"];
23             for (var i = 0; i < gridView.Rows.Count; i++)
24              {
25
26                 int rowSpanCount = 1;
27                 for (int j = i + 1; j < gridView.Rows.Count; j++)
28                  {
29                     //绑定行合并处理
30                     if (string.IsNullOrEmpty(columnName))
31                      {
32                         //比较2行的值是否相同
33                         if (gridView.Rows[i].Cells[columnIndex].Text == gridView.Rows[j].Cells[columnIndex].Text)
34                          {
35                             //合并行的数量+1
36                              rowSpanCount++;
37                             //隐藏相同的行
38                              gridView.Rows[j].Cells[columnIndex].Visible = false;
39                             if (!string.IsNullOrEmpty(columns))
40                              {
41                                  columns.Split(',').ToList<string>().ForEach(c => gridView.Rows[j].Cells[int.Parse(c)].Visible=false);
42                              }
43                          }
44                         else
45                          {
46                             break;
47                          }
48                      }
49                     else
50                      {
51                         //模板行的合并处理
52                         if (GetPropertyValue(gridView.Rows[i].Cells[columnIndex].FindControl(columnName), propertyName).ToString() == GetPropertyValue(gridView.Rows[j].Cells[columnIndex].FindControl(columnName), propertyName).ToString())
53                          {
54                              rowSpanCount++;
55                             //隐藏相同的行
56                              gridView.Rows[j].Cells[columnIndex].Visible = false;
57                             if (!string.IsNullOrEmpty(columns))
58                              {
59                                 
60                                  columns.Split(',').ToList<string>().ForEach(c => gridView.Rows[j].Cells[int.Parse(c)].Visible = false);
61                              }
62                          }
63                         else
64                          {
65                             break;
66                          }
67                      }
68                  }
69                 if (rowSpanCount > 1)
70                  {
71                     //行合并
72                      gridView.Rows[i].Cells[columnIndex].RowSpan = rowSpanCount;
73                     //判断是否有额外的行需要合并
74                     if (!string.IsNullOrEmpty(columns))
75                      {
76                         //额外的行合并
77                          columns.Split(',').ToList<string>().ForEach(c => gridView.Rows[i].Cells[int.Parse(c)].RowSpan = rowSpanCount);
78                      }
79                      i = i + rowSpanCount - 1;
80                  }
81                 
82
83              }
84             return gridView;
85          }