wangxinhui
2025-12-29 d0cc37c3c11859cc55f30624692dca55be2b8a32
项目代码/WMS/WMSServices/WIDESEA_StockRepository/ProStockInfoRepository.cs
@@ -21,5 +21,15 @@
        {
            _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;
        }
    }
}