From 569bb53b544e2e178b64e229d45f047da032af36 Mon Sep 17 00:00:00 2001
From: hao <1836460075@qq.com>
Date: 星期五, 27 六月 2025 10:25:14 +0800
Subject: [PATCH] 销售退货，发货，采购退货申请反审核防呆
---
StandardInterface/MES.Service/service/QC/RetMatService.cs | 23 ++++++++++++++++++++++-
1 files changed, 22 insertions(+), 1 deletions(-)
diff --git a/StandardInterface/MES.Service/service/QC/RetMatService.cs b/StandardInterface/MES.Service/service/QC/RetMatService.cs
index ddf0bee..dd0cedb 100644
--- a/StandardInterface/MES.Service/service/QC/RetMatService.cs
+++ b/StandardInterface/MES.Service/service/QC/RetMatService.cs
@@ -55,7 +55,7 @@
s.ITEM_MODEL AS spec,
a.THLD005 AS qty,
a.THLD014 AS reason,
- s.ID AS item_id
+ s.ID AS itemId
FROM MES_ITEM_THL_DETAIL a
LEFT JOIN MES_ITEM_THL b ON a.THLMID = b.ID
LEFT JOIN MES_ITEMS s ON a.ITEM_ID = s.ID
@@ -131,5 +131,26 @@
}
+
+ public void Reject(string docNo, string user)
+ {
+ var db = SqlSugarHelper.GetInstance();
+
+ string sql = @"
+ UPDATE MES_ITEM_THL
+ SET BH_TIME = SYSDATE,
+ BH_USER = :pi_user,
+ THL010 = '',
+ THL011 = '',
+ THL012 = 0
+ WHERE THL_NO = :pi_no
+ ";
+
+ db.Ado.ExecuteCommand(sql,
+ new SugarParameter("pi_user", user),
+ new SugarParameter("pi_no", docNo)
+ );
+ }
+
}
}
--
Gitblit v1.9.3