| | |
| | | int uid=page.getPageAll();
|
| | | Connection conn=DBUtil.getConn();
|
| | | String numberSql="SELECT FOUND_ROWS() number";//存放总数
|
| | | String sql="select SQL_CALC_FOUND_ROWS distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId " +
|
| | | String sql="select SQL_CALC_FOUND_ROWS distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.station_install " +
|
| | | " from web_site.tb_battmap_information,db_battinf.tb_battinf " +
|
| | | " where tb_battmap_information.StationId=db_battinf.tb_battinf.StationId " +
|
| | | " and tb_battmap_information.StationId in (" +
|
| | |
| | | binformation.setLatitude(rs.getDouble("latitude"));
|
| | | binformation.setInformation(rs.getString("information"));
|
| | | binformation.setFBSDeviceId(rs.getInt("fBSDeviceId"));
|
| | | binformation.setInformation(rs.getString("station_install"));
|
| | | Page p=new Page();
|
| | | binformation.setPage(p);
|
| | | list.add(binformation);
|
| | |
| | | private Float Load_curr;// 负载电流
|
| | | private Float DisCurrMax;//最大核容电流
|
| | | private String SignalName;
|
| | | private Integer StartNum; |
| | | private Integer StartNum; |
| | | private Integer Station_install; //机房设备是否安装
|
| | | |
| | | private Integer Size;
|
| | | private Page page;
|
| | | private Object obj;
|
| | |
| | | public void setStationId_ex(String stationId_ex) {
|
| | | StationId_ex = stationId_ex;
|
| | | }
|
| | | public Integer getStation_install() {
|
| | | return Station_install;
|
| | | }
|
| | | public void setStation_install(Integer station_install) {
|
| | | Station_install = station_install;
|
| | | }
|
| | | @Override
|
| | | public String toString() {
|
| | | return "BattInf [num=" + num + ", StationId=" + StationId
|
| | |
| | | + ", SignalId=" + SignalId + ", CInterFaceId=" + CInterFaceId
|
| | | + ", Load_curr=" + Load_curr + ", DisCurrMax=" + DisCurrMax
|
| | | + ", SignalName=" + SignalName + ", StartNum=" + StartNum
|
| | | + ", Size=" + Size + ", page=" + page + ", obj=" + obj
|
| | | + ", station_phone=" + station_phone + "]";
|
| | | + ", Station_install=" + Station_install + ", Size=" + Size
|
| | | + ", page=" + page + ", obj=" + obj + ", station_phone="
|
| | | + station_phone + "]";
|
| | | }
|
| | | |
| | | |
| | | |
| | | |
| | |
|
| | | |
| | | |
| | | }
|
| | |
| | | int numAlarm=0;
|
| | | int numPlan=0;
|
| | | if(list!=null&&list.size()>0){
|
| | | for(int i=0;i<list.size();i++){
|
| | | for(int i=0;i<list.size();i++){ |
| | | state="item-normal";
|
| | | ServiceModel model=new ServiceModel();
|
| | | BattMap_information binformation = list.get(i);
|
| | |
| | | }
|
| | | }
|
| | | }
|
| | | if("0".equals(list.get(i).getInformation())){
|
| | | state=""; //若机房未安装将指定的机房设置成灰色的
|
| | | }
|
| | | model.setData(list.get(i));
|
| | | model.setCode(numAlarm); //告警总数
|
| | | model.setSum(numBadBatt); //落后总数
|