From 919ffdcf960b886d99a1977767add03ba42e4cd1 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 10 二月 2022 17:34:05 +0800 Subject: [PATCH] 基础建模每个模块的权限 --- WebAPI/Controllers/BaseSet/Gy_MaterialController.cs | 50 ++ WebAPI/Controllers/BaseSet/Gy_PropertyController.cs | 11 WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs | 43 + WebAPI/Controllers/BaseSet/Gy_SourceController.cs | 49 ++ WebAPI/Controllers/BaseSet/Gy_SupplierController.cs | 13 WebAPI/Controllers/基础资料/基础资料/Gy_MaintainBillController.cs | 16 WebAPI/Controllers/基础资料/基础资料/Gy_DotCheckBillController.cs | 7 WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs | 39 + WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs | 12 WarM/仓库管理/Gy_BarCodeBill_ChaiMa.cs | 2 WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs | 50 ++ WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs | 48 ++ WebAPI/Controllers/基础资料/基础资料/Gy_ConkReasonBillController.cs | 33 + WebAPI/Controllers/BaseSet/Gy_UnitController.cs | 49 ++ WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs | 56 ++- WebAPI/Controllers/BaseSet/Pay_PeriodInfoSetController.cs | 51 +- WebAPI/Controllers/BaseSet/Gy_GroupController.cs | 76 +++- WebAPI/Controllers/WebAPIController.cs | 37 + WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs | 32 + WebAPI/Controllers/BaseSet/Gy_CheckItemController.cs | 45 +- WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs | 32 + WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs | 31 + WebAPI/Controllers/BaseSet/Gy_ProcessController.cs | 51 +- WebAPI/Controllers/BaseSet/Gy_CustomerController.cs | 26 + WebAPI/Controllers/基础资料/工资基础资料/Gy_ProcPriceController.cs | 22 + WebAPI/Controllers/BaseSet/Gy_WarehouseController.cs | 50 +- LMES/LMES.csproj.user | 1 27 files changed, 661 insertions(+), 271 deletions(-) diff --git a/LMES/LMES.csproj.user b/LMES/LMES.csproj.user index 51efb67..23bc47a 100644 --- a/LMES/LMES.csproj.user +++ b/LMES/LMES.csproj.user @@ -9,5 +9,6 @@ <ErrorReportUrlHistory /> <FallbackCulture>zh-CN</FallbackCulture> <VerifyUploadedFiles>false</VerifyUploadedFiles> + <ProjectView>ShowAllFiles</ProjectView> </PropertyGroup> </Project> \ No newline at end of file diff --git "a/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs" "b/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs" index 6ff1a3a..c44fce7 100644 --- "a/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs" +++ "b/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs" @@ -200,7 +200,7 @@ model.HQty = DBUtility.ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HNum2].Value); model.HQty = DBUtility.ClsPub.isInt(grdMain_Pay.Rows[i].Cells[HNum2].Value); model.HBatchNo = DBUtility.ClsPub.isStrNull(grdMain_Pay.Rows[i].Cells[HBatchNo].Value); - model.HMaterID = DBUtility.ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HMaterCol].Value); + model.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"].ToString()); model.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HUnitID"].ToString()); model.HSupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSupID"].ToString()); model.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"].ToString()); diff --git a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs index 650b243..dcd802f 100644 --- a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs @@ -25,10 +25,20 @@ /// </summary> [Route("Gy_BadReason/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_BadReason", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " order by HItemID desc", "h_v_IF_BadReasonList"); diff --git a/WebAPI/Controllers/BaseSet/Gy_CheckItemController.cs b/WebAPI/Controllers/BaseSet/Gy_CheckItemController.cs index 2fbc50f..3e3e33f 100644 --- a/WebAPI/Controllers/BaseSet/Gy_CheckItemController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_CheckItemController.cs @@ -27,10 +27,20 @@ /// </summary> [Route("Gy_CheckItem/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_QCCheckItem", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckItemList " + sWhere, "h_v_IF_QCCheckItemList"); @@ -126,14 +136,15 @@ DAL.ClsGy_QCCheckItem_View oDeptHlp = new DAL.ClsGy_QCCheckItem_View(); try { - //if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鍒犻櫎鏉冮檺"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鍒犻櫎鏉冮檺"; + objJsonResult.data = null; + return objJsonResult; + } + if (oDeptHlp.GetInfoByID(HItemID)) { if (oDept.HavChildCodes(HItemID)) @@ -313,14 +324,14 @@ //鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!ClsPub.Security_Log(msg5, 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } if (!DBUtility.ClsPub.AllowNumber(HNumber)) diff --git a/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs b/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs index 377f7f9..71c441a 100644 --- a/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs @@ -27,10 +27,20 @@ /// </summary> [Route("Gy_Currency/list1")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Currency", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_CurrencyList where 绂佺敤鏍囪=''" + sWhere, "h_v_Gy_CurrencyList"); @@ -106,10 +116,10 @@ { DataSet ds; var _value = msg["msg"].ToString(); - string msg1 = _value.ToString(); - //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - //string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = _value.ToString(); + string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg1 = sArray[0].ToString(); + string user = sArray[1].ToString(); Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //鑾峰彇鏈�澶D鍊艰祴鍊� @@ -124,6 +134,16 @@ ListModels oListModels = new ListModels(); try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Currency_Edit", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DAL.ClsGy_Currency_Ctl oBill = new DAL.ClsGy_Currency_Ctl(); List<Model.ClsGy_Currency_Model> lsmain = new List<Model.ClsGy_Currency_Model>(); msg1 = msg1.Replace("\\", ""); @@ -306,21 +326,21 @@ /// <returns></returns> [Route("DeltetGy_Currency")] [HttpGet] - public object DeltetGy_Currency(string HItemID) + public object DeltetGy_Currency(string HItemID,string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Currency_Edit", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_CustomerController.cs b/WebAPI/Controllers/BaseSet/Gy_CustomerController.cs index df3bb8f..ac746cc 100644 --- a/WebAPI/Controllers/BaseSet/Gy_CustomerController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_CustomerController.cs @@ -25,10 +25,19 @@ /// </summary> [Route("Gy_Customer/list")] [HttpGet] - public object list(string sWhere, string Organization) + public object list(string sWhere,string user, string Organization) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Crm_CustomerFileList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } string sql1 = string.Format(@"select * from h_v_Gy_CustomerList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -165,14 +174,25 @@ try { var _value = oMain["oMain"].ToString(); - string msg1 = _value.ToString(); + string msg3 = _value.ToString(); + string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg1 = sArray[0].ToString(); + string msg2 = sArray[1].ToString(); //鍙嶅簭鍒楀寲 msg1 = "[" + msg1.ToString() + "]"; DAL.ClsGy_Customer_Ctl oDept = new DAL.ClsGy_Customer_Ctl(); DAL.ClsGy_Customer_View oDeptHlp = new DAL.ClsGy_Customer_View(); - + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Customer_Edit", 1, false, msg2)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } List<Customer> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Customer>>(msg1); diff --git a/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs b/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs index 357293e..b23a06c 100644 --- a/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_DepartmentController.cs @@ -25,10 +25,19 @@ /// </summary> [Route("Gy_Department/list")] [HttpGet] - public object list(string sWhere,string Organization) + public object list(string sWhere,string user,string Organization) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_Department", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } string sql1 = string.Format(@"select * from h_v_IF_DepartmentList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -103,21 +112,21 @@ /// <returns></returns> [Route("DeltetGy_Department")] [HttpGet] - public object DeltetGy_Department(string HItemID) + public object DeltetGy_Department(string HItemID,string user) { DataSet ds; DataSet ds1; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Department_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) @@ -368,6 +377,16 @@ string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); + + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Department_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Department> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Department>>(msg2); diff --git a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs index 5047ff9..82236eb 100644 --- a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs @@ -27,10 +27,19 @@ /// </summary> [Route("Gy_Employee/list")] [HttpGet] - public object list(string sWhere,string Organization) + public object list(string sWhere,string user,string Organization) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } string sql1 = string.Format(@"select * from h_v_IF_EmployeeList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -261,9 +270,20 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); + + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Gy_Employee> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Employee>>(msg2); @@ -795,21 +815,20 @@ /// <returns></returns> [Route("DeltetGy_Employee")] [HttpGet] - public object DeltetGy_Employee(string HItemID) + public object DeltetGy_Employee(string HItemID,string user) { DataSet ds; - //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Employee_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_GroupController.cs b/WebAPI/Controllers/BaseSet/Gy_GroupController.cs index 22e0ba4..d5247bc 100644 --- a/WebAPI/Controllers/BaseSet/Gy_GroupController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_GroupController.cs @@ -26,10 +26,20 @@ /// </summary> [Route("Gy_Group/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_Group_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere, "h_v_GroupList"); @@ -146,10 +156,26 @@ { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg2 = sArray[0].ToString(); + string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); + + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log(msg5, 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } + //鍙嶅簭鍒楀寲 - msg1 = "[" + msg1.ToString() + "]"; + msg2 = "[" + msg2.ToString() + "]"; DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl(); - List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1); + List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg2); long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; @@ -227,9 +253,9 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); - //string msg4 = sArray[2].ToString(); - //string msg5 = sArray[3].ToString(); + string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg2); @@ -253,15 +279,15 @@ long HLevel = 1; //var HProcID = ""; - ////鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log(msg5, 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ @@ -430,9 +456,9 @@ /// 鐝粍鍒犻櫎鍔熻兘 /// </summary> /// <returns></returns> - [Route("DeltetGy_Group")] + [Route("Gy_Group/DeltetGy_Group")] [HttpGet] - public object DeltetGy_Group(string HItemID) + public object DeltetGy_Group(string HItemID,string user) { DataSet ds; DataSet ds1; @@ -440,14 +466,14 @@ try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Group_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs index 6ecfc85..5d086a8 100644 --- a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs @@ -27,10 +27,19 @@ /// </summary> [Route("Gy_Material/list")] [HttpGet] - public object list(string sWhere, string Organization) + public object list(string sWhere,string user, string Organization) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Material", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } string sql1 = string.Format(@"select * from h_v_Gy_MaterialList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -80,12 +89,23 @@ { DataSet ds; var _value = msg["msg"].ToString(); - string msg1 = _value.ToString(); - //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - //string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = _value.ToString(); + string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg1 = sArray[0].ToString(); + string msg2 = sArray[1].ToString(); Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Material_Edit", 1, false, msg2)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + //鑾峰彇鏈�澶D鍊艰祴鍊� DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_Material ", "Gy_Material"); if (Maxds != null || Maxds.Tables[0].Rows.Count > 0) @@ -96,6 +116,7 @@ HItemID = maxid; } ListModels oListModels = new ListModels(); + try { DLL.ClsGy_Material_Ctl oBill = new DLL.ClsGy_Material_Ctl(); @@ -276,21 +297,20 @@ /// <returns></returns> [Route("Gy_Material/Delete")] [HttpGet] - public object DeltetGy_Material(string HItemID) + public object DeltetGy_Material(string HItemID,string user) { DataSet ds; - //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Material_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs b/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs index aa0f926..14bef06 100644 --- a/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_OrderBackInfoController.cs @@ -27,10 +27,19 @@ /// </summary> [Route("Gy_OrderBackInfo/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_OrderBackInfoList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_OrderBackInfoList " + sWhere, "h_v_Gy_OrderBackInfoList"); @@ -120,11 +129,20 @@ /// </summary> [Route("Gy_OrderBackInfo/Delete_Json")] [HttpGet] - public object Delete_Json(long HItemID, string User, string ModRightNameDelete) + public object Delete_Json(long HItemID, string User) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_OrderBackInfo_Delete", 1, false, User)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = oCN.RunProcReturn("delete from Gy_OrderBackInfo where HItemID = " + HItemID, "Gy_OrderBackInfo"); objJsonResult.code = "1"; @@ -158,12 +176,18 @@ { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg2 = sArray[0].ToString(); + string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); + + //鍙嶅簭鍒楀寲 - msg1 = "[" + msg1.ToString() + "]"; + msg2 = "[" + msg2.ToString() + "]"; + List<Gy_OrderBackInfo> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderBackInfo>>(msg2); - List<Gy_OrderBackInfo> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_OrderBackInfo>>(msg1); - - long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID; + long HItemID = int.Parse(msg3); string HNumber = list[0].HNumber; string HName = list[0].HName; string HShortNumber = list[0].HNumber; @@ -172,7 +196,17 @@ string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; bool HUseFlag = list[0].HUseFlag; - + + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log(msg5, 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (!DBUtility.ClsPub.AllowNumber(HNumber)) { objJsonResult.code = "0"; @@ -256,7 +290,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; objJsonResult.data = null; return objJsonResult; } diff --git a/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs b/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs index cf4015b..9839763 100644 --- a/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_OrderLevController.cs @@ -27,10 +27,20 @@ /// </summary> [Route("Gy_OrderLev/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_OrderLev", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_OrderLevList " + sWhere, "h_v_Gy_OrderLevList"); @@ -206,7 +216,11 @@ try { var _value = oMain["oMain"].ToString(); - string msg1 = _value.ToString(); + string msg3 = _value.ToString(); + string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg1 = sArray[0].ToString(); + string msg2 = sArray[1].ToString(); + //鍙嶅簭鍒楀寲 msg1 = "[" + msg1.ToString() + "]"; @@ -227,7 +241,17 @@ string HYX = list[0].HYX; bool HStopflag = list[0].HStopflag; bool HUseFlag = list[0].HUseFlag; - + + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_VipLevel_Edit", 1, false, msg2)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (!DBUtility.ClsPub.AllowNumber(HNumber)) { objJsonResult.code = "0"; @@ -314,7 +338,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; objJsonResult.data = null; return objJsonResult; } diff --git a/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs b/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs index d0a35c5..16639e3 100644 --- a/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_ProcessController.cs @@ -275,7 +275,7 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //鍙嶅簭鍒楀寲 @@ -310,15 +310,15 @@ long HDeptID = list[0].HDeptID; long HProcID = list[0].HProcID; - ////鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log("Gy_Process_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.data = null; + return objJsonResult; + } //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ @@ -412,10 +412,20 @@ /// </summary> [Route("Gy_Process/list")] [HttpGet] - public object getProcessList(string sWhere) + public object getProcessList(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_Process_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessList " + sWhere, "h_v_Gy_ProcessList"); @@ -499,22 +509,21 @@ /// <returns></returns> [Route("DeltetGy_Process")] [HttpGet] - public object DeltetGy_Process(string HItemID) + public object DeltetGy_Process(string HItemID, string user) { DataSet ds; DataSet ds1; - //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Process_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_PropertyController.cs b/WebAPI/Controllers/BaseSet/Gy_PropertyController.cs index c1b6c78..61e8eca 100644 --- a/WebAPI/Controllers/BaseSet/Gy_PropertyController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_PropertyController.cs @@ -25,10 +25,19 @@ /// </summary> [Route("Gy_Property/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Property", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_PropertyList " + sWhere, "h_v_IF_PropertyList"); diff --git a/WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs b/WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs index de922ca..a4a89bc 100644 --- a/WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_QCCheckClassController.cs @@ -27,10 +27,20 @@ /// </summary> [Route("Gy_QCCheckClass/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_QCCheckItem", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckClassList " + sWhere, "h_v_IF_QCCheckClassList"); @@ -207,15 +217,29 @@ { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg2 = sArray[0].ToString(); + string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); //鍙嶅簭鍒楀寲 - msg1 = "[" + msg1.ToString() + "]"; + msg2 = "[" + msg2.ToString() + "]"; DAL.ClsGy_QCCheckClass_Ctl oDept = new DAL.ClsGy_QCCheckClass_Ctl(); DAL.ClsGy_QCCheckClass_View oDeptHlp = new DAL.ClsGy_QCCheckClass_View(); + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log(msg5, 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } - List<CheckItem> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<CheckItem>>(msg1); + List<CheckItem> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<CheckItem>>(msg2); long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID; string HNumber = list[0].HNumber; @@ -313,7 +337,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.Message = "鏃犱繚瀛樻潈闄�"; objJsonResult.data = null; return objJsonResult; } diff --git a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs index f72e812..bb25b6e 100644 --- a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs @@ -28,10 +28,19 @@ /// </summary> [Route("Gy_Source/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_Source", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_SourceList where 1=1 ", "h_v_IF_SourceList"); @@ -80,10 +89,21 @@ { DataSet ds; var _value = msg["msg"].ToString(); - string msg1 = _value.ToString(); - //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - //string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = _value.ToString(); + string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + 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; + } + Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //鑾峰彇鏈�澶D鍊艰祴鍊� @@ -280,21 +300,20 @@ /// <returns></returns> [Route("DeltetGy_Source")] [HttpGet] - public object DeltetGy_Source(string HItemID) + public object DeltetGy_Source(string HItemID,string user) { DataSet ds; - //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Source_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs index 87a95d2..e919172 100644 --- a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs @@ -25,10 +25,19 @@ /// </summary> [Route("Gy_Supplier/list")] [HttpGet] - public object list(string sWhere,string Organization) + public object list(string sWhere,string user,string Organization) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Supplier", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } string sql1 = string.Format(@"select * from h_v_Gy_SupplierList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -303,7 +312,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; objJsonResult.data = null; return objJsonResult; } diff --git a/WebAPI/Controllers/BaseSet/Gy_UnitController.cs b/WebAPI/Controllers/BaseSet/Gy_UnitController.cs index 8aa4810..35b155e 100644 --- a/WebAPI/Controllers/BaseSet/Gy_UnitController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_UnitController.cs @@ -27,10 +27,20 @@ /// </summary> [Route("Gy_Unit/list1")] [HttpGet] - public object list(string sWhere,string Organization) + public object list(string sWhere,string user,string Organization) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_UnitGroup", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + string sql1 = string.Format(@"select * from h_v_Gy_UnitList where 绂佺敤鏍囪='' and 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -96,12 +106,13 @@ { DataSet ds; var _value = msg["msg"].ToString(); - string msg1 = _value.ToString(); - //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - //string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg4 = _value.ToString(); + string[] sArray = msg4.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg1 = sArray[0].ToString(); + string msg3 = sArray[1].ToString(); Int64 HItemID = 0; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + //鑾峰彇鏈�澶D鍊艰祴鍊� DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_Unit ", "Gy_Unit"); if (Maxds != null || Maxds.Tables[0].Rows.Count > 0) @@ -114,6 +125,16 @@ ListModels oListModels = new ListModels(); try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_UnitGroup_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DAL.ClsGy_Unit_Ctl oBill = new DAL.ClsGy_Unit_Ctl(); List<Model.ClsGy_Unit_Model> lsmain = new List<Model.ClsGy_Unit_Model>(); msg1 = msg1.Replace("\\", ""); @@ -295,21 +316,21 @@ /// <returns></returns> [Route("DeltetGy_Unit")] [HttpGet] - public object DeltetGy_Unit(string HItemID) + public object DeltetGy_Unit(string HItemID,string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_UnitGroup_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_WarehouseController.cs b/WebAPI/Controllers/BaseSet/Gy_WarehouseController.cs index a4e2e57..2f4d238 100644 --- a/WebAPI/Controllers/BaseSet/Gy_WarehouseController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_WarehouseController.cs @@ -25,10 +25,19 @@ /// </summary> [Route("Gy_Warehouse/list")] [HttpGet] - public object list(string sWhere,string Organization) + public object list(string sWhere,string user,string Organization) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Warehouse", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } string sql1 = string.Format(@"select * from h_v_IF_WareHouseList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -280,9 +289,8 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); - //string msg4 = sArray[2].ToString(); - //string msg5 = sArray[3].ToString(); + string msg3 = sArray[1].ToString(); + //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(msg2); @@ -305,14 +313,14 @@ string HUpDater = list[0].HUpDater; ////鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!ClsPub.Security_Log("Gy_Warehouse_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.data = null; + return objJsonResult; + } //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ @@ -395,21 +403,21 @@ /// <returns></returns> [Route("DeltetGy_Warehouse")] [HttpGet] - public object DeltetGy_Warehouse(string HItemID) + public object DeltetGy_Warehouse(string HItemID,string user) { DataSet ds; DataSet ds1; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_Warehouse_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs b/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs index 33cf622..3d1cc34 100644 --- a/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs @@ -26,10 +26,20 @@ /// </summary> [Route("Gy_WorkCenter/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_WorkCenterList " + sWhere, "h_v_WorkCenterList"); @@ -227,10 +237,10 @@ DAL.ClsGy_WorkCenter_View oDeptHlp = new DAL.ClsGy_WorkCenter_View(); var _value = oMain["oMain"].ToString(); - string msg1 = _value.ToString(); - string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = _value.ToString(); + string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg1 = sArray[0].ToString(); + string msg2 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //鍙嶅簭鍒楀寲 @@ -256,15 +266,15 @@ var HLevel = list[0].HLevel; var HWorkTimes = list[0].HWorkTimes; - ////鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log("Gy_WorkCenter_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.data = null; + return objJsonResult; + } //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ @@ -442,7 +452,7 @@ /// <returns></returns> [Route("DeltetGy_WorkCenter")] [HttpGet] - public object DeltetGy_WorkCenter(string HItemID) + public object DeltetGy_WorkCenter(string HItemID,string user) { DataSet ds; DataSet ds1; @@ -450,14 +460,14 @@ try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Pay_PeriodInfoSetController.cs b/WebAPI/Controllers/BaseSet/Pay_PeriodInfoSetController.cs index e8a2aa3..7fd8432 100644 --- a/WebAPI/Controllers/BaseSet/Pay_PeriodInfoSetController.cs +++ b/WebAPI/Controllers/BaseSet/Pay_PeriodInfoSetController.cs @@ -26,10 +26,19 @@ /// </summary> [Route("Pay_PeriodInfoSet/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Pay_PeriodInfoSetList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Pay_PeriodInfoSetList " + sWhere, "h_v_Pay_PeriodInfoSetList"); @@ -187,7 +196,7 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //鍙嶅簭鍒楀寲 @@ -204,15 +213,15 @@ bool HStopflag = list[0].HStopflag; string HUseFlag = list[0].HUseFlag; - ////鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log("Pay_PeriodInfoSet_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄�"; + objJsonResult.data = null; + return objJsonResult; + } //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ @@ -285,22 +294,20 @@ /// <returns></returns> [Route("DeltetPay_PeriodInfoSet")] [HttpGet] - public object DeltetPay_PeriodInfoSet(string HItemID) + public object DeltetPay_PeriodInfoSet(string HItemID,string user) { DataSet ds; - DataSet ds1; - //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Pay_PeriodInfoSet_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git a/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs b/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs index c763c47..d90c677 100644 --- a/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs +++ b/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs @@ -25,10 +25,19 @@ /// </summary> [Route("Xt_ORGANIZATIONS/list")] [HttpGet] - public object list(string sWhere, string Organization) + public object list(string sWhere,string user, string Organization) { try { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_WorkCenter_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } string sql1 = string.Format(@"select * from h_v_IF_ORGANIZATIONSList where 缁勭粐鍚嶇О='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { @@ -139,7 +148,7 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //鍙嶅簭鍒楀寲 @@ -155,15 +164,15 @@ string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; - ////鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log("Gy_WorkCenter_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.data = null; + return objJsonResult; + } //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index e4d5592..c3bb13f 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -1270,10 +1270,21 @@ { DataSet ds; var _value = msg["msg"].ToString(); - string msg1 = _value.ToString(); - //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - //string msg2 = sArray[0].ToString(); - //string msg3 = sArray[1].ToString(); + string msg3 = _value.ToString(); + string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg1 = sArray[0].ToString(); + string msg2 = sArray[1].ToString(); + + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_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(); //鑾峰彇鏈�澶D鍊艰祴鍊� @@ -1469,21 +1480,21 @@ /// <returns></returns> [Route("DeltetGy_BadReason")] [HttpGet] - public object DeltetGy_BadReason(string HItemID) + public object DeltetGy_BadReason(string HItemID,string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_BadReason_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ConkReasonBillController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ConkReasonBillController.cs" index 442ac6e..6ec6d8b 100644 --- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ConkReasonBillController.cs" +++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ConkReasonBillController.cs" @@ -22,10 +22,20 @@ #region 鏁呴殰鍘熷洜鍒楄〃 [Route("Gy_ConkReasonBill/Get_ConkReasonBillList")] [HttpGet] - public object Get_ConkReasonBillList(string sWhere) + public object Get_ConkReasonBillList(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_ConkReason", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + ds = Sc_GetConkReasonBill(sWhere); if (ds == null) { @@ -72,8 +82,18 @@ #region [鏁呴殰鍘熷洜鍒犻櫎鍔熻兘] [Route("Gy_ConkReasonBill/set_DeleteBill")] [HttpGet] - public object set_DeleteBill(string HItemID) + public object set_DeleteBill(string HItemID,string user) { + //鍒犻櫎鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_ConkReason_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HItemID); if (lngBillKey == 0) @@ -158,6 +178,15 @@ ListModels oListModels = new ListModels(); try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_ConkReason_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Model.ClsGy_ConkReason_Model oBill = new Model.ClsGy_ConkReason_Model(); List<Model.ClsGy_ConkReason_Model> lsmain = new List<Model.ClsGy_ConkReason_Model>(); msg1 = msg1.Replace("\\", ""); diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" index 8791f60..a637901 100644 --- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" +++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_DotCheckBillController.cs" @@ -74,7 +74,7 @@ try { - if (!DBUtility.ClsPub.Security_Log("Gy_DotCheck", 1, false, User)) + if (!DBUtility.ClsPub.Security_Log("Gy_DotCheck_Delete", 1, false, User)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -82,6 +82,7 @@ objJsonResult.data = null; return objJsonResult; } + ds = oCN.RunProcReturn("Select * from Gy_DotCheck Where HItemID='" + HItemID + "'", "Gy_DotCheck", ref DBUtility.ClsPub.sExeReturnInfo); if (ds.Tables[0].Rows.Count != 0) { @@ -167,7 +168,7 @@ string HUseFlag = list[0].HUseFlag; //鍒ゆ柇鏉冮檺 - if (!ClsPub.Security_Log("Gy_DotCheck", 1, false, msg4)) + if (!ClsPub.Security_Log("Gy_DotCheck_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -257,7 +258,7 @@ bool HEndFlag = list[0].HEndFlag; //鍒ゆ柇鏉冮檺 - if (!ClsPub.Security_Log("Gy_DotCheck", 1, false, msg3)) + if (!ClsPub.Security_Log("Gy_DotCheck_Edit", 1, false, msg3)) { objJsonResult.code = "0"; objJsonResult.count = 0; diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_MaintainBillController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_MaintainBillController.cs" index ad93445..151caf3 100644 --- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_MaintainBillController.cs" +++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_MaintainBillController.cs" @@ -257,14 +257,14 @@ int HParentID = list[0].HParentID; //鍒ゆ柇鏉冮檺 - //if (!ClsPub.Security_Log("Gy_Maintain_Edit", 1, false, msg3)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!ClsPub.Security_Log("Gy_Maintain_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鎵惧埌璇ュ姛鑳芥ā鍧楋紒"; + objJsonResult.data = null; + return objJsonResult; + } if (!DBUtility.ClsPub.AllowNumber(HNumber)) { diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ProcPriceController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ProcPriceController.cs" index fe20814..57fd32f 100644 --- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ProcPriceController.cs" +++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_ProcPriceController.cs" @@ -21,10 +21,20 @@ #region 杩斿洖宸ュ簭宸ヤ环鍒楄〃 [Route("Gy_ProcPrice/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_ProcPriceList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + ds = oCN.RunProcReturn("select * from h_v_Gy_ProcPriceList where 1 = 1 " + sWhere, "h_v_Gy_ProcPriceList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { @@ -71,9 +81,19 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string OperationType = sArray[2].ToString().Trim(); + string msg4 = sArray[3].ToString(); bool bResult; try { + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Gy_ProcPriceList_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } msg2 = "[" + msg2.ToString() + "]"; List<ClsGy_ProcPrice> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_ProcPrice>>(msg2); List<ClsGy_ProcPrice> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_ProcPrice>>(msg3); -- Gitblit v1.9.1