如何实现ASPxGridView的多表头功能

最新推荐文章于 2020-01-03 08:51:31 发布

小菜鸟鹏

最新推荐文章于 2020-01-03 08:51:31 发布

阅读量2.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： DevExpress 文章标签： table null string object

本文链接：https://blog.youkuaiyun.com/zyp_tfy/article/details/6650916

DevExpress 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一种实现ASPxGridView多表头的方法，通过自定义代码可以在数据绑定前添加额外的表头行，支持字段按指定字符进行合并。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

如何实现ASPxGridView的多表头功能

　　关于如何实现ASPxGridView的多表头功能，写了一个公共方法可供使用，调用时只许在绑定方法前面调用即可。

代码如下：

//调用该方法即可
 public static void SetAspxGridViewBand(DevExpress.Web.ASPxGridView.ASPxGridView gridView)
    {
        gridView.HtmlRowCreated += new DevExpress.Web.ASPxGridView.ASPxGridViewTableRowEventHandler(GridView1_HtmlRowCreated);
    }

    static void GridView1_HtmlRowCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewTableRowEventArgs e)
    {
        DevExpress.Web.ASPxGridView.ASPxGridView gridView = sender as DevExpress.Web.ASPxGridView.ASPxGridView;
        ////if the first data row has been added
        if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Data && e.VisibleIndex == gridView.PageIndex * gridView.SettingsPager.PageSize)
        {
            Table table = e.Row.Parent as Table;
            if (table != null)
            {
                TableRow row = new TableRow();
                TableCell firstBand = GetNewTableCell(row, string.Empty);
                foreach (DevExpress.Web.ASPxGridView.GridViewDataColumn col in gridView.Columns)
                {
                    if (col.FieldName.IndexOf("|") > 0)
                    {
                        string bandname = col.FieldName.Substring(0, col.FieldName.IndexOf("|"));
                        TableCell band = null;
                        foreach (TableCell t in row.Cells)
                        {
                            if (t.Text == bandname)
                            {
                                band = t;
                                break;
                            }
                        }

                        if (band == null)
                        {
                            band = GetNewTableCell(row, bandname);
                        }

                        col.Caption = col.FieldName.Substring(col.FieldName.IndexOf("|") + 1);
                        band.ColumnSpan++;
                    }
                    else
                    {
                        firstBand.ColumnSpan++;
                    }
                }

                table.Rows.AddAt(0, row);
            }
        }
    }

//可以在此修改单元格样式
    private static TableCell GetNewTableCell(TableRow row, string bandname)
    {
        TableCell band = new TableCell();
        band.Text = bandname;
        row.Cells.Add(band);
        band.CssClass = "dxgvHeader";
        band.HorizontalAlign = HorizontalAlign.Center;
        band.BorderStyle = BorderStyle.NotSet;      
        band.BorderColor = row.BorderColor;
        return band;
    }

注意：

1、该方法在绑定方法之前调用。

2、需合并的单元格的列需如下设置：

 
<dx:GridViewDataTextColumn
Caption="合计|重号"
VisibleIndex="0"
FieldName="合计|重号">

                               </dx:GridViewDataTextColumn>

<dx:GridViewDataTextColumn
Caption="合计|缺号"
VisibleIndex="0"
FieldName="合计|缺号">

                               </dx:GridViewDataTextColumn>

<dx:GridViewDataTextColumn
Caption="合计|错号"
VisibleIndex="0"
FieldName="合计|错号"><BR>                                </dx:GridViewDataTextColumn>