From 020774a716af699a0854439ed223e54327706206 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期六, 30 八月 2025 09:54:22 +0800
Subject: [PATCH] 代码提交，校验栈板码已经在MES入库，不允许解绑
---
StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs b/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs
index 920f28d..3a97cf8 100644
--- a/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs
+++ b/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs
@@ -417,6 +417,17 @@
// 瑙ｇ粦
else if (mesPalletBinding.Type.ToUpper() == "F")
{
+ string sql1 = $"SELECT COUNT(*) COUNT FROM MES_PALLET_BINDING WHERE STACKCODE = '{mesPalletBinding.StackCode}' and IS_INBOUND=1";
+ DataTable data = sqlHelper.ExecuteQuery(sql1);
+
+ if (data.Rows[0]["COUNT"].ToString() != "0")
+ {
+ msg[0] = "false";
+ msg[1] = "璇ユ爤鏉跨爜宸茬粡鍦∕ES鍏ュ簱锛屼笉鍏佽瑙ｇ粦锛佹爤鏉跨爜锛�" + mesPalletBinding.StackCode;
+ transaction.Rollback();
+ return msg;
+ }
+
// 鍏堟煡璇㈢粦瀹氱殑璁板綍
string sqlSelect = $"SELECT * FROM MES_PALLET_BINDING WHERE STACKCODE = '{mesPalletBinding.StackCode}'";
DataTable dt = sqlHelper.ExecuteQuery( sqlSelect);
--
Gitblit v1.9.3