| | |
|---|
| | | .Any(v => |
|---|
| | | v.ProductCode == proOutOrderDetail.PCode |
|---|
| | | && v.ProductVersion.StartsWith(proOutOrderDetail.PVer.Substring(0,1)) |
|---|
| | | && (isCanLot ? isCanLot : v.BagNo == proOutOrderDetail.PLot) |
|---|
| | | && (isCanLot ? isCanLot : v.ProductCode == proOutOrderDetail.PLot) |
|---|
| | | && (isCanDate ? isCanDate : v.DateCode == proOutOrderDetail.DateCode) |
|---|
| | | )) |
|---|
| | | .ToList(); |
|---|
| | |
|---|
| | | { |
|---|
| | | List<Dt_ProStockInfo>? proStockInfos = null; |
|---|
| | | bool isCanDate = string.IsNullOrEmpty(mesRworkOutboundOrder.DateCode); |
|---|
| | | proStockInfos = Db.Queryable<Dt_ProStockInfo>().Where(x => locationInfos.Contains(x.LocationCode) && x.ProStockAttribute==ProStockAttributeEnum.灏炬暟.ObjToInt()) |
|---|
| | | proStockInfos = Db.Queryable<Dt_ProStockInfo>().Where(x => locationInfos.Contains(x.LocationCode)) |
|---|
| | | .Includes(x => x.proStockInfoDetails) |
|---|
| | | .Where(x => x.proStockInfoDetails |
|---|
| | | .Any(v => v.SaleOrder == mesRworkOutboundOrder.SaleOrder |
|---|
| | | && v.ProductCode == mesRworkOutboundOrder.ProductCode |
|---|
| | | .Any(v => v.ProductCode == mesRworkOutboundOrder.ProductCode |
|---|
| | | && v.ProductVersion == mesRworkOutboundOrder.ProductVersion |
|---|
| | | && (isCanDate ? isCanDate : v.DateCode == mesRworkOutboundOrder.DateCode) |
|---|
| | | )) |
|---|
| | |
|---|
| | | .Includes(x => x.proStockInfoDetails) |
|---|
| | | .Where(x => x.proStockInfoDetails |
|---|
| | | .Any(v => |
|---|
| | | v.ProductCode == erpProScrapSheetDetail.ScrapProLotNo |
|---|
| | | v.LotNumber == erpProScrapSheetDetail.ScrapProLotNo |
|---|
| | | && v.ProductCode == erpProScrapSheetDetail.ScrapProCode |
|---|
| | | && v.ProductVersion == erpProScrapSheetDetail.ScrapProVersion |
|---|
| | | )) |
|---|
