From f4b58fc3135f315444a5543f60b63ccb24c57f09 Mon Sep 17 00:00:00 2001 From: zrg <z1873@LAPTOP-EAVL132E> Date: 星期六, 26 七月 2025 12:47:16 +0800 Subject: [PATCH] 增加通用功能 根据用户关联组织 进行数据隔离 查询 --- WebAPI/Controllers/BLL/Xt_UserController.cs | 62 +++++++++++++++++++++++++----- 1 files changed, 51 insertions(+), 11 deletions(-) diff --git a/WebAPI/Controllers/BLL/Xt_UserController.cs b/WebAPI/Controllers/BLL/Xt_UserController.cs index b0ecd17..5ff4933 100644 --- a/WebAPI/Controllers/BLL/Xt_UserController.cs +++ b/WebAPI/Controllers/BLL/Xt_UserController.cs @@ -383,8 +383,6 @@ } #endregion - - #region 鏍规嵁鐢ㄦ埛缂栫爜鏌ユ壘宸插垎閰嶄緵搴斿晢鍒楄〃 [Route("Xt_User/SupperPlaylist")] [HttpGet] @@ -843,6 +841,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈缁勭粐缁存姢 鍒犻櫎 /// <summary> ///鍙傛暟锛歴tring HInterID銆� @@ -877,7 +876,7 @@ oCN.BeginTran(); - string sql = "delete from Gy_UserORGRelation where HItemID = " + HInterID; + string sql = "delete from Gy_UserByOrgRelation where HItemID = " + HInterID; oCN.RunProc(sql); oCN.Commit(); @@ -898,6 +897,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈缁勭粐缁存姢 缂栬緫鍒濆鍖� /// <summary> ///鍙傛暟锛歴tring sql銆� @@ -940,6 +940,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈缁勭粐缁存姢 淇濆瓨 [Route("Xt_User/UserRelationOrganizationList_Save")] [HttpPost] @@ -991,11 +992,11 @@ string HOrgName = item["HOrgName"].ToString(); //缁勭粐鍚嶇О - sql = "select * from Gy_UserORGRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID; - ds = oCN.RunProcReturn(sql, "Gy_UserORGRelation"); + sql = "select * from Gy_UserByOrgRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID; + ds = oCN.RunProcReturn(sql, "Gy_UserByOrgRelation"); if (ds.Tables[0].Rows.Count == 0) { - sql = "insert into Gy_UserORGRelation(HUserID,HOrgID)" + + sql = "insert into Gy_UserByOrgRelation(HUserID,HOrgID)" + "values(" + "'" + HUserID + "'" + "," + HOrgID + "" + @@ -1034,15 +1035,15 @@ string HOrgNumber = item["HOrgNumber"].ToString(); //缁勭粐浠g爜 string HOrgName = item["HOrgName"].ToString(); //缁勭粐鍚嶇О - sql = "select * from Gy_UserORGRelation where HItemID = " + HItemID; - ds = oCN.RunProcReturn(sql, "Gy_UserORGRelation"); + sql = "select * from Gy_UserByOrgRelation where HItemID = " + HItemID; + ds = oCN.RunProcReturn(sql, "Gy_UserByOrgRelation"); if (ds.Tables[0].Rows.Count > 0) { - sql = "select * from Gy_UserORGRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID + " and HItemID <> " + HItemID; - ds = oCN.RunProcReturn(sql, "Gy_UserORGRelation"); + sql = "select * from Gy_UserByOrgRelation where HUserID = '" + HUserID + "' and HOrgID = " + HOrgID + " and HItemID <> " + HItemID; + ds = oCN.RunProcReturn(sql, "Gy_UserByOrgRelation"); if (ds.Tables[0].Rows.Count == 0) { - sql = "update Gy_UserORGRelation set " + + sql = "update Gy_UserByOrgRelation set " + "HUserID = '" + HUserID + "' " + ",HOrgID = " + HOrgID + " " + "where HItemID = " + HItemID; @@ -2468,6 +2469,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈鑱屽憳缁存姢 鍒犻櫎 /// <summary> ///鍙傛暟锛歴tring HInterID銆� @@ -2523,6 +2525,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈鑱屽憳缁存姢 缂栬緫鍒濆鍖� /// <summary> ///鍙傛暟锛歴tring sql銆� @@ -2565,6 +2568,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈鑱屽憳缁存姢 淇濆瓨 [Route("Xt_User/UserRelationEmployeelist_Save")] [HttpPost] @@ -3029,6 +3033,7 @@ } } #endregion + #region 鏌ヨ鎸囧畾鐢ㄦ埛鎵�鍏宠仈瀹㈡埛涓殑瀹㈡埛 [Route("Xt_User/CustomerPlaylistFromUserCustomerList")] [HttpGet] @@ -3082,6 +3087,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈瀹㈡埛淇濆瓨 [Route("Xt_User/SaveUserCustomer")] [HttpPost] @@ -3138,6 +3144,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈瀹㈡埛 鏂囦欢涓婁紶 [Route("Xt_User/Gy_UserCustomer_ImportByExcel")] @@ -3299,6 +3306,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈瀹㈡埛 瀵煎叆(鏁版嵁楠岃瘉) [Route("Xt_User/Gy_UserCustomer_ImportByExcel_Confirm")] [HttpPost] @@ -3479,6 +3487,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈瀹㈡埛 瀵煎叆(淇濆瓨) [Route("Xt_User/Gy_UserCustomer_ImportByExcel_Save")] [HttpPost] @@ -3769,6 +3778,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈瀹㈡埛缁存姢 缂栬緫鍒濆鍖� /// <summary> ///鍙傛暟锛歴tring sql銆� @@ -3811,6 +3821,7 @@ } } #endregion + #region 鐢ㄦ埛鍏宠仈瀹㈡埛缁存姢 淇濆瓨 [Route("Xt_User/UserRelationCustomerlist_Save")] [HttpPost] @@ -3969,6 +3980,7 @@ } } #endregion + #region 鏍规嵁鐢ㄦ埛缂栫爜鏌ユ壘宸插垎閰嶅伐搴忓垪琛� [Route("Xt_User/ProcessPlaylist")] @@ -4512,5 +4524,33 @@ } } #endregion + + #region 鏍规嵁鐢ㄦ埛鍏宠仈缁勭粐 杩囨护鏉′欢 + [Route("Xt_User/getOrgIDListByUser")] + [HttpGet] + public object getOrgIDListByUser(string UserID, string UserName,string HOrgID) + { + try + { + + //鏍规嵁鐢ㄦ埛ID 鏌ヨ鐢ㄦ埛鍏宠仈缁勭粐琛� + ds = oCN.RunProcReturn("exec h_p_GetHorgIDByUser_Query '"+ UserID + "','"+ UserName + "','"+ HOrgID + "'", "h_p_GetHorgIDByUser_Query"); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file -- Gitblit v1.9.1