aspxgridview根据不同内容汇总数据

来源:互联网 发布:情义我心知 电影 编辑:程序博客网 时间:2024/06/05 15:45
int totalSum;
02protected void lggrdpcxx_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
03{
04    string yszt ;
05    string ywzt ;
06    string yxxs ;
07    string sfqy ;
08    if (lggrdpcxx.VisibleRowCount > 0)
09    {
10        yszt = e.GetValue("验收状态").ToString();
11        ywzt = e.GetValue("业务状态").ToString();
12        yxxs = e.GetValue("允许销售").ToString();
13        sfqy = e.GetValue("是否启用").ToString();
14        // Initialization.
15        if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
16            totalSum = 0;
17        // Calculation.
18        if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
19            if (yszt == "合格" && ywzt == "入库完成" && yxxs == "是" && sfqy == "是")
20                totalSum += Convert.ToInt32(e.FieldValue);
21        // Finalization.
22        if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
23            e.TotalValue = totalSum;
24    }
25}