From 3a050b4d542dd2aefa65de27a6acecca1d9dda3d Mon Sep 17 00:00:00 2001 From: chengsc <11752@DESKTOP-DS49RCP> Date: 星期日, 25 五月 2025 14:27:04 +0800 Subject: [PATCH] 修改问题 --- Pda/View/AsnSetting/WorkshopIn.html | 0 Wms/WMS.BLL/HttpServer.cs | 6 +- Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs | 55 +++++++++--------- Wms/WMS.BLL/Logic/AllotSku.cs | 2 Pda/View/SoSetting/WorkshopOut.html | 0 Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs | 68 ++++++++++++---------- HTML/views/SOSetting/ExportNotice.html | 4 Wms/Wms/Controllers/DownApiController.cs | 2 8 files changed, 71 insertions(+), 66 deletions(-) diff --git a/HTML/views/SOSetting/ExportNotice.html b/HTML/views/SOSetting/ExportNotice.html index b301111..375d93b 100644 --- a/HTML/views/SOSetting/ExportNotice.html +++ b/HTML/views/SOSetting/ExportNotice.html @@ -156,8 +156,8 @@ <div class="layui-input-inline" style="width: 220px;"> <select name="PickingArea" id="PickingArea" lay-search> <option value=""></option> - <option value="1">1</option> - <option value="2">2</option> + <option value="17">17宸ヤ綅</option> + <option value="18">18宸ヤ綅</option> </select> </div> </div> diff --git a/Pda/View/AsnSetting/WorkshopIn.html b/Pda/View/AsnSetting/WorkshopIn.html new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/Pda/View/AsnSetting/WorkshopIn.html diff --git a/Pda/View/SoSetting/WorkshopOut.html b/Pda/View/SoSetting/WorkshopOut.html new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/Pda/View/SoSetting/WorkshopOut.html diff --git a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs index ba7f4bd..fc62305 100644 --- a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs +++ b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs @@ -1321,15 +1321,15 @@ { throw new Exception("鎵樼洏娌℃湁鍑哄簱鍗曚俊鎭�"); } - var task = Db.Queryable<LogTask>().First(m => m.PalletNo == palletNo && m.IsDel == "0" && m.Status == "5"); - if (task == null) - { - throw new Exception("娌℃湁鏌ヨ鍒版墭鐩樹换鍔′俊鎭�"); - } - if (task.Status != "5") - { - throw new Exception("浠诲姟鐘舵�佷笉鏄瓑寰呯‘璁�"); - } + //var task = Db.Queryable<LogTask>().First(m => m.PalletNo == palletNo && m.IsDel == "0" && m.Status == "5"); + //if (task == null) + //{ + // throw new Exception("娌℃湁鏌ヨ鍒版墭鐩樹换鍔′俊鎭�"); + //} + //if (task.Status != "5") + //{ + // throw new Exception("浠诲姟鐘舵�佷笉鏄瓑寰呯‘璁�"); + //} return detail; } catch (Exception e) @@ -1349,20 +1349,26 @@ try { Db.BeginTran(); - var task = Db.Queryable<LogTask>().First(m => m.PalletNo == palletNo && m.IsDel == "0" && m.Status == "5"); - if (task == null) + //var task = Db.Queryable<LogTask>().First(m => m.PalletNo == palletNo && m.IsDel == "0" && m.Status == "5"); + //if (task == null) + //{ + // throw new Exception("娌℃湁鏌ヨ鍒版墭鐩樹换鍔′俊鎭�"); + //} + //if (task.Status != "5") + //{ + // throw new Exception("浠诲姟鐘舵�佷笉鏄瓑寰呯‘璁�"); + //} + ////浠诲姟鐘舵�佸彉鏇翠负鎵ц瀹屾垚 + //task.Status = "2"; + //Db.Updateable(task).ExecuteCommand(); + var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo).ToList(); + if (stockDetail.Count == 0) { - throw new Exception("娌℃湁鏌ヨ鍒版墭鐩樹换鍔′俊鎭�"); + throw new Exception("搴撳瓨鎵樼洏娌℃湁淇℃伅"); } - if (task.Status != "5") - { - throw new Exception("浠诲姟鐘舵�佷笉鏄瓑寰呯‘璁�"); - } - //浠诲姟鐘舵�佸彉鏇翠负鎵ц瀹屾垚 - task.Status = "2"; - Db.Updateable(task).ExecuteCommand(); - var locatList = Db.Queryable<SysStorageLocat>().Where(m=>m.WareHouseNo == "W04" && (m.AreaNo == "B06" || m.AreaNo == "B07") && m.IsDel == "0").ToList(); - var locat = locatList.FirstOrDefault(m => m.LocatNo == task.EndLocat); + var locate = stockDetail.First().LocatNo; + var locatList = Db.Queryable<SysStorageLocat>().Where(m=>m.WareHouseNo == "W04" && (m.AreaNo == "B06" || m.AreaNo == "B07" || m.AreaNo == "B09") && m.IsDel == "0").ToList(); + var locat = locatList.FirstOrDefault(m => m.LocatNo == locate); //鍒ゆ柇鎵樼洏鍌ㄤ綅鏄惁鍦ㄨ溅闂� if (locat == null) { @@ -1371,7 +1377,7 @@ locat.Status = "0"; Db.Updateable(locat).ExecuteCommand(); //鍒ゆ柇鎵樼洏淇℃伅 - var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo).ToList(); + foreach (var item in stockDetail) { if (item.UDF5 != "1" || string.IsNullOrWhiteSpace(item.SONo)) @@ -1383,7 +1389,7 @@ //item.RoadwayNo = ""; //item.AreaNo = ""; item.LocatNo = ""; - item.PalletNo = ""; + //item.PalletNo = ""; item.LockQty = 0; // 閿佸畾鏁伴噺鏇翠负0 item.Status = "0"; // 鐘舵�佸彉涓哄緟鍒嗛厤 var boxInfo = Db.Queryable<DataBoxInfo>().Where(m => m.StockDetailId == item.Id).ToList(); @@ -1396,15 +1402,15 @@ } Db.Updateable(stockDetail).ExecuteCommand(); //鎵樼洏鍙樻洿鐘舵�� - var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == palletNo); - if (pallet == null) - { - throw new Exception("娌℃湁鏌ヨ鍒版墭鐩樹俊鎭�"); - } - pallet.Status = "0"; - Db.Updateable(pallet).ExecuteCommand(); + //var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == palletNo); + //if (pallet == null) + //{ + // throw new Exception("娌℃湁鏌ヨ鍒版墭鐩樹俊鎭�"); + //} + //pallet.Status = "0"; + //Db.Updateable(pallet).ExecuteCommand(); //娣诲姞鎿嶄綔鏃ュ織 - new OperationCrServer().AddLogOperationCr("搴撳唴浣滀笟", "鎿嶄綔鏃ュ織", palletNo, "缂栬緫", $"杞﹂棿鏀惰揣锛歿palletNo}鎵樼洏鏀惰揣", userId); + new OperationCrServer().AddLogOperationCr("PDA妯″潡", "杞﹂棿鏀惰揣", palletNo, "瀹屾垚", $"杞﹂棿鏀惰揣锛歿palletNo}鎵樼洏鏀惰揣", userId); Db.CommitTran(); } catch (Exception e) diff --git a/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs b/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs index 507c75b..4ef8b56 100644 --- a/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs +++ b/Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs @@ -3376,11 +3376,12 @@ try { List<LogTask> logTaskList = new List<LogTask>();//姝ゆ鍑哄簱浠诲姟闆嗗悎锛屼负搴斿鍚屾墭鐩樹笉鍚岀墿鏂欏嚭搴� + + //寰幆鍒嗛厤鐨勪俊鎭敓鎴愬嚭搴撲换鍔� foreach (var item in list) { var taskNoStr = ""; - string toLocation = string.Empty;//鐩爣浣嶇疆 // 鍌ㄤ綅鍙� var locateNo = outStockDetail.First(m => m.PalletNo == item.PalletNo).LocatNo; @@ -3390,11 +3391,11 @@ //鍒ゆ柇鎵樼洏鏄惁鍦ㄥ簱鍐� if (string.IsNullOrWhiteSpace(locateNo)) //搴撳 { - if (notice.Type == "0") - { - flagList.Add(5); - continue; - } + //if (notice.Type == "0") + //{ + // flagList.Add(5); + // continue; + //} //鍒ゆ柇鎵樼洏鏄惁鍦ㄥ叆搴撲腑 var imBl = com.GetImTask(item.PalletNo); if (imBl != null) @@ -3446,8 +3447,6 @@ } #endregion - - if (locate.Status == "1") //鏈夌墿鍝� { @@ -3515,7 +3514,7 @@ Type = "2",//浠诲姟绫诲瀷 0 鍏ュ簱浠诲姟 1 鍑哄簱浠诲姟 2 绉诲簱浠诲姟 Status = "0",//浠诲姟鐘舵��0锛氱瓑寰呮墽琛�1姝e湪鎵ц2鎵ц瀹屾垚 OrderType = "1",//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� - Msg = "浠�" + locate.LocatNo + "鍒�" + toLocation + "鐨勫嚭搴撲换鍔�", //鍏抽敭淇℃伅 + Msg = "浠�" + locate.LocatNo + "鍒�" + moveAddress + "鐨勭Щ搴撲换鍔�", //鍏抽敭淇℃伅 }; Db.Insertable(ykTask).ExecuteCommand(); logTaskList.Add(ykTask); @@ -3563,7 +3562,7 @@ IsSuccess = 0, //鏄惁涓嬪彂鎴愬姛 0澶辫触 1鎴愬姛 StartLocat = locate.LocatNo,//璧峰浣嶇疆 - EndLocat = toLocation,//outMode,//鐩爣浣嶇疆 + EndLocat = outMode,//outMode,//鐩爣浣嶇疆 PalletNo = item.PalletNo,//鎵樼洏鐮� IsSend = 1,//鏄惁鍙啀娆′笅鍙� IsCancel = 1,//鏄惁鍙彇娑� @@ -3571,11 +3570,11 @@ Type = "1",//浠诲姟绫诲瀷 0 鍏ュ簱浠诲姟 1 鍑哄簱浠诲姟 2 绉诲簱浠诲姟 Status = "0",//浠诲姟鐘舵��0锛氱瓑寰呮墽琛�1姝e湪鎵ц2鎵ц瀹屾垚 OrderType = "1",//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� - Msg = "浠�" + locate.LocatNo + "鍒�" + toLocation + "鐨勫嚭搴撲换鍔�", //鍏抽敭淇℃伅 + Msg = "浠�" + locate.LocatNo + "鍒�" + outMode + "鐨勫嚭搴撲换鍔�", //鍏抽敭淇℃伅 }; Db.Insertable(exTask).ExecuteCommand(); logTaskList.Add(exTask); - var endroad = allot.RoadwayToStationNum(locate.RoadwayNo, toLocation); + var endroad = allot.RoadwayToStationNum(locate.RoadwayNo, outMode); outDto1.Add(new OutCommandDto() { PalletNo = item.PalletNo,//鎵樼洏鍙� @@ -3715,23 +3714,23 @@ try { - //var time1 = DateTime.Now;//鍙戦�佹椂闂� .ToString("yyyy-MM-dd HH:mm:ss") - //response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橶CS鍑哄簱鍛戒护", "WCS"); - //var time2 = DateTime.Now;//杩斿洖鏃堕棿 .ToString("yyyy-MM-dd HH:mm:ss") + var time1 = DateTime.Now;//鍙戦�佹椂闂� .ToString("yyyy-MM-dd HH:mm:ss") + response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橶CS鍑哄簱鍛戒护", "WCS"); + var time2 = DateTime.Now;//杩斿洖鏃堕棿 .ToString("yyyy-MM-dd HH:mm:ss") - //////瑙f瀽杩斿洖鏁版嵁 - //var wcsModel = JsonConvert.DeserializeObject<WcsModel>(response); - //if (wcsModel.StatusCode == 0) - //{ - // //鏇存敼浠诲姟鐨勫彂閫佽繑鍥炴椂闂�// - // new TaskServer().EditTaskIssueOk(list2, time1, time2); - // str += "涓嬪彂鎴愬姛"; - //} - //if (wcsModel.StatusCode == -1) - //{ - // new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.Msg); - // throw new Exception(wcsModel.Msg); - //} + ////瑙f瀽杩斿洖鏁版嵁 + var wcsModel = JsonConvert.DeserializeObject<WcsModel2>(response); + if (wcsModel.code == 200) + { + //鏇存敼浠诲姟鐨勫彂閫佽繑鍥炴椂闂�// + new TaskServer().EditTaskIssueOk(list2, time1, time2); + str += "涓嬪彂鎴愬姛"; + } + else + { + new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.message); + throw new Exception(wcsModel.message); + } } catch (Exception ex) { diff --git a/Wms/WMS.BLL/HttpServer.cs b/Wms/WMS.BLL/HttpServer.cs index 20e977d..81d4d68 100644 --- a/Wms/WMS.BLL/HttpServer.cs +++ b/Wms/WMS.BLL/HttpServer.cs @@ -534,9 +534,9 @@ { areaList.Add(item); } - + var roadStr = Db.Queryable<SysStorageRoadway>().Where(m => m.IsDel == "0" && m.Status == "0").Select(m=>m.RoadwayNo).ToList(); //宸烽亾缁勪俊鎭� - var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo) && !string.IsNullOrWhiteSpace(m.RoadwayNo)) + var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo) && !string.IsNullOrWhiteSpace(m.RoadwayNo) && roadStr.Contains(m.RoadwayNo)) .GroupBy(m => m.RoadwayNo).OrderBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList(); #endregion @@ -1231,7 +1231,7 @@ else { locate2.Status = "1"; - Db.Updateable(locate).ExecuteCommand(); + Db.Updateable(locate2).ExecuteCommand(); } Db.Updateable(stockDetail).ExecuteCommand(); diff --git a/Wms/WMS.BLL/Logic/AllotSku.cs b/Wms/WMS.BLL/Logic/AllotSku.cs index 4a44dff..a780b7a 100644 --- a/Wms/WMS.BLL/Logic/AllotSku.cs +++ b/Wms/WMS.BLL/Logic/AllotSku.cs @@ -252,7 +252,7 @@ //瀵嗛泦搴撳唴鎵樼洏 var detail2 = list.Where(m => m.WareHouseNo == "W01").ToList(); - var detail3 = list.GroupBy(m=>m.RoadwayNo).OrderBy(m=>m.Key).ToList(); + var detail3 = detail2.GroupBy(m=>m.RoadwayNo).OrderBy(m=>m.Key).ToList(); foreach (var item in detail3) { diff --git a/Wms/Wms/Controllers/DownApiController.cs b/Wms/Wms/Controllers/DownApiController.cs index 6aa7908..e9f10fe 100644 --- a/Wms/Wms/Controllers/DownApiController.cs +++ b/Wms/Wms/Controllers/DownApiController.cs @@ -131,7 +131,7 @@ { var list = _exNoticeSvc.IssueOutHouseMk(soNo, outMode, int.Parse(userId), _config.WcsHost + _config.IssueComApiUrl, out string str); - return Ok(new { code = 0, msg = "str" }); + return Ok(new { code = 0, msg = str }); } else if (house == "W02") { -- Gitblit v1.8.0