| | |
| | | _basicRepository = basicRepository; |
| | | } |
| | | //鏍规嵁鏄庣粏鏁版嵁鏌ユ壘鍙敤搴撳瓨搴撳瓨 |
| | | public List<Dt_ProStockInfo> GetProStocks(Dt_ProOutOrderDetail proOutOrderDetail,List<string> locationInfos) |
| | | public List<Dt_ProStockInfo> GetProStocks(Dt_ProOutOrderDetail proOutOrderDetail,List<string> locationInfos, bool isFineWorks = false) |
| | | { |
| | | List<Dt_ProStockInfo>? proStockInfos = null; |
| | | bool isCanLot= string.IsNullOrEmpty(proOutOrderDetail.PLot); |
| | | bool isCanDate = string.IsNullOrEmpty(proOutOrderDetail.DateCode); |
| | | bool isCanVer = string.IsNullOrEmpty(proOutOrderDetail.OutSpecifyVer); |
| | | isFineWorks = !isFineWorks; |
| | | ////鍒ゆ柇瀹㈡埛鍑哄叆瑙勫垯 |
| | | //Dt_CustomerInfo customerInfo = _basicRepository.CustomerInfoRepository.QueryFirst(x=>x.Code== proOutOrderDetail.Customer); |
| | | //if (customerInfo==null) |
| | |
| | | .Any(v => |
| | | v.ProductCode == proOutOrderDetail.PCode |
| | | && v.ProductVersion.StartsWith(proOutOrderDetail.PVer.Substring(0,1)) |
| | | && (isCanLot ? isCanLot : v.BagNo == proOutOrderDetail.PLot) |
| | | && (isCanDate ? isCanDate : v.DateCode == proOutOrderDetail.DateCode) |
| | | && (isCanLot ? isCanLot : v.ProductCode == proOutOrderDetail.PLot) |
| | | && (isFineWorks ? isFineWorks : v.IsFineWorks == 1) |
| | | )) |
| | | .ToList(); |
| | | //} |
| | |
| | | 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) |
| | | )) |