设备报警

懒羊羊

2023-12-15 b5173779b9ae16149f24001b3b39cfb4ec425a8e

设备报警

 jcdm-main/src/main/java/com/jcdm/main/em/equipmentAlarm/controller/EmEquipmentAlarmController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,105 @@
package com.jcdm.main.em.equipmentAlarm.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;

import com.jcdm.main.em.equipmentAlarm.domain.EmEquipmentAlarm;
import com.jcdm.main.em.equipmentAlarm.service.IEmEquipmentAlarmService;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.jcdm.common.annotation.Log;
import com.jcdm.common.core.controller.BaseController;
import com.jcdm.common.core.domain.AjaxResult;
import com.jcdm.common.enums.BusinessType;
import com.jcdm.common.utils.poi.ExcelUtil;
import com.jcdm.common.core.page.TableDataInfo;

/**
 * è®¾å¤‡æŠ¥è­¦Controller
 * 
 * @author ruimin
 * @date 2023-12-15
 */
@RestController
@RequestMapping("/em/equipmentAlarm")
public class EmEquipmentAlarmController extends BaseController
{
    @Autowired
    private IEmEquipmentAlarmService emEquipmentAlarmService;

    /**
     * æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('em:equipmentAlarm:list')")
    @GetMapping("/list")
    public TableDataInfo list(EmEquipmentAlarm emEquipmentAlarm)
    {
        startPage();
        List<EmEquipmentAlarm> list = emEquipmentAlarmService.selectEmEquipmentAlarmList(emEquipmentAlarm);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºè®¾å¤‡æŠ¥è­¦åˆ—表
     */
    @PreAuthorize("@ss.hasPermi('em:equipmentAlarm:export')")
    @Log(title = "设备报警", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, EmEquipmentAlarm emEquipmentAlarm)
    {
        List<EmEquipmentAlarm> list = emEquipmentAlarmService.selectEmEquipmentAlarmList(emEquipmentAlarm);
        ExcelUtil<EmEquipmentAlarm> util = new ExcelUtil<EmEquipmentAlarm>(EmEquipmentAlarm.class);
        util.exportExcel(response, list, "设备报警数据");
    }

    /**
     * èŽ·å–设备报警详细信息
     */
    @PreAuthorize("@ss.hasPermi('em:equipmentAlarm:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(emEquipmentAlarmService.selectEmEquipmentAlarmById(id));
    }

    /**
     * æ–°å¢žè®¾å¤‡æŠ¥è­¦
     */
    @PreAuthorize("@ss.hasPermi('em:equipmentAlarm:add')")
    @Log(title = "设备报警", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody EmEquipmentAlarm emEquipmentAlarm)
    {
        return toAjax(emEquipmentAlarmService.insertEmEquipmentAlarm(emEquipmentAlarm));
    }

    /**
     * ä¿®æ”¹è®¾å¤‡æŠ¥è­¦
     */
    @PreAuthorize("@ss.hasPermi('em:equipmentAlarm:edit')")
    @Log(title = "设备报警", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody EmEquipmentAlarm emEquipmentAlarm)
    {
        return toAjax(emEquipmentAlarmService.updateEmEquipmentAlarm(emEquipmentAlarm));
    }

    /**
     * åˆ é™¤è®¾å¤‡æŠ¥è­¦
     */
    @PreAuthorize("@ss.hasPermi('em:equipmentAlarm:remove')")
    @Log(title = "设备报警", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(emEquipmentAlarmService.deleteEmEquipmentAlarmByIds(ids));
    }
}

 jcdm-main/src/main/java/com/jcdm/main/em/equipmentAlarm/domain/EmEquipmentAlarm.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,257 @@
package com.jcdm.main.em.equipmentAlarm.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.jcdm.common.annotation.Excel;
import com.jcdm.common.core.domain.BaseEntity;

/**
 * è®¾å¤‡æŠ¥è­¦å¯¹è±¡ em_equipment_alarm
 * 
 * @author ruimin
 * @date 2023-12-15
 */
