From 36208913c4834ba2d148ff0b14bae64340cecd28 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 04 三月 2024 11:31:33 +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