From bae6f41fd7ab5f4c572e196a0646f61ec6fb03f2 Mon Sep 17 00:00:00 2001 From: 杨乐 <yang.le.192@qq.com> Date: 星期三, 26 一月 2022 16:25:36 +0800 Subject: [PATCH] 条码主档 采购管理 权限编辑 --- WebAPI/Controllers/Sc_MouldRepairInBillListController.cs | 187 +++++++++++++++++++++++++++++++++++++--------- 1 files changed, 148 insertions(+), 39 deletions(-) diff --git a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs index d0ea4e9..d2ee9e2 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) @@ -782,10 +807,20 @@ /// <returns></returns> [Route("Kf_MoveStockBill/GetMoveStockBillList")] [HttpGet] - public object GetMoveStockBillList(string sWhere) + public object GetMoveStockBillList(string sWhere,string user) { try { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Kf_MoveStockBillQuery", 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_MoveStockBillList order by 鏃ユ湡 desc", "h_v_IF_MoveStockBillList"); @@ -828,10 +863,19 @@ /// <returns></returns> [Route("Kf_SellOutBill/GetSellOutBillList")] [HttpGet] - public object GetSellOutBillList(string sWhere) + public object GetSellOutBillList(string sWhere,string user) { try { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBillQuery", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁鏌ヨ鏉冮檺!"; + objJsonResult.data = null; + return objJsonResult; + } ds = Sc_GetSellOutBillList(sWhere); if (ds == null || ds.Tables[0].Rows.Count <= 0) @@ -906,10 +950,20 @@ /// <returns></returns> [Route("Kf_OtherOutBill/GetOtherOutBillList")] [HttpGet] - public object GetOtherOutBillList(string sWhere) + public object GetOtherOutBillList(string sWhere,string user) { try { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Kf_OtherOutBillQuery", 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_Kf_OtherOutBillList where 1=1 order by 鏃ユ湡 desc", "h_v_Kf_OtherOutBillList"); @@ -1053,10 +1107,20 @@ /// <returns></returns> [Route("Kf_ProductInBill/GetProductInBill")] [HttpGet] - public object GetProductInBill(string sWhere) + public object GetProductInBill(string sWhere,string user) { try { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Kf_ProductInBill_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡璇㈡潈闄�!"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { @@ -1133,10 +1197,19 @@ /// <returns></returns> [Route("Kf_OtherInBill/GetOtherInBill")] [HttpGet] - public object GetOtherInBill(string sWhere) + public object GetOtherInBill(string sWhere,string user) { try { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Kf_OtherInBillQuery", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡璇㈡潈闄�!"; + objJsonResult.data = null; + return objJsonResult; + } if (sWhere == null || sWhere.Equals("")) { @@ -1180,10 +1253,19 @@ /// <returns></returns> [Route("Kf_EntrustInBill/GetEntrustInBill")] [HttpGet] - public object GetEntrustInBill(string sWhere) + public object GetEntrustInBill(string sWhere,string user) { try { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Kf_EntrustInBillQuery", 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_Kf_EntrustInBillList where 1=1", "h_v_Kf_EntrustInBillList"); @@ -1266,12 +1348,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 +1543,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 +1779,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 +1971,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 +2049,7 @@ #region 妯″叿鏁呴殰鐧昏琛ㄤ繚瀛�/缂栬緫 /// <summary> - /// 淇濆瓨妯″叿缁翠慨鍗� + /// 淇濆瓨鏁呴殰鐧昏琛� /// </summary> /// <param name="msg"></param> /// <returns></returns> @@ -1961,12 +2062,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 +2255,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; -- Gitblit v1.9.1