先看效果图:
以上列表中运用的都是基本的东东:
1.多表头;
2.按值改变行颜色;
3.分页码
代码:
// File: GridViewHepler.cs // Description: 动态生成复合表头帮助类 // 相邻父列头之间用'#'分隔,父列头与子列头用空格(' ')分隔,相邻子列头用逗号分隔(',') // 两行:序号#分公司#组别#本日成功签约单数 预警,续约,流失,合计#累计成功签约单数 预警,续约,流失,合计#任务数#完成比例#排名 // 三行:等级#级别#上期结存 件数,重量,比例#本期调入 收购调入 件数,重量,比例#本期发出 车间投料 件数,重量,比例#本期发出 产品外销百分比 件数,重量,比例#平均值 // 三行时请注意:列头要重复 using System; using System.Collections.Generic; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.IO; using System.Data; namespace scsoft.Common { /// <summary> /// 动态生成复合表头帮助类 /// </summary> public class GridViewHeader { /// <summary> /// 动态生成复合表头帮助类 /// </summary> public GridViewHeader() { // // TODO: Add constructor logic here // } /**/ /// <summary> /// 重写表头,最多显示三行 /// 相邻父列头之间用'#'分隔,父列头与子列头用空格(' ')分隔,相邻子列头用逗号分隔(',') /// 三行时请注意:列头要重复 /// </summary> /// <param name="targetHeader">目标表头</param> /// <param name="newHeaderNames">新表头</param> /// <remarks> /// </remarks> public static void SplitTableHeader(GridViewRow targetHeader, string newHeaderNames) { TableCellCollection tcl = targetHeader.Cells;//获得表头元素的实例 tcl.Clear();//清除元素 int row = GetRowCount(newHeaderNames); int col = GetColCount(newHeaderNames); string[,] nameList = ConvertList(newHeaderNames, row, col); int RowSpan = 0; int ColSpan = 0; for (int k = 0; k < row; k++) { string LastFName = ""; for (int i = 0; i < col; i++) { if (LastFName == nameList[i, k] && k != row - 1) { LastFName = nameList[i, k]; continue; } else { LastFName = nameList[i, k]; } int bFlag = IsVisible(nameList, k, i, LastFName); switch (bFlag) { case 0: break; case 1: RowSpan = GetSpanRowCount(nameList, row, k, i); ColSpan = GetSpanColCount(nameList, row, col, k, i); tcl.Add(new TableHeaderCell());//添加表头控件 tcl[tcl.Count - 1].RowSpan = RowSpan; tcl[tcl.Count - 1].ColumnSpan = ColSpan; tcl[tcl.Count - 1].HorizontalAlign = HorizontalAlign.Center; tcl[tcl.Count - 1].Text = LastFName; break; case -1: string[] EndColName = LastFName.Split(new char[] { ',' }); foreach (string eName in EndColName) { tcl.Add(new TableHeaderCell());//添加表头控件 tcl[tcl.Count - 1].HorizontalAlign = HorizontalAlign.Center; tcl[tcl.Count - 1].Text = eName; } break; } } if (k != row - 1) {//不是起始行,加入新行标签 if (targetHeader.CssClass != "") tcl[tcl.Count - 1].Text = tcl[tcl.Count - 1].Text + "</td></tr><tr class=\"" + targetHeader.CssClass + "\"> <th style=\"display:none; \"> "; else tcl[tcl.Count - 1].Text = tcl[tcl.Count - 1].Text + "</td></tr><tr>"; } } } /**/ /// <summary> /// 如果上一行已经输出和当前内容相同的列头,则不显示 /// </summary> /// <param name="ColumnList">表头集合</param> /// <param name="rowIndex">行索引</param> /// <param name="colIndex">列索引</param> /// <returns>1:显示,-1:含','分隔符,0:不显示</returns> private static int IsVisible(string[,] ColumnList, int rowIndex, int colIndex, string CurrName) { if (rowIndex != 0) { if (ColumnList[colIndex, rowIndex - 1] == CurrName) { return 0; } else { if (ColumnList[colIndex, rowIndex].Contains(",")) { return -1; } else { return 1; } } } return 1; } /**/ /// <summary> /// 取得和当前索引行及列对应的下级的内容所跨的行数 /// </summary> /// <param name="ColumnList">表头集合</param> /// <param name="row">行数</param> /// <param name="rowIndex">行索引</param> /// <param name="colIndex">列索引</param> /// <returns>行数</returns> private static int GetSpanRowCount(string[,] ColumnList, int row, int rowIndex, int colIndex) { string LastName = ""; int RowSpan = 1; for (int k = rowIndex; k < row; k++) { if (ColumnList[colIndex, k] == LastName) { RowSpan++; } else { LastName = ColumnList[colIndex, k]; } } return RowSpan; } /// <summary> /// 取得和当前索引行及列对应的下级的内容所跨的列数 /// </summary> /// <param name="ColumnList">表头集合</param> /// <param name="row">行数</param> /// <param name="col">列数</param> /// <param name="rowIndex">行索引</param> /// <param name="colIndex">列索引</param> /// <returns>列数</returns> private static int GetSpanColCount(string[,] ColumnList, int row, int col, int rowIndex, int colIndex) { string LastName = ColumnList[colIndex, rowIndex]; int ColSpan = ColumnList[colIndex, row - 1].Split(new char[] { ',' }).Length; ColSpan = ColSpan == 1 ? 0 : ColSpan; for (int i = colIndex + 1; i < col; i++) { if (ColumnList[i, rowIndex] == LastName) { ColSpan += ColumnList[i, row - 1].Split(new char[] { ',' }).Length; } else { LastName = ColumnList[i, rowIndex]; break; } } return ColSpan; } /**/ /// <summary> /// 将已定义的表头保存到数组 /// </summary> /// <param name="newHeaders">新表头</param> /// <param name="row">行数</param> /// <param name="col">列数</param> /// <returns>表头数组</returns> private static string[,] ConvertList(string newHeaders, int row, int col) { // 用@分割 string[] ColumnNames = newHeaders.Split(new char[] { '@' }); if (ColumnNames.Length <= 1) ColumnNames = newHeaders.Split(new char[] { '#' }); string[,] news = new string[col, row]; string Name = ""; for (int i = 0; i < col; i++) { string[] CurrColNames = ColumnNames[i].ToString().Split(new char[] { ' ' }); for (int k = 0; k < row; k++) { if (CurrColNames.Length - 1 >= k) { if (CurrColNames[k].Contains(",")) { if (CurrColNames.Length != row) { if (Name == "") { news[i, k] = news[i, k - 1]; Name = CurrColNames[k].ToString(); } else { news[i, k + 1] = Name; Name = ""; } } else { news[i, k] = CurrColNames[k].ToString(); } } else { news[i, k] = CurrColNames[k].ToString(); } } else { if (Name == "") { news[i, k] = news[i, k - 1]; } else { news[i, k] = Name; Name = ""; } } } } return news; } /**/ /// <summary> /// 取得复合表头的行数 /// </summary> /// <param name="newHeaders">新表头</param> /// <returns>行数</returns> private static int GetRowCount(string newHeaders) { // 用@分割 string[] ColumnNames = newHeaders.Split(new char[] { '@' }); int Count = 0; if (ColumnNames.Length <=1) ColumnNames = newHeaders.Split(new char[] { '#' }); foreach (string name in ColumnNames) { int TempCount = name.Split(new char[] { ' ' }).Length; if (TempCount > Count) Count = TempCount; } return Count; } /**/ /// <summary> /// 取得复合表头的列数 /// </summary> /// <param name="newHeaders">新表头</param> /// <returns>列数</returns> private static int GetColCount(string newHeaders) { // 用@分割 string[] ColumnNames = newHeaders.Split(new char[] { '@' }); if (ColumnNames.Length <= 1) ColumnNames = newHeaders.Split(new char[] { '#' }); return ColumnNames.Length; } } }
运用时代码如下:
if (e.Row.RowType == DataControlRowType.Header)
{
SQLServerDAL.AndyGridViewTHeaderHepler dHelper = new SQLServerDAL.AndyGridViewTHeaderHepler();
string header = "序号#分公司#组别#本日成功签约单数 预警,续约,流失,合计#累计成功签约单数 预警,续约,流失,合计#任务数#完成比例#排名";
//---------------------------------------------------------------------------------------
// Andy Lu 19:21 2008/10/6 **电信社区宽带揽装业务发展竞赛龙虎榜
// 加载 gridview Header 的样式
//---------------------------------------------------------------------------------------
e.Row.CssClass = GridView1.HeaderStyle.CssClass;
dHelper.SplitTableHeader(e.Row, header);
}
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/mengyao/archive/2008/11/06/3241893.aspx