devXtragrid控件分组合计总结

Xtragrid分组合计总计

第一步从数据库得到基本数据源&＃xff0c;并增加几个空列用于存储合计的数据以及计算出来的合计百分比。

对查询出来的数据进行组装&＃xff0c;就是用datatabl的computer方法对数据进行合计和计算

例如&＃xff1a;dt.Compute("Sum(SALE_REAL_AMOUNT)", string.Format("UPSIDE_CODE like &＃39;{0}%&＃39;", tmp_big_type_code));

增加合计的列&＃xff0c;要自定义合计的设定summmaryType为customer,

增加事件 gvReport_CustomDrawGroupRow

用于自定义分组内容的显示

private void gvReport_CustomDrawGroupRow(object sender, DevExpress.XtraGrid.Views.Base.RowObjectCustomDrawEventArgs e)

        {

            GridGroupRowInfo GridGroupRowInfo &＃61; e.Info as GridGroupRowInfo;

            if (GridGroupRowInfo &＃61;&＃61; null) return;

            if (GridGroupRowInfo.Column.FieldName &＃61;&＃61; "UPSIDE_CODE")

            {

                int i &＃61; gvReport.GetDataRowHandleByGroupRowHandle(e.RowHandle);

                DataRow row &＃61; gvReport.GetDataRow(i);

                GridGroupRowInfo.GroupText &＃61; row["UPSIDE_CODE"] &＃43; row["UPSIDE_NAME"].ToString();

            }

        }

CustomSummaryCalculate 用于自定义分组合计

private void gvReport_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)

        {

            if (e.IsGroupSummary)

            {

                GridGroupSummaryItem item1&＃61;e.Item as GridGroupSummaryItem;

                if (item1 &＃61;&＃61; null) return;

                if (item1.FieldName &＃61;&＃61; "PER_AMOUNT")

                {

                   item1.DisplayFormat &＃61; "{0}";

                   e.TotalValue &＃61; e.GetValue("PER_SUM_AMOUNT").ToString();

                }

                else if (item1.FieldName &＃61;&＃61; "PRIFT_RATE")

                {

                   item1.DisplayFormat &＃61; "{0}";

                   e.TotalValue &＃61; e.GetValue("SUM_PRIFT_RATE").ToString();//

                }

            }

        }