var sourceIds = bMS_Base_PurbillvouchsList?.Select(t => t.F_ChildOrderId)?.ToList() ?? new List<string>();
var children = db.FindList<BMS_Base_PurbillvouchsEntity>(t => sourceIds.Contains(t.F_ChildOrderId));
var groups = children?.GroupBy(t => t.F_ChildOrderId);
foreach (var item in groups)
{
var entity = new BMS_ArrivalVouchsEntity()
{
F_ID = item.Key,
F_InvoiceAmount = item.Sum(t => t.F_ApplicationPayment),
F_InvoicedQuantity=item.Sum(t=>t.F_InvoicedQuantity)
};
db.Update(entity);
item?.ToList().ForEach(t =>
{
t.F_InvoicedCount = entity.F_InvoiceAmount;
t.F_InvoicedQuantity = entity.F_InvoicedQuantity;
db.Update(t);
});
}
System.Linq的使用
最新推荐文章于 2024-03-26 09:49:57 发布