linq group by 多条件并返回原数据。解决方法

linq group by 多条件并返回原数据。

C# code

(from p in qList                  group p by                     new { p.itemCode, p.City, p.VcCode }                  into g                       select new                  {                     q_count = g.Sum(p=>p.iSampleCount),                    q_price = g.Sum(p=>p.iPrice),                    q_amt = g.Sum(p=>p.iAmt),                    q_itemCode = //这里我想得到p.itemCode                 }).ToList();

请问这里该怎么写才能得到需要的值？

[解决办法]
C# code
(from p in qList 
group p by 
new { p.itemCode, p.City, p.VcCode } 
into g 
select new 
{ 
q_count = g.Sum(p=>p.iSampleCount),
q_price = g.Sum(p=>p.iPrice),
q_amt = g.Sum(p=>p.iAmt),
q_itemCode = g.Key. itemCode
}).ToList();


[解决办法]
q_itemCode = g.Key.itemCode

查看更多 下一篇