From e4513b5abb10a008f82ca45805a1f568141b8390 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期二, 19 十一月 2024 10:10:51 +0800 Subject: [PATCH] 保养记录,点检记录,设备停机单,设备开机单,设备工艺参数点检表列表,故障登记单,派工单,维修记录单,维修验收单,维修签到单 后端更改数据库查询 --- WebAPI/Controllers/BaseSet/Gy_SourceController.cs | 36 ++++++++++++++++++------------------ 1 files changed, 18 insertions(+), 18 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs index e5bed9c..9ebd278 100644 --- a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs @@ -38,14 +38,14 @@ { List<object> columnNameList = new List<object>(); //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� - //if (!DBUtility.ClsPub.Security_Log("Gy_Source_Query", 1, false, user)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犳潈闄愭煡璇�!"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Source_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳潈闄愭煡璇�!"; + objJsonResult.data = null; + return objJsonResult; + } if (sWhere == null || sWhere.Equals("")) { @@ -110,15 +110,15 @@ string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); - ////鏌ョ湅鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Gy_Source_Edit", 1, false, msg2)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_Source_Edit", 1, false, msg2)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); @@ -676,7 +676,7 @@ { try { - string sql1 = string.Format("select hitemid,hnumber,hname from Gy_Source"+ sWhere + " order by hnumber"); + string sql1 = string.Format("select hitemid,hnumber,hname,HUSEORGID from Gy_Source" + sWhere + " order by hnumber"); ds = oCN.RunProcReturn(sql1, "Gy_Source"); -- Gitblit v1.9.1