Gridview 复杂表头 合并的实现

要是实现 下列类型的 表头

开始的时候根据http://www.cnblogs.com/myjece/archive/2009/03/06/1404681.html 写法如下

 

int layerCount = 0;//层数 TableCell[] oldCells; if (e.Row.RowType == DataControlRowType.Header) { oldCells = new TableCell[e.Row.Cells.Count]; e.Row.Cells.CopyTo(oldCells, 0); //获取最大层数 for (int i = 0; i < e.Row.Cells.Count; i++) { int t = oldCells[i].Text.Split('|').Length; if (t > layerCount) { layerCount = t; } } e.Row.Cells.Clear(); TableHeaderCell tc = null; int flag = 0; //处理行 for (int i = 1; i <= layerCount; i++) { for (int j = 1; j <= oldCells.Length; j++) { string[] arr = oldCells[j - 1].Text.Split('|'); if (arr.Length == i) { tc = new TableHeaderCell(); if (layerCount - i > 0) { tc.RowSpan = layerCount - i + 1;//定义表头的所占的行数 } tc.Text = arr[i - 1]; tc.CssClass = _gv.HeaderStyle.CssClass; e.Row.Cells.Add(tc); } else if (arr.Length > i) { flag++; if (j >= oldCells.Length || oldCells[j].Text.Split('|').Length < i || arr[i - 1] != oldCells[j].Text.Split('|')[i - 1]) { tc = new TableHeaderCell(); tc.ColumnSpan = flag; tc.Text = arr[i - 1]; tc.CssClass = _gv.HeaderStyle.CssClass; e.Row.Cells.Add(tc); flag = 0; } } } if (i < layerCount) { if (tc != null) { tc.Text += "</tr><tr>"; } } } }

uclBB1.GridViewHeadText ="项目分区,项目分区,井数(口),好油层|层段数,好油层|调整前|日配注(m³/d),好油层|调整前|注水强度(m³/d.m),好油层|调整后|日配注(m³/d),好油层|调整后|注水强度(m³/d.m),差油层|层段数,差油层|调整前|日配注(m³/d),差油层|调整前|注水强度(m³/d.m),差油层|调整后|日配注(m³/d),差油层|调整后|注水强度(m³/d.m),合计|层段数,合计|调整前|日配注(m³/d),合计|调整前|注水强度(m³/d.m),合计|调整后|日配注(m³/d),合计|调整后|注水强度(m³/d.m)";

但是单独列跨两行 没有实现。如项目分类 列。

所以改进了一下

#region 合并表头 protected void gvUser_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) {int layerCount = 0;//层数 ArrayList oldCells = new ArrayList(); try { int iCellCount = e.Row.Cells.Count;//列数 foreach (TableCell oldtc in e.Row.Cells ) { oldCells.Add(oldtc); } for (int k = 0; k < iCellCount; k++)//将gvHeadText中的列名付给oldcells { ((TableCell)oldCells[k]).Text = ((string)ViewState["GridviewHeadText"]).Split(',')[k].ToString(); } //获取最大层数 for (int i = 0; i < iCellCount; i++) { int t = ((TableCell)oldCells[i]).Text.Split('|').Length; if (t > layerCount) { layerCount = t; } } e.Row.Cells.Clear(); TableHeaderCell tc = null; int flag = 0; int flag1 = 1; //处理行 for (int i = 1; i <= layerCount; i++) { for (int j = 1; j <= oldCells.Count; j++) { string[] arr = ((TableCell)oldCells[j - 1]).Text.Split('|'); if (arr.Length == i) { tc = new TableHeaderCell(); if (layerCount - i > 0) { tc.RowSpan = layerCount - i + 1;//定义表头的所占的行数 } tc.Text = arr[i - 1]; tc.CssClass = gvUser.HeaderStyle.CssClass; if(j!=oldCells.Count) { for (int k = j+1 ; k < oldCells.Count; k++) { if (((TableCell)oldCells[j - 1]).Text == ((TableCell)oldCells[k - 1]).Text) { flag1++; oldCells.RemoveAt(k-1); tc.ColumnSpan = flag1; } } flag1 = 1; } e.Row.Cells.Add(tc); } else if (arr.Length > i) { flag++; if (j >= oldCells.Count || ((TableCell)oldCells[j]).Text.Split('|').Length < i || arr[i - 1] != ((TableCell)oldCells[j]).Text.Split('|')[i - 1]) { tc = new TableHeaderCell(); tc.ColumnSpan = flag; tc.Text = arr[i - 1]; tc.CssClass = gvUser.HeaderStyle.CssClass; e.Row.Cells.Add(tc); flag = 0; } } } if (i < layerCount) { if (tc != null) { tc.Text += "</tr><tr>"; } } } } catch (System.Exception ex) { Response.Write(e.ToString() + "：CY7BB_gvuer_RowCreat函数出错"); } } } #endregion

就是将gridbiewheader 数据源中重复的删除。

最终效果如下；

bug 重复列必须相邻 否则可能会出错。因为在判断重复那块没有严密处理。

 

综合调整方案注水结构变化表项目分区项目分区井数(口)好油层差油层合计层段数调整前调整后层段数调整前调整后层段数调整前调整后日配注(m3/d)注水强度(m3/d.m)日配注(m3/d)注水强度(m3/d.m)日配注(m3/d)注水强度(m3/d.m)日配注(m3/d)注水强度(m3/d.m)日配注(m3/d)注水强度(m3/d.m)日配注(m3/d)注水强度(m3/d.m)葡北一断块基础井43679103.459203.559211304.111304.14617753.8917753.93一次井15284804.114603.94244106.374106.37168904.918704.8二次井36402.16552.971120510.321510.842456.382707.03老井6110114303.5814353.6412717454.8517554.886629104.329154.34合计6611015503.6815553.7413818804.8818804.887331404.3631354.38葡北二断块基础井7611412752.6812752.6811411353.6311953.827521203.2321803.33一次井7112817753.1118503.215820955.4920455.286832854.2333004.18二次井8151804.091804.09141756.61756.683555.043555.04老井15525732302.9633053.0128634054.7234154.715157603.8358353.85合计16327233652.9534703.0231737054.737504.7316661953.8263353.88葡北三断块基础井5510717053.6317103.651332010520104.986134204.5534254.55一次井8517725703.926153.9718532007.7332657.898957205.5558005.63二次井20414602.665253498556.748757.072413154.3814004.69老井16032547353.6448503.7236760656.4461506.53174104555.02106255.11合计16433248153.6249303.7138162956.3363656.41180107654.98109205.05