From a72d939b5cafd1d02b3cae75975f1959fd0f814a Mon Sep 17 00:00:00 2001 From: ch <37327@LLOOCCY> Date: 星期三, 27 七月 2022 08:46:55 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs | 17 +++++++++++++++-- 1 files changed, 15 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs index 9992ce8..4f3054e 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs @@ -7,6 +7,7 @@ using System.Net; using System.Net.Http; using System.Web.Http; +using ViewAPI; using WebAPI.Models; namespace WebAPI.Controllers.MJGL @@ -28,6 +29,7 @@ { try { + Log.LogInfo("鎴愬姛锛�"); //璁板綍鎻愪氦鏁版嵁 //缂栬緫鏉冮檺 if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBillList", 1, false, user)) { @@ -37,7 +39,7 @@ objJsonResult.data = null; return objJsonResult; } - + Log.LogInfo("鏈夋潈闄�"); ds = Sc_GetMouldProdInHouseBill(sWhere,Organization); //if (ds.Tables[0].Rows.Count != 0 || ds != null) @@ -69,6 +71,7 @@ public static DataSet Sc_GetMouldProdInHouseBill(string sWhere, string Organization) { + LogService.Write(sWhere+";"+ Organization); string sql1 = string.Format(@"select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -77,6 +80,7 @@ else { string sql = sql1 + sWhere+ "order by hmainid desc"; + Log.LogInfo(sql); return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList"); } } @@ -631,7 +635,16 @@ if (bResult) { string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; - oCn.RunProc(sql); + DataSet db=oCn.RunProcReturn(sql, "h_p_Sc_MouldChangeFileStatus"); + if (db.Tables[0].Rows[0]["issuccess"].ToString()=="0") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍣ㄥ叿浣嶇疆鍚屾澶辫触锛�"; + //WebAPIController.Add_Log("閫佽揣鍗曚笅鎺�", UserName, "鐢熸垚閫佽揣鍗�"); + objJsonResult.data = 1; + return objJsonResult; + } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; -- Gitblit v1.9.1