From e978f1eb746dd9814c3680bb35e890b15498a6df Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.14>
Date: 星期三, 28 十一月 2018 13:32:48 +0800
Subject: [PATCH] 设备变迁的查询修改
---
gx_tieta/src/com/fgkj/dao/impl/Fbsdev_Statechange_infImpl.java | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Fbsdev_Statechange_infImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Fbsdev_Statechange_infImpl.java
index 04cc247..f2c3ea2 100644
--- a/gx_tieta/src/com/fgkj/dao/impl/Fbsdev_Statechange_infImpl.java
+++ b/gx_tieta/src/com/fgkj/dao/impl/Fbsdev_Statechange_infImpl.java
@@ -48,7 +48,7 @@
String sql="";
String numberSql=" SELECT FOUND_ROWS() number";
Connection conn=DBUtil.getConn();
- String baseSql="select SQL_CALC_FOUND_ROWS distinct dev_id,rec_time,last_stat,now_stat,state_change_reason,dev_alarm,stationName " +
+ String baseSql="select SQL_CALC_FOUND_ROWS distinct dev_id,rec_time,last_stat,now_stat,eve_type,module_num,state_change_reason,dev_alarm,stationName " +
" from db_app_sys.tb_fbsdev_statechange_inf,db_battinf.tb_battinf " +
" where db_app_sys.tb_fbsdev_statechange_inf.dev_id=db_battinf.tb_battinf.fbsdeviceid " +
" and rec_time>? and rec_time<? ";
@@ -89,6 +89,8 @@
state_inf.setState_change_reason(rs.getInt("state_change_reason"));
state_inf.setState_change_reason_name(BattTestData.getStopType(BattTestData.TEST_LOADER_FBS9100S, rs.getInt("state_change_reason")));
state_inf.setDev_alarm(rs.getInt("dev_alarm"));
+ state_inf.setEve_type(rs.getInt("eve_type"));
+ state_inf.setModule_num(rs.getInt("module_num"));
state_inf.setNote(rs.getString("stationName"));
list.add(state_inf);
}
--
Gitblit v1.9.1