From 19be6575a27a007b3dba7b0d28ddb769b5a1fed6 Mon Sep 17 00:00:00 2001 From: Demo <Demo@DESKTOP-CPA90BF> Date: 星期二, 26 三月 2024 16:31:46 +0800 Subject: [PATCH] Merge branch 'csc' --- Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs | 51 ++++++++++++++++++++++++++++++--------------------- 1 files changed, 30 insertions(+), 21 deletions(-) diff --git a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs index 2485aa5..2344c3b 100644 --- a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs +++ b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs @@ -377,12 +377,12 @@ { //鑾峰彇浠诲姟淇℃伅 var logtask = Db.Queryable<LogTask>().First(a => a.PalletNo == upBindPalletNo && a.IsDel == "0" && a.Status == "1"); - if (logtask == null) + if (logtask != null) { strMsg = "璇ユ墭鐩樹换鍔″凡瀹屾垚 鎴栨湭鎴愬姛鍒涘缓浠诲姟 璇锋牳瀹烇紒"; return strMsg; } - string bindstr = "select * from BllPalletBind Where IsDel = @isdel and PalletNo = @palletno and ASNDetailNo = 0 and ASNNo = ''"; + string bindstr = "select * from BllPalletBind Where IsDel = @isdel and PalletNo = @palletno and ASNDetailNo = 0 and ASNNo = '' "; //鑾峰彇缁戝畾鎵樼洏琛ㄤ俊鎭� List<PalletBindVm> bindVms = Db.Ado.SqlQuery<PalletBindVm>(bindstr, new { @@ -398,10 +398,13 @@ return strMsg; } //鍒犻櫎缁戝畾鎵樼洏琛ㄤ俊鎭� - string delstr = "delete from BllPalletBind Where PalletNo = @palletno"; + string delstr = "update BllPalletBind set IsDel = 1,UpdateUser = @UpdateUser,UpdateTime = @UpdateTime Where PalletNo = @palletno and Id =@Id "; int i = Db.Ado.ExecuteCommand(delstr, new { - palletno = upBindPalletNo + UpdateUser = createUser, + UpdateTime = DateTime.Now, + palletno = upBindPalletNo, + Id = bindVms[0].Id }); //淇敼鎵樼洏鐘舵�� Db.BeginTran(); @@ -428,12 +431,12 @@ box.IsDel = "1"; Db.Updateable(box).ExecuteCommand(); - //淇敼浠诲姟鐘舵�� - logtask.IsDel = "1"; - logtask.Status = "4"; //3 宸插彇娑� - logtask.UpdateUser = createUser; //鍙栨秷浜� - logtask.UpdateTime = DateTime.Now; //鍙栨秷鏃堕棿 - Db.Updateable(logtask).ExecuteCommand(); + ////淇敼浠诲姟鐘舵�� + //logtask.IsDel = "1"; + //logtask.Status = "4"; //3 宸插彇娑� + //logtask.UpdateUser = createUser; //鍙栨秷浜� + //logtask.UpdateTime = DateTime.Now; //鍙栨秷鏃堕棿 + //Db.Updateable(logtask).ExecuteCommand(); //鏇存敼搴撳瓨鏁伴噺 //string str = $"update DataStock set Qty = Qty - {(int)bindVms[0].Qty} Where SkuNo = '100099'"; // 鏇存敼鎵樼洏浣跨敤鐘舵�� @@ -2032,10 +2035,10 @@ Demo = model.Demo, }; - if (model.TableType == 0 && isDeposit == 0 && isTextTable == 0) - { - throw new Exception($"缁戝畾澶辫触锛寋model.PalletNo}鎵樼洏缁戝畾鏁伴噺澶т簬璇ョ墿鍝佹墭鐩樺寘瑁呮暟閲忥紒"); - } + //if (model.TableType == 0 && isDeposit == 0 && isTextTable == 0) 涓嶅お鐞嗚В杩欐浠g爜鐨勫惈涔� + //{ + // throw new Exception($"缁戝畾澶辫触锛寋model.PalletNo}鎵樼洏缁戝畾鏁伴噺澶т簬璇ョ墿鍝佹墭鐩樺寘瑁呮暟閲忥紒"); + //} // 鎻掑叆鎵樼洏缁戝畾琛� bindId = Db.Insertable(bind).ExecuteReturnIdentity(); } @@ -2193,10 +2196,10 @@ try { #region 楠岃瘉淇℃伅 - if (string.IsNullOrEmpty(model.ASNNo)) - { - throw new Exception("鍏ュ簱鍗曚笉鑳戒负绌�!"); - } + //if (string.IsNullOrEmpty(model.ASNNo)) + //{ + // throw new Exception("鍏ュ簱鍗曚笉鑳戒负绌�!"); + //} if (string.IsNullOrEmpty(model.PalletNo)) { throw new Exception("鎵樼洏鏉$爜涓嶈兘涓虹┖!"); @@ -2588,7 +2591,7 @@ IsFinish = 0,//鏄惁鍙畬鎴� Type = "0",//浠诲姟绫诲瀷 0 鍏ュ簱浠诲姟 1 鍑哄簱浠诲姟 2 绉诲簱浠诲姟 Status = "2",//浠诲姟鐘舵��0锛氱瓑寰呮墽琛�1姝e湪鎵ц2鎵ц瀹屾垚 - OrderType = "0",//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� + OrderType = "3",//0 鍏ュ簱鍗� 1 鍑哄簱鍗� 2 鐩樼偣鍗� 3 绉诲簱鍗� Msg = "鍔涜骞冲簱鐨勫洖搴撲换鍔�", }; Db.Insertable(exTask).ExecuteCommand(); @@ -2600,8 +2603,14 @@ //淇敼鍌ㄤ綅淇℃伅 Db.Updateable(storageLocat).ExecuteCommand(); - new OperationASNServer().AddLogOperationAsn("PDA妯″潡", "骞冲簱鍏ュ簱", model.PalletNo, "瀹屾垚", $"鍦≒DA涓婂畬鎴愬崟鎹彿涓猴細{model.ASNNo}鐨勬墭鐩樼爜涓猴細{model.PalletNo}鐨勫钩搴撳叆搴撴搷浣�", (int)model.CreateUser); - + if (iscount == 1) + { + new OperationASNServer().AddLogOperationAsn("PDA妯″潡", "骞冲簱鍏ュ簱", model.PalletNo, "瀹屾垚", $"鍦≒DA涓婂畬鎴愭墭鐩樼爜涓猴細{model.PalletNo}鐨勫钩搴撳洖娴佸叆搴撴搷浣�", (int)model.CreateUser); + } + else + { + new OperationASNServer().AddLogOperationAsn("PDA妯″潡", "骞冲簱鍏ュ簱", model.PalletNo, "瀹屾垚", $"鍦≒DA涓婂畬鎴愬崟鎹彿涓猴細{model.ASNNo}鐨勬墭鐩樼爜涓猴細{model.PalletNo}鐨勫钩搴撳叆搴撴搷浣�", (int)model.CreateUser); + } Db.CommitTran(); } catch (Exception ex) -- Gitblit v1.8.0