From 0f5f5e435cbc4c60ffad2bb84cfe8cc57ea32ddc Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期一, 11 十一月 2024 17:28:14 +0800
Subject: [PATCH] 调整语法不兼容
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 2c6cce4..dca5d73 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -2960,7 +2960,7 @@
if(dto.getStationName()!=null&&!dto.getStationName().isEmpty()){
sql+=" and stationname='"+dto.getStationName()+"' ";
}
- sql+=" order by db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".mon_num asc ";
+ sql+=" order by db_batt_testdata.tb_battresdata_inf.test_record_count asc,db_batt_testdata.tb_battresdata_"+dto.getBattGroupId()+".mon_num asc ";
List<ReportBattResultDTO> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
@Override
public List getResults(ResultSet rs) throws SQLException {
@@ -3079,7 +3079,8 @@
if(dto.getStationName()!=null&&!dto.getStationName().isEmpty()){
sql+=" and stationname='"+dto.getStationName()+"' ";
}
- sql+=" order by db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".mon_num asc ";
+ //sql+=" order by db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".mon_num asc ";
+ sql+=" order by db_batt_testdata.tb_batttestdata_inf.test_record_count asc,db_batt_testdata.tb_batttestdatastop_"+dto.getBattGroupId()+".mon_num asc ";
List<ReportBattResultDTO> list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
@Override
public List getResults(ResultSet rs) throws SQLException {
--
Gitblit v1.9.1