| | |
|---|
| | | String baseSql=" SELECT SQL_CALC_FOUND_ROWS tb_devalarm_data_history.num,record_id,dev_id,dev_ip,alm_type,alm_level,alm_start_time,alm_end_time," +
|
|---|
| | | " alm_is_confirmed,alm_confirmed_time,alm_cleared_type, " +
|
|---|
| | | " DISTINCTbinf.stationName,DISTINCTbinf.stationName5,DISTINCTbinf.FbsDeviceName " +
|
|---|
| | | " FROM db_alarm.tb_devalarm_data_history,(SELECT DISTINCT db_battinf.tb_battinf.FbsDeviceId,db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName5,db_battinf.tb_battinf.FbsDeviceName from db_battinf.tb_battinf where db_battinf.tb_battinf.StationName LIKE ? AND db_battinf.tb_battinf.StationName1 LIKE ? AND db_battinf.tb_battinf.StationName2 LIKE ? AND db_battinf.tb_battinf.StationName5 LIKE ?) as DISTINCTbinf " +
|
|---|
| | | " FROM db_alarm.tb_devalarm_data_history,"
|
|---|
| | | + "(SELECT DISTINCT db_battinf.tb_battinf.FbsDeviceId,db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName5,db_battinf.tb_battinf.FbsDeviceName 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_battinf.tb_battinf.StationName LIKE ? AND db_battinf.tb_battinf.StationName1 LIKE ? AND db_battinf.tb_battinf.StationName2 LIKE ? AND db_battinf.tb_battinf.StationName5 LIKE ? "
|
|---|
| | | + "and 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=?) as DISTINCTbinf " +
|
|---|
| | | " WHERE tb_devalarm_data_history.dev_id=DISTINCTbinf.FbsDeviceId " +
|
|---|
| | | " AND alm_start_time>=? and alm_start_time<=? ";
|
|---|
| | |
|
|---|
| | |
|---|
| | | String alarmTypeSql=" AND alm_cleared_type!=0";
|
|---|
| | | baseSql+=alarmTypeSql;*/
|
|---|
| | | //判断是否为管理的机房
|
|---|
| | | String stationSql=" and db_alarm.tb_devalarm_data_history.dev_id in(select distinct db_battinf.tb_battinf.FbsDeviceId " +
|
|---|
| | | /*String stationSql=" and db_alarm.tb_devalarm_data_history.dev_id 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=? )";
|
|---|
| | | baseSql+=stationSql;
|
|---|
| | | baseSql+=stationSql;*/
|
|---|
| | |
|
|---|
| | | //排序
|
|---|
| | | String endSql=" ORDER BY alm_start_time DESC ";
|
|---|
| | |
|---|
| | | String limitSql=" LIMIT ?,? ";
|
|---|
| | |
|
|---|
| | | sql=baseSql+endSql+limitSql;
|
|---|
| | | |
|---|
| | | List<Batt_devalarm_data_history> list=DAOHelper.executeQueryLimit(sql, conn,new Object[]{"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName5()+"%",binf.getBattProductDate(),binf.getBattProductDate1()
|
|---|
| | | ,uinf.getUId(),(page.getPageCurr() - 1)*page.getPageSize()
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List<Batt_devalarm_data_history> list=DAOHelper.executeQueryLimit(sql, conn,new Object[]{"%"+binf.getStationName()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName5()+"%",uinf.getUId(),binf.getBattProductDate(),binf.getBattProductDate1()
|
|---|
| | | ,(page.getPageCurr() - 1)*page.getPageSize()
|
|---|
| | | ,page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | binf.setStationName1("");
|
|---|
| | | binf.setStationName2("");
|
|---|
| | | binf.setStationName3("");
|
|---|
| | | binf.setStationName5("");
|
|---|
| | | binf.setStationId("");
|
|---|
| | | binf.setBattGroupNum(1);
|
|---|
| | | binf.setBattInUseDate(ActionUtil.getSimpDate(date1));
|
|---|
| | | binf.setBattInUseDate1(ActionUtil.getSimpDate(date2));
|
|---|
| | | binf.setBattProductDate(ActionUtil.getSimpDate(date1));
|
|---|
| | | binf.setBattProductDate1(ActionUtil.getSimpDate(date2));
|
|---|
| | |
|
|---|
| | | User_inf uinf=new User_inf();
|
|---|
| | | uinf.setUId(1002);
|
|---|
| | |
|---|
| | | bmd.setPage(p);
|
|---|
| | | bmd.setBinf(binf);
|
|---|
| | | bmd.setUinf(uinf);
|
|---|
| | | //List<Batt_devalarm_data_history> list=bimpl.serchByCondition(bmd);
|
|---|
| | | List<Batt_devalarm_data_history> list=bimpl.serchStateBydev_id(binf);
|
|---|
| | | List<Batt_devalarm_data_history> list=bimpl.serchByCondition(bmd);
|
|---|
| | | //List<Batt_devalarm_data_history> list=bimpl.serchStateBydev_id(binf);
|
|---|
| | | System.out.println(list.size());
|
|---|
| | | for (Batt_devalarm_data_history b : list) {
|
|---|
| | | System.out.println(b.getDev_ip()+" "+b.getDev_id()+" "+b.getNum()+" "+b.getRecord_id()+" "+b.getAlm_type()+" "+b.getAlm_level()+" "+b.getAlm_is_confirmed()+" "+b.getAlm_cleared_type()+" "+b.getUsr_id()+" "+b.getNote()+" "+b.getStationName());
|
|---|
