DEV ASPxGridView自定义TotalSummary的实现方法：根据条件计算某列

DEV ASPxGridView自定义TotalSummary的实现方法：根据条件计算某列

aspx代码：

...
              </Columns>
                  <TotalSummary>
                       <dx:ASPxSummaryItem FieldName="数kg" SummaryType="Custom" />
                       <dx:ASPxSummaryItem FieldName="数L" SummaryType="Custom" />
                       <dx:ASPxSummaryItem FieldName="量kg" SummaryType="Custom" />
                       <dx:ASPxSummaryItem FieldName="量L" SummaryType="Custom" />
                       
                </TotalSummary>
                <Styles>
                    <Header Wrap="False"></Header>

                    <Cell Wrap="False"></Cell>
                </Styles>
                ...

c#代码：

 protected void ASPxGridView1_CustomSummaryCalculate(object sender, CustomSummaryEventArgs e)
         {
             
             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
                 totalSum = 0;
             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
             //if (ASPxGridView1.Selection.IsRowSelectedByKey(e.GetValue(ASPxGridView1.KeyFieldName)))
             {
                 string current_ywfl_str = e.GetValue("业务分类").ToString().Trim();
                 if (current_ywfl_str == "进油")
                 {
                     totalSum += Convert.ToDecimal(e.FieldValue);
                 }
                 else
                 {
                     if (current_ywfl_str == "出油")
                     {
                         totalSum -= Convert.ToDecimal(e.FieldValue);
                     }
                 }
             }


             if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
             {
                 string calc_jg = "";
                 if (totalSum > 0)
                 {
                     calc_jg = "亏:";
                 }
                 else if (totalSum == 0)
                 {
                     calc_jg = "平:";
                 }
                 else
                 {
                     calc_jg = "涨:";
                 }
                 e.TotalValue = calc_jg + totalSum;
             }
         }

秋风写于淄博 业务联系与技术交流：QQ375172665