From 1b0f42c11f7573e56cc85551b762367f3d5da9cc Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.28>
Date: 星期三, 24 十月 2018 10:15:17 +0800
Subject: [PATCH] 拓扑图开关状态batt_online_state
---
gx_tieta/src/com/fgkj/dto/ram/Fbs9100_state.java | 11 ++++++++++-
gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java | 6 ++++--
2 files changed, 14 insertions(+), 3 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java
index 848926e..7f7d86f 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_stateImpl.java
@@ -345,7 +345,7 @@
//瀹炴椂鐩戞祴鐣岄潰鏍规嵁dev_alarmstate鐘舵�佸垽鏂帴瑙﹀櫒鐘舵��
public List serchContactorState(Object obj) {
Fbs9100_state fs=(Fbs9100_state) obj;
- String sql="select dev_id,dev_alarmstate,dev_workstate,record_datetime,dev_temp,dev_res_test_state,dev_testtype,dev_testgroupnum,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type from db_ram_db.tb_fbs9100_state where dev_id=? limit 1";
+ String sql="select dev_id,dev_alarmstate,dev_workstate,record_datetime,dev_temp,dev_res_test_state,dev_testtype,dev_testgroupnum,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type,batt_online_state from db_ram_db.tb_fbs9100_state where dev_id=? limit 1";
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{fs.getDev_id()},new CallBack() {
public List getResults(ResultSet rs) {
@@ -379,6 +379,7 @@
fstate.setDev_61850alarms(rs.getString("dev_61850alarms"));
fstate.setDev_last_captest_stop_type(rs.getInt("dev_last_captest_stop_type"));
fstate.setDev_temp(rs.getFloat("dev_temp"));
+ fstate.setBatt_online_state(rs.getInt("batt_online_state"));
list.add(fstate);
}
} catch (SQLException e) {
@@ -394,7 +395,7 @@
public List serchByInfo(Object obj) {
BattInf binf=(BattInf) obj;
String sql="select fbs_rt.BattGroupId,fbs_rt.group_curr,fbs_rt.group_vol,fbs_rt.online_vol,fbs_rt.batt_state,fbs_rt.batt_test_type" +
- ",dev_id,dev_workstate,dev_alarmstate,dev_temp,dev_res_test_state,dev_testgroupnum,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type " +
+ ",dev_id,dev_workstate,dev_alarmstate,dev_temp,dev_res_test_state,dev_testgroupnum,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type,batt_online_state " +
"from db_ram_db.tb_fbs9100_state," +
"(select distinct db_ram_db.tb_batt_rtstate.BattGroupId,group_curr,group_vol,online_vol,batt_state,batt_test_type,db_battinf.tb_battinf.FBSDeviceId from db_ram_db.tb_batt_rtstate,db_battinf.tb_battinf " +
"where db_battinf.tb_battinf.BattGroupId=db_ram_db.tb_batt_rtstate.BattGroupId " +
@@ -439,6 +440,7 @@
fstate.setDev_61850alarms(rs.getString("dev_61850alarms"));
fstate.setDev_last_captest_stop_type(rs.getInt("dev_last_captest_stop_type"));
fstate.setDev_temp(rs.getFloat("dev_temp"));
+ fstate.setBatt_online_state(rs.getInt("batt_online_state"));
list.add(fstate);
}
} catch (SQLException e) {
diff --git a/gx_tieta/src/com/fgkj/dto/ram/Fbs9100_state.java b/gx_tieta/src/com/fgkj/dto/ram/Fbs9100_state.java
index 27ea4b8..07321b1 100644
--- a/gx_tieta/src/com/fgkj/dto/ram/Fbs9100_state.java
+++ b/gx_tieta/src/com/fgkj/dto/ram/Fbs9100_state.java
@@ -30,6 +30,7 @@
private Integer dev_commcount;
private Integer dev_errcommcount;
private Integer dev_rxnullerrcount;
+ private Integer batt_online_state;
private String online_vols;
private String group_vols;
@@ -284,6 +285,12 @@
public void setDev_temp(Float dev_temp) {
this.dev_temp = dev_temp;
}
+ public Integer getBatt_online_state() {
+ return batt_online_state;
+ }
+ public void setBatt_online_state(Integer batt_online_state) {
+ this.batt_online_state = batt_online_state;
+ }
@Override
public String toString() {
return "Fbs9100_state [num=" + num + ", dev_ip=" + dev_ip
@@ -305,7 +312,8 @@
+ ", dev_restest_monindex=" + dev_restest_monindex
+ ", dev_commcount=" + dev_commcount + ", dev_errcommcount="
+ dev_errcommcount + ", dev_rxnullerrcount="
- + dev_rxnullerrcount + ", online_vols=" + online_vols
+ + dev_rxnullerrcount + ", batt_online_state="
+ + batt_online_state + ", online_vols=" + online_vols
+ ", group_vols=" + group_vols + ", group_currs=" + group_currs
+ ", stationName=" + stationName + ", deviceName=" + deviceName
+ ", note=" + note + ", page=" + page + ", dev_conresist="
@@ -318,4 +326,5 @@
+
}
--
Gitblit v1.9.1