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