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/XSGL/Xs_CusBalanceReportController.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_CusBalanceReportController.cs b/WebAPI/Controllers/XSGL/Xs_CusBalanceReportController.cs index 4aa172b..5ffec76 100644 --- a/WebAPI/Controllers/XSGL/Xs_CusBalanceReportController.cs +++ b/WebAPI/Controllers/XSGL/Xs_CusBalanceReportController.cs @@ -111,12 +111,12 @@ //鏌ヨ if (sWhere == null || sWhere.Equals("")) { - string sql = "exec h_p_Xs_CusBalanceReport_Query '','" + userid + "'"; + string sql = "exec h_p_Xs_CusBalanceReport_HIsUsingBalanceEntry_Query '','" + userid + "'," + HCusID; ds = oCN.RunProcReturn(sql, "h_p_Xs_CusBalanceReport_Query"); } else { - string sql = "exec h_p_Xs_CusBalanceReport_Query '" + sWhere + "','" + userid + "'"; + string sql = "exec h_p_Xs_CusBalanceReport_HIsUsingBalanceEntry_Query '" + sWhere +"','" + userid + "'," + HCusID; ds = oCN.RunProcReturn(sql, "h_p_Xs_CusBalanceReport_Query"); } -- Gitblit v1.9.1