GridView多表头类

好多天没有怎么更新博客了，有点不好意思。先上图：

以上列表中运用的都是基本的东东：

1.多表头；

2.按值改变行颜色；

3.分页码

代码：

AndyGridViewTHeaderHepler.cs

1. //-----------------------------------------------------------------------------------
2. //
3. //  Created: 23:07 2008/9/28    Author:  Andy Lu
4. //  File: AndyGridViewTHeaderHepler.cs
5. //  Description: 动态生成复合表头帮助类
6. //  相邻父列头之间用'#'分隔,父列头与子列头用空格(' ')分隔,相邻子列头用逗号分隔(',').
7. //  两行：序号#分公司#组别#本日成功签约单数 预警,续约,流失,合计#累计成功签约单数 预警,续约,流失,合计#任务数#完成比例#排名
8. //  三行：等级#级别#上期结存 件数,重量,比例#本期调入 收购调入 件数,重量,比例#本期发出 车间投料 件数,重量,比例#本期发出 产品外销百分比 件数,重量,比例#平均值
9. //  三行时请注意：列头要重复
10. //
11. //-----------------------------------------------------------------------------------
12. using System;
13. using System.Data;
14. using System.Configuration;
15. using System.Web;
16. using System.Web.Security;
17. using System.Web.UI;
18. using System.Web.UI.WebControls;
19. using System.Web.UI.WebControls.WebParts;
20. using System.Web.UI.HtmlControls;
21. using System.Collections.Generic;
22. using System.Collections;
23. namespace SQLServerDAL
24. {
25.     public class AndyGridViewTHeaderHepler
26.     {
27.         public AndyGridViewTHeaderHepler()
28.         {
29.             //
30.             // TODO: Add constructor logic here
31.             //
32.         }
33.         /// <summary>
34.         /// 重写表头
35.         /// </summary>
36.         /// <param name="targetHeader">目标表头</param>
37.         /// <param name="newHeaderNames">新表头</param>
38.         /// <remarks>
39.         /// </remarks>
40.         public void SplitTableHeader(GridViewRow targetHeader, string newHeaderNames)
41.         {
42.             TableCellCollection tcl = targetHeader.Cells;//获得表头元素的实例
43.             tcl.Clear();//清除元素
44.             int row = GetRowCount(newHeaderNames);
45.             int col = GetColCount(newHeaderNames);
46.             string[,] nameList = ConvertList(newHeaderNames,row,col);
47.             int RowSpan = 0;
48.             int ColSpan = 0;
49.             for (int k = 0; k < row; k++)
50.             {
51.                 string LastFName = "";
52.                 for (int i = 0; i < col; i++)
53.                 {
54.                     if (LastFName == nameList[i, k] && k!=row-1)
55.                     {
56.                         LastFName = nameList[i, k];
57.                         continue;
58.                     }
59.                     else
60.                     {
61.                         LastFName = nameList[i, k];
62.                     }
63.                     int bFlag=IsVisible(nameList, k, i, LastFName);
64.                     switch (bFlag)
65.                     {
66.                         case 0:
67.                             break;
68.                         case 1:
69.                             RowSpan = GetSpanRowCount(nameList,row, k, i);
70.                             ColSpan = GetSpanColCount(nameList,row,col, k, i);
71.                             tcl.Add(new TableHeaderCell());//添加表头控件
72.                             tcl[tcl.Count - 1].RowSpan = RowSpan;
73.                             tcl[tcl.Count - 1].ColumnSpan = ColSpan;
74.                             tcl[tcl.Count - 1].HorizontalAlign = HorizontalAlign.Center;
75.                             tcl[tcl.Count - 1].Text = LastFName;
76.                             break;
77.                         case -1:
78.                             string[] EndColName = LastFName.Split(new char[] { ',' });
79.                             foreach(string eName in EndColName){
80.                                 tcl.Add(new TableHeaderCell());//添加表头控件
81.                                 tcl[tcl.Count - 1].HorizontalAlign = HorizontalAlign.Center;
82.                                 tcl[tcl.Count - 1].Text = eName;
83.                             }
84.                             break;
85.                     }
86.                 }
87.                 if (k != row-1)
88.                 {//不是起始行,加入新行标签
89.                     tcl[tcl.Count - 1].Text = tcl[tcl.Count - 1].Text+"</th></tr><tr class="+targetHeader.CssClass+">";
90.                 }
91.             }
92.         }
93.         /// <summary>
94.         /// 如果上一行已经输出和当前内容相同的列头，则不显示
95.         /// </summary>
96.         /// <param name="ColumnList">表头集合</param>
97.         /// <param name="rowIndex">行索引</param>
98.         /// <param name="colIndex">列索引</param>
99.         /// <returns>1:显示,-1:含','分隔符,0:不显示</returns>
100.         private int IsVisible(string[,] ColumnList,int rowIndex, int colIndex,string CurrName)
101.         {
102.             if (rowIndex!=0){
103.                 if (ColumnList[colIndex,rowIndex-1]==CurrName){
104.                     return 0;
105.                 }else{
106.                     if (ColumnList[colIndex, rowIndex].Contains(","))
107.                     {
108.                         return -1;
109.                     }else{
110.                         return 1;
111.                     }
112.                 }
113.             }
114.             return 1;
115.         }
116.         /// <summary>
117.         /// 取得和当前索引行及列对应的下级的内容所跨的行数
118.         /// </summary>
119.         /// <param name="ColumnList">表头集合</param>
120.         /// <param name="row">行数</param>
121.         /// <param name="rowIndex">行索引</param>
122.         /// <param name="colIndex">列索引</param>
123.         /// <returns>行数</returns>
124.         private int GetSpanRowCount(string[,] ColumnList, int row,int rowIndex, int colIndex)
125.         {
126.             string LastName = "";
127.             int RowSpan = 1;
128.             for (int k = rowIndex; k < row; k++)
129.             {
130.                 if (ColumnList[colIndex,k]==LastName){
131.                     RowSpan++;
132.                 }else{
133.                     LastName = ColumnList[colIndex, k];
134.                 }
135.             }
136.             return RowSpan;
137.         }
138.         /// <summary>
139.         /// 取得和当前索引行及列对应的下级的内容所跨的列数
140.         /// </summary>
141.         /// <param name="ColumnList">表头集合</param>
142.         /// <param name="row">行数</param>
143.         /// <param name="col">列数</param>
144.         /// <param name="rowIndex">行索引</param>
145.         /// <param name="colIndex">列索引</param>
146.         /// <returns>列数</returns>
147.         private int GetSpanColCount(string[,] ColumnList,int row, int col,int rowIndex, int colIndex)
148.         {
149.             string LastName = ColumnList[colIndex, rowIndex] ;
150.             int ColSpan = ColumnList[colIndex, row-1].Split(new char[] { ',' }).Length;
151.             ColSpan = ColSpan == 1 ? 0 : ColSpan;
152.             for(int i=colIndex+1;i<col;i++)
153.             {
154.                 if (ColumnList[i, rowIndex] == LastName)
155.                 {
156.                     ColSpan += ColumnList[i, row - 1].Split(new char[] { ',' }).Length;
157.                 }
158.                 else
159.                 {
160.                     LastName = ColumnList[i, rowIndex];
161.                     break;
162.                 }
163.             }
164.             return ColSpan;
165.         }
166.         /// <summary>
167.         /// 将已定义的表头保存到数组
168.         /// </summary>
169.         /// <param name="newHeaders">新表头</param>
170.         /// <param name="row">行数</param>
171.         /// <param name="col">列数</param>
172.         /// <returns>表头数组</returns>
173.         private string[,] ConvertList(string newHeaders, int row, int col)
174.         {
175.             string[] ColumnNames = newHeaders.Split(new char[] {'#'});
176.             string[,] news = new string[col, row];
177.             string Name = "";
178.             for (int i = 0; i < col; i++)
179.             {
180.                 string[] CurrColNames = ColumnNames[i].ToString().Split(new char[] { ' ' });
181.                 for (int k = 0; k < row; k++)
182.                 {
183.                     if (CurrColNames.Length - 1 >= k)
184.                     {
185.                         if (CurrColNames[k].Contains(","))
186.                         {
187.                             if (CurrColNames.Length != row)
188.                             {
189.                                 if (Name == "")
190.                                 {
191.                                     news[i, k] = news[i, k - 1];
192.                                     Name = CurrColNames[k].ToString();
193.                                 }
194.                                 else
195.                                 {
196.                                     news[i, k + 1] = Name;
197.                                     Name = "";
198.                                 }
199.                             }else{
200.                                 news[i, k] = CurrColNames[k].ToString();
201.                             }
202.                         }else{
203.                             news[i, k] = CurrColNames[k].ToString();
204.                         }
205.                     }else{
206.                         if (Name == "")
207.                         {
208.                             news[i, k] = news[i, k - 1];
209.                         }else{
210.                             news[i, k] = Name;
211.                             Name = "";
212.                         }
213.                     }
214.                 }
215.             }
216.             return news;
217.         }
218.         /// <summary>
219.         /// 取得复合表头的行数
220.         /// </summary>
221.         /// <param name="newHeaders">新表头</param>
222.         /// <returns>行数</returns>
223.         private int GetRowCount(string newHeaders)
224.         {
225.             string[] ColumnNames = newHeaders.Split(new char[] { '#' });
226.             int Count = 0;
227.             foreach(string name in ColumnNames){
228.                 int TempCount = name.Split(new char[] { ' ' }).Length;
229.                 if (TempCount > Count)
230.                     Count = TempCount;
231.             }
232.             return Count;
233.         }
234.         /// <summary>
235.         /// 取得复合表头的列数
236.         /// </summary>
237.         /// <param name="newHeaders">新表头</param>
238.         /// <returns>列数</returns>
239.         private int GetColCount(string newHeaders)
240.         {
241.             return newHeaders.Split(new char[] { '#' }).Length;
242.         }
243.     }
244. }

运用时代码如下：

1.             if (e.Row.RowType == DataControlRowType.Header)
2.             {
3.                 SQLServerDAL.AndyGridViewTHeaderHepler dHelper = new SQLServerDAL.AndyGridViewTHeaderHepler();
4.                 string header = "序号#分公司#组别#本日成功签约单数 预警,续约,流失,合计#累计成功签约单数 预警,续约,流失,合计#任务数#完成比例#排名";
5.                 //---------------------------------------------------------------------------------------
6.                 // Andy Lu 19:21 2008/10/6 **电信社区宽带揽装业务发展竞赛龙虎榜 
7.                 // 加载 gridview Header 的样式
8.                 //---------------------------------------------------------------------------------------
9.                 e.Row.CssClass = GridView1.HeaderStyle.CssClass; 
10.                 dHelper.SplitTableHeader(e.Row, header);
11.              }