From 950fac9fd7b9477fc2bbe3253d217f62ac7608e5 Mon Sep 17 00:00:00 2001 From: wxw <Administrator@DESKTOP-5BIMHQ3> Date: 星期一, 21 七月 2025 17:01:21 +0800 Subject: [PATCH] SAP接口开发 --- Wms/WMS.BLL/HttpServer.cs | 67 ++++++++++++++++++++------------- 1 files changed, 41 insertions(+), 26 deletions(-) diff --git a/Wms/WMS.BLL/HttpServer.cs b/Wms/WMS.BLL/HttpServer.cs index 55e1e9a..f7fbbc3 100644 --- a/Wms/WMS.BLL/HttpServer.cs +++ b/Wms/WMS.BLL/HttpServer.cs @@ -1763,9 +1763,9 @@ { throw new Exception("鍌ㄤ綅鎹熷潖涓嶈兘鍑哄簱"); } - if (locate.WareHouseNo != "W02") + if (locate.WareHouseNo != "W02" && locate.WareHouseNo != "W04") { - throw new Exception("鎵樼洏涓嶅湪璐ф灦搴撲笂"); + throw new Exception("鎵樼洏涓嶅湪璐ф灦搴撲笂涔熶笉鍦ㄥ钩搴�"); } var locateEnd = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == outModeLocate && m.IsDel == "0");//褰撳墠鍑哄簱鐨勭洰鏍囧偍浣嶄俊鎭� if (locateEnd == null) @@ -1778,11 +1778,16 @@ if (logEnd != null && logEnd.PalletNo != palletNo) { throw new Exception("鐩爣鍌ㄤ綅鐘舵�佷笉鏄┖鍌ㄤ綅"); - } + } + var detailEnd = Db.Queryable<DataStockDetail>().First(w => w.IsDel == "0" && w.LocatNo == locateEnd.LocatNo); + if (detailEnd != null && detailEnd.PalletNo != palletNo) + { + throw new Exception("鐩爣鍌ㄤ綅鐘舵�佷笉鏄┖鍌ㄤ綅"); + } } #endregion - if (locate.Status == "1") //鏈夌墿鍝� + if (locate.WareHouseNo == "W02" && locate.Status == "1") //鏈夌墿鍝� { #region 娣诲姞鍑哄簱浠诲姟 @@ -1861,9 +1866,9 @@ Db.Updateable(item).ExecuteCommand(); #endregion - + } - else if (locate.Status == "3") //鍑哄簱涓� + else if (locate.Status == "3" || locate.WareHouseNo == "W04") //鍑哄簱涓垨宸插湪骞冲簱 { #region 鏀瑰彉鏁版嵁 //鍒ゆ柇鏄惁鏄凡缁忓嚭杩囧簱鍙堝洖搴擄紙鐘舵�佷负寰呮嫞璐х殑 1锛� @@ -1887,21 +1892,31 @@ } } } - var taskNo = Db.Queryable<LogTask>().First(m => m.OrderType == "1" && m.TaskNo != item.TaskNo && m.Status == "1" && m.PalletNo == item.PalletNo); - if (taskNo == null) + if (locate.WareHouseNo == "W04") { - taskNo = logTaskList.FirstOrDefault(m => m.PalletNo == item.PalletNo);//褰撳墠鏈夊悓鎵樼洏涓嶅悓鐗╂枡鍑哄簱 + item.TaskNo = ""; + item.Status = "2"; // 鍑哄簱鍒嗛厤淇℃伅鐘舵�佹敼涓烘鍦ㄦ墽琛� + item.OutMode = item.OutMode;//鍑哄簱鍙� + //item.UnstackingMode = unstackingMode2;//鎷嗗灈妯″紡 + Db.Updateable(item).ExecuteCommand(); } - if (taskNo == null) + else { - throw new Exception($"鎵樼洏鍙凤細{item.PalletNo},鍑哄簱寮傚父"); - } - item.TaskNo = taskNo.TaskNo; - item.Status = "1"; // 鍑哄簱鍒嗛厤淇℃伅鐘舵�佹敼涓烘鍦ㄦ墽琛� - item.OutMode = item.OutMode;//鍑哄簱鍙� - //item.UnstackingMode = unstackingMode2;//鎷嗗灈妯″紡 - Db.Updateable(item).ExecuteCommand(); - + var taskNo = Db.Queryable<LogTask>().First(m => m.OrderType == "1" && m.TaskNo != item.TaskNo && m.Status == "1" && m.PalletNo == item.PalletNo); + if (taskNo == null) + { + taskNo = logTaskList.FirstOrDefault(m => m.PalletNo == item.PalletNo);//褰撳墠鏈夊悓鎵樼洏涓嶅悓鐗╂枡鍑哄簱 + } + if (taskNo == null) + { + throw new Exception($"鎵樼洏鍙凤細{item.PalletNo},鍑哄簱寮傚父"); + } + item.TaskNo = taskNo.TaskNo; + item.Status = "1"; // 鍑哄簱鍒嗛厤淇℃伅鐘舵�佹敼涓烘鍦ㄦ墽琛� + item.OutMode = item.OutMode;//鍑哄簱鍙� + //item.UnstackingMode = unstackingMode2;//鎷嗗灈妯″紡 + Db.Updateable(item).ExecuteCommand(); + } #endregion } else if (locate.Status == "5") //绉诲嚭涓� @@ -2012,15 +2027,15 @@ //Db.Insertable(exTask).ExecuteCommand(); - // 璋冪敤Limes鎺ュ彛鍙戣捣璇烽獙 - var sendModel = new SendLimesModel() + // 璋冪敤Sqp鎺ュ彛鍙戣捣璇烽獙 + var sendModel = new SendSapQcDetailVm() { QcNo = data.QcNo, - SkuNo = data.SkuNo, - Qty = data.Qty.ToString(), - LotNo = data.LotNo, - SupplierLot = data.SupplierLot, - RequestUser = userName, // 璇烽獙浜� + skuNo=data.SkuNo, + skuName = data.SkuNo, + lotNo = data.LotNo, + Qty = Convert.ToDecimal(data.Qty), + SupplierLot = data.SupplierLot }; var jsonData = JsonConvert.SerializeObject(sendModel); string response = ""; @@ -2028,7 +2043,7 @@ try { var time1 = DateTime.Now;//鍙戦�佹椂闂� .ToString("yyyy-MM-dd HH:mm:ss") - //response = HttpHelper.DoPost(url, jsonData, "涓婁紶Limes绯荤粺鍙戣捣璇烽獙", "Limes"); + //response = HttpHelper.DoPost(url, jsonData, "涓婁紶Sap绯荤粺鍙戣捣璇烽獙", "Sap"); var time2 = DateTime.Now;//杩斿洖鏃堕棿 .ToString("yyyy-MM-dd HH:mm:ss") ////瑙f瀽杩斿洖鏁版嵁 -- Gitblit v1.8.0