DEV控件GridControl的分组和Summary_C#

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);