From b0c29a051b101921da5e757cae7250f92e878d41 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期三, 06 四月 2022 16:58:58 +0800 Subject: [PATCH] 采购订单委外订单 安瑞采购经理职位查看权限 --- WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs | 67 +++++++++++++++++++++++---------- 1 files changed, 47 insertions(+), 20 deletions(-) diff --git a/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs b/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs index 104769c..230388f 100644 --- a/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs +++ b/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs @@ -28,36 +28,45 @@ /// </summary> [Route("Gy_WorkPayTypeBill/GetWorkPayTypelist")] [HttpGet] - public object GetWorkPayTypelist(string sWhere) + public object GetWorkPayTypelist(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Gy_WorkPayType", 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_WorkPayTypeList " + sWhere, "h_v_Gy_WorkPayTypeList"); + ds = oCN.RunProcReturn("select * from h_v_Gy_WorkPayTypeList order by 宸ヨ祫绫诲瀷浠g爜 ", "h_v_Gy_WorkPayTypeList"); } else { string sql1 = "select * from h_v_Gy_WorkPayTypeList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ " order by 宸ヨ祫绫诲瀷浠g爜 "; ds = oCN.RunProcReturn(sql, "h_v_Gy_WorkPayTypeList"); } - if (ds == null || ds.Tables[0].Rows.Count == 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "false锛�"; - objJsonResult.data = null; - return objJsonResult; - } - else - { - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "Sucess锛�"; - objJsonResult.data = ds.Tables[0]; - return objJsonResult; - } + + //if (ds.Tables[0].Rows.Count != 0 || ds != null) + //{ + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + //} + //else + //{ + //objJsonResult.code = "0"; + //objJsonResult.count = 0; + //objJsonResult.Message = "鏃犳暟鎹�"; + //objJsonResult.data = null; + //return objJsonResult; + //} } catch (Exception e) { @@ -78,8 +87,16 @@ /// </summary> [Route("Gy_WorkPayTypeBill/Delete_Json")] [HttpGet] - public object Delete_Json(string HInterID) + public object Delete_Json(string HInterID,string user) { + if (!DBUtility.ClsPub.Security_Log("Gy_WorkPayType_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } //鐢╥d鏌ュ埌璇ュ璞� string sql = "select * from Gy_WorkPayType where HItemID = " + HInterID; ds = oCN.RunProcReturn(sql, "Gy_WorkPayType"); @@ -160,11 +177,21 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); + string msg4 = sArray[2].ToString(); ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Gy_WorkPayType_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DLL.ClsGy_WorkPayTypeBill oBill = new DLL.ClsGy_WorkPayTypeBill(); List<Model.ClsGy_WorkPayType_Model> lsmain = new List<Model.ClsGy_WorkPayType_Model>(); msg2 = msg2.Replace("\\", ""); -- Gitblit v1.9.1