From 27d7b50f43c85f12507ab1a61290fa9551d4d780 Mon Sep 17 00:00:00 2001 From: yxj <1qaz@123> Date: 星期二, 17 五月 2022 16:58:35 +0800 Subject: [PATCH] 不良评审单、工序进站单、工序出站单、委外接收单、委外发出单删除时增加制单人与删除人是否一致系统参数控制;不良明细良率报表修改优化,原报表取值数据代码里写死改为取存储过程里数据显示 --- WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs index 9992ce8..96b346d 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"); } } -- Gitblit v1.9.1