From 63d187526792e6e29bfec07d0e3f0dce07df31b3 Mon Sep 17 00:00:00 2001 From: helongyang <647556386@qq.com> Date: 星期六, 19 七月 2025 17:32:41 +0800 Subject: [PATCH] 成品报废单新增优化 --- 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/ProOutOrderDetailService.cs | 114 +++++++++++++++++++++++++------------------------------- 1 files changed, 51 insertions(+), 63 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/ProOutOrderDetailService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/ProOutOrderDetailService.cs" index 1941997..cb4e9f8 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/ProOutOrderDetailService.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/ProOutOrderDetailService.cs" @@ -4,6 +4,8 @@ using System.Text; using System.Threading.Tasks; using WIDESEA_Common.LocationEnum; +using WIDESEA_Common.OrderEnum; +using WIDESEA_Common.StockEnum; using WIDESEA_Core; using WIDESEA_Core.BaseRepository; using WIDESEA_Core.BaseServices; @@ -14,6 +16,7 @@ using WIDESEA_IRecordService; using WIDESEA_IStockService; using WIDESEA_Model.Models; +using WIDESEA_OutboundRepository; namespace WIDESEA_OutboundService { @@ -25,14 +28,16 @@ private readonly IStockService _stockInfoService; private readonly IBasicService _basicService; private readonly IOutProStockInfoService _outProStockInfoService; + private readonly IProOutOrderRepository _proOutOrderRepository; private readonly IRecordService _recordService; - public ProOutOrderDetailService(IProOutOrderDetailRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, IStockService stockInfoService, IBasicService basicService,IOutProStockInfoService outProStockInfoService, IRecordService recordService) : base(BaseDal) + public ProOutOrderDetailService(IProOutOrderDetailRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, IStockService stockInfoService, IBasicService basicService,IOutProStockInfoService outProStockInfoService, IRecordService recordService, IProOutOrderRepository proOutOrderRepository) : base(BaseDal) { _unitOfWorkManage = unitOfWorkManage; _stockInfoService = stockInfoService; _basicService = basicService; _outProStockInfoService = outProStockInfoService; _recordService = recordService; + _proOutOrderRepository=proOutOrderRepository; } /// <summary> /// 鍑哄簱搴撳瓨鍒嗛厤鍚庯紝鏇存柊鏁版嵁搴撴暟鎹� @@ -41,13 +46,22 @@ { try { + //鏇存柊搴撳瓨灞炴�� _stockInfoService.ProStockInfoService.Repository.UpdateData(proStockInfos); List<Dt_ProStockInfoDetail> proStockInfoDetails = new List<Dt_ProStockInfoDetail>(); foreach (var item in proStockInfos) { proStockInfoDetails.AddRange(item.proStockInfoDetails); } + //鏇存柊搴撳瓨鏄庣粏 + proStockInfoDetails.ForEach(x => x.ProOutDetailStatus = StockStatusEmun.鍑哄簱閿佸畾.ObjToInt()); _stockInfoService.ProStockInfoDetailService.Repository.UpdateData(proStockInfoDetails); + Dt_ProOutOrder proOutOrder = _proOutOrderRepository.QueryFirst(x => x.Id == proOutOrderDetails.FirstOrDefault().ProOrderId); + if (proOutOrder.ProOrderStatus == OutOrderStatusEnum.鏈紑濮�.ObjToInt()) + { + proOutOrder.ProOrderStatus = OutOrderStatusEnum.鍑哄簱涓�.ObjToInt(); + _proOutOrderRepository.UpdateData(proOutOrder); + } BaseDal.UpdateData(proOutOrderDetails); List<Dt_OutProStockInfo> addOutStockLockInfos = outProStockInfos.Where(x => x.Id == 0).ToList(); @@ -81,30 +95,22 @@ /// <summary> /// 鍒嗛厤搴撳瓨澶勭悊璐т綅鏁版嵁 /// </summary> - public (List<Dt_ProStockInfo>, List<Dt_ProOutOrderDetail>, List<Dt_OutProStockInfo>, List<Dt_LocationInfo>) AssignProStockOut(int warehouseId, Dt_ProOutOrder proOutOrder) + public (List<Dt_ProStockInfo>, List<Dt_ProOutOrderDetail>, List<Dt_OutProStockInfo>, List<Dt_LocationInfo>) AssignProStockOut(List<Dt_ProOutOrderDetail> proOutOrderDetails) { - List<Dt_ProOutOrderDetail> OutOrderDetails = proOutOrder.Details; - if (!OutOrderDetails.Any()) - { - throw new Exception($"鏈壘鍒板嚭搴撳崟鏄庣粏淇℃伅"); - } List<Dt_ProStockInfo> outStocks = new List<Dt_ProStockInfo>(); List<Dt_OutProStockInfo> outProStockInfos = new List<Dt_OutProStockInfo>(); List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>(); - List<Dt_ProOutOrderDetail> groupDetails = OutOrderDetails.GroupBy(x => new { x.SaleOrder, x.PCode, x.PVer, x.PLot, x.DateCode }).Select(x => new Dt_ProOutOrderDetail() + //鑾峰彇鎴愬搧璁㈠崟 + Dt_ProOutOrder proOutOrder = _proOutOrderRepository.QueryFirst(x=>x.Id==proOutOrderDetails.FirstOrDefault().ProOrderId); + if (proOutOrder==null) { - QtyPcs = x.Sum(x => x.QtyPcs) - x.Sum(x => x.OverQtyPcs), - SaleOrder = x.Key.SaleOrder, - PCode = x.Key.PCode, - PVer = x.Key.PVer, - PLot = x.Key.PLot, - DateCode = x.Key.DateCode, - }).ToList(); - foreach (var item in groupDetails) + throw new Exception("鏈壘鍒版垚鍝佽鍗�"); + } + foreach (var item in proOutOrderDetails) { float needQty = item.QtyPcs; //鏌ユ壘鍙敤搴撳瓨 - List<Dt_ProStockInfo> stockInfoss = _stockInfoService.ProStockInfoService.GetUseableStocks(warehouseId, item); + List<Dt_ProStockInfo> stockInfoss = _stockInfoService.ProStockInfoService.GetUseableStocks(proOutOrder.WarehouseId, item); if (!stockInfoss.Any()) { throw new Exception("鏈壘鍒板彲鍒嗛厤搴撳瓨"); @@ -112,53 +118,35 @@ //鑾峰彇鍑哄簱搴撳瓨 List<Dt_ProStockInfo> assignOutStocks = _stockInfoService.ProStockInfoService.GetOutboundStocks(stockInfoss, item, needQty, out float residueQuantity); item.LockQtyPcs += needQty - residueQuantity; - outStocks.AddRange(assignOutStocks); - float assignQuantity = needQty - residueQuantity; - bool isCanLot = !string.IsNullOrEmpty(item.PLot); - bool isCanDate = !string.IsNullOrEmpty(item.DateCode); - List<Dt_ProOutOrderDetail> details = OutOrderDetails - .Where(x => x.SaleOrder == item.SaleOrder && x.PCode == item.PCode && x.PVer == item.PVer - && (isCanLot ? x.PLot == item.PLot : true) - && (isCanDate ? x.DateCode == item.DateCode : true)) - .ToList(); - - for (int i = 0; i < details.Count; i++) + if (item.QtyPcs > item.LockQtyPcs) { - float orderQuantity = details[i].QtyPcs; - for (int j = 0; j < assignOutStocks.Count; j++) + throw new Exception($"浜у搧缂栫爜{item.PCode},鐗堟湰{item.PVer.Substring(0, 1)}鍙垎閰嶆暟閲忎笉瓒�,鍙敤鏁伴噺{item.LockQtyPcs}"); + } + outStocks.AddRange(assignOutStocks); + //鍒嗛厤鍑哄簱鐨凱CS鏁伴噺 + float assignQuantity = needQty; + //璁㈠崟鏄庣粏鐨勫嚭搴揚CS鏁伴噺 + float orderQuantity = item.QtyPcs; + for (int j = 0; j < assignOutStocks.Count; j++) + { + //鍑哄簱璁㈠崟鏄庣粏宸插垎閰嶆暟閲� + float detailAssignQuantity = outProStockInfos.Where(x => x.OrderDetailId == item.Id).Sum(x => x.AssignQuantity); + + + float orderDetailNeedQuantity = item.QtyPcs - detailAssignQuantity; + //鐢熸垚鍑哄簱璇︽儏 + if (orderDetailNeedQuantity > assignOutStocks[j].proStockInfoDetails.Sum(x => x.OutboundQuantity)) { - float detailAssignQuantity = outProStockInfos.Where(x => x.SaleOrder == item.SaleOrder && x.PCode == item.PCode && x.PVer == item.PVer - && (item.PLot.IsNotEmptyOrNull() ? x.PLot == item.PLot : false) - && (item.DateCode.IsNotEmptyOrNull() ? x.DateCode == item.PLot : false) - && x.OrderDetailId == details[i].Id).Sum(x => x.AssignQuantity);//鍑哄簱璁㈠崟鏄庣粏宸插垎閰嶆暟閲� - - float palletAssignQuantity = outProStockInfos.Where(x => x.SaleOrder == item.SaleOrder && x.PCode == item.PCode && x.PVer == item.PVer - && (item.PLot.IsNotEmptyOrNull() ? x.PLot == item.PLot : false) - && (item.DateCode.IsNotEmptyOrNull() ? x.DateCode == item.PLot : false - && x.PalletCode == assignOutStocks[j].PalletCode)).Sum(x => x.AssignQuantity); - //鍑哄簱璇︽儏宸插垎閰嶆暟閲� - palletAssignQuantity = outProStockInfos.Where(x => x.SaleOrder == item.SaleOrder && x.PCode == item.PCode && x.PVer == item.PVer - && (item.PLot.IsNotEmptyOrNull() ? x.PLot == item.PLot : false) - && (item.DateCode.IsNotEmptyOrNull() ? x.DateCode == item.PLot : false && x.PalletCode == assignOutStocks[j].PalletCode)).Sum(x => x.AssignQuantity);//鍑哄簱璇︽儏宸插垎閰嶆暟閲� - float palletOutboundQuantity = assignOutStocks[j].proStockInfoDetails.Sum(x => x.OutboundQuantity); - if (palletAssignQuantity < palletOutboundQuantity)//濡傛灉鍑哄簱璇︽儏宸插垎閰嶆暟閲忓皬浜庢墭鐩樺凡鍒嗛厤鏁伴噺锛屽垯鍙互缁х画娣诲姞璇ユ墭鐩樺嚭搴撲俊鎭� - { - float orderDetailNeedQuantity = details[i].QtyPcs - detailAssignQuantity; - if (orderDetailNeedQuantity > assignOutStocks[j].proStockInfoDetails.Sum(x => x.OutboundQuantity) - palletAssignQuantity) - { - details[i].LockQtyPcs += assignOutStocks[j].proStockInfoDetails.Sum(x => x.OutboundQuantity) - palletAssignQuantity; - Dt_OutProStockInfo outStockLockInfo = _outProStockInfoService.GetOutStockLockInfo(proOutOrder, details[i], assignOutStocks[j], assignOutStocks[j].proStockInfoDetails.Sum(x => x.OutboundQuantity) - palletAssignQuantity); - outProStockInfos.Add(outStockLockInfo); - } - else - { - Dt_OutProStockInfo outStockLockInfo = _outProStockInfoService.GetOutStockLockInfo(proOutOrder, details[i], assignOutStocks[j], details[i].QtyPcs - details[i].LockQtyPcs); - outProStockInfos.Add(outStockLockInfo); - details[i].LockQtyPcs = details[i].QtyPcs; - break; - } - - } + item.LockQtyPcs += assignOutStocks[j].proStockInfoDetails.Sum(x => x.OutboundQuantity); + Dt_OutProStockInfo outStockLockInfo = _outProStockInfoService.GetOutStockLockInfo(proOutOrder, item, assignOutStocks[j], assignOutStocks[j].proStockInfoDetails.Sum(x => x.OutboundQuantity)); + outProStockInfos.Add(outStockLockInfo); + } + else + { + Dt_OutProStockInfo outStockLockInfo = _outProStockInfoService.GetOutStockLockInfo(proOutOrder, item, assignOutStocks[j], item.QtyPcs - detailAssignQuantity); + outProStockInfos.Add(outStockLockInfo); + item.LockQtyPcs = item.QtyPcs; + break; } } List<string> locationArr = outStocks.Select(x => x.LocationCode).ToList(); @@ -166,7 +154,7 @@ locationInfos.AddRange(_basicService.LocationInfoService.Repository.GetLocationInfos(locationArr)); } - return (outStocks, OutOrderDetails, outProStockInfos, locationInfos); + return (outStocks, proOutOrderDetails, outProStockInfos, locationInfos); } } } -- Gitblit v1.9.3