Dev 控件之:datacontrol 分组,合计Summary:(Footersummary) (row footer summary)
(Row summary) 设置
1.样式图:
图一:分组
图2:小计合计
2.分组:如图一所示
DevExpress.XtraGrid.Columns.GridColumn column = gridView1.Columns["流水号"];//拿到要分组的列
if (column ==null) return;
column.GroupIndex = 0; //未分组情况下列的GroupIndex为-1,所有都是一个组
3.(Footersummary)总体合计:也就是图2表的右下角利润合计
代码如下:
DevExpress.XtraGrid.Columns.GridColumncol_Profit = gridView1.Columns["参考利润"];
gridView1.Columns["参考利润"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView1.Columns["参考利润"].SummaryItem.DisplayFormat = "利润合计: {0:c2}";
4.(row footersummary)小计的出现:
或许是本人愚钝,小计的出现还是费了点波折:
注:下面是dev帮助文档提供的资料,但这是直接从界面绑定数据的作法
Add summary items by clicking Add, and customize them.
A singleitem is represented by a GridGroupSummaryItem classobject, which is a GridSummaryItem classdescendant. It provides the following main properties.
- GridSummaryItem.SummaryType - Specifiesthe type of summary to calculate against groups.
- GridSummaryItem.FieldName -Specifies the field against which the summary must be calculated.
- GridGroupSummaryItem.ShowInGroupColumnFooter -Specifies where to display group summary values - in group rows or in aspecific column's footer.
- GridSummaryItem.DisplayFormat - Allowsyou to customize the display format of group summary values.
Here we use the GridSummaryItem.DisplayFormat propertyfor demonstration purposes. To learn more about summary value formats, see Format SummaryValues.
如果您的数据源是从程序中绑定的,或许下面的内容对您有用:
GridGroupSummaryItemitem1 = new GridGroupSummaryItem();
item1.FieldName = "参考利润;
item1.SummaryType =DevExpress.Data.SummaryItemType.Sum;
item1.DisplayFormat = "利润小计: {0:c2}";//格式
item1.ShowInGroupColumnFooter =col_Profit;//这句就是给groupcolumnfooter加上小计 col_Profit在上文代码(总计合计)中有
gridView1.GroupSummary.Add(item1);
5.(rowsummary)还有就是row summary哪一行中能很明显的给人一个总计啊.平均值啊等等的实现
如图:
具体代码如下:
:
GridGroupSummaryItemitem2 = new GridGroupSummaryItem();
item2.FieldName = "参考利润;
item2.SummaryType =DevExpress.Data.SummaryItemType.Sum;
item2.DisplayFormat = "利润小计: {0:c2}";
gridView1.GroupSummary.Add(item2);
:
GridGroupSummaryItemitem = new GridGroupSummaryItem();
item.FieldName = "ProductName";
item.SummaryType = DevExpress.Data.SummaryItemType.Count;
gridView1.GroupSummary.Add(item);