From 89051aef8a2c1a85d457914cf6317fe70e0e321c Mon Sep 17 00:00:00 2001 From: hutongqing <hutongqing@hnkhzn.com> Date: 星期日, 29 十二月 2024 04:33:10 +0800 Subject: [PATCH] 1 --- 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/OutboundOrderService.cs | 173 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 167 insertions(+), 6 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/OutboundOrderService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/OutboundOrderService.cs" index fa29aa5..7db7c96 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/OutboundOrderService.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_OutboundService/OutboundOrderService.cs" @@ -1,6 +1,8 @@ 锘縰sing AutoMapper; +using MailKit.Search; using Newtonsoft.Json; using Newtonsoft.Json.Serialization; +using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime; using System; using System.Collections.Generic; using System.Linq; @@ -8,7 +10,10 @@ using System.Text; using System.Threading.Tasks; using WIDESEA_Common.OrderEnum; +using WIDESEA_Common.StockEnum; +using WIDESEA_Common.WareHouseEnum; using WIDESEA_Core; +using WIDESEA_Core.BaseRepository; using WIDESEA_Core.BaseServices; using WIDESEA_Core.Enums; using WIDESEA_Core.Helper; @@ -16,9 +21,12 @@ using WIDESEA_DTO.ERP; using WIDESEA_DTO.Inbound; using WIDESEA_DTO.Outbound; +using WIDESEA_External.ERPService; +using WIDESEA_External.Model; using WIDESEA_IBasicService; using WIDESEA_IOutboundRepository; using WIDESEA_IOutboundService; +using WIDESEA_IStockRepository; using WIDESEA_IStockService; using WIDESEA_Model.Models; @@ -27,16 +35,26 @@ public class OutboundOrderService : ServiceBase<Dt_OutboundOrder, IOutboundOrderRepository>, IOutboundOrderService { private readonly IMapper _mapper; + private readonly IUnitOfWorkManage _unitOfWorkManage; private readonly IBasicService _basicService; private readonly IOutboundOrderDetailRepository _outboundOrderDetailRepository; - + private readonly IStockInfoService _stockInfoService; + private readonly IStockInfoRepository _stockInfoRepository; public IOutboundOrderRepository Repository => BaseDal; + private readonly IInvokeERPService _invokeERPService; + private readonly IOutStockLockInfoService _outStockLockInfoService; - public OutboundOrderService(IOutboundOrderRepository BaseDal, IMapper mapper, IBasicService basicService, IOutboundOrderDetailRepository outboundOrderDetailRepository) : base(BaseDal) + public OutboundOrderService(IOutboundOrderRepository BaseDal, IMapper mapper,IUnitOfWorkManage unitOfWorkManage, IBasicService basicService, IOutboundOrderDetailRepository outboundOrderDetailRepository, IStockInfoService stockInfoService, + IStockInfoRepository stockInfoRepository, IInvokeERPService invokeERPService, IOutStockLockInfoService outStockLockInfoService) : base(BaseDal) { _mapper = mapper; + _unitOfWorkManage = unitOfWorkManage; _basicService = basicService; _outboundOrderDetailRepository = outboundOrderDetailRepository; + _stockInfoService = stockInfoService; + _stockInfoRepository = stockInfoRepository; + _invokeERPService = invokeERPService; + _outStockLockInfoService = outStockLockInfoService; } public WebResponseContent ReceiveOutOrder(ErpOutOrderDTO model) @@ -81,7 +99,6 @@ OrderQuantity = model.Qty, OrderId = oldOutboundOrder.Id }; - _outboundOrderDetailRepository.AddData(outboundOrderDetail); } } @@ -96,17 +113,18 @@ OrderDetailStatus = OrderDetailStatusEnum.New.ObjToInt(), OrderQuantity = model.Qty, }; - Dt_OutboundOrder outboundOrder = new Dt_OutboundOrder() { + OrderNo=model.OrderNo, UpperOrderNo = model.OrderNo, OrderStatus = OutOrderStatusEnum.鏈紑濮�.ObjToInt(), OrderType = OutOrderTypeEnum.Issue.ObjToInt(), CreateType = OrderCreateTypeEnum.UpperSystemPush.ObjToInt(), WarehouseId = warehouse.WarehouseId, + DepartmentCode = model.DepartmentCode, + DepartmentName = model.DepartmentName, Details = new List<Dt_OutboundOrderDetail> { outboundOrderDetail } }; - Db.InsertNav(outboundOrder).Include(x => x.Details).ExecuteCommand(); } } @@ -121,7 +139,7 @@ { return WebResponseContent.Instance.Error($"鏈壘鍒拌鏄庣粏琛屽彿淇℃伅"); } - if(outboundOrderDetail.OrderDetailStatus != OrderDetailStatusEnum.New.ObjToInt()) + if (outboundOrderDetail.OrderDetailStatus != OrderDetailStatusEnum.New.ObjToInt()) { return WebResponseContent.Instance.Error($"璇ユ槑缁嗕笉鍙慨鏀�"); } @@ -137,11 +155,154 @@ _outboundOrderDetailRepository.UpdateData(outboundOrderDetail); } + else if (model.Way == 3) + { + if (oldOutboundOrder == null) + { + return WebResponseContent.Instance.Error($"鏈壘鍒拌鍑哄簱鍗�"); + } + } return WebResponseContent.Instance.OK(); } catch (Exception ex) { + _unitOfWorkManage.RollbackTran(); + return WebResponseContent.Instance.Error(ex.Message); + } + } + //涓婃姤鍑哄簱瀹屾垚 + public WebResponseContent TestOutUpload(int id,Dt_StockInfo stockInfo) + { + try + { + Dt_OutboundOrder outboundOrder = Db.Queryable<Dt_OutboundOrder>().Where(x=>x.Id==id).Includes(x=>x.Details).First(); + Dt_Warehouse warehouse = _basicService.WarehouseService.Repository.QueryFirst(x => x.WarehouseId == outboundOrder.WarehouseId); + //娴嬭瘯鏋跺簱缁橢RP涓婃姤鍑哄簱瀹屾垚 + ERPIssueModel issueModel = new ERPIssueModel(); + List<Dt_StockInfo> stockInfos = new List<Dt_StockInfo>(); + if (stockInfo==null) + { + stockInfos = TestOutStocksUpdate(warehouse).Data as List<Dt_StockInfo> ?? new List<Dt_StockInfo>(); + List<ERPPickItemModel> eRPOutPick =new List<ERPPickItemModel>(); + for (int i = 0; i < stockInfos.Count; i++) + { + ERPPickItemModel pickItemModel = new ERPPickItemModel() + { + Lotno= stockInfos[i].Details[0].BatchNo, + Qty= stockInfos[i].Details[0].StockQuantity.ObjToInt().ToString(), + Location= warehouse.WarehouseCode + }; + eRPOutPick.Add(pickItemModel); + } + + ERPPickModel pickModel = new ERPPickModel() + { + Rowindex = outboundOrder.Details[0].RowNo, + Material = outboundOrder.Details[0].MaterielCode, + Qty = (outboundOrder.Details[0].OrderQuantity.ObjToInt()).ToString(), + Dataitem = eRPOutPick + }; + + ERPIssueItemModel issueItemModel = new ERPIssueItemModel() + { + Pickcode = outboundOrder.UpperOrderNo, + PickList = new List<ERPPickModel>() { pickModel } + }; + issueModel = new ERPIssueModel() + { + UniqueTag = id.ToString(), + Code = outboundOrder.OrderNo,//娴嬭瘯 + WarehouseCode = warehouse.WarehouseCode, + Docremark = "", + Deptno = outboundOrder.DepartmentCode, + Deptname = outboundOrder.DepartmentName, + Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), + Createuser = outboundOrder.Creater, + Issitem = new List<ERPIssueItemModel>() { issueItemModel }, + }; + } + else + { + Dt_OutboundOrderDetail orderDetail = outboundOrder.Details.FirstOrDefault(x => x.MaterielCode == stockInfo.Details[0].MaterielCode); + + ERPPickItemModel pickItemModel = new ERPPickItemModel() + { + Lotno = stockInfo.Details[0].BatchNo, + Qty = stockInfo.Details[0].StockQuantity.ObjToInt().ToString(), + Location = stockInfo.LocationCode + }; + ERPPickModel pickModel = new ERPPickModel() + { + Rowindex = outboundOrder.Details[0].RowNo, + Material = outboundOrder.Details[0].MaterielCode, + Qty = (outboundOrder.Details[0].OrderQuantity.ObjToInt()).ToString(), + Dataitem = new List<ERPPickItemModel> { pickItemModel } + }; + ERPIssueItemModel issueItemModel = new ERPIssueItemModel() + { + Pickcode = outboundOrder.UpperOrderNo, + PickList = new List<ERPPickModel>() { pickModel } + }; + issueModel = new ERPIssueModel() + { + UniqueTag = id.ToString(), + Code = outboundOrder.OrderNo,//娴嬭瘯 + WarehouseCode = warehouse.WarehouseCode, + Docremark = "", + Deptno = outboundOrder.DepartmentCode, + Deptname = outboundOrder.DepartmentName, + Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), + Createuser = outboundOrder.Creater, + Issitem = new List<ERPIssueItemModel>() { issueItemModel }, + }; + } + + string response = _invokeERPService.InvokeOutStandardsApi(issueModel); + ErpRequestContent requestContent = response.DeserializeObject<ErpRequestContent>(); + if (requestContent.res == 1) + { + if (stockInfos.Count>0) + { + _stockInfoRepository.UpdateData(stockInfos); + } + return WebResponseContent.Instance.OK(requestContent.Data); + } + else + { + return WebResponseContent.Instance.Error(requestContent.Data); + } + } + catch (Exception ex) + { + return WebResponseContent.Instance.Error(ex.Message); + } + } + /// <summary> + /// 鏇存敼鍑哄簱鍗曞簱瀛樼姸鎬� + /// </summary> + /// <param name="warehouse"></param> + /// <param name="model"></param> + /// <returns></returns> + public WebResponseContent TestOutStocksUpdate(Dt_Warehouse warehouse) + { + try + { + //鑾峰彇鍑哄簱鍗曞簱瀛� + List<Dt_StockInfo> stockInfos = _stockInfoRepository.Db.Queryable<Dt_StockInfo>().Where(x => x.WarehouseId == warehouse.WarehouseId).Includes(x => x.Details).ToList(); + if (stockInfos.Count<=0) + { + return WebResponseContent.Instance.Error($"搴撳瓨涓嶈冻"); + } + //鏇存敼鐘舵�� + stockInfos.ForEach(x => + { + x.StockStatus = StockStatusEmun.鍏ュ簱瀹屾垚.ObjToInt(); + }); + return WebResponseContent.Instance.OK("鎴愬姛", stockInfos); + } + catch (Exception ex) + { return WebResponseContent.Instance.Error(ex.Message); } } -- Gitblit v1.9.3