ups告警历史删除和确定，取消

lxw

2023-11-30 103afdf4871d4bdf07b22b4904ede7d3fc8cc70b

ups告警历史删除和确定，取消

 src/main/java/com/whyc/controller/UpspwrdevAlarmHistoryController.java

@@ -6,10 +6,7 @@
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.bind.annotation.*;

import java.text.ParseException;

@@ -26,4 +23,22 @@
    public Response getAlmHis(@RequestBody UpsAlarmDTO upsAlarmDTO) throws ParseException {
        return service.getAlmHis(upsAlarmDTO);
    }

    @GetMapping("setHisAlmIsConfirmed")
    @ApiOperation(value = "ups历史告警确认")
    public Response setHisAlmIsConfirmed(@RequestParam int num,@RequestParam String year){
        return service.setHisAlmIsConfirmed(num,year);
    }
    @GetMapping("cancleHisAlmIsConfirmed")
    @ApiOperation(value = "ups历史告警取消")
    public Response cancleHisAlmIsConfirmed(@RequestParam int num,@RequestParam String year){
        return service.cancleHisAlmIsConfirmed(num,year);
    }

    @GetMapping("delHisAlm")
    @ApiOperation(value = "ups历史告警删除")
    public Response delHisAlm(@RequestParam int num,@RequestParam String year){
        return service.delHisAlm(num,year);
    }

}

 src/main/java/com/whyc/service/SubTablePageInfoService.java

@@ -3339,4 +3339,23 @@
        });
        return list;
    }
    //ups历史告警确认
    public int setHisAlmIsConfirmed(int num, String year) {
        String sql=" update db_upspwrdev_alarm.tb_upspwrdev_alarm_history_"+year+" set alm_is_confirmed =1," +
                " where num = "+num+" ";
        int flag=sqlExecuteService.executeUpdate(sql,null);
        return flag;
    }
    //ups历史告警取消
    public int cancleHisAlmIsConfirmed(int num, String year) {
        String sql=" update db_upspwrdev_alarm.tb_upspwrdev_alarm_history_"+year+" set alm_is_confirmed =0," +
                " where num = "+num+" ";
        int flag=sqlExecuteService.executeUpdate(sql,null);
        return flag;
    }
    //ups历史告警删除
    public void delHisAlm(int num, String year) {
        String sql="delete from db_upspwrdev_alarm.tb_upspwrdev_alarm_history_"+year+" where num = "+num+"";
        sqlExecuteService.execute(sql);
    }
}

 src/main/java/com/whyc/service/UpspwrdevAlarmHistoryService.java

@@ -1,13 +1,16 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.AlarmDaoFactory;
import com.whyc.dto.Response;
import com.whyc.dto.UpsAlarmDTO;
import com.whyc.pojo.PwrdevAlarmHistory;
import com.whyc.pojo.UpspwrdevAlarm;
import com.whyc.pojo.UpspwrdevAlarmHistory;
import com.whyc.util.ActionUtil;
import com.whyc.util.SubTablePageInfoUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
@@ -21,6 +24,9 @@

    @Resource
    private SubTablePageInfoUtils subTablePageInfoUtils;

    @Autowired
    private SubTablePageInfoService subService;


    //ups历史告警数据
@@ -42,4 +48,21 @@
        }
        return new Response<>().setII(1, pageInfo, null, "返回结果");
    }


    //ups历史告警确认
    public Response setHisAlmIsConfirmed(int num,String year) {
        int flag=subService.setHisAlmIsConfirmed(num,year);
        return new Response().set(1,flag>0,"ups历史告警确认");
    }
    //ups历史告警取消
    public Response cancleHisAlmIsConfirmed(int num,String year) {
        int flag=subService.cancleHisAlmIsConfirmed(num,year);
        return new Response().set(1,flag>0,"ups历史告警取消");
    }
    //ups历史告警删除
    public Response delHisAlm(int num,String year) {
        subService.delHisAlm(num,year);
        return new Response().set(1,true,"ups历史告警删除");
    }
}