From 7d4a3769516ced49baad2ada0d0adaa12754d987 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期一, 08 十二月 2025 20:32:10 +0800
Subject: [PATCH] 销售通知单添加校验，生成出库单不允许出库
---
StandardPda/MES.Service/service/BasicData/SalesDeliveryNoticeManager.cs | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/service/BasicData/SalesDeliveryNoticeManager.cs b/StandardPda/MES.Service/service/BasicData/SalesDeliveryNoticeManager.cs
index 50425cc..51dedf3 100644
--- a/StandardPda/MES.Service/service/BasicData/SalesDeliveryNoticeManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/SalesDeliveryNoticeManager.cs
@@ -55,6 +55,15 @@
List<SalesDeliveryNoticeDetail> mesSalesDeliveryDatas)
{
var decimals = mesSalesDeliveryDatas.Select(s => s.Id).ToArray();
+ var XS_OUT_COUNT =
+ Db.Ado.SqlQuery<decimal>("SELECT count(*) FROM MES_INV_ITEM_OUTS A where A.WORK_NO = '"+ mesSalesDelivery.BillNo+ "' and A.BILL_TYPE_ID = 200 AND A.TRANSACTION_NO = 250")
+ .First();
+
+ if (XS_OUT_COUNT > 0)
+ {
+ throw new NotImplementedException("璇ラ攢鍞氦浠橀�氱煡鍗曞凡鐢熸垚鍑哄簱鍗曪紝涓嶈兘淇敼锛�");
+ }
+
var update = base.DeleteById(mesSalesDelivery.Id);
var insertOrUpdate = db
.Deleteable<SalesDeliveryNoticeDetail>().In(decimals)
@@ -69,6 +78,15 @@
SalesDeliveryNotice mesSalesDelivery,
List<SalesDeliveryNoticeDetail> mesSalesDeliveryDatas, string type)
{
+
+ var XS_OUT_COUNT =
+ Db.Ado.SqlQuery<decimal>("SELECT count(*) FROM MES_INV_ITEM_OUTS A where A.WORK_NO = '" + mesSalesDelivery.BillNo + "' and A.BILL_TYPE_ID = 200 AND A.TRANSACTION_NO = 250")
+ .First();
+
+ if (XS_OUT_COUNT > 0)
+ {
+ throw new NotImplementedException("璇ラ攢鍞氦浠橀�氱煡鍗曞凡鐢熸垚鍑哄簱鍗曪紝涓嶈兘淇敼锛�");
+ }
if (mesSalesDelivery.Id != null) base.DeleteById(mesSalesDelivery.Id);
if (mesSalesDeliveryDatas.Count > 0)
--
Gitblit v1.9.3