| | |
| | | + ",dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,dev_captest_cap,dev_captest_timelong "
|
| | | + ",dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type "
|
| | | + ",db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1,db_battinf.tb_battinf.StationName2,db_battinf.tb_battinf.StationName3,db_battinf.tb_battinf.StationName5 "
|
| | | + ",db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.BattGroupId "
|
| | | + ",db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.BattGroupId,db_battinf.tb_battinf.battgroupname "
|
| | | + " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr "
|
| | | + " where dev_workstate="+FBS9100_ComBase.DISCHARGE
|
| | | + " and db_battinf.tb_battinf.fbsdeviceId=db_ram_db.tb_fbs9100_state.dev_id "
|
| | |
| | | while(rs.next()){
|
| | | Fbs9100_state fstate=new Fbs9100_state();
|
| | | int dev_alarmstate=rs.getInt("dev_alarmstate");
|
| | | String ContactorState="开关闭合";
|
| | | if(dev_alarmstate==1 ||
|
| | | dev_alarmstate==2 ||
|
| | | dev_alarmstate==3 ||
|
| | | dev_alarmstate==4 ||
|
| | | dev_alarmstate==6 ){
|
| | | ContactorState="开关断开";
|
| | | }else{
|
| | | ContactorState="开关闭合";
|
| | | }
|
| | | |
| | | fstate.setDev_testgroupnum(rs.getInt("dev_testgroupnum")); //被测电池组号
|
| | | fstate.setDev_alarmstate(rs.getInt("dev_alarmstate"));
|
| | | fstate.setDev_res_test_state(rs.getInt("dev_res_test_state"));
|
| | | fstate.setDev_testtype(rs.getInt("dev_testtype"));
|
| | | fstate.setNote(ContactorState);
|
| | | fstate.setDev_workstate(rs.getInt("dev_workstate"));
|
| | | fstate.setDev_id(rs.getInt("dev_id"));
|
| | | fstate.setDev_version(rs.getString("dev_version"));
|
| | |
| | | fstate.setStationName5(rs.getString("stationName5"));
|
| | | fstate.setBattgroupid(rs.getInt("battgroupid"));
|
| | | fstate.setMonvolstd(rs.getInt("monvolstd"));
|
| | | fstate.setNote(rs.getString("battgroupname"));
|
| | | list.add(fstate);
|
| | | }
|
| | | } catch (SQLException e) {
|