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中去

posted on 2019-09-16 10:18  伍佰仟  阅读(106)  评论(0)    收藏  举报