| | |
| | | { |
| | | _basicRepository = basicRepository; |
| | | } |
| | | public List<Dt_ProStockInfo> GetStockInfos(string materielCode, List<string> locationCodes) |
| | | { |
| | | List<Dt_ProStockInfo> stockInfos = Db.Queryable<Dt_ProStockInfo>().Where(x => locationCodes.Contains(x.LocationCode) && x.StockStatus == StockStatusEmun.鍏ュ簱瀹屾垚.ObjToInt()).Includes(x => x.proStockInfoDetails) |
| | | .Where(x => x.proStockInfoDetails |
| | | .Any(v => |
| | | v.ProductCode == materielCode && |
| | | v.OutboundQuantity<=0) |
| | | ).OrderBy(x=>x.CreateDate).ToList(); |
| | | return stockInfos; |
| | | } |
| | | } |
| | | } |