| | |
|---|
| | | }
|
|---|
| | | //申请表中已审批通过的设备连接数
|
|---|
| | | public List devCommNum() {
|
|---|
| | | String sql=" select distinct db_battinf.tb_battinf_apply.FbsDeviceId,dev_commcount " +
|
|---|
| | | String sql=" select distinct db_battinf.tb_battinf_apply.FbsDeviceId,dev_commcount,dev_errcommcount " +
|
|---|
| | | " from db_battinf.tb_battinf_apply,db_ram_db.tb_fbs9100_state " +
|
|---|
| | | " where apply_en=1 and db_battinf.tb_battinf_apply.FbsDeviceId=db_ram_db.tb_fbs9100_state.dev_id "
|
|---|
| | | + " order by apply_date desc" ;
|
|---|
| | |
|---|
| | | Fbs9100_state fbs=new Fbs9100_state();
|
|---|
| | | fbs.setDev_id(rs.getInt("FbsDeviceId"));
|
|---|
| | | fbs.setDev_commcount(rs.getInt("dev_commcount"));
|
|---|
| | | fbs.setDev_errcommcount(rs.getInt("dev_errcommcount"));
|
|---|
| | | list.add(fbs);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
