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