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