From 38ec8ce86f5a647732fd8ceb5b71704212c1f4e7 Mon Sep 17 00:00:00 2001
From: Administrator <Administrator@DESKTOP-5BIMHQ3>
Date: 星期日, 04 二月 2024 11:45:36 +0800
Subject: [PATCH] 优化打印标签页面

---
 Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs |   22 +++++++++++++++++++---
 1 files changed, 19 insertions(+), 3 deletions(-)

diff --git a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
index 7e4859c..3b76924 100644
--- a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
+++ b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
@@ -676,7 +676,7 @@
                 #endregion
 
                 #region 鍦扮爜淇℃伅(鍌ㄤ綅淇℃伅)
-                var storageLocat = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == model.LocatNo && w.Status == "0");
+                var storageLocat = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == model.LocatNo && w.Status == "0" && w.WareHouseNo == "W02");
                 if (storageLocat == null)
                 {
                     strMsg = "-1:鍌ㄤ綅淇℃伅涓嶅瓨鍦ㄦ垨闈炵┖闂茬姸鎬侊紝璇锋牳鏌�!";
@@ -922,6 +922,8 @@
 
                         //淇敼缁勬墭鐘舵��
                         palletbindInfo.Status = "2"; //2 鍏ュ簱瀹屾垚
+                        palletbindInfo.WareHouseNo = "W02";//鎵�灞炰粨搴�
+                        palletbindInfo.LocatNo = model.LocatNo;//鍌ㄤ綅鍦板潃
                         palletbindInfo.UpdateTime = serverTime;
                         palletbindInfo.UpdateUser = model.CreateUser;
                         palletbindInfo.CompleteTime = serverTime; //瀹屾垚鏃堕棿
@@ -1087,7 +1089,12 @@
                     #endregion
 
                     #endregion
-                }
+                }                
+                storageLocat.Status = "1";
+                storageLocat.UpdateTime= serverTime; //淇敼鏃堕棿
+                storageLocat.UpdateUser = model.CreateUser; //淇敼浜�
+                //淇敼鍌ㄤ綅鐘舵��                                           
+                Db.Updateable(storageLocat).ExecuteCommand();
 
                 new OperationASNServer().AddLogOperationAsn("PDA妯″潡", "骞冲簱鍏ュ簱", model.PalletNo, "瀹屾垚", $"鍦≒DA涓婂畬鎴愬崟鎹彿涓猴細{model.ASNNo}鐨勬墭鐩樼爜涓猴細{model.PalletNo}鐨勫钩搴撳叆搴撴搷浣�", (int)model.CreateUser);
 
@@ -1793,6 +1800,10 @@
                         IsBelt = "0",
                         CreateUser = userId
                     };
+                    if (model.SkuQty > pNum)
+                    {
+                        throw new Exception($"缁戝畾澶辫触锛寋model.PalletNo}鎵樼洏缁戝畾鏁伴噺澶т簬璇ョ墿鍝佹墭鐩樺寘瑁呮暟閲忥紒");
+                    }
                     // 鎻掑叆鎵樼洏缁戝畾琛�
                     bindId = Db.Insertable(bind).ExecuteReturnIdentity();
                 }
@@ -1886,6 +1897,10 @@
                 {
                     bind.BitPalletMark = "0";
                 }
+                if (bind.Qty > pNum)
+                {
+                    throw new Exception($"缁戝畾澶辫触锛寋bind.PalletNo}鎵樼洏缁戝畾鏁伴噺澶т簬璇ョ墿鍝佹墭鐩樺寘瑁呮暟閲忥紒");
+                }
                 Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();
 
                 // 鏇存敼鍏ュ簱鍗曟槑缁嗗凡缁勬暟閲�
@@ -1915,12 +1930,13 @@
                 //娣诲姞鎵樼洏璁板綍琛ㄦ暟鎹�
                 sqlStr += $"insert into LogPalletTrack values('{model.PalletNo}','{model.AsnNo}','缁勭洏','0',getDate(),{userId},NULL,NULL);";
                 Db.Ado.ExecuteCommand(sqlStr);
-                new OperationASNServer().AddLogOperationAsn("PDA妯″潡", "鎵樼洏缁戝畾1", model.AsnNo, "娣诲姞", $"娣诲姞浜嗘墭鐩樼爜涓猴細{model.PalletNo}銆亄msgStr}鐨勭粍鐩樹俊鎭�", userId);
+                new OperationASNServer().AddLogOperationAsn("PDA妯″潡", "鎵樼洏缁戝畾", model.AsnNo, "娣诲姞", $"娣诲姞浜嗘墭鐩樼爜涓猴細{model.PalletNo}銆亄msgStr}鐨勭粍鐩樹俊鎭�", userId);
 
                 Db.CommitTran();
             }
             catch (Exception ex)
             {
+                Db.RollbackTran();
                 throw ex;
             }
         }

--
Gitblit v1.8.0