From 8a6281f8962f5ac973763bc03f5ff15c35c2a713 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期五, 17 五月 2024 17:27:17 +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