查询要使用分组依据 [英] Query Want to Use Group By

问题描述

var results = (from c in db.RATEPROCESSes
                                  join b in db.BATCHes on c.BATCHKEY equals b.id
                                  where c.MANIFESTDATE >= DateTime.Parse(fdate) && c.MANIFESTDATE <= DateTime.Parse(sdate) && c.ACCOUNTNBR == accountno
                                  select new { Pieces = b.pieces, ACCOUNTNBR = c.ACCOUNTNBR, Manifestdate = c.MANIFESTDATE, BATCHKEY = c.BATCHKEY }).Select(x => new Batch_RateProcess { ACCOUNTNBR = x.ACCOUNTNBR, Pieces = x.Pieces, Manifestdate = DateTime.Parse(x.Manifestdate.ToString()), BATCHKEY = x.BATCHKEY.ToString()});

我想使用accountnbr分组吗????

i want to use group by accountnbr how can i do it????

推荐答案

var preResults = (from c in db.RATEPROCESSes
                                  join b in db.BATCHes on c.BATCHKEY equals b.id
                                  where c.MANIFESTDATE >= DateTime.Parse(fdate) && c.MANIFESTDATE <= DateTime.Parse(sdate) && c.ACCOUNTNBR == accountno
                                  select new { Pieces = b.pieces, ACCOUNTNBR = c.ACCOUNTNBR, Manifestdate = c.MANIFESTDATE, BATCHKEY = c.BATCHKEY })

var results=preresults.Select(x => new Batch_RateProcess { ACCOUNTNBR = x.ACCOUNTNBR, 
     Pieces = x.Pieces, Manifestdate = DateTime.Parse(x.Manifestdate.ToString()), 
     BATCHKEY = x.BATCHKEY.ToString()})
           .GroupBy(rateProcess=>rateProcess.ACCOUNTNBR);

这篇关于查询要使用分组依据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！