public class EmEquipmentAlarm extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ID */
    private Long id;

    /** è®¾å¤‡ç¼–号 */
    @Excel(name = "设备编号")
    private String equipmentCode;

    /** è®¾å¤‡åç§° */
    @Excel(name = "设备名称")
    private String equipmentName;

    /** è®¾å¤‡ç±»åž‹ */
    @Excel(name = "设备类型")
    private String equipmentType;

    /** è½¦é—´ç¼–号 */
    @Excel(name = "车间编号")
    private String workshopCode;

    /** äº§çº¿ç¼–号 */
    @Excel(name = "产线编号")
    private String lineCode;

    /** å·¥åºç¼–号 */
    @Excel(name = "工序编号")
    private String processesCode;

    /** æ•…障代码 */
    @Excel(name = "故障代码")
    private String errorNo;

    /** æ•…障描述 */
    @Excel(name = "故障描述")
    private String errorDesc;

    /** æŠ¥è­¦æ—¶é—´ */
    @Excel(name = "报警时间")
    private String alarmTime;

    /** æ˜¯å¦æ¢å¤(0否1是) */
    @Excel(name = "是否恢复(0否1是)")
    private String whetherRecovery;

    /** æ¢å¤æ—¶é—´ */
    @Excel(name = "恢复时间")
    private String recoveryTime;

    /** é¢„留字段1 */
    private String spareField1;

    /** é¢„留字段2 */
    private String spareField2;

    /** é¢„留字段3 */
    private String spareField3;

    /** é¢„留字段4 */
    private String spareField4;

    /** å¤‡æ³¨ */
    @Excel(name = "备注")
    private String remarks;

    public void setId(Long id) 
    {
        this.id = id;
    }

    public Long getId() 
    {
        return id;
    }
    public void setEquipmentCode(String equipmentCode) 
    {
        this.equipmentCode = equipmentCode;
    }

    public String getEquipmentCode() 
    {
        return equipmentCode;
    }
    public void setEquipmentName(String equipmentName) 
    {
        this.equipmentName = equipmentName;
    }

    public String getEquipmentName() 
    {
        return equipmentName;
    }
    public void setEquipmentType(String equipmentType) 
    {
        this.equipmentType = equipmentType;
    }

    public String getEquipmentType() 
    {
        return equipmentType;
    }
    public void setWorkshopCode(String workshopCode) 
    {
        this.workshopCode = workshopCode;
    }

    public String getWorkshopCode() 
    {
        return workshopCode;
    }
    public void setLineCode(String lineCode) 
    {
        this.lineCode = lineCode;
    }

    public String getLineCode() 
    {
        return lineCode;
    }
    public void setProcessesCode(String processesCode) 
    {
        this.processesCode = processesCode;
    }

    public String getProcessesCode() 
    {
        return processesCode;
    }
    public void setErrorNo(String errorNo) 
    {
        this.errorNo = errorNo;
    }

    public String getErrorNo() 
    {
        return errorNo;
    }
    public void setErrorDesc(String errorDesc) 
    {
        this.errorDesc = errorDesc;
    }

    public String getErrorDesc() 
    {
        return errorDesc;
    }
    public void setAlarmTime(String alarmTime) 
    {
        this.alarmTime = alarmTime;
    }

    public String getAlarmTime() 
    {
        return alarmTime;
    }
    public void setWhetherRecovery(String whetherRecovery) 
    {
        this.whetherRecovery = whetherRecovery;
    }

    public String getWhetherRecovery() 
    {
        return whetherRecovery;
    }
    public void setRecoveryTime(String recoveryTime) 
    {
        this.recoveryTime = recoveryTime;
    }

    public String getRecoveryTime() 
    {
        return recoveryTime;
    }
    public void setSpareField1(String spareField1) 
    {
        this.spareField1 = spareField1;
    }

    public String getSpareField1() 
    {
        return spareField1;
    }
    public void setSpareField2(String spareField2) 
    {
        this.spareField2 = spareField2;
    }

    public String getSpareField2() 
    {
        return spareField2;
    }
    public void setSpareField3(String spareField3) 
    {
        this.spareField3 = spareField3;
    }

    public String getSpareField3() 
    {
        return spareField3;
    }
    public void setSpareField4(String spareField4) 
    {
        this.spareField4 = spareField4;
    }

    public String getSpareField4() 
    {
        return spareField4;
    }
    public void setRemarks(String remarks) 
    {
        this.remarks = remarks;
    }

    public String getRemarks() 
    {
        return remarks;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("equipmentCode", getEquipmentCode())
            .append("equipmentName", getEquipmentName())
            .append("equipmentType", getEquipmentType())
            .append("workshopCode", getWorkshopCode())
            .append("lineCode", getLineCode())
            .append("processesCode", getProcessesCode())
            .append("errorNo", getErrorNo())
            .append("errorDesc", getErrorDesc())
            .append("alarmTime", getAlarmTime())
            .append("whetherRecovery", getWhetherRecovery())
            .append("recoveryTime", getRecoveryTime())
            .append("spareField1", getSpareField1())
            .append("spareField2", getSpareField2())
            .append("spareField3", getSpareField3())
            .append("spareField4", getSpareField4())
            .append("remarks", getRemarks())
            .toString();
    }
}

 jcdm-main/src/main/java/com/jcdm/main/em/equipmentAlarm/mapper/EmEquipmentAlarmMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.jcdm.main.em.equipmentAlarm.mapper;

