devexpress gridcontrol自定义求和计算，支持分组时计算

最新推荐文章于 2025-05-29 06:37:47 发布

独孤天紫

最新推荐文章于 2025-05-29 06:37:47 发布

阅读量122

点赞数

文章标签： c#

原文链接：https://blog.youkuaiyun.com/qq_38977099/article/details/120586500

版权

devexpress gridcontrol自定义求和计算，支持分组时计算

 decimal num1 = 0;
 decimal num2 = 0;
 decimal num3 = 0;
 private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
 {
     if (e.IsGroupSummary)//如果是分组的汇总
     {
         if ((e.Item as GridSummaryItem).FieldName == "Detail")
         {
             //开始计算
             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
             {
                 e.TotalValue = 0;
                 num1 = 0;
                 num2 = 0;
                 num3 = 0;
             }
             else
             //正在计算
             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
             {
                 num1 += Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "KaiPiao"));
                 num2 += Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "Debit"));
                 num3 += Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "Credit"));
             }
             else //计算完毕
             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
             {
                 e.TotalValue = Math.Round(num1 + num2 - num3, 2);
             }

         }
     }

     else if (e.IsTotalSummary)//如果是底部求和的汇总
     {
         if ((e.Item as GridSummaryItem).FieldName == "Detail")
         {
             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
             {
                 e.TotalValue = 0;
                 num1 = 0;
                 num2 = 0;
                 num3 = 0;
             }
             else
             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
             {

                 num1 += Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "KaiPiao"));
                 num2 += Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "Debit"));
                 num3 += Convert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "Credit"));

             }
             else if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
             {
                 e.TotalValue = Math.Round(num1 + num2 - num3, 2);
             }
         }
     }
 }