From d065710c923bdf99f395d04d31926b8b9c16edef Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期五, 01 八月 2025 09:36:06 +0800 Subject: [PATCH] 条码主档:作废 增加 作废前控制 --- WebAPI/Controllers/BaseSet/Gy_MaterialController.cs | 31 +++++++++++++++++++++++++++++++ 1 files changed, 31 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs index f1a2477..d17d39e 100644 --- a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs @@ -2218,6 +2218,24 @@ //杩涜闇�瑕佽繘琛岀殑浣滃簾/鍙嶄綔搴熸搷浣� if (IsAudit == 0) //浣滃簾鎻愪氦 { + string sql_deleteBeforeCtrl = "exec h_p_Gy_BarCodeBill_Cancelltion_Before " + HInterID; + DataSet ds_deleteBeforeCtrl = oCN.RunProcReturn(sql_deleteBeforeCtrl, "h_p_Gy_BarCodeBill_Cancelltion_Before"); + if (ds_deleteBeforeCtrl == null || ds_deleteBeforeCtrl.Tables.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "浣滃簾澶辫触锛氭潯鐮佷綔搴熷墠鎺у埗澶辫触锛�"; + objJsonResult.data = null; + return objJsonResult; + }else if(ds_deleteBeforeCtrl.Tables[0].Rows[0]["HBack"].ToString() != "0") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "浣滃簾澶辫触锛�" + ds_deleteBeforeCtrl.Tables[0].Rows[0]["HRemark"].ToString(); + objJsonResult.data = null; + return objJsonResult; + } + oCN.BeginTran(); //浣滃簾鏉$爜 @@ -2665,6 +2683,7 @@ int HNowSPID = mainList[0].HNowSPID; string HMouldUseStatus = mainList[0].HMouldUseStatus; int HUSEORGID = mainList[0].HUSEORGID; + DateTime HNextMainDate = mainList[0].HNextMainDate; //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); @@ -2745,6 +2764,7 @@ ",HNowWHID=" + HNowWHID + ",HNowSPID=" + HNowSPID + ",HInitLife='" + HInitLife + + ",HNextMainDate='" + HNextMainDate + "',HMouldUseStatus='" + HMouldUseStatus + "' where HInterID=" + HInterID.ToString()); @@ -2964,6 +2984,17 @@ objJsonResult.data = null; return objJsonResult; } + + ds = oCN.RunProcReturn("select * from Gy_MouldFileMain where HInterID = " + hmainid + " and ISNULL(HChecker,'') <> ''", "Gy_MouldFileMain"); + if (ds.Tables[0].Rows.Count > 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍒犻櫎澶辫触锛佸崟鎹凡瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.DeleteBill(hmainid, ref DBUtility.ClsPub.sExeReturnInfo)) { oCN.BeginTran(); -- Gitblit v1.9.1