| | |
|---|
| | | " ,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.FbsDeviceName " +
|
|---|
| | | " ,db_ram_db.tb_batt_rtstate.batt_test_tlong " +
|
|---|
| | | " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf,db_ram_db.tb_batt_rtstate " +
|
|---|
| | | //" ,db_ram_db.tb_batt_rtstate.batt_test_tlong " +
|
|---|
| | | " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf " +//,db_ram_db.tb_batt_rtstate
|
|---|
| | | " where dev_workstate="+FBS9100_ComBase.DISCHARGE+" "+
|
|---|
| | | " and db_battinf.tb_battinf.fbsdeviceId=db_ram_db.tb_fbs9100_state.dev_id " +
|
|---|
| | | " and db_battinf.tb_battinf.battgroupid=db_ram_db.tb_batt_rtstate.battgroupid " +
|
|---|
| | | //" and db_battinf.tb_battinf.battgroupid=db_ram_db.tb_batt_rtstate.battgroupid " +
|
|---|
| | | " and db_battinf.tb_battinf.fbsdeviceId in(select distinct db_battinf.tb_battinf.fbsdeviceId from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " and db_user.tb_user_inf.uid=? ) " +
|
|---|
| | | " " ;
|
|---|
| | | System.err.println(sql);
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | /*fstate.setOnline_vols(((Float)rs.getFloat("online_vol")).toString());
|
|---|
| | | fstate.setGroup_vols(((Float)rs.getFloat("group_vol")).toString());
|
|---|
| | | fstate.setGroup_currs(((Float)rs.getFloat("group_curr")).toString());*/
|
|---|
| | | fstate.setNum(rs.getInt("batt_test_tlong"));
|
|---|
| | | //fstate.setNum(rs.getInt("batt_test_tlong"));
|
|---|
| | | list.add(fstate);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
