| | |
| | | @Override |
| | | public List serchByCondition(Object obj) { |
| | | BattInf binf=(BattInf) obj; |
| | | String sql="select distinct db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.BattGroupName " |
| | | String sql="select distinct db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.stationName3,db_battinf.tb_battinf.BattGroupName " |
| | | + ",db_ram_db.tb_batt_rtstate.group_vol,db_ram_db.tb_batt_rtstate.group_curr,db_ram_db.tb_batt_rtstate.batt_state,db_ram_db.tb_batt_rtstate.rec_datetime " |
| | | //+ ",(case when db_alarm.tb_battalarm_data.alm_signal_id is null then 0 ELSE db_alarm.tb_battalarm_data.alm_signal_id end) AS alm_signal_id " |
| | | + " FROM db_battinf.tb_battinf " |
| | |
| | | BattInf binf=new BattInf(); |
| | | binf.setBattGroupId(rs.getInt("battGroupId")); |
| | | binf.setBattGroupName(rs.getString("battGroupName")); |
| | | |
| | | binf.setStationName3(rs.getString("stationName3"));; |
| | | binf.setMonVolLowToAvg(rs.getFloat("group_vol")); |
| | | binf.setLoad_curr(rs.getFloat("group_curr")); |
| | | binf.setNum(rs.getInt("batt_state")); |