读书人

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

发布时间: 2012-02-01 16:58:19 作者: rapoo

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

读书人网 >.NET

热点推荐