From 0633cf93eedfd75b65367e8c7626fc98c00cfd86 Mon Sep 17 00:00:00 2001
From: hao <1836460075@qq.com>
Date: 星期四, 13 十一月 2025 14:46:29 +0800
Subject: [PATCH] 采购退货申请防呆
---
StandardInterface/MES.Service/service/CgthSqManager.cs | 9 +++++++++
StandardInterface/MES.Service/Modes/MesInvItemOuts.cs | 5 +++++
2 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/StandardInterface/MES.Service/Modes/MesInvItemOuts.cs b/StandardInterface/MES.Service/Modes/MesInvItemOuts.cs
index eeae84c..2dd22f6 100644
--- a/StandardInterface/MES.Service/Modes/MesInvItemOuts.cs
+++ b/StandardInterface/MES.Service/Modes/MesInvItemOuts.cs
@@ -296,6 +296,11 @@
/// </summary>
[SugarColumn(ColumnName = "STATES")]
public string? States { get; set; }
+ /// <summary>
+ /// 涓婄骇鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "SJ_DH")]
+ public string? Sjdh { get; set; }
[SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
diff --git a/StandardInterface/MES.Service/service/CgthSqManager.cs b/StandardInterface/MES.Service/service/CgthSqManager.cs
index 59e979c..2bd9b1c 100644
--- a/StandardInterface/MES.Service/service/CgthSqManager.cs
+++ b/StandardInterface/MES.Service/service/CgthSqManager.cs
@@ -162,6 +162,15 @@
private bool SaveOrUpdateData(SqlSugarScope db, CgthSq mesWomcaa,
List<CgthSqDetail> mesWomcabs)
{
+ // 1. 鏍¢獙鏄惁瀛樺湪棰嗘枡璁板綍锛圡esInvItemOuts锛�
+ var hasMaterialOut = db.Queryable<MesInvItemOuts>()
+ .Any(x => x.Sjdh == mesWomcaa.BillNo);
+
+ if (hasMaterialOut)
+ {
+ throw new Exception($"MES宸叉湁棰嗘枡璁板綍锛屽崟鍙凤細{mesWomcaa.BillNo}锛屼笉鑳芥洿鏂帮紒");
+ }
+
if (mesWomcaa.Id != null) base.DeleteById(mesWomcaa.Id);
if (mesWomcabs.Count > 0)
--
Gitblit v1.9.3