From 01685f3ab68f64b51b83eee40af90f4030866691 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期二, 03 六月 2025 18:18:21 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/BaseSet/Gy_MaterialController.cs | 32 +++++++++++++++++++++++++++++--- 1 files changed, 29 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs index 4a38771..4fc4425 100644 --- a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs @@ -583,6 +583,18 @@ } else { + //宸插鏍镐笉鍏佽淇敼 + DataSet dss; + dss = oCN.RunProcReturn("select * from Gy_Material where HItemID=" + oBill.oModel.HItemID, "Gy_Material"); + //鍒ゆ柇鏄惁鍙紪杈� + if (dss.Tables[0].Rows[0]["HCheckEmp"].ToString() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹姸鎬佸凡缁忓鏍革紝涓嶅厑璁镐慨鏀癸紒"; + objJsonResult.data = null; + return objJsonResult; + } bResult = oBill.ModifyByID(oBill.oModel.HItemID); } if (bResult) @@ -848,6 +860,7 @@ string msg2 = sArray[1].ToString(); string msg_HUSEORGID = sArray[2].ToString(); string msg_itemIdList = sArray[3].ToString(); + string msg_UpdateInfo = sArray[4].ToString(); bool bResult = false; Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -880,7 +893,7 @@ msg1 = msg1.Replace("\\", ""); msg1 = msg1.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_Material(msg1); - JObject jobject = JObject.Parse(msg1); + JObject jobject = JObject.Parse(msg_UpdateInfo); var paramStr = ""; foreach (var property in jobject.Properties()) { @@ -889,10 +902,12 @@ // 鎷兼帴鏍煎紡: key=value paramStr += string.Format("{0}='{1}',", key, value); + // 鍒犻櫎鏈�鍚庝竴涓�楀彿 + } - LogService.Write(paramStr); + paramStr = paramStr.Substring(0, paramStr.Length - 1); - bResult = oBill.ModifyByIDListDynamic(msg_itemIdList, paramStr); + bResult = oBill.ModifyByIDListDynamic(msg_itemIdList, paramStr, lsmain); if (bResult) @@ -2949,6 +2964,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