From d04cea72d0c721f9e7e65d3074c5546ac6eb594f Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期五, 11 一月 2019 14:51:17 +0800
Subject: [PATCH] 修改系统批量
---
gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java | 38 ++++++++++++++++++++++++--------------
1 files changed, 24 insertions(+), 14 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
index 358347c..ee5eb46 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
@@ -4497,7 +4497,7 @@
//Page page=binf.getPage();
/*Connection conn=DBUtil.getConn();
String numberSql=" SELECT FOUND_ROWS() number";SQL_CALC_FOUND_ROWS*/
- String sql=" select distinct(StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
+ String sql=" select distinct(db_battinf.tb_battinf.StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
+ "FBSDeviceName,battGroupNum" +
",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax,montmpstd,floatVolLevel,offlineVolLevel,battFloatCurrent"
+ ",db_ram_db.tb_fbs9100_state.dev_version "
@@ -4507,7 +4507,7 @@
//+ " limit ?,? ";StationName1 like ? and StationName2 like ? and StationName3 like ? and StationName5 like ? "
//,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%",
//鏉′欢
- String sql0=" and stationid=? "; //鍏蜂綋鏈烘埧
+ String sql0=" and db_battinf.tb_battinf.stationid=? "; //鍏蜂綋鏈烘埧
String sql1=" and stationname1=? ";//鐪�
String sql2=" and stationname2=? ";//甯�
String sql5=" and stationname5=? ";//鍖哄幙
@@ -4602,17 +4602,20 @@
//Page page=binf.getPage();
/*Connection conn=DBUtil.getConn();
String numberSql=" SELECT FOUND_ROWS() number";SQL_CALC_FOUND_ROWS*/
- String sql=" select distinct(StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
- + "FBSDeviceName,battGroupNum" +
- ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax,montmpstd,floatVolLevel,offlineVolLevel,battFloatCurrent"
- + ",db_ram_db.tb_fbs9100_state.dev_version "
- + " from db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state "
+ String sql=" select distinct(tb_battinf.StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"
+ + "FBSDeviceName,count(FBSDeviceId) as batt_num" +
+ ",MonCount,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax,montmpstd,floatVolLevel,offlineVolLevel,battFloatCurrent"
+ + ",GROUP_CONCAT(tb_battinf.MonCapStd order by groupIndexInFBSDevice separator '/' ) as moncapstds "
+ + ",db_ram_db.tb_fbs9100_state.dev_version"
+ + ",web_site.tb_batt_endurance.real_cap_group1 ,web_site.tb_batt_endurance.real_cap_group2,web_site.tb_batt_endurance.real_cap_group3,web_site.tb_batt_endurance.real_cap_group4 "
+ + " from db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state,web_site.tb_batt_endurance "
+ " where db_battinf.tb_battinf.FBSDeviceId=db_ram_db.tb_fbs9100_state.dev_id "
+ + " and db_battinf.tb_battinf.FBSDeviceId=web_site.tb_batt_endurance.deviceid "
+ " and MonVolStd=? and Station_install=1 ";
//+ " limit ?,? ";StationName1 like ? and StationName2 like ? and StationName3 like ? and StationName5 like ? "
//,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%",
//鏉′欢
- String sql0=" and stationid=? "; //鍏蜂綋鏈烘埧
+ String sql0=" and db_battinf.tb_battinf.stationid=? "; //鍏蜂綋鏈烘埧
String sql1=" and stationname1=? ";//鐪�
String sql2=" and stationname2=? ";//甯�
String sql5=" and stationname5=? ";//鍖哄幙
@@ -4634,9 +4637,9 @@
}
//鎺掑簭
- String orderSql=" order by StationId asc,GroupIndexInFBSDevice asc ";
+ String orderSql=" GROUP BY FBSDeviceId order by StationId asc,GroupIndexInFBSDevice asc ";
sql+=orderSql;
- System.out.println(sql);
+ //System.out.println(sql);
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {binf.getMonVolStd(),binf.getStationName()}, new CallBack() {
@Override
@@ -4660,13 +4663,20 @@
binf.setFbsDeviceIp_YM(rs.getString("fbsDeviceIp_YM"));
binf.setFbsDeviceIp_WG(rs.getString("fbsDeviceIp_WG"));*/
binf.setFBSDeviceName(rs.getString("fBSDeviceName"));
- binf.setBattGroupNum(rs.getInt("battGroupNum"));
+ binf.setBattGroupNum(rs.getInt("batt_num"));
binf.setFloatVolLevel(rs.getFloat("floatVolLevel"));
binf.setOfflineVolLevel(rs.getFloat("offlineVolLevel"));
binf.setBattFloatCurrent(rs.getFloat("battFloatCurrent"));
binf.setMonCount(rs.getInt("monCount"));
- binf.setMonCapStd(rs.getFloat("monCapStd"));
+ //binf.setMonCapStd(rs.getFloat("monCapStd"));
+
+ binf.setMoncapstds(rs.getString("moncapstds"));
+ binf.setReal_cap_group1(rs.getFloat("real_cap_group1"));
+ binf.setReal_cap_group2(rs.getFloat("real_cap_group2"));
+ binf.setReal_cap_group3(rs.getFloat("real_cap_group3"));
+ binf.setReal_cap_group4(rs.getFloat("real_cap_group4"));
+
binf.setMonVolStd(rs.getFloat("monVolStd"));
binf.setMonResStd(rs.getFloat("monResStd"));
binf.setMonSerStd(rs.getFloat("monSerStd"));
@@ -4707,9 +4717,9 @@
BattInfImpl biml = new BattInfImpl();
BattInf binf = new BattInf();
- binf.setNum(2);
+ binf.setNum(0);
binf.setBattGroupId(1000001);
- binf.setStationName("骞胯タ鐪�-鐜夋灄-鐜夋灄鐜夊窞鍖鸿タ鍩庨噷-BTS璁惧");
+ binf.setStationName("42000611");
binf.setStationName1("");
binf.setStationName2("");
binf.setStationName3("");
--
Gitblit v1.9.1