From 73fb291c8893188ca5e4a8188d8dfe5a2d8321fc Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期三, 06 三月 2024 17:31:47 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
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