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