From c72afdd7ece074901405158fce8df69ee56cd36e Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期日, 12 一月 2025 19:24:49 +0800
Subject: [PATCH] WMS添加指定平库出库功能

---
 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs |   43 +++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 43 insertions(+), 0 deletions(-)

diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs"
index 47bcaf4..0e31f7b 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_StockService/StockInfoService.cs"
@@ -37,6 +37,12 @@
             _outboundRepository = outboundRepository;
         }
 
+        /// <summary>
+        /// 鏌ヨ璁㈠崟绔嬪簱搴撳瓨瑙嗗浘
+        /// </summary>
+        /// <param name="orderId"></param>
+        /// <param name="materielCode"></param>
+        /// <returns></returns>
         public List<StockSelectViewDTO> GetStockSelectViews(int orderId, string materielCode)
         {
             try
@@ -71,6 +77,43 @@
             }
 
         }
+        /// <summary>
+        /// 鏌ヨ璁㈠崟骞冲簱搴撳瓨瑙嗗浘
+        /// </summary>
+        /// <param name="orderId"></param>
+        /// <param name="materielCode"></param>
+        /// <returns></returns>
+        public List<StockSelectViewDTO> GetPKStockSelectViews(int orderId, string materielCode)
+        {
+            try
+            {
+                Dt_OutboundOrder outboundOrder = _outboundRepository.OutboundOrderRepository.QueryFirst(x => x.Id == orderId);
+                if (outboundOrder == null)
+                {
+                    throw new Exception($"鏈壘鍒板嚭搴撳崟淇℃伅");
+                }
+                return BaseDal.QueryTabs<Dt_StockInfo, Dt_StockInfoDetail, StockSelectViewDTO>((a, b) => a.Id == b.StockId && a.WarehouseId == outboundOrder.WarehouseId, (a, b) => new StockSelectViewDTO
+                {
+                    LocationCode = a.LocationCode,
+                    MaterielCode = b.MaterielCode,
+                    MaterielName = b.MaterielName,
+                    PalletCode = a.PalletCode,
+                    UseableQuantity = b.StockQuantity - b.OutboundQuantity
+                }, a => a.LocationCode == "骞冲簱浣�", b => b.StockQuantity > b.OutboundQuantity && b.MaterielCode == materielCode, x => true).GroupBy(x => x.PalletCode).Select(x => new StockSelectViewDTO
+                {
+                    LocationCode = x.FirstOrDefault()?.LocationCode ?? "",
+                    MaterielCode = x.FirstOrDefault()?.MaterielCode ?? "",
+                    MaterielName = x.FirstOrDefault()?.MaterielName ?? "",
+                    PalletCode = x.Key,
+                    UseableQuantity = x.Sum(x => x.UseableQuantity)
+                }).ToList();
+            }
+            catch (Exception ex)
+            {
+                return null;
+            }
+        }
+
         public WebResponseContent StockQueryData(SaveModel saveModel)
         {
             try

--
Gitblit v1.9.3