From cc89062c39d21fa063acd7c82ef655c77d9753a7 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期日, 27 四月 2025 08:18:16 +0800
Subject: [PATCH] 三升排产保存取消生产资源控制
---
WebAPI/DLL/ClsSc_ICMOStepBillWorkQtyStatus_Tmp.cs | 48 +++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 43 insertions(+), 5 deletions(-)
diff --git a/WebAPI/DLL/ClsSc_ICMOStepBillWorkQtyStatus_Tmp.cs b/WebAPI/DLL/ClsSc_ICMOStepBillWorkQtyStatus_Tmp.cs
index 4338d3b..32ab337 100644
--- a/WebAPI/DLL/ClsSc_ICMOStepBillWorkQtyStatus_Tmp.cs
+++ b/WebAPI/DLL/ClsSc_ICMOStepBillWorkQtyStatus_Tmp.cs
@@ -193,9 +193,10 @@
//瀹℃牳
- public bool CheckBill(int HSourceID, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, int HICMOInterID, int HICMOEntryID, Int64 lngBillKey, ref string sReturn)
+ public bool CheckBill(int HSourceID, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, int HICMOInterID, int HICMOEntryID, Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn)
{
-
+ string sql = "";
+ DataSet ds;
try
{
string HChecker = DBUtility.ClsPub.CurUserName;
@@ -203,6 +204,24 @@
oCn.BeginTran();
oCn.RunProc(" Update " + MvarItemKey + " set HBillStatus='2',HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString());
sReturn = "瀹℃牳鍗曟嵁鎴愬姛锛�";
+
+ //瀹℃牳鍚庢帶鍒�===============================================Begin================================================================
+ sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'";
+ ds = oCn.RunProcReturn(sql, procName);
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ sReturn = "瀹℃牳杩囩▼涓嚭閿欙紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ oCn.RollBack();
+ return false;
+ }
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString();
+ oCn.RollBack();
+ return false;
+ }
+ //瀹℃牳鍚庢帶鍒�===============================================End================================================================
+
oCn.Commit();
//鐢熸垚璋冩嫧鍗�
//寰楀埌璋冩嫧鍗� mainid 鍗曟嵁鍙�
@@ -221,9 +240,10 @@
}
//鍙嶅鏍�
- public bool AbandonCheck(int HSourceID, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, int HICMOInterID, int HICMOEntryID, Int64 lngBillKey, ref string sReturn)
+ public bool AbandonCheck(int HSourceID, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, int HICMOInterID, int HICMOEntryID, Int64 lngBillKey, string HBillNo, string procName, string sUser, ref string sReturn)
{
-
+ string sql = "";
+ DataSet ds;
try
{
string HChecker = DBUtility.ClsPub.CurUserName;
@@ -231,7 +251,25 @@
oCn.BeginTran();
//杩樺師鍗曟嵁鐘舵�佷负鏈鏍哥姸鎬�
oCn.RunProc(" Update " + MvarItemKey + " set HBillStatus='1',HChecker='',HCheckDate='' Where HInterID=" + lngBillKey.ToString());
- sReturn = "瀹℃牳鍗曟嵁鎴愬姛锛�";
+ sReturn = "鍙嶅鏍稿崟鎹垚鍔燂紒";
+
+ //瀹℃牳鍚庢帶鍒�===============================================Begin================================================================
+ sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'";
+ ds = oCn.RunProcReturn(sql, procName);
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ sReturn = "鍙嶅鏍歌繃绋嬩腑鍑洪敊锛岃涓庣綉缁滅鐞嗕汉鍛樿仈绯�";
+ oCn.RollBack();
+ return false;
+ }
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString();
+ oCn.RollBack();
+ return false;
+ }
+ //瀹℃牳鍚庢帶鍒�===============================================End================================================================
+
oCn.Commit();
//鐢熸垚璋冩嫧鍗�
//寰楀埌璋冩嫧鍗� mainid 鍗曟嵁鍙�
--
Gitblit v1.9.1