GridControl页脚显示列的汇总数据

1. gridView4.OptionsView.ShowFooter = true;//启用显示页脚

2.  

3. //索引为1的列

4. gridView4.Columns[1].SummaryItem.DisplayFormat = "{0:0.##}";

5. gridView4.Columns[1].SummaryItem.FieldName = "TotalMoney";

6. gridView4.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和

7. //索引为2的列

8. gridView4.Columns[2].SummaryItem.DisplayFormat = "{0:0.##}";

9. gridView4.Columns[2].SummaryItem.FieldName = "PayTotalMoney";

10. gridView4.Columns[2].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和

11. //索引为3的列

12. gridView4.Columns[3].SummaryItem.DisplayFormat = "{0:0.##}";

13. gridView4.Columns[3].SummaryItem.FieldName = "UnPayMoney";

14. gridView4.Columns[3].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和

15. gridView4.CustomDrawFooterCell += new FooterCellCustomDrawEventHandler(this.gridView4_CustomDrawFooterCell);//设置一下对齐方式，通过GridView的CustomDrawFooterCell 事件

1. //GridControl中的CustomDrawFooterCell事件

2. private void gridView4_CustomDrawFooterCell(object sender, DevExpress.XtraGrid.Views.Grid.FooterCellCustomDrawEventArgs e)

3. {

4. e.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;

5. }

效果图如下:

如果不想汇总所有数据,而是根据选择汇总,则可以在GridControl中设置勾选框,汇总选中的行数据进行汇总:

设置勾选

Grid Designer - Views - OptionSelection-设置其中的MultiSelect为True,设置MultiSelectMode为CheckBoxRowSelect

选择表格的SelectionChanged事件,代码如下

1. private void gridView6_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e)

2. {

3. gridView6.OptionsView.ShowFooter = true;//启用显示页脚

4. willPay = 0;//清零数据

5. foreach (var item in gridView6.GetSelectedRows())//遍历选中行

6. {

7. //获取选中行的对象

8. IncoiceInfoSum incoice = (IncoiceInfoSum)gridView6.GetRow(item);

9. willPay += incoice.ThisPay;//数据累加

10. }

11. //数据显示

12. gridView6.Columns[6].SummaryItem.DisplayFormat = "付款汇总:" + willPay.ToString("0.##") + "";

13. gridView6.CustomDrawFooterCell += new FooterCellCustomDrawEventHandler(this.gridView6_CustomDrawFooterCell);//单元格居中显示

14.  

15. //刷新选中行

16. gridView6.RefreshRow(gridView6.FocusedRowHandle);

17. }

这样就可以实现自动汇总勾选行的数据,效果如下:

•