通讯电源告警规则导出模板

whyclxw

2021-12-15 eeef9ea24e88dc3a9531617d0b493e363cf4f06b

通讯电源告警规则导出模板

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

@@ -29,5 +29,10 @@
    private Response createModel(@RequestBody List<PwrdevAlarmParam> list){
        return  service.createModel(list);
    }
    @ApiOperation("通信电源告警规则--导出模板")
    @GetMapping("/exportModel")
    private Response exportModel(@RequestParam int powerDeviceId){
        return  service.exportModel(powerDeviceId);
    }

}

 src/main/java/com/whyc/mapper/PwrdevAlarmParamMapper.java

@@ -17,8 +17,16 @@
    List<PwrdevTimeOutAlarm> getAllPage(int powerDeviceId);

    //通信电源告警规则--清空表
    int truncateTable();
    void truncateTable();

    //通信电源告警规则--新建模板
    int createModel(List<PwrdevAlarmParam> list);

    //通信电源告警规则--清空id表
    void truncateTable_id(int powerDeviceId);

    //查询模板表数据
    List searchId(int powerDeviceId);
    //通信电源告警规则--导出模板
    int exportModel(@Param("powerDeviceId") int powerDeviceId, List<PwrdevAlarmParam> list);
}

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

@@ -30,4 +30,11 @@
        int flag=mapper.createModel(list);
        return  new Response().set(flag);
    }
    //通信电源告警规则--导出模板
    public Response exportModel(int powerDeviceId) {
        mapper.truncateTable_id(powerDeviceId);
        List<PwrdevAlarmParam> list=mapper.searchId(powerDeviceId);
        int flag=mapper.exportModel(powerDeviceId,list);
        return  new Response().set(flag);
    }
}

 src/main/resources/mapper/PwrdevAlarmParamMapper.xml

@@ -5,6 +5,10 @@
        select * from db_pwrdev_alarm.${tableName};
    </select>

    <select id="searchId" resultType="PwrdevAlarmParam" >
        select * from db_pwrdev_alarm.tb_pwrdev_alarm_param;
    </select>

    <select id="getParamList" resultType="java.lang.String">
        select TABLE_NAME from information_schema.TABLES t where t.TABLE_SCHEMA ='db_pwrdev_alarm' and t.TABLE_NAME like 'tb_pwrdev_alarm_param%' limit 1
    </select>
@@ -17,6 +21,10 @@
        truncate table db_pwrdev_alarm.tb_pwrdev_alarm_param
    </update>

    <update id="truncateTable_id">
        truncate table db_pwrdev_alarm.tb_pwrdev_alarm_param_#{powerDeviceId}
    </update>

    <insert id="createModel">
        insert into db_pwrdev_alarm.tb_pwrdev_alarm_param(num,alarm_id,alarm_limitH,alarm_limitL,alarm_limitEn,UserAlarm_EN,alarm_level,alarm_devtype,alarm_name)
        VALUES
@@ -24,4 +32,11 @@
          (#{p.num},#{p.alarmId},#{p.alarmLimith},#{p.alarmLimitl},#{p.alarmLimiten},#{p.useralarmEn},#{p.alarmLevel},#{p.alarmDevtype},#{p.alarmName})
        </foreach>
    </insert>
    <insert id="exportModel">
        insert into db_pwrdev_alarm.tb_pwrdev_alarm_param_#{powerDeviceId}(num,alarm_id,alarm_limitH,alarm_limitL,alarm_limitEn,UserAlarm_EN,alarm_level,alarm_devtype,alarm_name)
        VALUES
        <foreach collection="list" item="p"  separator=",">
            (#{p.num},#{p.alarmId},#{p.alarmLimith},#{p.alarmLimitl},#{p.alarmLimiten},#{p.useralarmEn},#{p.alarmLevel},#{p.alarmDevtype},#{p.alarmName})
        </foreach>
    </insert>
</mapper>