先看效果图:
以上列表中运用的都是基本的东东:
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