var deGroup = from tt in list
where tt.WZ_TYPE_ID == 0
group tt by new { tt.SCTYPE_ID, tt.SCTYPE_IDNAME }
into qq
select new
{
SCTYPE_ID = qq.Key.SCTYPE_ID,
SCTYPE_IDNAME = qq.Key.SCTYPE_IDNAME,
DE = qq.Sum(itm => itm.DE),
JHAMOUNT = qq.Sum(itm => itm.JHAMOUNT),
SJAMOUNT = qq.Sum(itm => itm.SJAMOUNT),
JCAMOUNT = qq.Sum(itm => itm.JCAMOUNT),
JFAMOUNT = qq.Sum(itm => itm.JFAMOUNT),
DXAMOUNT = qq.Sum(itm => itm.DXAMOUNT),
count = qq.Count()
};
Linq 表达式分组求和
最新推荐文章于 2024-05-29 11:36:07 发布