DevExpress 表格显示分组小计与总计（GroupSummary）

作者:C/S框架网|www.csframewo 发布日期:2023/09/26 13:27:11

DevExpress 表格显示分组小计与总计（GroupSummary）

DevExpress表格支持两种小计显示样式

1、小计在分组下面显示

2、小计在分组行显示

C#源码

C# Code:

private void Form2_Load(object sender, EventArgs e)
{
gc.DataSource = DemoData.GetGoodsList();

//设置分组=SUM
gv.GroupSummary.Add(new DevExpress.XtraGrid.GridGroupSummaryItem
{
FieldName = "Qty",
SummaryType = DevExpress.Data.SummaryItemType.Sum,
DisplayFormat = "{0:0.##}",
ShowInGroupColumnFooter = colQty, //重要！在分组行下面显示
});

//设置分组=AVG
gv.GroupSummary.Add(new DevExpress.XtraGrid.GridGroupSummaryItem
{
FieldName = "Price",
SummaryType = DevExpress.Data.SummaryItemType.Average,
DisplayFormat = "{0:0.##}",
ShowInGroupColumnFooter = colPrice,
});

//设置分组=SUM
gv.GroupSummary.Add(new DevExpress.XtraGrid.GridGroupSummaryItem
{
FieldName = "Amount",
SummaryType = DevExpress.Data.SummaryItemType.Sum,
DisplayFormat = "{0:0.##}",
ShowInGroupColumnFooter = colAmount,
ShowInGroupColumnFooterName = "Amount",
});

//客户名称分组显示
gv.Columns["CustomerName"].GroupIndex = 0;

//自动扩展所有分组，显示所有记录
gv.ExpandAllGroups();
}

//来源:C/S框架网 | www.csframework.com | QQ:23404761

C# Code:

//小计样式1 - 小计在分组最下面
private void button1_Click(object sender, EventArgs e)
{
gv.OptionsBehavior.AllowPartialGroups = DevExpress.Utils.DefaultBoolean.False;
gc.RefreshDataSource();
gv.ExpandAllGroups();
}

//小计样式2 - 小计在分组行显示
private void button2_Click(object sender, EventArgs e)
{
gv.OptionsBehavior.AllowPartialGroups = DevExpress.Utils.DefaultBoolean.True;
gc.RefreshDataSource();
gv.ExpandAllGroups();
}

//来源:C/S框架网 | www.csframework.com | QQ:23404761

清除分组

C# Code:

gv.ClearGrouping();