import com.jcdm.main.em.equipmentAlarm.domain.EmEquipmentAlarm;

import java.util.List;

/**
 * è®¾å¤‡æŠ¥è­¦Mapper接口
 * 
 * @author ruimin
 * @date 2023-12-15
 */
public interface EmEquipmentAlarmMapper 
{
    /**
     * æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦
     * 
     * @param id è®¾å¤‡æŠ¥è­¦ä¸»é”®
     * @return è®¾å¤‡æŠ¥è­¦
     */
    public EmEquipmentAlarm selectEmEquipmentAlarmById(Long id);

    /**
     * æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦åˆ—表
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return è®¾å¤‡æŠ¥è­¦é›†åˆ
     */
    public List<EmEquipmentAlarm> selectEmEquipmentAlarmList(EmEquipmentAlarm emEquipmentAlarm);

    /**
     * æ–°å¢žè®¾å¤‡æŠ¥è­¦
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return ç»“æžœ
     */
    public int insertEmEquipmentAlarm(EmEquipmentAlarm emEquipmentAlarm);

    /**
     * ä¿®æ”¹è®¾å¤‡æŠ¥è­¦
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return ç»“æžœ
     */
    public int updateEmEquipmentAlarm(EmEquipmentAlarm emEquipmentAlarm);

    /**
     * åˆ é™¤è®¾å¤‡æŠ¥è­¦
     * 
     * @param id è®¾å¤‡æŠ¥è­¦ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteEmEquipmentAlarmById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤è®¾å¤‡æŠ¥è­¦
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteEmEquipmentAlarmByIds(Long[] ids);
}

 jcdm-main/src/main/java/com/jcdm/main/em/equipmentAlarm/service/IEmEquipmentAlarmService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,62 @@
package com.jcdm.main.em.equipmentAlarm.service;

import com.jcdm.main.em.equipmentAlarm.domain.EmEquipmentAlarm;

import java.util.List;

/**
 * è®¾å¤‡æŠ¥è­¦Service接口
 * 
 * @author ruimin
 * @date 2023-12-15
 */
public interface IEmEquipmentAlarmService 
{
    /**
     * æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦
     * 
     * @param id è®¾å¤‡æŠ¥è­¦ä¸»é”®
     * @return è®¾å¤‡æŠ¥è­¦
     */
    public EmEquipmentAlarm selectEmEquipmentAlarmById(Long id);

    /**
     * æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦åˆ—表
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return è®¾å¤‡æŠ¥è­¦é›†åˆ
     */
    public List<EmEquipmentAlarm> selectEmEquipmentAlarmList(EmEquipmentAlarm emEquipmentAlarm);

    /**
     * æ–°å¢žè®¾å¤‡æŠ¥è­¦
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return ç»“æžœ
     */
    public int insertEmEquipmentAlarm(EmEquipmentAlarm emEquipmentAlarm);

    /**
     * ä¿®æ”¹è®¾å¤‡æŠ¥è­¦
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return ç»“æžœ
     */
    public int updateEmEquipmentAlarm(EmEquipmentAlarm emEquipmentAlarm);

    /**
     * æ‰¹é‡åˆ é™¤è®¾å¤‡æŠ¥è­¦
     * 
     * @param ids éœ€è¦åˆ é™¤çš„设备报警主键集合
     * @return ç»“æžœ
     */
    public int deleteEmEquipmentAlarmByIds(Long[] ids);

