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 | 47 +++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 43 insertions(+), 4 deletions(-)
diff --git a/StandardInterface/MES.Service/service/CgthSqManager.cs b/StandardInterface/MES.Service/service/CgthSqManager.cs
index 44b5ba0..2bd9b1c 100644
--- a/StandardInterface/MES.Service/service/CgthSqManager.cs
+++ b/StandardInterface/MES.Service/service/CgthSqManager.cs
@@ -115,23 +115,62 @@
private bool UpdateData(SqlSugarScope db, CgthSq mesWomCgth,
List<CgthSqDetail> mesWomcabs)
{
- var decimals = mesWomcabs.Select(s => s.Id).ToArray();
+ //var decimals = mesWomcabs.Select(s => s.Id).ToArray();
//鎵爜涓嶅厑璁稿垹闄�
-
- throw new NotImplementedException("鎵爜涓嶅厑璁稿垹闄�");
+ var hasMaterialOut = db.Queryable<MesInvItemOuts>()
+ .Any(x => x.WorkNo == mesWomCgth.BillNo);
+
+ if (hasMaterialOut)
+ {
+ throw new Exception($"MES鏈夐鏂欒褰曪紝鍗曞彿锛歿mesWomCgth.BillNo}锛屼笉鑳藉垹闄わ紒");
+ }
+ /*
var update = base.DeleteById(mesWomCgth.Id);
var insertOrUpdate = db
.Deleteable<CgthSqDetail>().In(decimals)
.ExecuteCommand() > 0;
- if (update && insertOrUpdate) return true;
+ if (update && insertOrUpdate) return true;*/
+ // throw new NotImplementedException("鏇存柊澶辫触");
+
+ var decimals = mesWomcabs
+ ?.Where(x => x.Id.HasValue)
+ .Select(x => x.Id.Value)
+ .ToArray() ?? new decimal[0];
+ var update = true;
+ if (mesWomCgth != null)
+ {
+ if (mesWomCgth.Id != null)
+ {
+ update = base.DeleteById(mesWomCgth.Id);
+ }
+ }
+ var insertOrUpdate = true;
+ if (decimals != null && decimals.Length > 0)
+ {
+ insertOrUpdate = db.Deleteable<CgthSqDetail>().In(decimals).ExecuteCommand() > 0;
+ }
+
+ if (update && insertOrUpdate)
+ {
+ return true;
+ }
throw new NotImplementedException("鏇存柊澶辫触");
}
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