From 150ced737ad5d16d476df143c7e4238fc6b8b998 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期一, 27 六月 2022 17:15:09 +0800
Subject: [PATCH] fix : MySQL=》DMSQL
---
src/cn/ksource/web/facade/bpbj/SparePartsFacadeImpl.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/cn/ksource/web/facade/bpbj/SparePartsFacadeImpl.java b/src/cn/ksource/web/facade/bpbj/SparePartsFacadeImpl.java
index 8a0ccdb..05dabac 100644
--- a/src/cn/ksource/web/facade/bpbj/SparePartsFacadeImpl.java
+++ b/src/cn/ksource/web/facade/bpbj/SparePartsFacadeImpl.java
@@ -108,7 +108,7 @@
StringBuilder builder = new StringBuilder();
paramMap.put("create_id", userId);
- builder.append("SELECT COUNT(1) AS 'TOTAL',SUM(CASE WHEN STATE=2 THEN 1 ELSE 0 END) AS 'AUDITING' ,SUM(CASE WHEN STATE=3 THEN 1 ELSE 0 END) AS 'DELIVERY',SUM(CASE WHEN STATE=4 THEN 1 ELSE 0 END) AS 'CONFIRM' FROM SPARE_PART_APPLY WHERE CREATE_ID=:create_id");
+ builder.append("SELECT COUNT(1) AS TOTAL,SUM(CASE WHEN STATE=2 THEN 1 ELSE 0 END) AS AUDITING ,SUM(CASE WHEN STATE=3 THEN 1 ELSE 0 END) AS DELIVERY,SUM(CASE WHEN STATE=4 THEN 1 ELSE 0 END) AS CONFIRM FROM SPARE_PART_APPLY WHERE CREATE_ID=:create_id");
List<Map> list = baseDao.queryForList(builder.toString(),paramMap);
--
Gitblit v1.9.1