wangxinhui
2025-11-12 f54b7815d8451f362554e3d2d09b4991ce13d4ff
ÏîÄ¿´úÂë/WMS/WMSServices/WIDESEA_StockRepository/StockInfoRepository.cs
@@ -37,6 +37,20 @@
            List<Dt_StockInfo> stockInfos = Db.Queryable<Dt_StockInfo>().Where(x => locationCodes.Contains(x.LocationCode) && x.MaterielId == materielId && x.MaterielWide==width && x.StockOutLength<=0).OrderBy(x=>x.CreateDate).ToList();
            return stockInfos;
        }
        /// <summary>
        /// èŽ·å–ç”Ÿç®¡å¯ä½¿ç”¨åº“å­˜
        /// </summary>
        public List<Dt_StockInfo> GetStockInfos(string materielCode, decimal width, List<string> locationCodes)
        {
            List<Dt_StockInfo> stockInfos = Db.Queryable<Dt_StockInfo>().Where(x => locationCodes.Contains(x.LocationCode) && x.MaterielCode.StartsWith(materielCode) && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.MaterielWide == width && x.StockOutLength <= 0 && x.StockLength > 0).OrderBy(x => x.CreateDate).ToList();
            return stockInfos;
        }
        public List<Dt_StockInfo> GetStockInfos(string materielCode,  List<string> locationCodes)
        {
            List<Dt_StockInfo> stockInfos = Db.Queryable<Dt_StockInfo>().Where(x => locationCodes.Contains(x.LocationCode) && x.MaterielCode == materielCode && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.StockOutLength <= 0 && x.StockLength > 0).OrderBy(x => x.CreateDate).ToList();
            return stockInfos;
        }
        public List<Dt_StockInfo> GetStockInfosByIds(List<int> ids)
        {