From 39ee9078d88fd4787437360e7f69ed999aaf0b7b Mon Sep 17 00:00:00 2001 From: wangxinhui <wangxinhui@hnkhzn.com> Date: 星期六, 28 十二月 2024 09:14:41 +0800 Subject: [PATCH] 更新代码 --- 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_InboundService/InboundOrderService.cs | 203 ++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 152 insertions(+), 51 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_InboundService/InboundOrderService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_InboundService/InboundOrderService.cs" index c34d2ff..2363716 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_InboundService/InboundOrderService.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_InboundService/InboundOrderService.cs" @@ -21,6 +21,7 @@ using WIDESEA_Core.Utilities; using WIDESEA_DTO; using WIDESEA_DTO.Basic; +using WIDESEA_DTO.ERP; using WIDESEA_DTO.Inbound; using WIDESEA_External.ERPService; using WIDESEA_External.Model; @@ -61,6 +62,46 @@ _invokeERPService = invokeERPService; _warehouseService = warehouseService; } + /// <summary> + /// 鍏朵粬鍏ュ簱鍗曞垱寤� + /// </summary> + /// <returns></returns> + public WebResponseContent ReceiveWarehousingOrder(ErpInOrderDTO erpInOrder) + { + WebResponseContent content = new WebResponseContent(); + try + { + //鑾峰彇浠撳簱淇℃伅 + Dt_Warehouse warehouse = _warehouseService.Repository.QueryFirst(x=>x.WarehouseCode==erpInOrder.WaId); + if (warehouse==null) + { + return content.Error("鏈壘鍒颁粨搴撲俊鎭�"); + } + //鑾峰彇鏄惁瀛樺湪璁㈠崟 + Dt_InboundOrder inboundOrder = BaseDal.QueryFirst(x=>x.InboundOrderNo== erpInOrder.OrderNo); + if (erpInOrder.Way==1) + { + if (inboundOrder!=null) + { + + } + } + else if(erpInOrder.Way==2) + { + + } + else + { + + } + return content.OK(); + } + catch (Exception ex) + { + content.Error(ex.Message); + } + return content; + } public WebResponseContent GetInboundOrders(SaveModel saveModel) { WebResponseContent content = new WebResponseContent(); @@ -87,7 +128,13 @@ } return content; } - + /// <summary> + /// 鍗曚釜鐗╂枡鐮佺粍鐩� 閫傜敤娴嬭瘯鏋� + /// </summary> + /// <param name="inboundOrderId"></param> + /// <param name="palletCode"></param> + /// <param name="serNum"></param> + /// <returns></returns> public WebResponseContent MaterielGroup(int inboundOrderId, string palletCode, string serNum) { try @@ -97,60 +144,76 @@ { return WebResponseContent.Instance.Error($"鏈壘鍒板叆搴撳崟淇℃伅"); } - if (inboundOrder.Details == null || inboundOrder.Details.Count <= 0) + if (inboundOrder.OrderStatus>=InOrderStatusEnum.鍏ュ簱瀹屾垚.ObjToInt()) + { + return WebResponseContent.Instance.Error($"鍏ュ簱鍗曞凡缁撴潫"); + } + if (inboundOrder.Details.Count <= 0) { return WebResponseContent.Instance.Error($"鏈壘鍒板叆搴撳崟鏄庣粏淇℃伅"); } - - Dt_ReceiveOrder receiveOrder = _inboundRepository.ReceiveOrderRepository.Db.Queryable<Dt_ReceiveOrder>().Where(x => x.ReceiveOrderNo == inboundOrder.UpperOrderNo).Includes(x => x.Details).First(); - if (receiveOrder == null) + MatSerNumAnalysisModel model = new MatSerNumAnalysisModel() { - return WebResponseContent.Instance.Error($"鏈壘鍒板搴旂殑鏀惰揣鍗�"); - } - if (receiveOrder.Details == null || receiveOrder.Details.Count <= 0) - { - return WebResponseContent.Instance.Error($"鏈壘鍒板搴旂殑鏀惰揣鍗曟槑缁�"); - } - - List<string> purchaseOrderNos = receiveOrder.Details.Select(x => x.PurchaseOrderNo).ToList(); - - MatSerNumAnalysisModel model = CodeAnalysisHelper.CodeAnalysis<MatSerNumAnalysisModel>(AnalysisCodeEnum.MatSerNumAnalysis, serNum); - - List<Dt_InboundOrderDetail> inboundOrderDetails = inboundOrder.Details.Where(x => x.MaterielCode == model.MaterielCode).ToList(); - - if (inboundOrderDetails == null || inboundOrderDetails.Count <= 0) - { - return WebResponseContent.Instance.Error($"鏈湪鍏ュ簱鍗曟槑缁嗕腑鎵惧埌璇ョ墿鏂欎俊鎭�"); - } - if (receiveOrder.Details.FirstOrDefault(x => x.MaterielCode == model.MaterielCode) == null) - { - return WebResponseContent.Instance.Error($"鏈湪鏀惰揣鍗曟槑缁嗕腑鎵惧埌璇ョ墿鏂欎俊鎭�"); - } - if (purchaseOrderNos.FirstOrDefault(x => x == model.PurchaseOrderNo) == null) - { - return WebResponseContent.Instance.Error($"鏈湪鏀惰揣鍗曟槑缁嗕腑鎵惧埌璇ラ噰璐崟"); - } - - Dt_InboundOrderDetail? notGroupDetail = inboundOrderDetails.Where(x => x.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt() && x.OrderQuantity == model.Quantity).FirstOrDefault(); - - if (notGroupDetail == null) - { - return WebResponseContent.Instance.Error($"璇ョ墿鏂欏湪璇ュ叆搴撳崟涓凡鍏ㄩ儴缁勭洏瀹屾垚"); - } - + MaterielCode = "504907335", + LotNo = "20241217001", + ProductionDate = "2024-12-17", + EffectiveDate = "2025-12-17", + PurchaseOrderNo = "POHA02241227285", + Quantity = 1, + SerialNumber = "M:504907335,BS:20241217001,DM:2024-12-17,DE:2025-12-17,Q:1,PO:POHA02241227285" + };//娴嬭瘯 + //CodeAnalysisHelper.CodeAnalysis<MatSerNumAnalysisModel>(AnalysisCodeEnum.MatSerNumAnalysis, serNum); Dt_MaterielInfo materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterielCode == model.MaterielCode); if (materielInfo == null) { return WebResponseContent.Instance.Error($"鏈壘鍒拌鐗╂枡鐨勪俊鎭�"); } - - Dt_StockInfo stockInfo = new Dt_StockInfo() + if (materielInfo.WarehouseId != inboundOrder.WarehouseId) { - PalletCode = palletCode, - StockStatus = StockStatusEmun.缁勭洏鏆傚瓨.ObjToInt(), - WarehouseId = inboundOrder.WarehouseId - }; - + return WebResponseContent.Instance.Error($"璇ョ墿鏂欎笉灞炰簬鏈粨"); + } + Dt_ReceiveOrder receiveOrder = _inboundRepository.ReceiveOrderRepository.Db.Queryable<Dt_ReceiveOrder>().Where(x => x.ReceiveOrderNo == inboundOrder.UpperOrderNo).Includes(x => x.Details).First(); + if (receiveOrder == null) + { + return WebResponseContent.Instance.Error($"鏈壘鍒板搴旂殑鏀惰揣鍗�"); + } + if (receiveOrder.Details.Count <= 0) + { + return WebResponseContent.Instance.Error($"鏈壘鍒板搴旂殑鏀惰揣鍗曟槑缁�"); + } + List<string> purchaseOrderNos = receiveOrder.Details.Select(x => x.PurchaseOrderNo).ToList(); + if (!purchaseOrderNos.Contains(model.PurchaseOrderNo)) + { + return WebResponseContent.Instance.Error($"鏈壘鍒板搴旀敹璐у崟鏄庣粏涓噰璐崟"); + } + Dt_ReceiveOrderDetail? receiveOrderDetail = receiveOrder.Details.FirstOrDefault(x => x.MaterielCode == model.MaterielCode); + if (receiveOrderDetail == null) + { + return WebResponseContent.Instance.Error($"鏈湪鏀惰揣鍗曟槑缁嗕腑鎵惧埌璇ョ墿鏂欎俊鎭�"); + } + Dt_InboundOrderDetail? inboundOrderDetail = inboundOrder.Details.FirstOrDefault(x => x.MaterielCode == model.MaterielCode); + if (inboundOrderDetail == null) + { + return WebResponseContent.Instance.Error($"鏈湪鍏ュ簱鍗曟槑缁嗕腑鎵惧埌璇ョ墿鏂欎俊鎭�"); + } + if (inboundOrderDetail.OrderDetailStatus>OrderDetailStatusEnum.GroupAndInbound.ObjToInt()) + { + return WebResponseContent.Instance.Error($"瀵瑰簲鍏ュ簱鍗曟槑缁嗗凡缁撴潫"); + } + float inboundDetailSum = inboundOrderDetail.OverInQuantity + inboundOrderDetail.ReceiptQuantity ; + if (inboundDetailSum == inboundOrderDetail.OrderQuantity) + { + return WebResponseContent.Instance.Error($"璇ョ墿鏂欏叆搴撳崟鏄庣粏宸插叏閮ㄧ粍鐩樺畬鎴�"); + } + if (model.Quantity > receiveOrderDetail.ReceivedQuantity || (inboundDetailSum + model.Quantity) > receiveOrderDetail.ReceivedQuantity) + { + return WebResponseContent.Instance.Error($"涓庤鏀惰揣鍗曟槑缁嗘敹璐ф暟閲忎笉涓�鑷�"); + } + Dt_StockInfo oldStockinfo = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == palletCode); + if(oldStockinfo!=null) + { + return WebResponseContent.Instance.Error($"鎵樼洏閲嶅"); + } Dt_StockInfoDetail stockInfoDetail = new Dt_StockInfoDetail() { BatchNo = model.LotNo, @@ -163,16 +226,35 @@ Status = StockStatusEmun.缁勭洏鏆傚瓨.ObjToInt(), ProductionDate = model.ProductionDate, EffectiveDate = model.EffectiveDate, - InboundOrderRowNo = notGroupDetail.RowNo, + InboundOrderRowNo = inboundOrderDetail.RowNo, }; + Dt_StockInfo stockInfo = new Dt_StockInfo() + { + PalletCode = palletCode, + StockStatus = StockStatusEmun.缁勭洏鏆傚瓨.ObjToInt(), + WarehouseId = inboundOrder.WarehouseId, + Details=new List<Dt_StockInfoDetail> { stockInfoDetail } + }; + inboundOrderDetail.ReceiptQuantity += model.Quantity; + _unitOfWorkManage.BeginTran(); + if (inboundOrderDetail.OrderDetailStatus==OrderDetailStatusEnum.New.ObjToInt()) + { + inboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.GroupAndInbound.ObjToInt(); + } + _inboundRepository.InboundOrderDetailRepository.UpdateData(inboundOrderDetail); + if (inboundOrder.OrderStatus == InOrderStatusEnum.鏈紑濮�.ObjToInt()) + { + inboundOrder.OrderStatus = InOrderStatusEnum.鍏ュ簱涓�.ObjToInt(); + BaseDal.UpdateData(inboundOrder); + } _stockRepository.StockInfoRepository.Db.InsertNav(stockInfo).Include(x => x.Details).ExecuteCommand(); - _inboundRepository.InboundOrderDetailRepository.UpdateData(inboundOrderDetails); - + _unitOfWorkManage.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { + _unitOfWorkManage.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } @@ -341,6 +423,7 @@ } return content; } + public WebResponseContent MaterielGroup(int inboundOrderId, string palletCode, List<string> serNums) { try @@ -484,7 +567,25 @@ return WebResponseContent.Instance.Error(ex.Message); } } + public WebResponseContent FeedbackInboundOrder(Dt_StockInfo stockInfo) + { + WebResponseContent content=new WebResponseContent(); + try + { + } + catch (Exception ex) + { + content.Error(ex.Message); + } + return content; + } + + /// <summary> + /// 鍏ュ簱瀹屾垚鍥炰紶鍒癊RP 娴嬭瘯 + /// </summary> + /// <param name="id"></param> + /// <returns></returns> public WebResponseContent FeedbackInboundOrder(int id) { try @@ -547,9 +648,9 @@ ERPInboundModel model = new ERPInboundModel() { Code = inboundOrder.InboundOrderNo, - CreatorCode = inboundOrder.Creater, - EndDate = inboundOrder.CreateDate.ToString(), - StockDate = inboundOrder.CreateDate.ToString(), + CreatorCode = "TC20082",//娴嬭瘯 + EntDate = inboundOrder.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"), + StockDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), SuppliersId = inboundOrder.SupplierId, Type = "S", UniqueTag = inboundOrder.Id.ToString(), -- Gitblit v1.9.3