From 1957681f84da30970ce52ab79d4da066595b15dd Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期日, 03 三月 2024 18:33:19 +0800
Subject: [PATCH] 根据用户关联客户显示数据优化

---
 WebAPI/Controllers/LMESController.cs |   22 +---------------------
 1 files changed, 1 insertions(+), 21 deletions(-)

diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs
index 1824817..2006a1a 100644
--- a/WebAPI/Controllers/LMESController.cs
+++ b/WebAPI/Controllers/LMESController.cs
@@ -105,28 +105,8 @@
 
                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
 
-                
-                //鍒ゆ柇鐢ㄦ埛鏄惁鎷ユ湁鏌ョ湅鎵�鏈夊鎴锋潈闄�
-                if (DBUtility.ClsPub.Security_Log_second("Gy_UserLookAllCus", 1, false, user))
-                {
-                    ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery");
-                }
-                else
-                {
-                    //鑾峰彇鐢ㄦ埛缂栫爜
-                    string sql = "select * from Gy_Czygl where Czymc = '" + user + "'";
-                    ds = oCN.RunProcReturn(sql, "Gy_Czygl");
-                    string userID = ds.Tables[0].Rows[0]["Czybm"].ToString();
 
-                    string sql1 = " and HCusID in (select HCusID from Gy_UserCustomerRelation Where HUserID = '" + userID + "')";
-                    string sql2 = "select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + sql1 + " order by hmainid desc ";
-                    ds = oCN.RunProcReturn(sql2, "h_v_Sc_ProcessExchangeBillQuery");
-                }
-
-
-
-
-                
+                ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery");
 
 
                 //娣诲姞鍒楀悕

--
Gitblit v1.9.1