110,535
社区成员
发帖
与我相关
我的任务
分享
var resultData = (from R in received
join N in notInStock
on R.positionNo equals N.positionNo
into temp
from N in temp.DefaultIfEmpty()
select new
{
positionNo = R.positionNo==null?N.positionNo:R.positionNo,
itemCount = N.itemCoun //+ R.itemCount
}).ToList();
var resultData = (from R in received
join N in notInStock
on R.positionNo equals N.positionNo
into temp
from N in temp.DefaultIfEmpty()
select new
{
positionNo = R.positionNo == null ? N.positionNo : R.positionNo,
itemCount = (N?.itemCount == null ? 0 : N.itemCount) + R.itemCount
}).ToList();
var notInStock = (from S in db.SR_PO
join T in db.Track
on S.bomsNo equals T.bomsNo
where T.qty_storage == 0 && positionNo != null && S.positionNo.Contains(positionNo)
group new { S.positionNo, itemCount = T.partNo } by S.positionNo into G
select new
{
positionNo = G.Key,
itemCount = G.Select(P => P.itemCount).Distinct().Count()
}).ToList();