    /**
     * åˆ é™¤è®¾å¤‡æŠ¥è­¦ä¿¡æ¯
     * 
     * @param id è®¾å¤‡æŠ¥è­¦ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteEmEquipmentAlarmById(Long id);
}

 jcdm-main/src/main/java/com/jcdm/main/em/equipmentAlarm/service/impl/EmEquipmentAlarmServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,94 @@
package com.jcdm.main.em.equipmentAlarm.service.impl;

import java.util.List;

import com.jcdm.main.em.equipmentAlarm.domain.EmEquipmentAlarm;
import com.jcdm.main.em.equipmentAlarm.mapper.EmEquipmentAlarmMapper;
import com.jcdm.main.em.equipmentAlarm.service.IEmEquipmentAlarmService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * è®¾å¤‡æŠ¥è­¦Service业务层处理
 * 
 * @author ruimin
 * @date 2023-12-15
 */
@Service
public class EmEquipmentAlarmServiceImpl implements IEmEquipmentAlarmService
{
    @Autowired
    private EmEquipmentAlarmMapper emEquipmentAlarmMapper;

    /**
     * æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦
     * 
     * @param id è®¾å¤‡æŠ¥è­¦ä¸»é”®
     * @return è®¾å¤‡æŠ¥è­¦
     */
    @Override
    public EmEquipmentAlarm selectEmEquipmentAlarmById(Long id)
    {
        return emEquipmentAlarmMapper.selectEmEquipmentAlarmById(id);
    }

    /**
     * æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦åˆ—表
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return è®¾å¤‡æŠ¥è­¦
     */
    @Override
    public List<EmEquipmentAlarm> selectEmEquipmentAlarmList(EmEquipmentAlarm emEquipmentAlarm)
    {
        return emEquipmentAlarmMapper.selectEmEquipmentAlarmList(emEquipmentAlarm);
    }

    /**
     * æ–°å¢žè®¾å¤‡æŠ¥è­¦
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return ç»“æžœ
     */
    @Override
    public int insertEmEquipmentAlarm(EmEquipmentAlarm emEquipmentAlarm)
    {
        return emEquipmentAlarmMapper.insertEmEquipmentAlarm(emEquipmentAlarm);
    }

    /**
     * ä¿®æ”¹è®¾å¤‡æŠ¥è­¦
     * 
     * @param emEquipmentAlarm è®¾å¤‡æŠ¥è­¦
     * @return ç»“æžœ
     */
    @Override
    public int updateEmEquipmentAlarm(EmEquipmentAlarm emEquipmentAlarm)
    {
        return emEquipmentAlarmMapper.updateEmEquipmentAlarm(emEquipmentAlarm);
    }

