From c5f74c8471358dbfb6977f4d9d392b656c31a16a Mon Sep 17 00:00:00 2001
From: hao <1836460075@qq.com>
Date: 星期四, 17 七月 2025 17:26:29 +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