From e31ca4e3e1774b7ddb832e8ec498b5ada24b2608 Mon Sep 17 00:00:00 2001
From: pan <antony1029@163.com>
Date: 星期日, 16 十一月 2025 19:13:58 +0800
Subject: [PATCH] 提交
---
项目代码/WMS无仓储版/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs | 169 +++++++++++++++++++++++++++++++++++---------------------
1 files changed, 106 insertions(+), 63 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs"
index c047a3e..efe19b8 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs"
@@ -1,7 +1,10 @@
锘縰sing AutoMapper;
+using SqlSugar;
+using WIDESEA_Common.LocationEnum;
using WIDESEA_Common.StockEnum;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
+using WIDESEA_Core.Helper;
using WIDESEA_IBasicService;
using WIDESEA_IRecordService;
using WIDESEA_IStockService;
@@ -84,84 +87,118 @@
/// <param name="needQuantity"></param>
/// <param name="residueQuantity"></param>
/// <returns></returns>
- public List<Dt_StockInfo> GetOutboundStocks(List<Dt_StockInfo> stockInfos, string materielCode, decimal needQuantity, out decimal residueQuantity)
+ public (List<Dt_StockInfo>, Dictionary<int, decimal>) GetOutboundStocks(List<Dt_StockInfo> stockInfos, string materielCode, decimal needQuantity, out decimal residueQuantity)
{
List<Dt_StockInfo> outStocks = new List<Dt_StockInfo>();
- var stockTotalQuantity = stockInfos.Select(x => x.Details.Sum(v => v.StockQuantity - v.OutboundQuantity)).Sum(x => x);
- //stockInfos = stockInfos.OrderBy(x => x.Id).ToList();
- if (stockTotalQuantity >= needQuantity)//搴撳瓨澶�
+ Dictionary<int, decimal> stockAllocations = new Dictionary<int, decimal>(); // 璁板綍姣忎釜搴撳瓨鏄庣粏鐨勫垎閰嶆暟閲�
+
+ // 鎸夊厛杩涘厛鍑烘帓搴忔墍鏈夌浉鍏崇殑搴撳瓨鏄庣粏
+ var sortedStockDetails = stockInfos
+ .SelectMany(x => x.Details)
+ .Where(x => x.MaterielCode == materielCode &&
+ x.StockQuantity > x.OutboundQuantity) // 鏈夊彲鐢ㄥ簱瀛�
+ .OrderBy(x => x.ProductionDate) // 鎸夌敓浜ф棩鏈熸帓搴忥紝鍏堣繘鍏堝嚭
+ .ThenBy(x => x.StockId) // 鐩稿悓鐢熶骇鏃ユ湡鎸夊簱瀛業D鎺掑簭
+ .ToList();
+
+ if (!sortedStockDetails.Any())
{
- int index = 0;
- while (needQuantity > 0)
- {
- Dt_StockInfo stockInfo = stockInfos[index];
- // 璁＄畻鍙敤搴撳瓨鏃惰浆鎹负decimal
- decimal useableStockQuantity = stockInfo.Details
- .Where(x => x.MaterielCode == materielCode)
- .Sum(x => (decimal)x.StockQuantity - (decimal)x.OutboundQuantity);
+ residueQuantity = needQuantity;
+ return (outStocks, stockAllocations);
+ }
- // 灏唍eedQuantity杞崲涓篸ecimal杩涜姣旇緝
- if (useableStockQuantity < (decimal)needQuantity && useableStockQuantity > 0)
- {
- stockInfo.Details.ForEach(x =>
- x.OutboundQuantity = x.StockQuantity);
+ // 璁＄畻鎬诲彲鐢ㄥ簱瀛�
+ var stockTotalQuantity = sortedStockDetails.Sum(x => x.StockQuantity - x.OutboundQuantity);
- // 浣跨敤decimal杩涜璁＄畻鍚庡啀杞洖float
- needQuantity = needQuantity - useableStockQuantity;
- }
- else
- {
- stockInfo.Details.ForEach(x =>
- {
- if (x.StockQuantity > x.OutboundQuantity && x.MaterielCode == materielCode)
- {
- // 灏嗙浉鍏冲�艰浆鎹负decimal杩涜绮剧‘璁＄畻
- decimal currentStock = (decimal)x.StockQuantity;
- decimal currentOutbound = (decimal)x.OutboundQuantity;
- decimal currentNeed = (decimal)needQuantity;
- decimal available = currentStock - currentOutbound;
-
- if (available >= currentNeed)
- {
- x.OutboundQuantity = currentOutbound + currentNeed;
- needQuantity = 0;
- }
- else
- {
- needQuantity =currentNeed - available;
- x.OutboundQuantity = x.StockQuantity;
- }
- }
- });
- }
- outStocks.Add(stockInfo);
- index++;
- }
-
+ if (stockTotalQuantity < needQuantity)
+ {
+ residueQuantity = needQuantity - stockTotalQuantity;
+
}
else
{
- throw new Exception("搴撳瓨涓嶈冻");
+ residueQuantity = 0;
}
- residueQuantity = needQuantity;
- return outStocks;
+
+ decimal remainingNeed = needQuantity;
+
+ // 鎸夊厛杩涘厛鍑洪『搴忓垎閰嶅簱瀛�
+ foreach (var detail in sortedStockDetails)
+ {
+ if (remainingNeed <= 0) break;
+
+ decimal availableQuantity = detail.StockQuantity - detail.OutboundQuantity;
+ if (availableQuantity <= 0) continue;
+
+ decimal allocateQuantity = Math.Min(availableQuantity, remainingNeed);
+
+ // 鏇存柊鍑哄簱鏁伴噺
+ detail.OutboundQuantity += allocateQuantity;
+ remainingNeed -= allocateQuantity;
+
+ // 璁板綍鍒嗛厤鏁伴噺
+ stockAllocations[detail.Id] = allocateQuantity;
+
+ // 濡傛灉杩欎釜搴撳瓨杩樻病娣诲姞鍒板嚭搴撳垪琛ㄤ腑锛屽氨娣诲姞
+ var stockInfo = stockInfos.First(x => x.Id == detail.StockId);
+ if (!outStocks.Contains(stockInfo))
+ {
+ outStocks.Add(stockInfo);
+ }
+ }
+
+ residueQuantity = remainingNeed;
+ return (outStocks, stockAllocations);
+ }
+
+ /// <summary>
+ /// 鏍规嵁鏉＄爜鑾峰彇搴撳瓨淇℃伅
+ /// </summary>
+ public async Task<Dt_StockInfoDetail> GetStockDetailByBarcode(string barcode, string materielCode)
+ {
+ return await Db.Queryable<Dt_StockInfoDetail>()
+ .Includes(x => x.StockInfo)
+ .Where(x => x.Barcode == barcode && x.MaterielCode == materielCode)
+ .FirstAsync();
}
- public List<Dt_StockInfo> GetStockInfos(string materielCode, string lotNo, List<string> locationCodes)
+ /// <summary>
+ /// 鑾峰彇鐗╂枡鐨勬墍鏈夋潯鐮佷俊鎭�
+ /// </summary>
+ public async Task<List<Dt_StockInfoDetail>> GetMaterialBarcodes(string materielCode, string batchNo = null)
{
- List<Dt_StockInfo> stockInfos = null;
- if (!string.IsNullOrEmpty(lotNo))
+ var query = Db.Queryable<Dt_StockInfoDetail>()
+ .Includes(x => x.StockInfo)
+ .Where(x => x.MaterielCode == materielCode && x.StockQuantity > x.OutboundQuantity);
+
+ if (!string.IsNullOrEmpty(batchNo))
{
- var stockSort = Db.Queryable<Dt_StockInfo>().Where(x => locationCodes.Contains(x.LocationCode)).Includes(x => x.Details).Where(x => x.Details.Any(v => v.MaterielCode == materielCode && v.BatchNo == lotNo)).ToList();
- stockInfos = stockSort.OrderBy(x => x.Details.FirstOrDefault()?.EffectiveDate).ThenBy(x => x.Details.Sum(v => v.StockQuantity)).ToList();
- }
- else
- {
- var stockSort = Db.Queryable<Dt_StockInfo>().Where(x => locationCodes.Contains(x.LocationCode)).Includes(x => x.Details).Where(x => x.Details.Any(v => v.MaterielCode == materielCode)).ToList();
- stockInfos = stockSort.OrderBy(x => x.Details.FirstOrDefault()?.EffectiveDate).ThenBy(x => x.Details.Sum(v => v.StockQuantity)).ToList();
+ query = query.Where(x => x.BatchNo == batchNo);
}
- return stockInfos;
+ return await query.OrderBy(x => x.ProductionDate).ToListAsync();
+ }
+ public List<Dt_StockInfo> GetStockInfos(string materielCode, string lotNo, List<string> locationCodes)
+ {
+ var query = Db.Queryable<Dt_StockInfo>()
+ .Where(x => locationCodes.Contains(x.LocationCode)
+ // && x.StockStatus == (int)StockStatusEmun.姝ｅ父)
+ ).Includes(x => x.Details);
+
+ if (!string.IsNullOrEmpty(materielCode))
+ {
+ query = query.Where(x => x.Details.Any(d => d.MaterielCode == materielCode));
+ }
+
+ if (!string.IsNullOrEmpty(lotNo))
+ {
+ query = query.Where(x => x.Details.Any(d => d.BatchNo == lotNo));
+ }
+
+ var stocks = query.ToList();
+
+ return stocks.OrderBy(x => x.Details.Where(d => d.MaterielCode == materielCode &&
+ (string.IsNullOrEmpty(lotNo) || d.BatchNo == lotNo)).Min(d => d.ProductionDate)).ToList();
//ISugarQueryable<Dt_LocationInfo> sugarQueryable = Db.Queryable<Dt_LocationInfo>().Where(x => locationCodes.Contains(x.LocationCode));
//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).OrderBy(a => a.CreateDate).Includes(a => a.Details).ToList();
@@ -173,5 +210,11 @@
return GetStockInfos(materielCode, batchNo, locationCodes);
}
+
+ public Dt_StockInfo GetPalletStockInfo(int locationType)
+ {
+
+ return Db.Queryable<Dt_StockInfo>().Where(x => x.StockStatus == StockStatusEmun.鍏ュ簱瀹屾垚.ObjToInt() && SqlFunc.Subqueryable<Dt_LocationInfo>().Where(v => v.LocationCode == x.LocationCode && v.LocationType == locationType && v.LocationStatus == LocationStatusEnum.Pallet.ObjToInt() && (v.EnableStatus == EnableStatusEnum.OnlyOut.ObjToInt() || EnableStatusEnum.Normal.ObjToInt() == v.EnableStatus)).Any()).OrderBy(x => x.ModifyDate).First();
+ }
}
}
--
Gitblit v1.9.3