From 4d198cd78684d17c849b0bd7d323894009ca17f5 Mon Sep 17 00:00:00 2001
From: dhz <duhuizhe>
Date: 星期三, 22 六月 2022 09:59:44 +0800
Subject: [PATCH] 备件管理bug 修改
---
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