From 18d2f40bbf40469b033de6f07ca8a8e3bc191132 Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期六, 26 四月 2025 19:21:40 +0800
Subject: [PATCH] 优化代码
---
项目代码/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/StockInfoRepository.cs | 30 +++++++++++++++++++++++++++++-
1 files changed, 29 insertions(+), 1 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/StockInfoRepository.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/StockInfoRepository.cs"
index adef8e2..1d14516 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/StockInfoRepository.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StockRepository/StockInfoRepository.cs"
@@ -57,6 +57,16 @@
return Db.Queryable<Dt_StockInfo>().Where(x => x.PalletCode == palletCode).Includes(x => x.Details).First();
}
+ public List<Dt_StockInfo> GetDt_StockInfos(string LocationCode)
+ {
+ return Db.Queryable<Dt_StockInfo>().Includes(x => x.Details).Where(x => x.LocationCode == LocationCode).ToList();
+ }
+
+ public Dt_StockInfo GetStockInfo(int id)
+ {
+ return Db.Queryable<Dt_StockInfo>().Where(x => x.Id == id).Includes(x => x.Details).First();
+ }
+
public List<Dt_StockInfo> GetStockInfos(string materielCode)
{
return Db.Queryable<Dt_StockInfo>().Includes(x => x.Details).Where(x => x.Details.Any(v => v.MaterielCode == materielCode)).ToList();
@@ -64,7 +74,15 @@
//ISugarQueryable<Dt_StockInfo> sugarQueryable1 = Db.Queryable<Dt_StockInfo>().Includes(x => x.Details).Where(x => x.Details.Any(v => v.MaterielCode == materielCode));
//return sugarQueryable.InnerJoin(sugarQueryable1, (a, b) => a.LocationCode == b.LocationCode).Select((a, b) => b).Includes(x => x.Details).ToList();
}
-
+ /// <summary>
+ /// 鏍规嵁璐т綅缂栧彿鑾峰彇缁勭洏搴撳瓨淇℃伅
+ /// </summary>
+ /// <param name="locationCodes"></param>
+ /// <returns></returns>
+ public List<Dt_StockInfo> LocationCodesGetStockInfos(List<string> locationCodes, StockStatusEmun statusEmun = StockStatusEmun.宸插叆搴�)
+ {
+ return Db.Queryable<Dt_StockInfo>().Where(x => locationCodes.Contains(x.LocationCode) /*&& x.StockStatus == statusEmun.ObjToInt()*/).Includes(x => x.Details).ToList();
+ }
public List<Dt_StockInfo> GetStockInfos(string materielCode, List<string> locationCodes)
{
return Db.Queryable<Dt_StockInfo>().Where(x => locationCodes.Contains(x.LocationCode)).Includes(x => x.Details).Where(x => x.Details.Any(v => v.MaterielCode == materielCode)).ToList();
@@ -94,6 +112,16 @@
{
return Db.UpdateNav(stockInfo).Include(x => x.Details).ExecuteCommand();
}
+ public List<object> GetBatchNoStockInfo(string materielCode)
+ {
+ List<object> strings = new List<object>();
+ var Dt_StockInfoDetails = Db.Queryable<Dt_StockInfoDetail>().Where(x => x.MaterielCode == materielCode && x.Status == StockStatusEmun.宸插叆搴�.ObjToInt()).ToList().GroupBy(x => x.BatchNo).Select(x => x.Key);
+ foreach (var item in Dt_StockInfoDetails)
+ {
+ strings.Add(item);
+ }
+ return strings;
+ }
public Dt_StockInfo GetPalletStockInfo(string roadwayNo)
{
--
Gitblit v1.9.3