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