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.              }