From 2920728d7908da2ee196f3af8b3d1c635696e9a1 Mon Sep 17 00:00:00 2001 From: zwc <526854230@qq.com> Date: 星期三, 15 一月 2025 15:47:15 +0800 Subject: [PATCH] 修改问题 --- Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs | 508 ++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 468 insertions(+), 40 deletions(-) diff --git a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs index 4b30086..b146a20 100644 --- a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs +++ b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs @@ -1,15 +1,21 @@ 锘縰sing System; +using System.Collections; using System.Collections.Generic; using System.Linq; +using System.Security.Policy; using System.Text; +using System.Threading.Tasks; using Model.InterFaceModel; using Model.ModelDto.BllCheckDto; +using Model.ModelDto.LogDto; using Model.ModelDto.PdaDto; +using Model.ModelDto.SysDto; using Model.ModelVm; using Newtonsoft.Json; using SqlSugar; using Utility.Tools; using WMS.BLL.LogServer; +using WMS.BLL.SysServer; using WMS.DAL; using WMS.Entity.BllAsnEntity; using WMS.Entity.BllCheckEntity; @@ -900,7 +906,8 @@ } try { - string EndLocat = string.Empty;//鐩爣浣嶇疆 + string EndLocat = string.Empty,OrderTy = "";//鐩爣浣嶇疆 + var log = Db.Queryable<LogTask>().First(w => w.IsDel == "0" && w.PalletNo == palletNo && (w.Status == "0" || w.Status == "1")); if (log != null) @@ -920,10 +927,14 @@ throw new Exception("鎵�閫夊尯鍩熶俊鎭笉瀛樺湪,璇锋鏌�!"); } EndLocat = GetLocat(areaNo, stockDetail.SkuNo, stockDetail.LotNo, palletNo); + OrderTy = "3";//绉诲簱 } else { EndLocat = ruku; + OrderTy = "0";//鍏ュ簱 + + } var stock = Db.Queryable<DataStock>().First(w => w.IsDel == "0" && w.SkuNo == stockDetail.SkuNo && w.LotNo == stockDetail.LotNo); if (stock == null) @@ -976,7 +987,7 @@ IsFinish = 1,//鏄惁鍙畬鎴� Type = "2",//浠诲姟绫诲瀷 0 鍏ュ簱浠诲姟 1 鍑哄簱浠诲姟 2 绉诲簱浠诲姟 Status = "0",//浠诲姟鐘舵��0锛氱瓑寰呮墽琛�1姝e湪鎵ц2鎵ц瀹屾垚 - OrderType = "3",//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� + OrderType = OrderTy,//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� CreateTime = DateTime.Now }; @@ -1005,53 +1016,105 @@ #region 鍛煎彨灏忚溅浠g爜 + var endlono = EndLocat; + var tasktype = "D00"; //榛樿涓虹偣鍒扮偣浠诲姟 + //鏍规嵁鐩殑鍦板潃搴撳尯鑾峰彇灏忚溅浠诲姟绫诲瀷 + switch (storageLocatEnd.AreaNo) + { + case "B13" : + tasktype = "D02"; // 鍙犳墭浠诲姟锛堢洰鐨勫湴鍧�涓虹┖鎵樼洏鏀堕泦鍖猴級 + break; + case "B15": + tasktype = "D01"; // 鎷嗘墭浠诲姟锛堢洰鐨勫湴鍧�涓烘嫞璐у尯锛� + break; + } + + //缂撳瓨搴撲綅杞崲 3妤煎師杈呮枡Y003_001锛孻003_002锛孻003_003 1妤糦138_001鍒癥138_021澶栧寘缂撳瓨鍖� 1妤糦128_001鍒癥128_015鍐呭寘缂撳瓨鍖� + if (storageLocatEnd.AreaNo == "B12") + { + switch (EndLocat.ToString().Substring(4, 1)) + { + case "1": + endlono = "Y003_00" + EndLocat.ToString().Substring(6, 1); + tasktype = "D00"; //鐐瑰埌鐐逛换鍔� + break; + case "2": + endlono = "Y138_0" + EndLocat.ToString().Substring(5, 2); + tasktype = "F20"; //鐢垫浠诲姟 + break; + case "3": + endlono = "Y128_0" + EndLocat.ToString().Substring(5, 2); + tasktype = "F20"; //鐢垫浠诲姟 + break; + default: + break; + } + } + + //鐐瑰埌鐐规寚浠ら泦鍚� + object[] position = new object[2]; + position[0] = new + { + positionCode = stockDetail.LocatNo, + type = "00" + }; + position[1] = new + { + positionCode = endlono, + type = "00" + }; List<AgvSchedulingTask> agvTaskList = new List<AgvSchedulingTask>(); + Random r = new Random(); + long ran =DateTime.Now.Ticks; AgvSchedulingTask agvTask = new AgvSchedulingTask(); - agvTask.ReqCode = taskNo; - agvTask.TaskTyp = "F01"; - agvTask.WbCode = ""; - agvTask.PositionCodePath = null; - agvTask.PodCode = "-1"; + agvTask.TaskCode = taskNo; + agvTask.ReqCode = ran.ToString(); + agvTask.TaskTyp = tasktype; + agvTask.PositionCodePath = position; + agvTask.CtnrTyp = "1"; + if (tasktype == "D02") + { + agvTask.CtnrNum = "10"; //鍙犳墭浠诲姟闇�瑕佷笅鍙戠┖鎵樼洏鏁伴噺 + } agvTaskList.Add(agvTask); - var IsTrue = false; - while (IsTrue == true) + + // 姝e紡杩愯绋嬪簭鏀惧紑 + string str = ""; + var list2 = agvTaskList.Select(m => m.ReqCode).ToList(); + var jsonData = JsonConvert.SerializeObject(agvTaskList); + jsonData = jsonData.Substring(1, jsonData.Length - 1); + jsonData = jsonData.Substring(0, jsonData.Length - 1); + string response = ""; + + try { - // 姝e紡杩愯绋嬪簭鏀惧紑 - string str = ""; - var list2 = agvTaskList.Select(m => m.ReqCode).ToList(); - var jsonData = JsonConvert.SerializeObject(agvTaskList); - string response = ""; + var time1 = DateTime.Now;//鍙戦�佹椂闂� .ToString("yyyy-MM-dd HH:mm:ss") + response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橝GV杞繍鍛戒护", "AGV"); + var time2 = DateTime.Now;//杩斿洖鏃堕棿 .ToString("yyyy-MM-dd HH:mm:ss") - try + //////瑙f瀽杩斿洖鏁版嵁 + var agvModel = JsonConvert.DeserializeObject<OutCommanAgvDto>(response); + if (agvModel.Code == "0") { - var time1 = DateTime.Now;//鍙戦�佹椂闂� .ToString("yyyy-MM-dd HH:mm:ss") - response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橝GV杞繍鍛戒护", "AGV"); - var time2 = DateTime.Now;//杩斿洖鏃堕棿 .ToString("yyyy-MM-dd HH:mm:ss") - - //////瑙f瀽杩斿洖鏁版嵁 - var agvModel = JsonConvert.DeserializeObject<OutCommanAgvDto>(response); - if (agvModel.Code == "0") - { - //鏇存敼浠诲姟鐨勫彂閫佽繑鍥炴椂闂�// - new TaskServer().EditTaskIssueOk(list2, time1, time2); - str += "涓嬪彂鎴愬姛"; - IsTrue = true; - } - if (agvModel.Code == "1") - { - new TaskServer().EditTaskIssueNo(list2, time1, time2, agvModel.Message); - throw new Exception(agvModel.Message); - } + //鏇存敼浠诲姟鐨勫彂閫佽繑鍥炴椂闂�// + new TaskServer().EditTaskIssueOk(list2, time1, time2); + str += "涓嬪彂鎴愬姛"; } - catch (Exception ex) + if (agvModel.Code == "1") { - throw new Exception(ex.Message); + new TaskServer().EditTaskIssueNo(list2, time1, time2, agvModel.Message); + throw new Exception(agvModel.Message); } } + catch (Exception ex) + { + throw new Exception(ex.Message); + } + #endregion //鎻愪氦浜嬪姟 @@ -1070,7 +1133,7 @@ /// <param name="palletNo"></param> /// <param name="areaNo"></param> /// <param name="userId"></param> - public List<string> AgvTransport2(string soNo, string palletNo, string areaNo, int userId, string url) + public List<string> AgvTransport2(string soNo, string palletNo, string areaNo,string ruku, int userId, string url) { if (string.IsNullOrEmpty(soNo)) { @@ -1192,12 +1255,58 @@ }; Db.Insertable(exTask).ExecuteCommand(); + var endlono = EndLocat; + var tasktype = "D00"; + + //鏍规嵁鐩殑鍦板潃搴撳尯鑾峰彇灏忚溅浠诲姟绫诲瀷 + switch (storageLocatEnd.AreaNo) + { + case "B13": + tasktype = "D02"; // 鍙犳墭浠诲姟锛堢洰鐨勫湴鍧�涓虹┖鎵樼洏鏀堕泦鍖猴級 + break; + case "B15": + tasktype = "D01"; // 鎷嗘墭浠诲姟锛堢洰鐨勫湴鍧�涓烘嫞璐у尯锛� + break; + } + + //缂撳瓨搴撲綅杞崲 3妤煎師杈呮枡Y003_001锛孻003_002锛孻003_003 1妤糦138_001鍒癥138_021澶栧寘缂撳瓨鍖� 1妤糦128_001鍒癥128_015鍐呭寘缂撳瓨鍖� + if (storageLocatEnd.AreaNo == "B12") + { + switch (EndLocat.ToString().Substring(4, 1)) + { + case "1": + endlono = "Y003_00" + EndLocat.ToString().Substring(6, 1); + break; + case "2": + endlono = "Y138_0" + EndLocat.ToString().Substring(5, 2); + tasktype = "F20"; //鐢垫浠诲姟 + break; + case "3": + endlono = "Y128_0" + EndLocat.ToString().Substring(5, 2); + tasktype = "F20"; //鐢垫浠诲姟 + break; + default: + break; + } + } + + //鐐瑰埌鐐规寚浠ら泦鍚� + object[] position = new object[2]; + position[0] = new + { + positionCode = item.LocatNo, + type = "00" + }; + position[1] = new + { + positionCode = endlono, + type = "00" + }; + AgvSchedulingTask agvTask = new AgvSchedulingTask(); agvTask.ReqCode = taskNo; - agvTask.TaskTyp = "F01"; - agvTask.WbCode = ""; - agvTask.PositionCodePath = null; - agvTask.PodCode = "-1"; + agvTask.TaskTyp = tasktype; + agvTask.PositionCodePath = position; agvTaskList.Add(agvTask); @@ -1245,6 +1354,8 @@ string str = ""; var list2 = agvTaskList.Select(m => m.ReqCode).ToList(); var jsonData = JsonConvert.SerializeObject(agvTaskList); + jsonData = jsonData.Substring(1, jsonData.Length - 1); + jsonData = jsonData.Substring(0, jsonData.Length - 1); string response = ""; try @@ -1286,6 +1397,126 @@ throw new Exception(ex.Message); } } + + /// <summary> + /// agv璋冨害浠诲姟涓嬪彂 + /// </summary> + /// <param name="type">鎼繍绫诲瀷</param> + /// <param name="taskno">浠诲姟鍙�</param> + /// <param name="positionStart">璧峰鍦板潃</param> + /// <param name="positionEnd">鐩殑鍦板潃</param> 2 + /// <param name="url">鎺ュ彛URL</param> + public OutCommanAgvDto AGVTask(string type, string taskno, string positionStart, string positionEnd ,string url) + { + + var endlono = positionEnd; + var tasktype = type; + var storageLocatEnd = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == endlono && w.Flag == "0" && w.Status == "0"); + if (storageLocatEnd == null) + { + throw new Exception("鐢熸垚鐨凙GV浠诲姟鐩殑鍦板潃涓嶆纭�"); + } + //鏍规嵁鐩殑鍦板潃搴撳尯鑾峰彇灏忚溅浠诲姟绫诲瀷 + switch (storageLocatEnd.AreaNo) + { + case "B13": + tasktype = "D02"; // 鍙犳墭浠诲姟锛堢洰鐨勫湴鍧�涓虹┖鎵樼洏鏀堕泦鍖猴級 + break; + case "B15": + tasktype = "D01"; // 鎷嗘墭浠诲姟锛堢洰鐨勫湴鍧�涓烘嫞璐у尯锛� + break; + } + + // MES鐢宠澶囨枡锛屽鏂欏尯搴撲綅闇�瑕佽浆鎹� 杞﹂棿澶囨枡缂撳瓨浣嶅悕绉帮細3妤煎師杈呮枡Y003_001-->Y003_003 1妤煎鍖呯紦瀛樺尯Y138_001-->Y138_021 1妤煎唴鍖呯紦瀛樺尯Y128_001-->Y128_015 + if (storageLocatEnd.AreaNo == "B12") + { + switch (endlono.ToString().Substring(4, 1)) + { + case "1": + endlono = "Y003_00" + endlono.Substring(6, 1); + break; + case "2": + endlono = "Y138_0" + endlono.Substring(5, 2); + tasktype = "F20"; //鐢垫浠诲姟 + break; + case "3": + endlono = "Y128_0" + endlono.Substring(5, 2); + tasktype = "F20"; //鐢垫浠诲姟 + break; + default: + break; + } + } + List<AgvSchedulingTask> agvTaskList = new List<AgvSchedulingTask>(); + + object[] position = new object[2]; + position[0] = new + { + positionCode = positionStart, + type = "00" + }; + position[1] = new + { + positionCode = endlono, + type = "00" + }; + + AgvSchedulingTask agvTask = new AgvSchedulingTask(); + agvTask.ReqCode = taskno; //agv璇锋眰缂栧彿锛岄渶瑕侀殢鏈虹敓鎴� 锛堟渶澶�32浣嶏級 + agvTask.TaskCode = taskno; //浠诲姟鍙� + agvTask.TaskTyp = tasktype; //鎼繍绫诲瀷 + agvTask.PositionCodePath = position; //璧峰鍜岀洰鐨勪綅闆嗗悎 + agvTask.CtnrTyp = "1"; //瀹瑰櫒绫诲瀷锛屽�间负1 + if (tasktype == "D02") + { + agvTask.CtnrNum = "10"; //鍙犳墭浠诲姟闇�瑕佷笅鍙戠┖鎵樼洏鏁伴噺 + } + + agvTaskList.Add(agvTask); + + string str = ""; + var list2 = agvTaskList.Select(m => m.ReqCode).ToList(); + var jsonData = JsonConvert.SerializeObject(agvTaskList); + jsonData = jsonData.Substring(1, jsonData.Length-1); + jsonData = jsonData.Substring(0, jsonData.Length - 1); + var response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橝GV杞繍鍛戒护", "AGV"); + var agvModel = JsonConvert.DeserializeObject<OutCommanAgvDto>(response); + + return agvModel; + } + + /// <summary> + /// agv浠诲姟鍙栨秷 + /// </summary> + /// <param name="taskno">鍙栨秷浠诲姟缂栧彿</param> + /// <param name="url">鎺ュ彛URL</param> + public void cancelTask(string taskno,string url) + { + try + { + AgvCancelTask agvTaskList = new AgvCancelTask(); + agvTaskList.ReqCode = "006"; //闅忔満鐢熸垚 + agvTaskList.TaskCode = taskno.ToString(); + //agvTaskList.ReqTime = DateTime.Now.ToString(); + + var jsonData = JsonConvert.SerializeObject(agvTaskList); + var response = HttpHelper.DoPost(url, jsonData, "涓嬪彂缁橝GV杞繍鍛戒护", "AGV"); + var agvModel = JsonConvert.DeserializeObject<cancelTaskModel>(response); + + if (agvModel.Code != "0") + { + throw new Exception("涓嬪彂AGV鍙栨秷浠诲姟澶辫触"); + } + + } + catch (Exception ex) + { + + throw ex; + } + + } + /// <summary> /// 鏍规嵁鍖哄煙鍒嗛厤鍌ㄤ綅 /// </summary> @@ -1333,6 +1564,203 @@ } #endregion + #region 浜哄伐杞繍 + + //浜哄伐杞繍 + public void ArtificialTransport(string palletNo, string locatNo, string endLocatNo, string mesTokenUrl, string mesUrl,int userId) + { + if (string.IsNullOrEmpty(palletNo)) + { + throw new Exception("璇锋壂鎻忔墭鐩樻潯鐮侊紒"); + } + if (string.IsNullOrEmpty(locatNo)) + { + throw new Exception("璇烽�夋嫨璧峰鍦板潃锛�"); + } + if (string.IsNullOrEmpty(endLocatNo)) + { + throw new Exception("璇疯緭鍏ョ洰鏍囧湴鍧�锛�"); + } + + try + { + #region 鍒ゆ柇淇℃伅 + //寮�鍚簨鍔� + Db.BeginTran(); + + var stockDetail = Db.Queryable<DataStockDetail>().Where(w => w.IsDel == "0" && w.PalletNo == palletNo).ToList(); + if (stockDetail.Count == 0) + { + throw new Exception("鎵樼洏涓婄墿鏂欏簱瀛樻槑缁嗕俊鎭笉瀛樺湪,璇锋鏌�!"); + } + + if (string.IsNullOrEmpty(stockDetail.First().LocatNo)) + { + throw new Exception("鎵樼洏鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + if (stockDetail.First().WareHouseNo != "W02") + { + throw new Exception("璇ユ墭鐩樻湭鍦ㄥ钩搴撳唴,璇锋鏌�!"); + } + + + + //璧峰鍌ㄤ綅淇℃伅 + var storageLocat = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == locatNo); + if (storageLocat == null) + { + throw new Exception("璧峰鍦板潃鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + //鐩爣鍌ㄤ綅淇℃伅 + var EndLocat = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == endLocatNo); + if (EndLocat == null) + { + throw new Exception("鐩爣鍦板潃鍌ㄤ綅淇℃伅涓嶅瓨鍦�,璇锋鏌�!"); + } + + #endregion + + + + //闇�鍏堝垽鏂洰鏍囧湴鍧�鍓嶆柟鏄惁鏈夌┖鍌ㄤ綅 + + storageLocat.Status = "0"; //鏇存敼璧峰鍌ㄤ綅 + Db.Updateable(storageLocat).ExecuteCommand(); + EndLocat.Status = "1"; //鏇存敼鐩爣鍌ㄤ綅 + Db.Updateable(storageLocat).ExecuteCommand(); + + var data = new List<RequertBeiliaoInfoModel>(); + + //鏇存敼搴撳瓨鏄庣粏 + foreach (var item in stockDetail) + { + item.LocatNo = EndLocat.LocatNo;//鍌ㄤ綅鏇存敼 + item.WareHouseNo = EndLocat.WareHouseNo;//鎵�灞炰粨搴撴洿鏀� + item.RoadwayNo = EndLocat.RoadwayNo;//鎵�灞炲贩閬撴洿鏀� + item.AreaNo = EndLocat.AreaNo;//鎵�灞炲尯鍩熸洿鏀� + + Db.Updateable(item).ExecuteCommand(); + + if (EndLocat != null && EndLocat.AreaNo == "B12") //鏄惁鏄�3妤肩紦瀛樺尯 鏄細鍒犻櫎搴撳瓨 + { + if (string.IsNullOrWhiteSpace(item.SONo)) + { + throw new Exception("褰撳墠鎵樼洏涓嶆槸鎷兼墭鍑哄簱鎵樼洏"); + } + var boxInfo = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == item.Id).ToList(); + if (boxInfo.Count == 0) + { + throw new Exception("鎵樼洏涓婄墿鏂欑鐮佷俊鎭笉瀛樺湪,璇锋鏌�!"); + } + //var boxno = boxInfo.GroupBy(w => w.BoxNo).ToList(); + var boxno = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == item.Id).GroupBy(m => new + { + m.BoxNo + }).Select(it => new DataBoxInfo() + { + BoxNo = it.BoxNo + }).ToList(); + + //璁板綍鎵樼洏涓婁俊鎭粰MES + foreach (var item2 in boxno) { + var a = item.ProductionTime.ToString(); + data.Add(new RequertBeiliaoInfoModel() + { + no = item2.BoxNo, + materiel_no = item.SkuNo, + materiel_name = item.SkuName, + qty = item.Qty, + batch = item.LotNo, + producttime = item.ProductionTime.ToString().Substring(0,10), + expiry = item.ExpirationTime.ToString().Substring(0, 10) + + }); + } + //搴撳瓨绠辩爜鏄庣粏鍒犻櫎 + Db.Deleteable(boxInfo).ExecuteCommand(); + //鍒犻櫎搴撳瓨鎵樼洏淇℃伅 + Db.Deleteable(item).ExecuteCommand(); + //鏇存敼搴撳瓨鎬昏〃 + var stock = Db.Queryable<DataStock>().First(w => w.IsDel == "0" && w.SkuNo == item.SkuNo && w.LotNo == item.LotNo); + stock.LockQty -= (decimal)item.Qty; + stock.Qty -= (decimal)item.Qty; + Db.Updateable(stock).ExecuteCommand(); + //鏇存敼鎵樼洏鐘舵�� + var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == palletNo); + if (pallet != null) + { + pallet.Status = "0"; + Db.Updateable(pallet).ExecuteCommand(); + } + } + } + + + if (EndLocat != null && EndLocat.AreaNo == "B12") + { + //鑾峰彇浠ょ墝 + //var token = new Token().GetMesToken(mesTokenUrl); + var token = ""; + Dictionary<string, string> mesDic = new Dictionary<string, string>() + { + {"Authorization",token } + }; + var endlono = EndLocat.LocatNo; + //缂撳瓨搴撲綅杞崲 + switch (EndLocat.LocatNo.ToString().Substring(4, 1)) + { + case "1": + endlono = "Y003_00" + EndLocat.LocatNo.ToString().Substring(6, 1); + break; + case "2": + endlono = "Y138_0" + EndLocat.LocatNo.ToString().Substring(5, 2); + break; + case"3": + endlono = "Y128_0" + EndLocat.LocatNo.ToString().Substring(5, 2); + break; + default: + break; + } + var mescode = Db.Queryable<BllExportNotice>().Where(w => w.SONo == stockDetail.First().SONo).First(); + var mesData = new RequertBeiliaoModel() + { + morder_no = mescode.OrderCode, + pallet = stockDetail.First().PalletNo, + layer_no = endlono, + items = data + }; + var jsonData = JsonConvert.SerializeObject(mesData); + //璋冪敤鎺ュ彛 + var response = HttpHelper.DoPost(mesUrl, jsonData, "澶囨枡瀹屾垚杩愯嚦缂撳瓨鍖哄弽棣堣嚦MES", "MES", mesDic); + + var obj = JsonConvert.DeserializeObject<MesModel>(response);//瑙f瀽杩斿洖鏁版嵁 + if (obj.status != "success") + { + throw new Exception("澶囨枡鍚屾MES澶辫触锛�" + obj.message); + } + + } + + + + //娣诲姞鎿嶄綔鏃ュ織璁板綍 + var k = new OperationCrServer().AddLogOperationCr("PDA妯″潡", "浜哄伐杞繍", palletNo, "绉诲簱", $"PDA鍛煎彨灏忚溅瀵规墭鐩樺彿锛歿palletNo}鍙戣捣杞繍", userId); + + //鎻愪氦浜嬪姟 + Db.CommitTran(); + } + catch (Exception ex) + { + Db.RollbackTran(); + throw new Exception(ex.Message); + } + + + + + } + #endregion + #region 绠辩爜鏌ヨ /// <summary> /// 绠辩爜鏌ヨ -- Gitblit v1.8.0