From fa930a0008d9c3fa3fcd5e0bac6d8fe812059479 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 21 一月 2022 17:30:44 +0800 Subject: [PATCH] 器具设备工资权限 --- WebAPI/Controllers/SBGL/Gy_EquipTypeController.cs | 40 ++ WebAPI/Controllers/工资管理/Gy_ClassTimePrjSubController.cs | 39 + WebAPI/Controllers/工资管理/Gy_ClassTimePrjBillController.cs | 60 ++- WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs | 38 + WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs | 37 + WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs | 38 + WebAPI/Controllers/Sc_MouldRepairInBillListController.cs | 118 +++++- WebAPI/Controllers/工资管理/Gy_GroupEmpBillController.cs | 41 + WebAPI/Controllers/工资管理/Pay_OtherBalBillController.cs | 41 + WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs | 113 ++++- WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs | 56 ++- WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs | 33 + WebAPI/Controllers/GZGL/Gy_DuSubsidyItemBillController.cs | 35 + WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs | 31 + WebAPI/Controllers/SBGL/Sb_EquipRepairSendWorkBillController.cs | 38 + WarM/仓库管理/Gy_BarCodeBill_ChaiMa.cs | 2 WebAPI/Controllers/工资管理/Pay_WorkTimesBillController.cs | 41 + WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs | 31 + WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs | 30 + WebAPI/Controllers/工资管理/Pay_SingleBalBillController.cs | 41 + WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs | 30 + WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs | 47 ++ WebAPI/Controllers/工资管理/Pay_GroupBalBillController.cs | 31 + 23 files changed, 780 insertions(+), 231 deletions(-) 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 0b8af13..6ff1a3a 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" @@ -100,7 +100,7 @@ grdMain.Columns[HTagCol].Visible = false; grdMain.Columns[HInterID].Visible = false; - intoDate(); + //intoDate(); //鏍煎紡鍖栫綉鏍� //DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid_Mater); } diff --git a/WebAPI/Controllers/GZGL/Gy_DuSubsidyItemBillController.cs b/WebAPI/Controllers/GZGL/Gy_DuSubsidyItemBillController.cs index 8163f59..5f2e34d 100644 --- a/WebAPI/Controllers/GZGL/Gy_DuSubsidyItemBillController.cs +++ b/WebAPI/Controllers/GZGL/Gy_DuSubsidyItemBillController.cs @@ -28,10 +28,19 @@ /// </summary> [Route("Gy_DuSubsidyItemBill/Gy_DuSubsidyItemlist")] [HttpGet] - public object Gy_DuSubsidyItemlist(string sWhere) + public object Gy_DuSubsidyItemlist(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Gy_DuSubsidyItem", 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_DuSubsidyItemList " + sWhere, "h_v_Gy_DuSubsidyItemList"); @@ -70,16 +79,25 @@ } #endregion - #region 鍒犻櫎宸ヨ祫绫诲瀷 + #region 鎵hˉ椤圭洰鍒犻櫎 /// <summary> - /// 宸ヨ祫绫诲瀷鍒楄〃鍒犻櫎鎸夐挳 + /// 鎵hˉ椤圭洰鍒犻櫎鎸夐挳 ///鍙傛暟锛歴tring sql銆� ///杩斿洖鍊硷細object銆� /// </summary> [Route("Gy_DuSubsidyItemBill/Delete_Json")] [HttpGet] - public object Delete_Json(string HInterID) + public object Delete_Json(string HInterID,string user) { + if (!DBUtility.ClsPub.Security_Log("Gy_DuSubsidyItem_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + //鐢╥d鏌ュ埌璇ュ璞� string sql = "select * from Gy_DuSubsidyItem where HItemID = " + HInterID; ds = oCN.RunProcReturn(sql, "Gy_DuSubsidyItem"); @@ -160,11 +178,20 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); + string msg3 = sArray[1].ToString(); ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Gy_DuSubsidyItem_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsGy_DuSubsidyItemBill oBill = new DLL.ClsGy_DuSubsidyItemBill(); List<Model.ClsGy_DuSubsidyItem_Model> lsmain = new List<Model.ClsGy_DuSubsidyItem_Model>(); msg2 = msg2.Replace("\\", ""); diff --git a/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs b/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs index 104769c..b9c2fbd 100644 --- a/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs +++ b/WebAPI/Controllers/GZGL/Gy_WorkPayTypeBillController.cs @@ -28,10 +28,18 @@ /// </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"); @@ -78,8 +86,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 +176,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("\\", ""); diff --git a/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs b/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs index 50fb796..c16870c 100644 --- a/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs +++ b/WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs @@ -29,10 +29,19 @@ /// </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"); @@ -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("\\", ""); diff --git a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs index bd25fd3..974dade 100644 --- a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs +++ b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs @@ -23,18 +23,18 @@ [Route("Gy_EquipFileMain/GetList")] [HttpGet] - public object GetList(string sWhere) + public object GetList(string sWhere,string user) { try { - //if (!DBUtility.ClsPub.Security_Log(ModRightNameSelect, 1, false, user)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "娌℃湁鏌ョ湅鏉冮檺"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Gy_EquipFileList", 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_EquipFileMainList " + sWhere + "order by 鏃ユ湡 desc", "h_v_Gy_EquipFileMainList"); @@ -77,8 +77,17 @@ #region [璁惧妗f鍒犻櫎鍔熻兘] [Route("Gy_EquipFileMain/Delete_EquipFile")] [HttpGet] - public object Delete_EquipFile(string HItemID) + public object Delete_EquipFile(string HItemID,string user) { + if (!DBUtility.ClsPub.Security_Log("Gy_EquipFile_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + string s = ""; Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HItemID); @@ -156,6 +165,15 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); + + if (!DBUtility.ClsPub.Security_Log("Gy_EquipFile_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; @@ -250,6 +268,15 @@ string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); + if (!DBUtility.ClsPub.Security_Log("Gy_EquipFile_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Models.ClsGy_EquipFileMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_EquipFileMain>>(msg2); diff --git a/WebAPI/Controllers/SBGL/Gy_EquipTypeController.cs b/WebAPI/Controllers/SBGL/Gy_EquipTypeController.cs index b468dfd..ff3fd1b 100644 --- a/WebAPI/Controllers/SBGL/Gy_EquipTypeController.cs +++ b/WebAPI/Controllers/SBGL/Gy_EquipTypeController.cs @@ -24,10 +24,19 @@ [Route("Gy_EquipType/GetList")] [HttpGet] - public object GetList(string sWhere) + public object GetList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Gy_EquipTypeList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + ds = oCN.RunProcReturn("select HItemID,HParentID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_EquipFileType where 1=1 " + sWhere, "Gy_EquipFileType"); if (ds == null) { @@ -61,8 +70,17 @@ #region [璁惧鍒嗙被鍒犻櫎鍔熻兘] [Route("Gy_EquipType/Delete_EquipType")] [HttpGet] - public object Delete_EquipType(string HItemID) + public object Delete_EquipType(string HItemID,string user) { + if (!DBUtility.ClsPub.Security_Log("Gy_EquipType_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + string s = ""; Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HItemID); @@ -112,7 +130,16 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); + string msg4 = sArray[2].ToString(); + if (!DBUtility.ClsPub.Security_Log("Gy_EquipType_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; @@ -188,7 +215,16 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); + if (!DBUtility.ClsPub.Security_Log("Gy_EquipType_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Models.ClsGy_EquipFileType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_EquipFileType>>(msg2); diff --git a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs index ba11fb0..1cb308f 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckBillController.cs @@ -24,10 +24,18 @@ /// <returns></returns> [Route("Sb_EquipDotCheckBill/GetEquipDotCheckBillList")] [HttpGet] - public object GetEquipDotCheckBillList(string sWhere) + public object GetEquipDotCheckBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckBillList", 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_Sb_EquipDotCheckBillList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckBillList"); @@ -95,12 +103,22 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DAL.ClsSb_EquipDotCheckBill oBill = new DAL.ClsSb_EquipDotCheckBill(); List<Model.ClsSb_EquipDotCheckBillMain> lsmain = new List<Model.ClsSb_EquipDotCheckBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -220,17 +238,17 @@ /// <returns></returns> [Route("Sb_EquipDotCheckBill/DeltetEquipDotCheckBillList")] [HttpGet] - public object DeltetEquipDotCheckBillList(string HInterID) + public object DeltetEquipDotCheckBillList(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log_second("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log_second("Sb_EquipDotCheckBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; diff --git a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs index 302c7ba..42919f3 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckPlanBillController.cs @@ -20,10 +20,19 @@ /// <returns></returns> [Route("Sb_EquipDotCheckPlanBill/GetEquipDotCheckPlanBillList")] [HttpGet] - public object GetEquipDotCheckPlanBillList(string sWhere) + public object GetEquipDotCheckPlanBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBillList", 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_Sb_EquipDotCheckPlanBillList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckPlanBillList"); @@ -91,12 +100,21 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DAL.ClsSb_EquipDotCheckPlanBill oBill = new DAL.ClsSb_EquipDotCheckPlanBill(); List<Model.ClsSb_EquipDotCheckPlanBillMain> lsmain = new List<Model.ClsSb_EquipDotCheckPlanBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -215,17 +233,17 @@ /// <returns></returns> [Route("Sb_EquipDotCheckPlanBill/DeltetEquipDotCheckPlanBillList")] [HttpGet] - public object DeltetEquipDotCheckPlanBillList(string HInterID) + public object DeltetEquipDotCheckPlanBillList(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckPlanBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; diff --git a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs index 8f00320..0a4fd5c 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs @@ -23,10 +23,19 @@ #region 璁惧鐐规瑙勭▼鍗曞垪琛� [Route("Sb_EquipDotCheckRuleBill/GetEquipDotCheckRuleList")] [HttpGet] - public object GetEquipDotCheckRuleList(string sWhere) + public object GetEquipDotCheckRuleList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckRuleBillList", 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_Sb_EquipDotCheckRuleList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipDotCheckRuleList"); @@ -68,8 +77,16 @@ #region 璁惧鐐规瑙勭▼璁板綍鍒犻櫎鍔熻兘 [Route("Sb_EquipDotCheckRuleBill/DeleteEquipDotCheckRuleBillList")] [HttpGet] - public object DeleteEquipDotCheckRuleBillList(string HInterID) + public object DeleteEquipDotCheckRuleBillList(string HInterID,string user) { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckRuleBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); if (lngBillKey == 0) @@ -190,12 +207,22 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipDotCheckRuleBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DLL.ClsSb_EquipDotCheckRuleBill oBill = new DLL.ClsSb_EquipDotCheckRuleBill(); List<Models.ClsSb_EquipDotCheckRuleBillMain> lsmain = new List<Models.ClsSb_EquipDotCheckRuleBillMain>(); msg2 = msg2.Replace("\\", ""); diff --git a/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs index 494ec2a..e3c8d30 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs @@ -25,10 +25,18 @@ /// <returns></returns> [Route("Sb_EquipMaintainBill/GetEquipMaintainBillList")] [HttpGet] - public object GetEquipMaintainBillList(string sWhere) + public object GetEquipMaintainBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainBillList", 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_Sc_EquipMaintain " + sWhere + " order by hmainid desc", "h_v_Sc_EquipMaintain"); @@ -91,11 +99,20 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainBill_Edit", 1, false, msg5)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DAL.ClsSb_EquipMaintainBill oBill = new DAL.ClsSb_EquipMaintainBill(); List<Model.ClsSb_EquipMaintainBillMain> lsmain = new List<Model.ClsSb_EquipMaintainBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -240,17 +257,17 @@ /// <returns></returns> [Route("Sb_EquipMaintainBill/DeltetEquipMaintainBillList")] [HttpGet] - public object DeltetEquipMaintainBillList(string HInterID) + public object DeltetEquipMaintainBillList(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; diff --git a/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs index 6ef21b0..3474a8c 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipMaintainPlanBillController.cs @@ -20,10 +20,19 @@ /// <returns></returns> [Route("Sb_EquipMaintainPlanBill/GetEquipMaintainPlanBillList")] [HttpGet] - public object GetEquipMaintainPlanBillList(string sWhere) + public object GetEquipMaintainPlanBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainPlanBillList", 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_Sc_EquipMaintainPlan " + sWhere + " order by hmainid desc", "h_v_Sc_EquipMaintainPlan"); @@ -86,11 +95,20 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckBill_Edit", 1, false, msg5)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DAL.ClsSb_EquipMaintainPlanBill oBill = new DAL.ClsSb_EquipMaintainPlanBill(); List<Model.ClsSb_EquipMaintainPlanBillMain> lsmain = new List<Model.ClsSb_EquipMaintainPlanBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -235,8 +253,16 @@ /// <returns></returns> [Route("Sb_EquipMaintainPlanBill/DeltetEquipMaintainPlanBillList")] [HttpGet] - public object DeltetEquipMaintainPlanBillList(string HInterID) + public object DeltetEquipMaintainPlanBillList(string HInterID,string user) { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainPlanBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); if (lngBillKey == 0) diff --git a/WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs index 4bc6994..f145840 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs @@ -22,10 +22,19 @@ #region 璁惧淇濆吇瑙勭▼鍗曞垪琛� [Route("Sb_EquipMaintainRuleBill/GetEquipMaintainRuleList")] [HttpGet] - public object GetEquipMaintainRuleList(string sWhere) + public object GetEquipMaintainRuleList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainRuleBillList", 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_Sb_EquipMaintainRuleList " + sWhere + " order by hmainid desc", "h_v_Sb_EquipMaintainRuleList"); @@ -67,8 +76,16 @@ #region 璁惧淇濆吇瑙勭▼璁板綍鍒犻櫎鍔熻兘 [Route("Sb_EquipMaintainRuleBill/DeleteEquipMaintainRuleBillList")] [HttpGet] - public object DeleteEquipMaintainRuleBillList(string HInterID) + public object DeleteEquipMaintainRuleBillList(string HInterID,string user) { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainRuleBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); if (lngBillKey == 0) @@ -249,11 +266,21 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); + string msg5 = sArray[3].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainRuleBill_Edit", 1, false, msg5)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DLL.ClsSb_EquipMaintainRuleBill oBill = new DLL.ClsSb_EquipMaintainRuleBill(); List<Models.ClsSb_EquipMaintainRuleBillMain> lsmain = new List<Models.ClsSb_EquipMaintainRuleBillMain>(); msg2 = msg2.Replace("\\", ""); diff --git a/WebAPI/Controllers/SBGL/Sb_EquipRepairSendWorkBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipRepairSendWorkBillController.cs index 2090c65..9d16d2f 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipRepairSendWorkBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipRepairSendWorkBillController.cs @@ -24,10 +24,18 @@ #region 璁惧缁翠慨娲惧伐鍗曟煡璇㈠垪琛� [Route("Sb_EquipRepairSendWorkBill/GetEquipRepairSendWorkBillList")] [HttpGet] - public object GetEquipRepairSendWorkBillList(string sWhere) + public object GetEquipRepairSendWorkBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairSendWorkBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } string sql = "select * from h_v_Sb_EquipRepairSendWorkBillList where 1=1 "; if (sWhere == "" || sWhere == null) { @@ -98,8 +106,18 @@ int hentryid = int.Parse(sArray[2].ToString());//瀛愯〃鐨勯『搴廼d int OperationType = int.Parse(sArray[3].ToString());//鏁版嵁绫诲瀷 1娣诲姞 3淇敼 + string msg4 = sArray[4].ToString(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairSendWorkBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + omodel = Newtonsoft.Json.JsonConvert.DeserializeObject<ClsSb_EquipRepairSendWorkBillMain>(msg2); string BillType = "3909"; @@ -207,19 +225,19 @@ #region 璁惧缁翠慨娲惧伐鍗� 鍒犻櫎 [Route("Sb_EquipRepairSendWorkBill/DeleteWorkBill")] [HttpGet] - public object MouldDeleteBill(long HInterID, string User, string ModRightNameDelete) + public object MouldDeleteBill(long HInterID, string User) { 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("Sb_EquipRepairSendWorkBill_Delete", 1, false, User)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鍒犻櫎鏉冮檺"; + objJsonResult.data = null; + return objJsonResult; + } oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo); if (oBill.omodel.HBillStatus > 1) diff --git a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs index df55140..01fd6e5 100644 --- a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs +++ b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs @@ -31,10 +31,18 @@ /// <returns></returns> [Route("Sb_EqpRepairWorkBill/GetEqpRepairWorkBillList")] [HttpGet] - public object GetEqpRepairWorkBillList(string sWhere) + public object GetEqpRepairWorkBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairWorkBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sb_EquipRepairWorkBill_s(sWhere); @@ -84,10 +92,18 @@ /// <returns></returns> [Route("Sb_EqpRepairWorkBill/GetEqpRepairCheckWorkBillList")] [HttpGet] - public object GetEqpRepairCheckWorkBillList(string sWhere) + public object GetEqpRepairCheckWorkBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sb_EquipRepairCheckWorkBill_s(sWhere); objJsonResult.code = "1"; @@ -134,10 +150,18 @@ /// <returns></returns> [Route("Sb_EqpRepairWorkBill/GetEqpConkBookBillList")] [HttpGet] - public object GetEqpConkBookBillList(string sWhere) + public object GetEqpConkBookBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sb_EqpConkBookBillList_s(sWhere); objJsonResult.code = "1"; @@ -193,12 +217,21 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); //string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairWorkBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsSb_EquipRepairWorkBill oBill = new DLL.ClsSb_EquipRepairWorkBill(); List<Models.ClsSb_EquipRepairWorkBillMain> lsmain = new List<Models.ClsSb_EquipRepairWorkBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -408,17 +441,17 @@ /// <returns></returns> [Route("Sb_EqpRepairWorkBill/DeltetEqpRepairWorkBill")] [HttpGet] - public object DeltetEqpRepairWorkBill(string HInterID) + public object DeltetEqpRepairWorkBill(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairWorkBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; @@ -499,12 +532,21 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); //string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsSb_EquipRepairCheckBill oBill = new DLL.ClsSb_EquipRepairCheckBill(); List<Model.ClsSb_EquipRepairCheckBillMain> lsmain = new List<Model.ClsSb_EquipRepairCheckBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -688,17 +730,17 @@ /// <returns></returns> [Route("Sb_EqpRepairWorkBill/DeltetEqpRepairCheckBill")] [HttpGet] - public object DeltetEqpRepairCheckBill(string HInterID) + public object DeltetEqpRepairCheckBill(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; @@ -779,12 +821,21 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); - + string msg4 = sArray[2].ToString(); //string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DLL.ClsSb_EquipConkBookBill oBill = new DLL.ClsSb_EquipConkBookBill(); List<Model.ClsSb_EquipConkBookBillMain> lsmain = new List<Model.ClsSb_EquipConkBookBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -968,17 +1019,17 @@ /// <returns></returns> [Route("Sb_EqpRepairWorkBill/DeltetEqpConkBookBill")] [HttpGet] - public object DeltetEqpConkBookBill(string HInterID) + public object DeltetEqpConkBookBill(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sb_EquipConkBookBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; diff --git a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs index d0ea4e9..e9279f3 100644 --- a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs +++ b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs @@ -470,10 +470,18 @@ /// <returns></returns> [Route("Sc_MouldConkBookBill/GetMouldConkBookBillList")] [HttpGet] - public object GetMouldConkBookBillList(string sWhere) + public object GetMouldConkBookBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_MouldConkBookBillList_s(sWhere); objJsonResult.code = "1"; @@ -520,10 +528,19 @@ /// <returns></returns> [Route("Sc_MouldRepairCheckBill/GetMouldRepairCheckBillList")] [HttpGet] - public object GetMouldRepairCheckBillList(string sWhere) + public object GetMouldRepairCheckBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + ds = Sc_MouldRepairCheckBillList_s(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -626,10 +643,18 @@ /// <returns></returns> [Route("Sb_MouldRepairWorkBill/GetMouldRepairWorkBillList")] [HttpGet] - public object GetMouldRepairWorkBillList(string sWhere) + public object GetMouldRepairWorkBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_MouldRepairWorkBillList_s(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) @@ -1266,12 +1291,22 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); + string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DAL.ClsSb_MouldRepairWorkBill oBill = new DAL.ClsSb_MouldRepairWorkBill(); List<Model.ClsSb_MouldRepairWorkBillMain> lsmain = new List<Model.ClsSb_MouldRepairWorkBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -1451,17 +1486,17 @@ /// <returns></returns> [Route("Sb_MouldRepairWorkBill/DeltetMouldRepairWorkBill")] [HttpGet] - public object DeltetMouldRepairWorkBill(string HInterID) + public object DeltetMouldRepairWorkBill(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; @@ -1687,6 +1722,15 @@ ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + DLL.ClsSc_MouldRepairCheckBill oBill = new DLL.ClsSc_MouldRepairCheckBill(); List<Model.ClsSc_MouldRepairCheckBillMain> lsmain = new List<Model.ClsSc_MouldRepairCheckBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -1870,17 +1914,17 @@ /// <returns></returns> [Route("Sc_MouldRepairCheckBill/DeltetMouldRepairCheckBill")] [HttpGet] - public object DeltetMouldRepairCheckBill(string HInterID) + public object DeltetMouldRepairCheckBill(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairCheckBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; @@ -1948,7 +1992,7 @@ #region 妯″叿鏁呴殰鐧昏琛ㄤ繚瀛�/缂栬緫 /// <summary> - /// 淇濆瓨妯″叿缁翠慨鍗� + /// 淇濆瓨鏁呴殰鐧昏琛� /// </summary> /// <param name="msg"></param> /// <returns></returns> @@ -1961,12 +2005,20 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); - + string msg4 = sArray[2].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DAL.ClsSc_MouldConkBookBill oBill = new DAL.ClsSc_MouldConkBookBill(); List<Model.ClsSc_MouldConkBookBillMain> lsmain = new List<Model.ClsSc_MouldConkBookBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -2146,22 +2198,22 @@ #region [妯″叿鏁呴殰鐧昏琛ㄥ垹闄ゅ姛鑳絔 /// <summary> - /// 妯″叿缁翠慨鍗曞垹闄ゅ姛鑳� + /// 妯″叿鏁呴殰鐧昏琛ㄥ垹闄ゅ姛鑳� /// </summary> /// <returns></returns> [Route("Sc_MouldConkBookBill/DeltetMouldConkBookBill")] [HttpGet] - public object DeltetMouldConkBookBill(string HInterID) + public object DeltetMouldConkBookBill(string HInterID,string user) { //缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } Int64 lngBillKey = 0; diff --git a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs index a62889f..3c39e3b 100644 --- a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs +++ b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs @@ -25,10 +25,18 @@ #region 鍣ㄥ叿缁翠慨娲惧伐鍗曟煡璇� [Route("Sc_MouldRepairSendWorkBill/GetMouldRepairSendWorkBillList")] [HttpGet] - public object GetMouldRepairSendWorkBillList(string sWhere) + public object GetMouldRepairSendWorkBillList(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairSendWorkBillList", 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_Sc_MouldRepairSendWorkBill ", "h_v_Sc_MouldRepairSendWorkBill"); @@ -103,8 +111,18 @@ int hentryid = int.Parse(sArray[2].ToString());//瀛愯〃鐨勯『搴廼d int OperationType = int.Parse(sArray[3].ToString());//鏁版嵁绫诲瀷 1娣诲姞 3淇敼 + string msg4 = sArray[4].ToString(); try { + if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairSendWorkBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + omodel = Newtonsoft.Json.JsonConvert.DeserializeObject<ClsSb_MouldRepairWorkBillMain>(msg2); string BillType = "3843"; @@ -225,19 +243,19 @@ #region 鍣ㄥ叿缁翠慨娲惧伐鍗� 鍒犻櫎 [Route("Sc_MouldRepairSendWorkBill/MouldDeleteBill")] [HttpGet] - public object MouldDeleteBill(long HInterID, string User, string ModRightNameDelete) + public object MouldDeleteBill(long HInterID, string user) { 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("Sc_MouldRepairSendWorkBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鍒犻櫎鏉冮檺"; + objJsonResult.data = null; + return objJsonResult; + } oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo); if (oBill.omodel.HBillStatus > 1) @@ -290,19 +308,19 @@ [HttpGet] public object CheckDeOAuditBill(int HInterID, int IsAudit, string CurUserName) { - // string ModRightNameCheck = ""; 璇ユā鍧楃殑瀹℃牳鍔熻兘 + DBUtility.ClsPub.CurUserName = CurUserName; //瀛樺偍鐢ㄦ埛鍚� 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("Sc_MouldRepairSendWorkBill_Check", 1, false, CurUserName)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } //鍒ゆ柇id 鏄惁澶т簬0 if (HInterID <= 0) diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjBillController.cs" index 36551eb..326d3dd 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjBillController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjBillController.cs" @@ -27,10 +27,18 @@ /// </summary> [Route("Gy_ClassTimePrj/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrj", 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_ClassTimePrjList " + sWhere, "h_v_Gy_ClassTimePrjList"); @@ -83,14 +91,14 @@ DAL.ClsGy_ClassTimePrj_View oDeptHlp = new DAL.ClsGy_ClassTimePrj_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)) @@ -164,9 +172,23 @@ { 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() + "]"; - List<ClsGy_ClassTimePrj_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_ClassTimePrj_Model>>(msg1); + msg2 = "[" + msg2.ToString() + "]"; + List<ClsGy_ClassTimePrj_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_ClassTimePrj_Model>>(msg2); long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; @@ -251,14 +273,14 @@ long HGroupID = list[0].HGroupID; //鍒ゆ柇鏉冮檺 - //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/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs" index f7ec5a2..30aea4d 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_ClassTimePrjSubController.cs" @@ -25,10 +25,19 @@ /// </summary> [Route("Gy_ClassTimePrjSub/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrjSub", 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_ClassTimePrjSubList where 1=1 ", "h_v_Gy_ClassTimePrjSubList"); @@ -123,9 +132,18 @@ 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(); + + //鍒ゆ柇鏉冮檺 + if (!ClsPub.Security_Log("Gy_ClassTimePrjSub_Edit", 1, false, msg3)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + //鍙嶅簭鍒楀寲 msg2 = "[" + msg2.ToString() + "]"; List<Gy_ClassTimePrjSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_ClassTimePrjSub>>(msg2); @@ -195,18 +213,25 @@ } } /// <summary> - /// 浠撳簱鍒楄〃鍒犻櫎鍔熻兘 + /// 鏍哥畻璁板綍鍒犻櫎鍔熻兘 /// </summary> /// <returns></returns> [Route("DeltetGy_ClassTimePrjSub")] [HttpGet] - public object DeltetGy_ClassTimePrjSub(string HItemID) + public object DeltetGy_ClassTimePrjSub(string HItemID,string user) { DataSet ds; DataSet ds1; try { - + if (!DBUtility.ClsPub.Security_Log("Gy_ClassTimePrjSub_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\267\245\350\265\204\347\256\241\347\220\206/Gy_GroupEmpBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_GroupEmpBillController.cs" index 0e62675..37dcfff 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_GroupEmpBillController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Gy_GroupEmpBillController.cs" @@ -28,11 +28,18 @@ /// </summary> [Route("Gy_GroupEmpBill/GetGroupEmpBill")] [HttpGet] - public object GetGroupEmpBill(string sWhere) + public object GetGroupEmpBill(string sWhere,string user) { try { - + if (!DBUtility.ClsPub.Security_Log("Gy_Group", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_GetGroupEmpBill(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -129,7 +136,7 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string refSav = sArray[2].ToString(); - //string msg4 = sArray[3].ToString(); + string msg4 = sArray[3].ToString(); string UserName = ""; string s = ""; @@ -137,15 +144,15 @@ ListModels oListModels = new ListModels(); try { - ////缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log_second("Gy_GroupEmpBill_Edit", 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Gy_Group_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsGy_GroupEmpBill oBill = new DLL.ClsGy_GroupEmpBill(); List<Models.ClsGy_GroupEmpListMain> lsmain = new List<Models.ClsGy_GroupEmpListMain>(); @@ -234,10 +241,18 @@ /// <returns></returns> [Route("Gy_GroupEmpBill/DeltetGroupEmpBill")] [HttpGet] - public object DeltetGroupEmpBill(string HInterID) + public object DeltetGroupEmpBill(string HInterID,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Gy_Group_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } oCN.BeginTran(); oCN.RunProc("Delete From Gy_GroupEmpListMain where HInterID = " + HInterID); oCN.RunProc("Delete From Gy_GroupEmpListSub where HInterID = " + HInterID); diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" index 7d9ddea..56a805b 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" @@ -29,10 +29,18 @@ /// </summary> [Route("Pay_GroupBalBill/GetGroupBalBill")] [HttpGet] - public object GetGroupBalBill(string sWhere) + public object GetGroupBalBill(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Pay_SingleBalBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_GetGroupBalBill(sWhere); objJsonResult.code = "1"; @@ -138,11 +146,19 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); - + string msg5 = sArray[3].ToString(); string UserName = ""; ListModels oListModels = new ListModels(); try { + if (!DBUtility.ClsPub.Security_Log("Pay_SingleBalBill_Edit", 1, false, msg5)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsPay_GroupBalBill oBill = new DLL.ClsPay_GroupBalBill(); List<Models.ClsPay_GroupBalBillMain> lsmain = new List<Models.ClsPay_GroupBalBillMain>(); msg2 = msg2.Replace("\\", ""); @@ -266,10 +282,19 @@ /// <returns></returns> [Route("Pay_GroupBalBill/DeltetGroupBalBill")] [HttpGet] - public object Pay_GroupBalBill(string HInterID) + public object Pay_GroupBalBill(string HInterID,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Pay_SingleBalBill_Delete", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + oCN.BeginTran(); oCN.RunProc("Delete From Pay_GroupBalBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Pay_GroupBalBillSub where HInterID = " + HInterID); diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs" index 8cff81a..3fa3f10 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs" @@ -30,11 +30,18 @@ /// </summary> [Route("Pay_OtherBalBill/GetOtherBalBill")] [HttpGet] - public object GetOtherBalBill(string sWhere) + public object GetOtherBalBill(string sWhere,string user) { try { - + if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_GetOtherBalBill(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -131,7 +138,7 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string refSav = sArray[2].ToString(); - //string msg4 = sArray[3].ToString(); + string msg4 = sArray[3].ToString(); string UserName = ""; string s = ""; @@ -139,15 +146,15 @@ ListModels oListModels = new ListModels(); try { - ////缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log_second("Pay_SingleBalBill_Edit", 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Pay_OtherBalBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsPay_OtherBalBill oBill = new DLL.ClsPay_OtherBalBill(); List<Models.ClsPay_OtherBalBillMain> lsmain = new List<Models.ClsPay_OtherBalBillMain>(); @@ -318,10 +325,18 @@ /// <returns></returns> [Route("Pay_OtherBalBill/DeltetOtherBalBill")] [HttpGet] - public object Pay_OtherBalBill(string HInterID) + public object Pay_OtherBalBill(string HInterID,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Pay_OtherBalBill_Drop", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } oCN.BeginTran(); oCN.RunProc("Delete From Pay_OtherBalBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Pay_OtherBalBillSub where HInterID = " + HInterID); diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_SingleBalBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_SingleBalBillController.cs" index 5324816..ea09773 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_SingleBalBillController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_SingleBalBillController.cs" @@ -30,11 +30,18 @@ /// </summary> [Route("Pay_SingleBalBill/GetSingleBalBill")] [HttpGet] - public object GetSingleBalBill(string sWhere) + public object GetSingleBalBill(string sWhere,string user) { try { - + if (!DBUtility.ClsPub.Security_Log("Pay_SingleBalBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_GetSingleBalBill(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -131,7 +138,7 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string refSav = sArray[2].ToString(); - //string msg4 = sArray[3].ToString(); + string msg4 = sArray[3].ToString(); string UserName = ""; string s = ""; @@ -139,15 +146,15 @@ ListModels oListModels = new ListModels(); try { - ////缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log_second("Pay_SingleBalBill_Edit", 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Pay_SingleBalBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsPay_SingleBalBill oBill = new DLL.ClsPay_SingleBalBill(); List<Models.ClsPay_SingleBalBillMain> lsmain = new List<Models.ClsPay_SingleBalBillMain>(); @@ -318,10 +325,18 @@ /// <returns></returns> [Route("Pay_SingleBalBill/DeltetSingleBalBill")] [HttpGet] - public object Pay_SingleBalBill(string HInterID) + public object Pay_SingleBalBill(string HInterID,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Pay_SingleBalBill_Drop", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } oCN.BeginTran(); oCN.RunProc("Delete From Pay_SingleBalBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Pay_SingleBalBillSub where HInterID = " + HInterID); diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_WorkTimesBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_WorkTimesBillController.cs" index 42f6c0b..27ed529 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_WorkTimesBillController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_WorkTimesBillController.cs" @@ -31,11 +31,18 @@ /// </summary> [Route("Pay_WorkTimesBill/GetWorkTimesBill")] [HttpGet] - public object GetWorkTimesBill(string sWhere) + public object GetWorkTimesBill(string sWhere,string user) { try { - + if (!DBUtility.ClsPub.Security_Log("Pay_WorkTimesBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_GetWorkTimesBill(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -132,22 +139,22 @@ string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string refSav = sArray[2].ToString(); - //string msg4 = sArray[3].ToString(); + string msg4 = sArray[3].ToString(); string UserName = ""; string s = ""; ListModels oListModels = new ListModels(); try { - ////缂栬緫鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log_second("Pay_SingleBalBill_Edit", 1, false, msg4)) - //{ - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; - // objJsonResult.data = null; - // return objJsonResult; - //} + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Pay_WorkTimesBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } DLL.ClsPay_WorkTimesBill oBill = new DLL.ClsPay_WorkTimesBill(); List<Models.ClsPay_WorkTimesBillMain> lsmain = new List<Models.ClsPay_WorkTimesBillMain>(); @@ -286,10 +293,18 @@ /// <returns></returns> [Route("Pay_WorkTimesBill/DeltetWorkTimesBill")] [HttpGet] - public object DeltetWorkTimesBill(string HInterID) + public object DeltetWorkTimesBill(string HInterID,string user) { try { + if (!DBUtility.ClsPub.Security_Log("Pay_WorkTimesBill_Drop", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } oCN.BeginTran(); oCN.RunProc("Delete From Pay_WorkTimesBillMain where HInterID = " + HInterID); oCN.RunProc("Delete From Pay_WorkTimesBillSub where HInterID = " + HInterID); -- Gitblit v1.9.1