From dac1d793ad118eebf9048588a356ae0ea8a3aa95 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 10 二月 2022 17:42:41 +0800 Subject: [PATCH] 基础建模每个模块的权限 --- WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs | 37 +++++++++++++++++++++++++++++++++---- 1 files changed, 33 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs b/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs index 50fb796..7b51d3f 100644 --- a/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs +++ b/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs @@ -29,18 +29,27 @@ /// </summary> [Route("Gy_WorkTypeBill/GetWorkTypelist")] [HttpGet] - public object GetWorkTypelist(string sWhere) + public object GetWorkTypelist(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Gy_WorkType", 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_WorkTypeList " + sWhere, "h_v_Gy_WorkTypeList"); + ds = oCN.RunProcReturn("select * from h_v_Gy_WorkTypeList order by 宸ョ浠g爜", "h_v_Gy_WorkTypeList"); } else { string sql1 = "select * from h_v_Gy_WorkTypeList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ " order by 宸ョ浠g爜"; ds = oCN.RunProcReturn(sql, "h_v_Gy_WorkTypeList"); } if (ds == null || ds.Tables[0].Rows.Count == 0) @@ -79,8 +88,17 @@ /// </summary> [Route("Gy_WorkTypeBill/Delete_Json")] [HttpGet] - public object Delete_Json(string HInterID) + public object Delete_Json(string HInterID,string user) { + if (!DBUtility.ClsPub.Security_Log("Gy_WorkType_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + //鐢╥d鏌ュ埌璇ュ璞� string sql = "select * from Gy_WorkType where HItemID = "+HInterID; ds = oCN.RunProcReturn(sql, "Gy_WorkType"); @@ -161,11 +179,22 @@ 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(); ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log(msg4, 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DLL.ClsGy_WorkTypeBill oBill = new DLL.ClsGy_WorkTypeBill(); List<Model.ClsGy_WorkType_Model> lsmain = new List<Model.ClsGy_WorkType_Model>(); msg2 = msg2.Replace("\\", ""); -- Gitblit v1.9.1