GridView多表头类

 

http://blog.csdn.net/mengyao/

Code


 

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

1.多表头；

2.按值改变行颜色；

3.分页码

 

代码：

AndyGridViewTHeaderHepler.cs

//----------------------------------------------------------------------------------- 
// 
//  Created: 23:07 2008/9/28    Author:  Andy Lu 
//  File: AndyGridViewTHeaderHepler.cs 
//  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; 

namespace SQLServerDAL 
{ 
    public class AndyGridViewTHeaderHepler 
    { 
        public AndyGridViewTHeaderHepler() 
        { 
            // 
            // 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 class="+targetHeader.CssClass+">"; 
                } 
            } 
        } 
        /**//// <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; 
        } 
        
    } 
}
 

运用时代码如下：

 

            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); 


             }

转载于:https://www.cnblogs.com/jianlinglo/archive/2009/05/15/1457513.html