最近在做项目资金统计,需要对GridView的表头进行重新构建,如多行表头,尾行汇总等。先看下展示效果。
这里我们可以在GridView控件的RowCreated事件中对数据行的格式进行处理。
- protected void sgvCapitalDetailList_RowCreated(object sender, GridViewRowEventArgs e)
- {
- if (e.Row.RowType == DataControlRowType.Header)
- {
- RebuildHeader(e.Row.Cells);
- }
- if (e.Row.RowType == DataControlRowType.Footer)
- {
- ReBuildFooter(e.Row.Cells);
- }
- }
- /// <summary>
- /// 重建表尾
- /// </summary>
- /// <param name="tcFooter">表尾单元格集合</param>
- void ReBuildFooter(TableCellCollection tcFooter)
- {
- tcFooter.Clear();
- GridViewRow rowFooter = new GridViewRow(0, 0, DataControlRowType.Footer, DataControlRowState.Normal);
- rowFooter.BorderWidth = 1;
- rowFooter.Attributes.Add("class", "yy_sgv_fixRow1");
- rowFooter.Attributes.Add("style", "z-index:1000;background-color:#eafbc9;;font-family:宋体;font-weight:bold;border:1px #719626 solid;");
- TableCell footerCell = new TableCell();
- footerCell.Text = "总计";
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allOrganCaptital.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allOrganJGCaptital.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allZXJG.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allZDJG.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allYBJG.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allZXZW.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allOrganXLCaptital.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allAJJX.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allBCJJX.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allRCWH.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allZDFB.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allYBFB.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- footerCell = new TableCell();
- footerCell.Text = allKJXM.ToString();
- footerCell.HorizontalAlign = HorizontalAlign.Center;
- footerCell.Wrap = false;
- rowFooter.Cells.Add(footerCell);
- sgvCapitalDetailList.Controls[0].Controls.AddAt(rowSum + 3, rowFooter);
- }
- /// <summary>
- /// 重建表头
- /// </summary>
- /// <param name="tcHeader">表头单元格</param>
- void RebuildHeader(TableCellCollection tcHeader)
- {
- tcHeader.Clear();
- GridViewRow rowHeader = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
- rowHeader.Attributes.Add("class", "yy_sgv_fixRow1");
- rowHeader.Attributes.Add("style", "z-index:1000;background-color:#d2e8ff;color:#2965a2;font-family:宋体;font-weight:bold;border:1px solid;");
- rowHeader.BorderWidth = 1;
- TableCell headerCell = new TableCell();
- headerCell.Text = "企业名称";
- headerCell.RowSpan = 2;
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Attributes.Add("style", "vertical-align:middle;"); //合并后的单元格设置其垂直居中
- headerCell.Wrap = false;
- rowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "合计";
- headerCell.RowSpan = 2;
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Attributes.Add("style", "vertical-align:middle;");
- headerCell.Wrap = false;
- rowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "技改";
- headerCell.ColumnSpan=5;
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- rowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "修理";
- headerCell.ColumnSpan = 7;
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- rowHeader.Cells.Add(headerCell);
- GridViewRow secondRowHeader = new GridViewRow(1, 0, DataControlRowType.Header, DataControlRowState.Normal);
- secondRowHeader.Attributes.Add("class", "yy_sgv_fixRow1");
- secondRowHeader.Attributes.Add("style", "z-index:1000;background-color:#d2e8ff;color:#2965a2;font-family:宋体;font-weight:bold;");
- secondRowHeader.BorderWidth = 1;
- headerCell = new TableCell();
- headerCell.Text = "小计";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "专项技改";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "重点技改";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "一般技改";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "自行掌握";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "小计";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "A级检修";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "BC级检修";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "日常维护";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "重大非标";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "一般非标(<30万)";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- headerCell = new TableCell();
- headerCell.Text = "科技项目";
- headerCell.HorizontalAlign = HorizontalAlign.Center;
- headerCell.Wrap = false;
- secondRowHeader.Cells.Add(headerCell);
- sgvCapitalDetailList.Controls[0].Controls.AddAt(0, rowHeader);
- sgvCapitalDetailList.Controls[0].Controls.AddAt(1, secondRowHeader);
- }