| | |
| | | String sql="";
|
| | | String baseSql=" SELECT SQL_CALC_FOUND_ROWS distinct tb_devalarm_data.num,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time," +
|
| | | " alm_is_confirmed,alm_confirmed_time,alm_cleared_type," +
|
| | | " db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.FbsDeviceName " +
|
| | | " db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName5,db_battinf.tb_battinf.FbsDeviceName " +
|
| | | " FROM db_alarm.tb_devalarm_data,db_battinf.tb_battinf " +
|
| | | " WHERE " +
|
| | | " tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId " ;
|
| | |
| | | }else{
|
| | | baseSql+=stationSql2F;
|
| | | }
|
| | | //用于区县
|
| | | String stationSql5T=" and stationname5!=? ";//全部
|
| | | String stationSql5F=" and stationname5=? ";
|
| | | if(ddata.getStationName5().equals("")){
|
| | | baseSql+=stationSql5T;
|
| | | }else{
|
| | | baseSql+=stationSql5F;
|
| | | }
|
| | | //用于故障事件
|
| | | String almTypeT=" and alm_type!=? ";//全部
|
| | | String almTypeF=" and alm_type=? ";
|
| | |
| | | //分页
|
| | | String limitSql=" LIMIT ?,? ";
|
| | | sql=baseSql+endSql+limitSql;
|
| | | List<Batt_devalarm_data> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{ddata.getStationName1(),ddata.getStationName(),ddata.getStationName2(),ddata.getAlm_type(),uinf.getUId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
| | | List<Batt_devalarm_data> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{ddata.getStationName1(),ddata.getStationName(),ddata.getStationName2(),ddata.getStationName5(),ddata.getAlm_type(),uinf.getUId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
| | |
|
| | | public List getResults(ResultSet rs) {
|
| | | List list=new ArrayList();
|
| | |
| | |
|
| | | ddata.setDev_name(rs.getString("FbsDeviceName"));
|
| | | ddata.setStationName(rs.getString("stationName"));
|
| | | |
| | | ddata.setStationName5(rs.getString("stationName5")); |
| | | list.add(ddata);
|
| | | }
|
| | | } catch (SQLException e) {
|
| | |
| | | " from db_alarm.tb_devalarm_data,db_battinf.tb_battinf" +
|
| | | " where alm_cleared_type=0 " +
|
| | | " and db_alarm.tb_devalarm_data.dev_id=db_battinf.tb_battinf.fbsdeviceid " +
|
| | | " and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(alm_start_time))<30 " ;
|
| | | " and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(alm_start_time))<"+AlarmDaoFactory.alarm_voice_timelong ;
|
| | | //用户管理
|
| | | String userSql=" and tb_battinf.StationId in(" +
|
| | | " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=?" +
|