如何用SQLSugar轻松实现统计总数的高效写法？

本文共计132个文字，预计阅读时间需要1分钟。

csharplist=list.GroupBy(f=> f.ShipmentNum) .Select(f=> { var o=f.FirstOrDefault(); var number=f.Sum(f1=> f1.Number); o.Number=number; var weight=f.Sum(x=> x.Weight); o.Weight=weight; var meterWeight=f.Sum(x=> x.MeterWeight); o.MeterWeight=meterWeight; return o; }) .ToList();

list = list.GroupBy(f => f.ShipmentNum).Select(f =>
{
var o = f.FirstOrDefault();

var number = f.Sum(f1 => f1.Number);
o.Number = number;

var weight = f.Sum(x => x.Weight);
o.Weight = weight;

var meterweight = f.Sum(x => x.MeterWeight);
o.MeterWeight = meterweight;

o.DeclareTotalPrice = o.DeclarePrice * number; // 申报总价

return o;

}).ToList();

return list;