    /**
     * æ‰¹é‡åˆ é™¤è®¾å¤‡æŠ¥è­¦
     * 
     * @param ids éœ€è¦åˆ é™¤çš„设备报警主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteEmEquipmentAlarmByIds(Long[] ids)
    {
        return emEquipmentAlarmMapper.deleteEmEquipmentAlarmByIds(ids);
    }

    /**
     * åˆ é™¤è®¾å¤‡æŠ¥è­¦ä¿¡æ¯
     * 
     * @param id è®¾å¤‡æŠ¥è­¦ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteEmEquipmentAlarmById(Long id)
    {
        return emEquipmentAlarmMapper.deleteEmEquipmentAlarmById(id);
    }
}

 jcdm-main/src/main/resources/mapper/em/equipmentAlarm/EmEquipmentAlarmMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,121 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jcdm.main.em.equipmentAlarm.mapper.EmEquipmentAlarmMapper">

    <resultMap type="EmEquipmentAlarm" id="EmEquipmentAlarmResult">
        <result property="id"    column="id"    />
        <result property="equipmentCode"    column="equipment_code"    />
        <result property="equipmentName"    column="equipment_name"    />
        <result property="equipmentType"    column="equipment_type"    />
        <result property="workshopCode"    column="workshop_code"    />
        <result property="lineCode"    column="line_code"    />
        <result property="processesCode"    column="processes_code"    />
        <result property="errorNo"    column="error_no"    />
        <result property="errorDesc"    column="error_desc"    />
        <result property="alarmTime"    column="alarm_time"    />
        <result property="whetherRecovery"    column="whether_recovery"    />
        <result property="recoveryTime"    column="recovery_time"    />
        <result property="spareField1"    column="spare_field_1"    />
        <result property="spareField2"    column="spare_field_2"    />
        <result property="spareField3"    column="spare_field_3"    />
        <result property="spareField4"    column="spare_field_4"    />
        <result property="remarks"    column="remarks"    />
    </resultMap>

    <sql id="selectEmEquipmentAlarmVo">
        select id, equipment_code, equipment_name, equipment_type, workshop_code, line_code, processes_code, error_no, error_desc, alarm_time, whether_recovery, recovery_time, spare_field_1, spare_field_2, spare_field_3, spare_field_4, remarks from em_equipment_alarm
    </sql>

    <select id="selectEmEquipmentAlarmList" parameterType="EmEquipmentAlarm" resultMap="EmEquipmentAlarmResult">
        <include refid="selectEmEquipmentAlarmVo"/>
        <where>  
            <if test="equipmentCode != null  and equipmentCode != ''"> and equipment_code like concat('%', #{equipmentCode}, '%')</if>
            <if test="equipmentName != null  and equipmentName != ''"> and equipment_name like concat('%', #{equipmentName}, '%')</if>
            <if test="equipmentType != null  and equipmentType != ''"> and equipment_type = #{equipmentType}</if>
            <if test="errorNo != null  and errorNo != ''"> and error_no = #{errorNo}</if>
        </where>
    </select>
    
    <select id="selectEmEquipmentAlarmById" parameterType="Long" resultMap="EmEquipmentAlarmResult">
        <include refid="selectEmEquipmentAlarmVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertEmEquipmentAlarm" parameterType="EmEquipmentAlarm">
        insert into em_equipment_alarm
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="equipmentCode != null and equipmentCode != ''">equipment_code,</if>
            <if test="equipmentName != null and equipmentName != ''">equipment_name,</if>
            <if test="equipmentType != null and equipmentType != ''">equipment_type,</if>
            <if test="workshopCode != null">workshop_code,</if>
            <if test="lineCode != null">line_code,</if>
            <if test="processesCode != null and processesCode != ''">processes_code,</if>
            <if test="errorNo != null and errorNo != ''">error_no,</if>
            <if test="errorDesc != null">error_desc,</if>
            <if test="alarmTime != null">alarm_time,</if>
            <if test="whetherRecovery != null">whether_recovery,</if>
            <if test="recoveryTime != null">recovery_time,</if>
            <if test="spareField1 != null">spare_field_1,</if>
            <if test="spareField2 != null">spare_field_2,</if>
            <if test="spareField3 != null">spare_field_3,</if>
            <if test="spareField4 != null">spare_field_4,</if>
            <if test="remarks != null">remarks,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="equipmentCode != null and equipmentCode != ''">#{equipmentCode},</if>
            <if test="equipmentName != null and equipmentName != ''">#{equipmentName},</if>
            <if test="equipmentType != null and equipmentType != ''">#{equipmentType},</if>
            <if test="workshopCode != null">#{workshopCode},</if>
            <if test="lineCode != null">#{lineCode},</if>
            <if test="processesCode != null and processesCode != ''">#{processesCode},</if>
            <if test="errorNo != null and errorNo != ''">#{errorNo},</if>
            <if test="errorDesc != null">#{errorDesc},</if>
            <if test="alarmTime != null">#{alarmTime},</if>
            <if test="whetherRecovery != null">#{whetherRecovery},</if>
            <if test="recoveryTime != null">#{recoveryTime},</if>
            <if test="spareField1 != null">#{spareField1},</if>
            <if test="spareField2 != null">#{spareField2},</if>
            <if test="spareField3 != null">#{spareField3},</if>
            <if test="spareField4 != null">#{spareField4},</if>
            <if test="remarks != null">#{remarks},</if>
         </trim>
    </insert>

    <update id="updateEmEquipmentAlarm" parameterType="EmEquipmentAlarm">
        update em_equipment_alarm
        <trim prefix="SET" suffixOverrides=",">
            <if test="equipmentCode != null and equipmentCode != ''">equipment_code = #{equipmentCode},</if>
            <if test="equipmentName != null and equipmentName != ''">equipment_name = #{equipmentName},</if>
            <if test="equipmentType != null and equipmentType != ''">equipment_type = #{equipmentType},</if>
            <if test="workshopCode != null">workshop_code = #{workshopCode},</if>
            <if test="lineCode != null">line_code = #{lineCode},</if>
            <if test="processesCode != null and processesCode != ''">processes_code = #{processesCode},</if>
            <if test="errorNo != null and errorNo != ''">error_no = #{errorNo},</if>
            <if test="errorDesc != null">error_desc = #{errorDesc},</if>
            <if test="alarmTime != null">alarm_time = #{alarmTime},</if>
            <if test="whetherRecovery != null">whether_recovery = #{whetherRecovery},</if>
            <if test="recoveryTime != null">recovery_time = #{recoveryTime},</if>
            <if test="spareField1 != null">spare_field_1 = #{spareField1},</if>
            <if test="spareField2 != null">spare_field_2 = #{spareField2},</if>
            <if test="spareField3 != null">spare_field_3 = #{spareField3},</if>
            <if test="spareField4 != null">spare_field_4 = #{spareField4},</if>
            <if test="remarks != null">remarks = #{remarks},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteEmEquipmentAlarmById" parameterType="Long">
        delete from em_equipment_alarm where id = #{id}
    </delete>

    <delete id="deleteEmEquipmentAlarmByIds" parameterType="String">
        delete from em_equipment_alarm where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 jcdm-ui/src/api/main/em/equipmentAlarm/equipmentAlarm.js

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,44 @@
import request from '@/utils/request'

// æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦åˆ—表
export function listEquipmentAlarm(query) {
  return request({
    url: '/em/equipmentAlarm/list',
    method: 'get',
    params: query
  })
}

// æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦è¯¦ç»†
export function getEquipmentAlarm(id) {
  return request({
    url: '/em/equipmentAlarm/' + id,
    method: 'get'
  })
}

// æ–°å¢žè®¾å¤‡æŠ¥è­¦
export function addEquipmentAlarm(data) {
  return request({
    url: '/em/equipmentAlarm',
    method: 'post',
    data: data
  })
}

// ä¿®æ”¹è®¾å¤‡æŠ¥è­¦
export function updateEquipmentAlarm(data) {
  return request({
    url: '/em/equipmentAlarm',
    method: 'put',
    data: data
  })
}

// åˆ é™¤è®¾å¤‡æŠ¥è­¦
export function delEquipmentAlarm(id) {
  return request({
    url: '/em/equipmentAlarm/' + id,
    method: 'delete'
  })
}

 jcdm-ui/src/views/main/em/equipmentAlarm/index.vue

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,377 @@
<template>
  <div class="app-container">
    <el-card class="box-card">
    <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
      <el-form-item label="设备编号" prop="equipmentCode">
        <el-input
          v-model="queryParams.equipmentCode"
          placeholder="请输入设备编号"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="设备名称" prop="equipmentName">
        <el-input
          v-model="queryParams.equipmentName"
          placeholder="请输入设备名称"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
<!--      <el-form-item label="设备类型" prop="equipmentType">-->
<!--        <el-select v-model="queryParams.equipmentType" placeholder="请选择设备类型" clearable>-->
<!--          <el-option-->
<!--            v-for="dict in dict.type.${dictType}"-->
<!--            :key="dict.value"-->
<!--            :label="dict.label"-->
<!--            :value="dict.value"-->
<!--          />-->
<!--        </el-select>-->
<!--      </el-form-item>-->
      <el-form-item label="故障代码" prop="errorNo">
        <el-input
          v-model="queryParams.errorNo"
          placeholder="请输入故障代码"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>
    </el-card>
    <el-card style="margin-top: 10px" class="box-card">
    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
          type="primary"
          plain
          icon="el-icon-plus"
          size="mini"
          @click="handleAdd"
          v-hasPermi="['em:equipmentAlarm:add']"
        >新增</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="success"
          plain
          icon="el-icon-edit"
          size="mini"
          :disabled="single"
          @click="handleUpdate"
          v-hasPermi="['em:equipmentAlarm:edit']"
        >修改</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="danger"
          plain
          icon="el-icon-delete"
          size="mini"
          :disabled="multiple"
          @click="handleDelete"
          v-hasPermi="['em:equipmentAlarm:remove']"
        >删除</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
          @click="handleExport"
          v-hasPermi="['em:equipmentAlarm:export']"
        >导出</el-button>
      </el-col>
      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
    </el-row>

    <el-table border v-loading="loading" :data="equipmentAlarmList" @selection-change="handleSelectionChange">
      <el-table-column type="selection" width="55" align="center" />
      <el-table-column label="设备编号" width="120" align="center" prop="equipmentCode">
      </el-table-column>
      <el-table-column label="设备名称" width="150" align="center" prop="equipmentName">
      </el-table-column>
      <el-table-column label="设备类型" align="center" prop="equipmentType">
      </el-table-column>
      <el-table-column label="车间编号" width="80" align="center" prop="workshopCode">
      </el-table-column>
      <el-table-column label="产线编号" width="80" align="center" prop="lineCode">
      </el-table-column>
      <el-table-column label="工序编号" align="center" prop="processesCode">
      </el-table-column>
      <el-table-column label="故障代码" width="100" align="center" prop="errorNo">
      </el-table-column>
      <el-table-column label="故障描述" width="160" align="center" prop="errorDesc">
      </el-table-column>
      <el-table-column label="报警时间" width="160" align="center" prop="alarmTime">
      </el-table-column>
      <el-table-column label="是否恢复" align="center" prop="whetherRecovery">
      </el-table-column>
      <el-table-column label="恢复时间" width="160" align="center" prop="recoveryTime">
      </el-table-column>
      <el-table-column label="备注" align="center" prop="remarks">
      </el-table-column>
      <el-table-column fixed="right" width="200" label="操作" align="center" class-name="small-padding fixed-width">
        <template slot-scope="scope">
          <el-button
            size="mini"
            plain
            type="success"
            style="width: 72px"
            icon="el-icon-edit"
            @click="handleUpdate(scope.row)"
            v-hasPermi="['em:equipmentAlarm:edit']"
          >修改</el-button>
          <el-button
            size="mini"
            plain
            type="danger"
            style="width: 72px"
            icon="el-icon-delete"
            @click="handleDelete(scope.row)"
            v-hasPermi="['em:equipmentAlarm:remove']"
          >删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    </el-card>

    <pagination
      v-show="total>0"
      :total="total"
      :page.sync="queryParams.pageNum"
      :limit.sync="queryParams.pageSize"
      @pagination="getList"
    />

    <!-- æ·»åŠ æˆ–修改设备报警对话框 -->
    <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
      <el-form ref="form" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="设备编号" prop="equipmentCode">
          <el-input v-model="form.equipmentCode" placeholder="请输入设备编号" />
        </el-form-item>
        <el-form-item label="设备名称" prop="equipmentName">
          <el-input v-model="form.equipmentName" placeholder="请输入设备名称" />
        </el-form-item>
<!--        <el-form-item label="设备类型" prop="equipmentType">-->
<!--          <el-select v-model="form.equipmentType" placeholder="请选择设备类型">-->
<!--            <el-option-->
<!--              v-for="dict in dict.type.${dictType}"-->
<!--              :key="dict.value"-->
<!--              :label="dict.label"-->
<!--              :value="dict.value"-->
<!--            ></el-option>-->
<!--          </el-select>-->
<!--        </el-form-item>-->
        <el-form-item label="车间编号" prop="workshopCode">
          <el-input v-model="form.workshopCode" placeholder="请输入车间编号" />
        </el-form-item>
        <el-form-item label="产线编号" prop="lineCode">
          <el-input v-model="form.lineCode" placeholder="请输入产线编号" />
        </el-form-item>
<!--        <el-form-item label="工序编号" prop="processesCode">-->
<!--          <el-select v-model="form.processesCode" placeholder="请选择工序编号">-->
<!--            <el-option-->
<!--              v-for="dict in dict.type.${dictType}"-->
<!--              :key="dict.value"-->
<!--              :label="dict.label"-->
<!--              :value="dict.value"-->
<!--            ></el-option>-->
<!--          </el-select>-->
<!--        </el-form-item>-->
        <el-form-item label="故障代码" prop="errorNo">
          <el-input v-model="form.errorNo" placeholder="请输入故障代码" />
        </el-form-item>
        <el-form-item label="故障描述" prop="errorDesc">
          <el-input v-model="form.errorDesc" placeholder="请输入故障描述" />
        </el-form-item>
        <el-form-item label="是否恢复" prop="whetherRecovery">
          <el-input v-model="form.whetherRecovery" placeholder="请输入是否恢复(0否1是)" />
        </el-form-item>
        <el-form-item label="备注" prop="remarks">
          <el-input v-model="form.remarks" placeholder="请输入备注" />
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">ç¡® å®š</el-button>
        <el-button @click="cancel">取 æ¶ˆ</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import { listEquipmentAlarm, getEquipmentAlarm, delEquipmentAlarm, addEquipmentAlarm, updateEquipmentAlarm } from "@/api/main/em/equipmentAlarm/equipmentAlarm";

export default {
  name: "EquipmentAlarm",
  data() {
    return {
      // é®ç½©å±‚
      loading: true,
      // é€‰ä¸­æ•°ç»„
      ids: [],
      // éžå•ä¸ªç¦ç”¨
      single: true,
      // éžå¤šä¸ªç¦ç”¨
      multiple: true,
      // æ˜¾ç¤ºæœç´¢æ¡ä»¶
      showSearch: true,
      // æ€»æ¡æ•°
      total: 0,
      // è®¾å¤‡æŠ¥è­¦è¡¨æ ¼æ•°æ®
      equipmentAlarmList: [],
      // å¼¹å‡ºå±‚标题
      title: "",
      // æ˜¯å¦æ˜¾ç¤ºå¼¹å‡ºå±‚
      open: false,
      // æŸ¥è¯¢å‚æ•°
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        equipmentCode: null,
        equipmentName: null,
        equipmentType: null,
        errorNo: null,
      },
      // è¡¨å•å‚æ•°
      form: {},
      // è¡¨å•æ ¡éªŒ
      rules: {
        id: [
          { required: true, message: "ID不能为空", trigger: "blur" }
        ],
        equipmentCode: [
          { required: true, message: "设备编号不能为空", trigger: "blur" }
        ],
        equipmentName: [
          { required: true, message: "设备名称不能为空", trigger: "blur" }
        ],
        equipmentType: [
          { required: true, message: "设备类型不能为空", trigger: "change" }
        ],
        processesCode: [
          { required: true, message: "工序编号不能为空", trigger: "change" }
        ],
        errorNo: [
          { required: true, message: "故障代码不能为空", trigger: "blur" }
        ],
      }
    };
  },
  created() {
    this.getList();
  },
  methods: {
    /** æŸ¥è¯¢è®¾å¤‡æŠ¥è­¦åˆ—表 */
    getList() {
      this.loading = true;
      listEquipmentAlarm(this.queryParams).then(response => {
        this.equipmentAlarmList = response.rows;
        this.total = response.total;
        this.loading = false;
      });
    },
    // å–消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // è¡¨å•é‡ç½®
    reset() {
      this.form = {
        id: null,
        equipmentCode: null,
        equipmentName: null,
        equipmentType: null,
        workshopCode: null,
        lineCode: null,
        processesCode: null,
        errorNo: null,
        errorDesc: null,
        alarmTime: null,
        whetherRecovery: null,
        recoveryTime: null,
        spareField1: null,
        spareField2: null,
        spareField3: null,
        spareField4: null,
        remarks: null
      };
      this.resetForm("form");
    },
    /** æœç´¢æŒ‰é’®æ“ä½œ */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
    },
    /** é‡ç½®æŒ‰é’®æ“ä½œ */
    resetQuery() {
      this.resetForm("queryForm");
      this.handleQuery();
    },
    // å¤šé€‰æ¡†é€‰ä¸­æ•°æ®
    handleSelectionChange(selection) {
      this.ids = selection.map(item => item.id)
      this.single = selection.length!==1
      this.multiple = !selection.length
    },
    /** æ–°å¢žæŒ‰é’®æ“ä½œ */
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加设备报警";
    },
    /** ä¿®æ”¹æŒ‰é’®æ“ä½œ */
    handleUpdate(row) {
      this.reset();
      const id = row.id || this.ids
      getEquipmentAlarm(id).then(response => {
        this.form = response.data;
        this.open = true;
        this.title = "修改设备报警";
      });
    },
    /** æäº¤æŒ‰é’® */
    submitForm() {
      this.$refs["form"].validate(valid => {
        if (valid) {
          if (this.form.id != null) {
            updateEquipmentAlarm(this.form).then(response => {
              this.$modal.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addEquipmentAlarm(this.form).then(response => {
              this.$modal.msgSuccess("新增成功");
              this.open = false;
              this.getList();
            });
          }
        }
      });
    },
    /** åˆ é™¤æŒ‰é’®æ“ä½œ */
    handleDelete(row) {
      const ids = row.id || this.ids;
      this.$modal.confirm('是否确认删除设备报警编号为"' + ids + '"的数据项？').then(function() {
        return delEquipmentAlarm(ids);
      }).then(() => {
        this.getList();
        this.$modal.msgSuccess("删除成功");
      }).catch(() => {});
    },
    /** å¯¼å‡ºæŒ‰é’®æ“ä½œ */
    handleExport() {
      this.download('em/equipmentAlarm/export', {
        ...this.queryParams
      }, `equipmentAlarm_${new Date().getTime()}.xlsx`)
    }
  }
};
</script>