From fa00382db413a8489d07983b66f0869305b51a9a Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期五, 11 一月 2019 11:35:54 +0800
Subject: [PATCH] 批量读取系统参数
---
gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java b/gx_tieta/src/com/fgkj/dao/impl/BattInfImpl.java
index 761496a..4fc22da 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=? ";//鍖哄幙
@@ -4605,7 +4605,7 @@
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) as moncapstds "
+ + ",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 "
@@ -4615,7 +4615,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=? ";//鍖哄幙
@@ -4717,9 +4717,9 @@
BattInfImpl biml = new BattInfImpl();
BattInf binf = new BattInf();
- binf.setNum(2);
+ binf.setNum(0);
binf.setBattGroupId(1000001);
- binf.setStationName("鐧捐壊");
+ binf.setStationName("42000017");
binf.setStationName1("");
binf.setStationName2("");
binf.setStationName3("");
--
Gitblit v1.9.1