From 573f8cd63ce36c531ec019c8c5e20353090f12ac Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期四, 07 三月 2024 10:17:30 +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