linq 分组语法

 var result = from t1 in tmsDbContext.Modular_D_CheLiangWeiZhang
                         from t2 in tmsDbContext.Modular_D_CheLiangXinXi
                         where t1.Modular_D_CheLiangXinXi_Id == t2.Id && t1.CheLiangWeiZhang_WeiZhangRiQi >= _querymodel.startdate 
                         && t1.CheLiangWeiZhang_WeiZhangRiQi <= _querymodel.enddate
                         group new { t1, t2 } by t2.CheLiangXinXi_PaiZhao into g
                         select new groupweizhang_viewmodel
                         {
                             chepai = g.Key,
                             jine = g.Sum(p => p.t1.CheLiangWeiZhang_FaKuan),
                             chufakoufen = g.Sum(p => p.t1.CheLiangWeiZhang_KouFen)
                         };

return Ok(result.ToList());

 

2

 var groupdata = from item in query
                            group item by item.Modular_D_CheLiangXinXi.CheLiangXinXi_PaiZhao
                into f
                            select new groupviewmodel
                            {
                                chepai = f.Key,
                                jine = f.Sum(s => s.WeiXiuBaoYang_YiJieSuanJinE),
                            };


            return Ok(groupdata.ToList());