| | |
| | | //根据机房id查询机房下的电池组信息 |
| | | public List serchBattByStation(Object obj){ |
| | | BattInf binf=(BattInf) obj; |
| | | String sql="select DISTINCT StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationId,StationIP,FBSDeviceId,BattGroupName,BattGroupName1,BattGroupName2,MonCount,battgroupId,MonCapStd,MonVolStd,MonResStd,MonSerStd,BattProducer,BattInUseDate,GroupIndexInFBSDevice,Load_curr,DisCurrMax " + |
| | | String sql="select DISTINCT StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationId,StationIP,FBSDeviceId,BattGroupName,BattGroupName1,BattGroupName2,MonCount,battgroupId,MonCapStd,MonVolStd,MonResStd,MonSerStd,BattProducer,BattInUseDate " |
| | | + ",GroupIndexInFBSDevice,Load_curr,DisCurrMax,FloatVolLevel,OfflineVolLevel,BattFloatCurrent " + |
| | | "from db_battinf.tb_battinf where stationid=? " + |
| | | "ORDER BY StationName1,battgroupId "; |
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(),new Object[]{binf.getStationId()},new CallBack() { |
| | |
| | | batt.setGroupIndexInFBSDevice(rs.getInt("groupIndexInFBSDevice")); |
| | | batt.setLoad_curr(rs.getFloat("load_curr")); |
| | | batt.setDisCurrMax(rs.getFloat("disCurrMax")); |
| | | batt.setFloatVolLevel(rs.getFloat("floatVolLevel")); |
| | | batt.setOfflineVolLevel(rs.getFloat("offlineVolLevel")); |
| | | batt.setBattFloatCurrent(rs.getFloat("battFloatCurrent")); |
| | | list.add(batt); |
| | | } |
| | | } catch (SQLException e) { |