我无法理解如何在数据表中获取总和值。我尝试了很多方法。但没有奏效。
I cant understand how to get sum value in a data table. I tried many ways. but not worked.
dtFabricItem = dtFabricItem.AsEnumerable() .GroupBy(r => new { Col1 = r["ItemId"], Col2 = r["intColourId"] , Col3 = r["QualityReferenceNo"], Col4 = r["strSupplierColour"], Col5 = r["StrLabDipRefNo"], Col6 = r["strUnitName"], Col7 = r["decSuggestedQtyToBookYrd"], Col8 = r["strItemName"], Col9 = r["decPurchaseRate"] }) .Select(g => g.First()) .CopyToDataTable();我尝试过: dtFabricItem = dtFabricItem.AsEnumerable() .GroupBy(r => new { ItemId = r.Field< int>(ItemId), intColourId = r.Field< int>( intColourId), QualityReferenceNo = r.Field< string>(QualityReferenceNo), strSupplierColour = r.Field< string>(strSupplierColour), StrLabDipRefNo = r.Field< string>(StrLabDipRefNo), strUnitName = r.Field< string>(strUnitName), }) 。选择(grp => new { name = grp.Key.ItemId , 州= grp.Key.intColourId, sum = grp.Sum(金额) }) .OrderBy(o => o.state) .ToList();
What I have tried: dtFabricItem = dtFabricItem.AsEnumerable() .GroupBy(r => new { ItemId = r.Field<int>("ItemId"), intColourId = r.Field<int>("intColourId"), QualityReferenceNo = r.Field<string>("QualityReferenceNo"), strSupplierColour = r.Field<string>("strSupplierColour"), StrLabDipRefNo = r.Field<string>("StrLabDipRefNo"), strUnitName = r.Field<string>("strUnitName"), }) .Select(grp => new { name = grp.Key.ItemId, state = grp.Key.intColourId, sum = grp.Sum("Amount") }) .OrderBy(o => o.state) .ToList();
推荐答案您好, 参考: 多个分组和Sum LINQ 谢谢 Hello , Refer : Multiple group by and Sum LINQ Thanks
更多推荐
如何获取数据表的SUM值
发布评论