使用時在GridView的RowCreated事件中加入下面代碼調用
if (e.Row.RowType == DataControlRowType.Header)
{
DynamicTHeaderHepler dHelper =new DynamicTHeaderHepler();
string header ="等級#級別#上期結存 件數,重量,比例#本期調入 收購調入 件數,重量,比例#本期發出 車間投料 件數,重量,"
+"比例#本期發出 產品外銷百分比 件數,重量,比例#平均值";
dHelper.SplitTableHeader(e.Row, header);
}
類文件如下：
// Description: 動態生成復合表頭幫助類
// 相鄰父列頭之間用'#'分隔,父列頭與子列頭用空格(' ')分隔,相鄰子列頭用逗號分隔(',').
//***********************************************************************
using System; using System.Data; using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Collections;
public class DynamicTHeaderHepler
{
public DynamicTHeaderHepler()
{
// // TODO: Add constructor logic here //
}
/**
//// <summary>
/// 重寫表頭
/// </summary>
/// <param name="targetHeader">目標表頭</param>
/// <param name="newHeaderNames">新表頭</param>
/// <remarks>
/// 等級#級別#上期結存 件數,重量,比例#本期調入 收購調入 件數,重量,比例#本期發出 車間投料 件數,重量,
/// 比例#本期發出 產品外銷百分比 件數,重量,比例#平均值
/// </remarks>
public 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) {//不是起始行,加入新行標簽 tcl[tcl.Count - 1].Text = tcl[tcl.Count - 1].Text+"</th></tr><tr>"; } } }
/**//// <summary> /// 如果上一行已經輸出和當前內容相同的列頭，則不顯示 /// </summary> /// <param name="ColumnList">表頭集合</param> /// <param name="rowIndex">行索引</param> /// <param name="colIndex">列索引</param> /// <returns>1:顯示,-1:含','分隔符,0:不顯示</returns> private 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 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 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 string[,] ConvertList(string newHeaders, int row, int col) { string[] 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 int GetRowCount(string newHeaders) { string[] ColumnNames = newHeaders.Split(new char[] { '#' }); int Count = 0; 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 int GetColCount(string newHeaders) { return newHeaders.Split(new char[] { '#' }).Length; } }
