110,476
社区成员
发帖
与我相关
我的任务
分享
var reuslt = new List<int>();
result.Select(e => new
{
Qty1= dtQtyDetail.AsEnumerable().Sum(p => p.Field<Int16>("Qty1")),,
Qty2 = dtQtyDetail.AsEnumerable().Sum(p => p.Field<Int16>("Qty2")),
Qty3 = dtQtyDetail.AsEnumerable().Sum(p => p.Field<Int16>("Qty3"))
});
好恶心的代码 var q = from p in dtQtyDetail.AsEnumerable()
group p 1 into g
select new
{
Qty1 = g.Sum(p => p.Field<Int16>("Qty1")),
Qty2 = g.Sum(p => p.Field<Int16>("Qty2")),
Qty3 = g.Sum(p => p.Field<Int16>("Qty3"))
};
finally you still using a "fake" group by :)