linq gridview列表中相同条件的合并 并且其他属性下 数字相加
//Linq中的group by多表多字段,Sum求和
var dataListVar = (from a in dataList
group a by new { a.RQ, a.BC, a.BYe, a.GG, a.CZY,a.BZFZR } into b
select new CMSCLJ
{
BC=b.Key.BC,
RQ=b.Key.RQ,
GG = b.Key.GG,
BYe = b.Key.BYe,
BZFZR = b.Key.BZFZR,
CZY = b.Key.CZY,
BCZL = b.Sum(c => c.BCZL),
LJBCZL = b.Sum(c => c.LJBCZL),
BCFL = b.Sum(c => c.BCFL),
LJBCFL = b.Sum(c => c.LJBCFL),
BCJS = b.Sum(c => c.BCJS),
LJBCJS = b.Sum(c => c.LJBCJS)
}).ToList();
主要是先经过处理数据 然后把数据展示在gridview中去
浙公网安备 33010602011771号