From 6e06bba1c89f8077e29d0fbf0ce12f89f027d8d2 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期三, 22 六月 2022 16:16:37 +0800
Subject: [PATCH] fix(预防性防护): MySQL=》DMSQL
---
src/cn/ksource/web/facade/bpbj/OverageLossFacadeImpl.java | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/cn/ksource/web/facade/bpbj/OverageLossFacadeImpl.java b/src/cn/ksource/web/facade/bpbj/OverageLossFacadeImpl.java
index 9d17fe3..de5bc69 100644
--- a/src/cn/ksource/web/facade/bpbj/OverageLossFacadeImpl.java
+++ b/src/cn/ksource/web/facade/bpbj/OverageLossFacadeImpl.java
@@ -61,7 +61,7 @@
private String getOverageLossList(Map<String, String> params){
- StringBuilder sql = new StringBuilder("select * from OVERAGE_LOSS a where 1=1 and state !=0");
+ StringBuilder sql = new StringBuilder("select a.id,a.order_code,a.order_name,a.STATE,a.FLOW_ID,a.BUS_TYPE,a.CREATE_ID,a.CREATE_NAME,a.GMT_CREATE,a.GMT_MODIFIED from OVERAGE_LOSS a where 1=1 and state !=0");
//鐩樼偣鍗曞彿
if(StringUtil.isNotBlank(params.get("gdbh"))){
@@ -118,7 +118,8 @@
- sql.append(" group by a.id order by a.GMT_CREATE desc");
+ sql.append(" group by a.id,a.order_code,a.order_name,a.STATE,a.FLOW_ID,a.BUS_TYPE,a.CREATE_ID,a.CREATE_NAME,a.GMT_CREATE,a.GMT_MODIFIED" +
+ " order by a.GMT_CREATE desc");
return sql.toString();
}
--
Gitblit v1.9.1