From bcfd911073cddc18c64d3051decaf126561726b7 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 14 十二月 2023 17:14:42 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/BLL/Xt_UserController.cs | 22 +++++++++++++++++++--- 1 files changed, 19 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/BLL/Xt_UserController.cs b/WebAPI/Controllers/BLL/Xt_UserController.cs index 8b674ab..1b10f0b 100644 --- a/WebAPI/Controllers/BLL/Xt_UserController.cs +++ b/WebAPI/Controllers/BLL/Xt_UserController.cs @@ -22,10 +22,18 @@ #region[鐢ㄦ埛鍒楄〃鏌ヨ] [Route("Xt_User/list")] [HttpGet] - public object list(string sWhere) + public object list(string sWhere,string user) { try { + if (!DBUtility.ClsPub.Security_Log_second("Xt_User_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_IF_UserList " + sWhere, "h_v_IF_UserList"); @@ -194,13 +202,15 @@ ",HSellManID,HSellMan,HDeptID,HDept " + ",HWhID,HWHName,HSupID,HSupName " + ",HSCWHID,HSCWHName " + - ",HCloudUserName,HCloudUserPsd,HUSEORGID) " + + ",HCloudUserName,HCloudUserPsd,HUSEORGID,HProcID" + + ",HGroupID,HSourceID) " + "values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString() + "','" + lsmain[0].HEmpID.ToString() + "',"+ lsmain[0].HK3UserID.ToString() + "" + ","+ lsmain[0].HKeeperID.ToString() + ",'"+ lsmain[0].HKeeper.ToString() + "',"+ lsmain[0].HSecManagerID.ToString() + ",'"+ lsmain[0].HSecManager.ToString() + "'" + "," + lsmain[0].HSellManID.ToString() + ",'" + lsmain[0].HSellMan.ToString() + "'," + lsmain[0].HDeptID.ToString() + ",'" + lsmain[0].HDept.ToString() + "'" + "," + lsmain[0].HWhID.ToString() + ",'" + lsmain[0].HWHName.ToString() + "'," + lsmain[0].HSupID.ToString() + ",'" + lsmain[0].HSupName.ToString() + "'" + "," + lsmain[0].HSCWHID.ToString() + ",'" + lsmain[0].HSCWHName.ToString() + "'" + - ",'" + lsmain[0].HCloudUserName.ToString() + "','" + lsmain[0].HCloudUserPsd.ToString() + "',"+ lsmain[0].HOrgID.ToString() + ")"); + ",'" + lsmain[0].HCloudUserName.ToString() + "','" + lsmain[0].HCloudUserPsd.ToString() + "',"+ lsmain[0].HOrgID.ToString() + "," + lsmain[0].HProcID.ToString() + "" + + ","+ lsmain[0].HGroupID.ToString() + ","+ lsmain[0].HSourceID.ToString() + ")"); //鏂板鍚庢煡璇� 纭繚鏁版嵁娣诲姞鎴愬姛 ds = oCN.RunProcReturn("Select * from Gy_Czygl where Czybm='" + lsmain[0].Czybm.ToString() + "'", "Gy_Czygl"); @@ -247,6 +257,9 @@ ",HSCWHID=" + lsmain[0].HSCWHID.ToString() + ",HSCWHName='" + lsmain[0].HSCWHName.ToString() + "'" + ",HSupID=" + lsmain[0].HSupID.ToString() + + ",HProcID=" + lsmain[0].HProcID.ToString() + + ",HSourceID=" + lsmain[0].HSourceID.ToString() + + ",HGroupID=" + lsmain[0].HGroupID.ToString() + ",HSupName='" + lsmain[0].HSupName.ToString() + "'" + ",HCloudUserName='" + lsmain[0].HCloudUserName.ToString() + "'" + ",HCloudUserPsd='" + lsmain[0].HCloudUserPsd.ToString() + "'" + @@ -272,6 +285,9 @@ ",HSCWHID=" + lsmain[0].HSCWHID.ToString() + ",HSCWHName='" + lsmain[0].HSCWHName.ToString() + "'" + ",HSupID=" + lsmain[0].HSupID.ToString() + + ",HProcID=" + lsmain[0].HProcID.ToString() + + ",HSourceID=" + lsmain[0].HSourceID.ToString() + + ",HGroupID=" + lsmain[0].HGroupID.ToString() + ",HSupName='" + lsmain[0].HSupName.ToString() + "'" + ",HCloudUserName='" + lsmain[0].HCloudUserName.ToString() + "'" + ",HCloudUserPsd='" + lsmain[0].HCloudUserPsd.ToString() + "'" + -- Gitblit v1.9.1