临时表功能上传

admin

2024-06-16 c9c1560eeffdc73c38ab8ef6e1492b164b2360f5

临时表功能上传

 jcdm-main/src/main/java/com/jcdm/main/da/paramCollectionTemp/controller/DaParamCollectionTempController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.jcdm.main.da.paramCollectionTemp.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
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.main.da.paramCollectionTemp.domain.DaParamCollectionTemp;
import com.jcdm.main.da.paramCollectionTemp.service.IDaParamCollectionTempService;
import com.jcdm.common.utils.poi.ExcelUtil;
import com.jcdm.common.core.page.TableDataInfo;

/**
 * è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表Controller
 * 
 * @author Yi
 * @date 2024-06-13
 */
@RestController
@RequestMapping("/da/paramCollectionTemp")
public class DaParamCollectionTempController extends BaseController
{
    @Autowired
    private IDaParamCollectionTempService daParamCollectionTempService;

    /**
     * æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表列表
     */
    @PreAuthorize("@ss.hasPermi('da:paramCollectionTemp:list')")
    @GetMapping("/list")
    public TableDataInfo list(DaParamCollectionTemp daParamCollectionTemp)
    {
        startPage();
        List<DaParamCollectionTemp> list = daParamCollectionTempService.selectDaParamCollectionTempList(daParamCollectionTemp);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºè®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表列表
     */
    @PreAuthorize("@ss.hasPermi('da:paramCollectionTemp:export')")
    @Log(title = "设备产品过程参数采集临时表", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, DaParamCollectionTemp daParamCollectionTemp)
    {
        List<DaParamCollectionTemp> list = daParamCollectionTempService.selectDaParamCollectionTempList(daParamCollectionTemp);
        ExcelUtil<DaParamCollectionTemp> util = new ExcelUtil<DaParamCollectionTemp>(DaParamCollectionTemp.class);
        util.exportExcel(response, list, "设备产品过程参数采集临时表数据");
    }

    /**
     * èŽ·å–设备产品过程参数采集临时表详细信息
     */
    @PreAuthorize("@ss.hasPermi('da:paramCollectionTemp:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(daParamCollectionTempService.selectDaParamCollectionTempById(id));
    }

    /**
     * æ–°å¢žè®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     */
    @PreAuthorize("@ss.hasPermi('da:paramCollectionTemp:add')")
    @Log(title = "设备产品过程参数采集临时表", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody DaParamCollectionTemp daParamCollectionTemp)
    {
        return toAjax(daParamCollectionTempService.insertDaParamCollectionTemp(daParamCollectionTemp));
    }

    /**
     * ä¿®æ”¹è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     */
    @PreAuthorize("@ss.hasPermi('da:paramCollectionTemp:edit')")
    @Log(title = "设备产品过程参数采集临时表", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody DaParamCollectionTemp daParamCollectionTemp)
    {
        return toAjax(daParamCollectionTempService.updateDaParamCollectionTemp(daParamCollectionTemp));
    }

    /**
     * åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     */
    @PreAuthorize("@ss.hasPermi('da:paramCollectionTemp:remove')")
    @Log(title = "设备产品过程参数采集临时表", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(daParamCollectionTempService.deleteDaParamCollectionTempByIds(ids));
    }
}

 jcdm-main/src/main/java/com/jcdm/main/da/paramCollectionTemp/domain/DaParamCollectionTemp.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,377 @@
package com.jcdm.main.da.paramCollectionTemp.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;

import java.util.Date;

/**
 * è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表对象 da_param_collection_temp
 * 
 * @author Yi
 * @date 2024-06-13
 */
public class DaParamCollectionTemp extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”®id */
    private Long id;

    /** å·¥å•ç¼–号 */
    @Excel(name = "工单编号")
    private String workOrderNo;

    /** æ€»æˆåºåˆ—号 */
    @Excel(name = "总成序列号")
    private String sfcCode;

    /** äº§å“ç¼–号 */
    @Excel(name = "产品编号")
    private String productCode;

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

    /** å·¥ä½ç¼–号 */
    @Excel(name = "工位编号")
    private String locationCode;

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

    /** å‚数编码 */
    @Excel(name = "参数编码")
    private String paramCode;

    /** å‚数值 */
    @Excel(name = "参数值")
    private String paramValue;

    /** å‚数上限 */
    @Excel(name = "参数上限")
    private String paramUpper;

    /** å‚数下限 */
    @Excel(name = "参数下限")
    private String paramLower;

    /** æ ‡å‡†å€¼ */
    @Excel(name = "标准值")
    private String paramStandard;

    /** é‡‡é›†æ—¶é—´ */
    @Excel(name = "采集时间")
    private Date collectionTime;

    /** é¢„留字段1 */
    @Excel(name = "预留字段1")
    private String moduleCode;

    /** é¢„留字段2 */
    @Excel(name = "预留字段2")
    private String spareField2;

    /** åˆ›å»ºç”¨æˆ· */
    @Excel(name = "创建用户")
    private String createUser;

    /** æ›´æ”¹ç”¨æˆ· */
    @Excel(name = "更改用户")
    private String updateUser;

    /** çŠ¶æ€ï¼ˆ1合格、2不合格） */
    @Excel(name = "状态", readConverterExp = "1=合格、2不合格")
    private String state;

    /** å‚数名称 */
    @Excel(name = "参数名称")
    private String paramName;

    /** å•ä½ */
    @Excel(name = "单位")
    private String unit;

    /** ç±»åž‹ */
    @Excel(name = "类型")
    private String type;

    /** å‚数集编码 */
    @Excel(name = "参数集编码")
    private String parameterSetCode;

    /** å‚数集名称 */
    @Excel(name = "参数集名称")
    private String parameterSetName;

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

    /** å·¥åºåç§° */
    @Excel(name = "工序名称")
    private String processesName;

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

    public Long getId() 
    {
        return id;
    }
    public void setWorkOrderNo(String workOrderNo) 
    {
        this.workOrderNo = workOrderNo;
    }

    public String getWorkOrderNo() 
    {
        return workOrderNo;
    }
    public void setSfcCode(String sfcCode) 
    {
        this.sfcCode = sfcCode;
    }

    public String getSfcCode() 
    {
        return sfcCode;
    }
    public void setProductCode(String productCode) 
    {
        this.productCode = productCode;
    }

    public String getProductCode() 
    {
        return productCode;
    }
    public void setProductionLine(String productionLine) 
    {
        this.productionLine = productionLine;
    }

    public String getProductionLine() 
    {
        return productionLine;
    }
    public void setLocationCode(String locationCode) 
    {
        this.locationCode = locationCode;
    }

    public String getLocationCode() 
    {
        return locationCode;
    }
    public void setEquipmentNo(String equipmentNo) 
    {
        this.equipmentNo = equipmentNo;
    }

    public String getEquipmentNo() 
    {
        return equipmentNo;
    }
    public void setParamCode(String paramCode) 
    {
        this.paramCode = paramCode;
    }

    public String getParamCode() 
    {
        return paramCode;
    }
    public void setParamValue(String paramValue) 
    {
        this.paramValue = paramValue;
    }

    public String getParamValue() 
    {
        return paramValue;
    }
    public void setParamUpper(String paramUpper) 
    {
        this.paramUpper = paramUpper;
    }

    public String getParamUpper() 
    {
        return paramUpper;
    }
    public void setParamLower(String paramLower) 
    {
        this.paramLower = paramLower;
    }

    public String getParamLower() 
    {
        return paramLower;
    }
    public void setParamStandard(String paramStandard) 
    {
        this.paramStandard = paramStandard;
    }

    public String getParamStandard() 
    {
        return paramStandard;
    }
    public void setCollectionTime(Date collectionTime)
    {
        this.collectionTime = collectionTime;
    }

    public Date getCollectionTime()
    {
        return collectionTime;
    }
    public void setModuleCode(String moduleCode) 
    {
        this.moduleCode = moduleCode;
    }

    public String getModuleCode() 
    {
        return moduleCode;
    }
    public void setSpareField2(String spareField2) 
    {
        this.spareField2 = spareField2;
    }

    public String getSpareField2() 
    {
        return spareField2;
    }
    public void setCreateUser(String createUser) 
    {
        this.createUser = createUser;
    }

    public String getCreateUser() 
    {
        return createUser;
    }
    public void setUpdateUser(String updateUser) 
    {
        this.updateUser = updateUser;
    }

    public String getUpdateUser() 
    {
        return updateUser;
    }
    public void setState(String state) 
    {
        this.state = state;
    }

    public String getState() 
    {
        return state;
    }
    public void setParamName(String paramName) 
    {
        this.paramName = paramName;
    }

    public String getParamName() 
    {
        return paramName;
    }
    public void setUnit(String unit) 
    {
        this.unit = unit;
    }

    public String getUnit() 
    {
        return unit;
    }
    public void setType(String type) 
    {
        this.type = type;
    }

    public String getType() 
    {
        return type;
    }
    public void setParameterSetCode(String parameterSetCode) 
    {
        this.parameterSetCode = parameterSetCode;
    }

    public String getParameterSetCode() 
    {
        return parameterSetCode;
    }
    public void setParameterSetName(String parameterSetName) 
    {
        this.parameterSetName = parameterSetName;
    }

    public String getParameterSetName() 
    {
        return parameterSetName;
    }
    public void setProcessesCode(String processesCode) 
    {
        this.processesCode = processesCode;
    }

    public String getProcessesCode() 
    {
        return processesCode;
    }
    public void setProcessesName(String processesName) 
    {
        this.processesName = processesName;
    }

    public String getProcessesName() 
    {
        return processesName;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("workOrderNo", getWorkOrderNo())
            .append("sfcCode", getSfcCode())
            .append("productCode", getProductCode())
            .append("productionLine", getProductionLine())
            .append("locationCode", getLocationCode())
            .append("equipmentNo", getEquipmentNo())
            .append("paramCode", getParamCode())
            .append("paramValue", getParamValue())
            .append("paramUpper", getParamUpper())
            .append("paramLower", getParamLower())
            .append("paramStandard", getParamStandard())
            .append("collectionTime", getCollectionTime())
            .append("moduleCode", getModuleCode())
            .append("spareField2", getSpareField2())
            .append("createUser", getCreateUser())
            .append("createTime", getCreateTime())
            .append("updateUser", getUpdateUser())
            .append("updateTime", getUpdateTime())
            .append("state", getState())
            .append("paramName", getParamName())
            .append("unit", getUnit())
            .append("type", getType())
            .append("parameterSetCode", getParameterSetCode())
            .append("parameterSetName", getParameterSetName())
            .append("processesCode", getProcessesCode())
            .append("processesName", getProcessesName())
            .toString();
    }
}

 jcdm-main/src/main/java/com/jcdm/main/da/paramCollectionTemp/mapper/DaParamCollectionTempMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.jcdm.main.da.paramCollectionTemp.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jcdm.main.da.paramCollectionTemp.domain.DaParamCollectionTemp;

/**
 * è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表Mapper接口
 * 
 * @author Yi
 * @date 2024-06-13
 */
public interface DaParamCollectionTempMapper extends BaseMapper<DaParamCollectionTemp>
{
    /**
     * æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param id è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表主键
     * @return è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     */
    public DaParamCollectionTemp selectDaParamCollectionTempById(Long id);

    /**
     * æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表列表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表集合
     */
    public List<DaParamCollectionTemp> selectDaParamCollectionTempList(DaParamCollectionTemp daParamCollectionTemp);

    /**
     * æ–°å¢žè®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return ç»“æžœ
     */
    public int insertDaParamCollectionTemp(DaParamCollectionTemp daParamCollectionTemp);

    /**
     * ä¿®æ”¹è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return ç»“æžœ
     */
    public int updateDaParamCollectionTemp(DaParamCollectionTemp daParamCollectionTemp);

    /**
     * åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param id è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表主键
     * @return ç»“æžœ
     */
    public int deleteDaParamCollectionTempById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteDaParamCollectionTempByIds(Long[] ids);
}

 jcdm-main/src/main/java/com/jcdm/main/da/paramCollectionTemp/service/IDaParamCollectionTempService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.jcdm.main.da.paramCollectionTemp.service;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.IService;
import com.jcdm.main.da.paramCollectionTemp.domain.DaParamCollectionTemp;

/**
 * è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表Service接口
 * 
 * @author Yi
 * @date 2024-06-13
 */
public interface IDaParamCollectionTempService extends IService<DaParamCollectionTemp>
{
    /**
     * æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param id è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表主键
     * @return è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     */
    public DaParamCollectionTemp selectDaParamCollectionTempById(Long id);

    /**
     * æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表列表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表集合
     */
    public List<DaParamCollectionTemp> selectDaParamCollectionTempList(DaParamCollectionTemp daParamCollectionTemp);

    /**
     * æ–°å¢žè®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return ç»“æžœ
     */
    public int insertDaParamCollectionTemp(DaParamCollectionTemp daParamCollectionTemp);

    /**
     * ä¿®æ”¹è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return ç»“æžœ
     */
    public int updateDaParamCollectionTemp(DaParamCollectionTemp daParamCollectionTemp);

    /**
     * æ‰¹é‡åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„设备产品过程参数采集临时表主键集合
     * @return ç»“æžœ
     */
    public int deleteDaParamCollectionTempByIds(Long[] ids);

    /**
     * åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表信息
     * 
     * @param id è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表主键
     * @return ç»“æžœ
     */
    public int deleteDaParamCollectionTempById(Long id);
}

 jcdm-main/src/main/java/com/jcdm/main/da/paramCollectionTemp/service/impl/DaParamCollectionTempServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,101 @@
package com.jcdm.main.da.paramCollectionTemp.service.impl;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.jcdm.common.utils.DateUtils;
import com.jcdm.main.da.paramCollection.domain.DaParamCollection;
import com.jcdm.main.da.paramCollection.mapper.DaParamCollectionMapper;
import com.jcdm.main.da.paramCollection.service.IDaParamCollectionService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.jcdm.main.da.paramCollectionTemp.mapper.DaParamCollectionTempMapper;
import com.jcdm.main.da.paramCollectionTemp.domain.DaParamCollectionTemp;
import com.jcdm.main.da.paramCollectionTemp.service.IDaParamCollectionTempService;

/**
 * è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表Service业务层处理
 * 
 * @author Yi
 * @date 2024-06-13
 */
@Service
public class DaParamCollectionTempServiceImpl extends ServiceImpl<DaParamCollectionTempMapper, DaParamCollectionTemp> implements IDaParamCollectionTempService
{
    @Autowired
    private DaParamCollectionTempMapper daParamCollectionTempMapper;

    /**
     * æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param id è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表主键
     * @return è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     */
    @Override
    public DaParamCollectionTemp selectDaParamCollectionTempById(Long id)
    {
        return daParamCollectionTempMapper.selectDaParamCollectionTempById(id);
    }

    /**
     * æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表列表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     */
    @Override
    public List<DaParamCollectionTemp> selectDaParamCollectionTempList(DaParamCollectionTemp daParamCollectionTemp)
    {
        return daParamCollectionTempMapper.selectDaParamCollectionTempList(daParamCollectionTemp);
    }

    /**
     * æ–°å¢žè®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return ç»“æžœ
     */
    @Override
    public int insertDaParamCollectionTemp(DaParamCollectionTemp daParamCollectionTemp)
    {
        daParamCollectionTemp.setCreateTime(DateUtils.getNowDate());
        return daParamCollectionTempMapper.insertDaParamCollectionTemp(daParamCollectionTemp);
    }

    /**
     * ä¿®æ”¹è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param daParamCollectionTemp è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * @return ç»“æžœ
     */
    @Override
    public int updateDaParamCollectionTemp(DaParamCollectionTemp daParamCollectionTemp)
    {
        daParamCollectionTemp.setUpdateTime(DateUtils.getNowDate());
        return daParamCollectionTempMapper.updateDaParamCollectionTemp(daParamCollectionTemp);
    }

    /**
     * æ‰¹é‡åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„设备产品过程参数采集临时表主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteDaParamCollectionTempByIds(Long[] ids)
    {
        return daParamCollectionTempMapper.deleteDaParamCollectionTempByIds(ids);
    }

    /**
     * åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表信息
     * 
     * @param id è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteDaParamCollectionTempById(Long id)
    {
        return daParamCollectionTempMapper.deleteDaParamCollectionTempById(id);
    }
}

 jcdm-main/src/main/java/com/jcdm/main/plcserver/sub/OPCUaSubscription.java

@@ -527,13 +527,22 @@
            try {
                value = Float.parseFloat(part); // å°è¯•å°†å­—符串转换为浮点数
                String replacement;
                if (value == 1f) {
                if(i<2){
                    replacement = part;
                }else{
                    if (value == 1f) {
                        replacement = "OK";
                    } else{
                        replacement = "NG";
                    }
                }
            /*    if (value == 1f) {
                    replacement = "OK";
                } else if (value == 2f) {
                    replacement = "NG";
                } else {
                    replacement = part; // å¦‚果不是1或2，则保持不变
                }
                }*/
                sb.append(replacement);
                if (i < parts.length - 1) {
                    sb.append(','); // æ·»åŠ é€—号（除了最后一个元素）
@@ -604,6 +613,8 @@
            }
            daPassingStationCollectionService.saveBeachDaPassingStationCollection(passingStationCollections);
//            miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(21).build());
            logger.info("工位{}回复21",device);

            return "21";
        }else {
//            miloService.writeToOpcShort(ReadWriteEntity.builder().identifier(RecordDataDoneAddress).value(22).build());

 jcdm-main/src/main/resources/mapper/da/paramCollectionTemp/DaParamCollectionTempMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,179 @@
<?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.da.paramCollectionTemp.mapper.DaParamCollectionTempMapper">
    
    <resultMap type="DaParamCollectionTemp" id="DaParamCollectionTempResult">
        <result property="id"    column="id"    />
        <result property="workOrderNo"    column="work_order_no"    />
        <result property="sfcCode"    column="sfc_code"    />
        <result property="productCode"    column="product_code"    />
        <result property="productionLine"    column="production_line"    />
        <result property="locationCode"    column="location_code"    />
        <result property="equipmentNo"    column="equipment_no"    />
        <result property="paramCode"    column="param_code"    />
        <result property="paramValue"    column="param_value"    />
        <result property="paramUpper"    column="param_upper"    />
        <result property="paramLower"    column="param_lower"    />
        <result property="paramStandard"    column="param_standard"    />
        <result property="collectionTime"    column="collection_time"    />
        <result property="moduleCode"    column="module_code"    />
        <result property="spareField2"    column="spare_field2"    />
        <result property="createUser"    column="create_user"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateUser"    column="update_user"    />
        <result property="updateTime"    column="update_time"    />
        <result property="state"    column="state"    />
        <result property="paramName"    column="param_name"    />
        <result property="unit"    column="unit"    />
        <result property="type"    column="type"    />
        <result property="parameterSetCode"    column="parameter_set_code"    />
        <result property="parameterSetName"    column="parameter_set_name"    />
        <result property="processesCode"    column="processes_code"    />
        <result property="processesName"    column="processes_name"    />
    </resultMap>

    <sql id="selectDaParamCollectionTempVo">
        select id, work_order_no, sfc_code, product_code, production_line, location_code, equipment_no, param_code, param_value, param_upper, param_lower, param_standard, collection_time, module_code, spare_field2, create_user, create_time, update_user, update_time, state, param_name, unit, type, parameter_set_code, parameter_set_name, processes_code, processes_name from da_param_collection_temp
    </sql>

    <select id="selectDaParamCollectionTempList" parameterType="DaParamCollectionTemp" resultMap="DaParamCollectionTempResult">
        <include refid="selectDaParamCollectionTempVo"/>
        <where>  
            <if test="workOrderNo != null  and workOrderNo != ''"> and work_order_no = #{workOrderNo}</if>
            <if test="sfcCode != null  and sfcCode != ''"> and sfc_code = #{sfcCode}</if>
            <if test="productCode != null  and productCode != ''"> and product_code = #{productCode}</if>
            <if test="productionLine != null  and productionLine != ''"> and production_line = #{productionLine}</if>
            <if test="locationCode != null  and locationCode != ''"> and location_code = #{locationCode}</if>
            <if test="equipmentNo != null  and equipmentNo != ''"> and equipment_no = #{equipmentNo}</if>
            <if test="paramCode != null  and paramCode != ''"> and param_code = #{paramCode}</if>
            <if test="paramValue != null  and paramValue != ''"> and param_value = #{paramValue}</if>
            <if test="paramUpper != null  and paramUpper != ''"> and param_upper = #{paramUpper}</if>
            <if test="paramLower != null  and paramLower != ''"> and param_lower = #{paramLower}</if>
            <if test="paramStandard != null  and paramStandard != ''"> and param_standard = #{paramStandard}</if>
            <if test="collectionTime != null  and collectionTime != ''"> and collection_time = #{collectionTime}</if>
            <if test="moduleCode != null  and moduleCode != ''"> and module_code = #{moduleCode}</if>
            <if test="spareField2 != null  and spareField2 != ''"> and spare_field2 = #{spareField2}</if>
            <if test="createUser != null  and createUser != ''"> and create_user = #{createUser}</if>
            <if test="updateUser != null  and updateUser != ''"> and update_user = #{updateUser}</if>
            <if test="state != null  and state != ''"> and state = #{state}</if>
            <if test="paramName != null  and paramName != ''"> and param_name like concat('%', #{paramName}, '%')</if>
            <if test="unit != null  and unit != ''"> and unit = #{unit}</if>
            <if test="type != null  and type != ''"> and type = #{type}</if>
            <if test="parameterSetCode != null  and parameterSetCode != ''"> and parameter_set_code = #{parameterSetCode}</if>
            <if test="parameterSetName != null  and parameterSetName != ''"> and parameter_set_name like concat('%', #{parameterSetName}, '%')</if>
            <if test="processesCode != null  and processesCode != ''"> and processes_code = #{processesCode}</if>
            <if test="processesName != null  and processesName != ''"> and processes_name like concat('%', #{processesName}, '%')</if>
        </where>
    </select>
    
    <select id="selectDaParamCollectionTempById" parameterType="Long" resultMap="DaParamCollectionTempResult">
        <include refid="selectDaParamCollectionTempVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertDaParamCollectionTemp" parameterType="DaParamCollectionTemp" useGeneratedKeys="true" keyProperty="id">
        insert into da_param_collection_temp
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="workOrderNo != null">work_order_no,</if>
            <if test="sfcCode != null">sfc_code,</if>
            <if test="productCode != null">product_code,</if>
            <if test="productionLine != null">production_line,</if>
            <if test="locationCode != null">location_code,</if>
            <if test="equipmentNo != null">equipment_no,</if>
            <if test="paramCode != null">param_code,</if>
            <if test="paramValue != null">param_value,</if>
            <if test="paramUpper != null">param_upper,</if>
            <if test="paramLower != null">param_lower,</if>
            <if test="paramStandard != null">param_standard,</if>
            <if test="collectionTime != null">collection_time,</if>
            <if test="moduleCode != null">module_code,</if>
            <if test="spareField2 != null">spare_field2,</if>
            <if test="createUser != null">create_user,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateUser != null">update_user,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="state != null">state,</if>
            <if test="paramName != null">param_name,</if>
            <if test="unit != null">unit,</if>
            <if test="type != null">type,</if>
            <if test="parameterSetCode != null">parameter_set_code,</if>
            <if test="parameterSetName != null">parameter_set_name,</if>
            <if test="processesCode != null">processes_code,</if>
            <if test="processesName != null">processes_name,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="workOrderNo != null">#{workOrderNo},</if>
            <if test="sfcCode != null">#{sfcCode},</if>
            <if test="productCode != null">#{productCode},</if>
            <if test="productionLine != null">#{productionLine},</if>
            <if test="locationCode != null">#{locationCode},</if>
            <if test="equipmentNo != null">#{equipmentNo},</if>
            <if test="paramCode != null">#{paramCode},</if>
            <if test="paramValue != null">#{paramValue},</if>
            <if test="paramUpper != null">#{paramUpper},</if>
            <if test="paramLower != null">#{paramLower},</if>
            <if test="paramStandard != null">#{paramStandard},</if>
            <if test="collectionTime != null">#{collectionTime},</if>
            <if test="moduleCode != null">#{moduleCode},</if>
            <if test="spareField2 != null">#{spareField2},</if>
            <if test="createUser != null">#{createUser},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateUser != null">#{updateUser},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="state != null">#{state},</if>
            <if test="paramName != null">#{paramName},</if>
            <if test="unit != null">#{unit},</if>
            <if test="type != null">#{type},</if>
            <if test="parameterSetCode != null">#{parameterSetCode},</if>
            <if test="parameterSetName != null">#{parameterSetName},</if>
            <if test="processesCode != null">#{processesCode},</if>
            <if test="processesName != null">#{processesName},</if>
         </trim>
    </insert>

    <update id="updateDaParamCollectionTemp" parameterType="DaParamCollectionTemp">
        update da_param_collection_temp
        <trim prefix="SET" suffixOverrides=",">
            <if test="workOrderNo != null">work_order_no = #{workOrderNo},</if>
            <if test="sfcCode != null">sfc_code = #{sfcCode},</if>
            <if test="productCode != null">product_code = #{productCode},</if>
            <if test="productionLine != null">production_line = #{productionLine},</if>
            <if test="locationCode != null">location_code = #{locationCode},</if>
            <if test="equipmentNo != null">equipment_no = #{equipmentNo},</if>
            <if test="paramCode != null">param_code = #{paramCode},</if>
            <if test="paramValue != null">param_value = #{paramValue},</if>
            <if test="paramUpper != null">param_upper = #{paramUpper},</if>
            <if test="paramLower != null">param_lower = #{paramLower},</if>
            <if test="paramStandard != null">param_standard = #{paramStandard},</if>
            <if test="collectionTime != null">collection_time = #{collectionTime},</if>
            <if test="moduleCode != null">module_code = #{moduleCode},</if>
            <if test="spareField2 != null">spare_field2 = #{spareField2},</if>
            <if test="createUser != null">create_user = #{createUser},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateUser != null">update_user = #{updateUser},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="state != null">state = #{state},</if>
            <if test="paramName != null">param_name = #{paramName},</if>
            <if test="unit != null">unit = #{unit},</if>
            <if test="type != null">type = #{type},</if>
            <if test="parameterSetCode != null">parameter_set_code = #{parameterSetCode},</if>
            <if test="parameterSetName != null">parameter_set_name = #{parameterSetName},</if>
            <if test="processesCode != null">processes_code = #{processesCode},</if>
            <if test="processesName != null">processes_name = #{processesName},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteDaParamCollectionTempById" parameterType="Long">
        delete from da_param_collection_temp where id = #{id}
    </delete>

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

 jcdm-ui/src/api/main/da/paramCollectionTemp/paramCollectionTemp.js

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

// æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表列表
export function listParamCollectionTemp(query) {
  return request({
    url: '/da/paramCollectionTemp/list',
    method: 'get',
    params: query
  })
}

// æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表详细
export function getParamCollectionTemp(id) {
  return request({
    url: '/da/paramCollectionTemp/' + id,
    method: 'get'
  })
}

// æ–°å¢žè®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
export function addParamCollectionTemp(data) {
  return request({
    url: '/da/paramCollectionTemp',
    method: 'post',
    data: data
  })
}

// ä¿®æ”¹è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
export function updateParamCollectionTemp(data) {
  return request({
    url: '/da/paramCollectionTemp',
    method: 'put',
    data: data
  })
}

// åˆ é™¤è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表
export function delParamCollectionTemp(id) {
  return request({
    url: '/da/paramCollectionTemp/' + id,
    method: 'delete'
  })
}

 jcdm-ui/src/views/main/da/paramCollectionTemp/index.vue

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,587 @@
<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="workOrderNo">
            <el-input
              v-model="queryParams.workOrderNo"
              placeholder="请输入工单编号"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="总成序列号" prop="sfcCode">
            <el-input
              v-model="queryParams.sfcCode"
              placeholder="请输入总成序列号"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="产品编号" prop="productCode">
            <el-input
              v-model="queryParams.productCode"
              placeholder="请输入产品编号"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="产线编号" prop="productionLine">
            <el-input
              v-model="queryParams.productionLine"
              placeholder="请输入产线编号"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="工位编号" prop="locationCode">
            <el-input
              v-model="queryParams.locationCode"
              placeholder="请输入工位编号"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="设备编号" prop="equipmentNo">
            <el-input
              v-model="queryParams.equipmentNo"
              placeholder="请输入设备编号"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="参数编码" prop="paramCode">
            <el-input
              v-model="queryParams.paramCode"
              placeholder="请输入参数编码"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="参数值" prop="paramValue">
            <el-input
              v-model="queryParams.paramValue"
              placeholder="请输入参数值"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="参数上限" prop="paramUpper">
            <el-input
              v-model="queryParams.paramUpper"
              placeholder="请输入参数上限"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="参数下限" prop="paramLower">
            <el-input
              v-model="queryParams.paramLower"
              placeholder="请输入参数下限"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="标准值" prop="paramStandard">
            <el-input
              v-model="queryParams.paramStandard"
              placeholder="请输入标准值"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="预留字段1" prop="moduleCode">
            <el-input
              v-model="queryParams.moduleCode"
              placeholder="请输入预留字段1"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="预留字段2" prop="spareField2">
            <el-input
              v-model="queryParams.spareField2"
              placeholder="请输入预留字段2"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="创建用户" prop="createUser">
            <el-input
              v-model="queryParams.createUser"
              placeholder="请输入创建用户"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="更改用户" prop="updateUser">
            <el-input
              v-model="queryParams.updateUser"
              placeholder="请输入更改用户"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="状态" prop="state">
            <el-input
              v-model="queryParams.state"
              placeholder="请输入状态"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="参数名称" prop="paramName">
            <el-input
              v-model="queryParams.paramName"
              placeholder="请输入参数名称"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="单位" prop="unit">
            <el-input
              v-model="queryParams.unit"
              placeholder="请输入单位"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="参数集编码" prop="parameterSetCode">
            <el-input
              v-model="queryParams.parameterSetCode"
              placeholder="请输入参数集编码"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="参数集名称" prop="parameterSetName">
            <el-input
              v-model="queryParams.parameterSetName"
              placeholder="请输入参数集名称"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="工序编号" prop="processesCode">
            <el-input
              v-model="queryParams.processesCode"
              placeholder="请输入工序编号"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item label="工序名称" prop="processesName">
            <el-input
              v-model="queryParams.processesName"
              placeholder="请输入工序名称"
              clearable
              @keyup.enter.native="handleQuery"
            />
          </el-form-item>
          <el-form-item style="float: right">
            <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="['da:paramCollectionTemp: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="['da:paramCollectionTemp: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="['da:paramCollectionTemp: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="['da:paramCollectionTemp:export']"
            >导出</el-button>
          </el-col>
          <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
        </el-row>

        <el-table border v-loading="loading" :data="paramCollectionTempList" @selection-change="handleSelectionChange">
          <el-table-column type="selection" width="55" align="center" />
          <el-table-column label="主键id" align="center" prop="id" />
          <el-table-column label="工单编号" align="center" prop="workOrderNo">
          </el-table-column>
          <el-table-column label="总成序列号" align="center" prop="sfcCode">
          </el-table-column>
          <el-table-column label="产品编号" align="center" prop="productCode">
          </el-table-column>
          <el-table-column label="产线编号" align="center" prop="productionLine">
          </el-table-column>
          <el-table-column label="工位编号" align="center" prop="locationCode">
          </el-table-column>
          <el-table-column label="设备编号" align="center" prop="equipmentNo">
          </el-table-column>
          <el-table-column label="参数编码" align="center" prop="paramCode">
          </el-table-column>
          <el-table-column label="参数值" align="center" prop="paramValue">
          </el-table-column>
          <el-table-column label="参数上限" align="center" prop="paramUpper">
          </el-table-column>
          <el-table-column label="参数下限" align="center" prop="paramLower">
          </el-table-column>
          <el-table-column label="标准值" align="center" prop="paramStandard">
          </el-table-column>
          <el-table-column label="采集时间" align="center" prop="collectionTime">
          </el-table-column>
          <el-table-column label="预留字段1" align="center" prop="moduleCode">
          </el-table-column>
          <el-table-column label="预留字段2" align="center" prop="spareField2">
          </el-table-column>
          <el-table-column label="创建用户" align="center" prop="createUser">
          </el-table-column>
          <el-table-column label="更改用户" align="center" prop="updateUser">
          </el-table-column>
          <el-table-column label="状态" align="center" prop="state">
          </el-table-column>
          <el-table-column label="参数名称" align="center" prop="paramName">
          </el-table-column>
          <el-table-column label="单位" align="center" prop="unit">
          </el-table-column>
          <el-table-column label="类型" align="center" prop="type">
          </el-table-column>
          <el-table-column label="参数集编码" align="center" prop="parameterSetCode">
          </el-table-column>
          <el-table-column label="参数集名称" align="center" prop="parameterSetName">
          </el-table-column>
          <el-table-column label="工序编号" align="center" prop="processesCode">
          </el-table-column>
          <el-table-column label="工序名称" align="center" prop="processesName">
          </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"
                type="success"
                plain
                style="width: 72px"
                icon="el-icon-edit"
                @click="handleUpdate(scope.row)"
                v-hasPermi="['da:paramCollectionTemp:edit']"
              >修改</el-button>
              <el-button
                size="mini"
                type="danger"
                plain
                style="width: 72px"
                icon="el-icon-delete"
                @click="handleDelete(scope.row)"
                v-hasPermi="['da:paramCollectionTemp: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 v-dialogpop-up :title="title" :visible.sync="open" width="500px" append-to-body>
      <span slot="title">
        <i class="el-icon-s-order"></i>
        {{titleName}}
      </span>
      <el-form ref="form" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="工单编号" prop="workOrderNo">
          <el-input v-model="form.workOrderNo" placeholder="请输入工单编号" />
        </el-form-item>
        <el-form-item label="总成序列号" prop="sfcCode">
          <el-input v-model="form.sfcCode" placeholder="请输入总成序列号" />
        </el-form-item>
        <el-form-item label="产品编号" prop="productCode">
          <el-input v-model="form.productCode" placeholder="请输入产品编号" />
        </el-form-item>
        <el-form-item label="产线编号" prop="productionLine">
          <el-input v-model="form.productionLine" placeholder="请输入产线编号" />
        </el-form-item>
        <el-form-item label="工位编号" prop="locationCode">
          <el-input v-model="form.locationCode" placeholder="请输入工位编号" />
        </el-form-item>
        <el-form-item label="设备编号" prop="equipmentNo">
          <el-input v-model="form.equipmentNo" placeholder="请输入设备编号" />
        </el-form-item>
        <el-form-item label="参数编码" prop="paramCode">
          <el-input v-model="form.paramCode" placeholder="请输入参数编码" />
        </el-form-item>
        <el-form-item label="参数值" prop="paramValue">
          <el-input v-model="form.paramValue" placeholder="请输入参数值" />
        </el-form-item>
        <el-form-item label="参数上限" prop="paramUpper">
          <el-input v-model="form.paramUpper" placeholder="请输入参数上限" />
        </el-form-item>
        <el-form-item label="参数下限" prop="paramLower">
          <el-input v-model="form.paramLower" placeholder="请输入参数下限" />
        </el-form-item>
        <el-form-item label="标准值" prop="paramStandard">
          <el-input v-model="form.paramStandard" placeholder="请输入标准值" />
        </el-form-item>
        <el-form-item label="预留字段1" prop="moduleCode">
          <el-input v-model="form.moduleCode" placeholder="请输入预留字段1" />
        </el-form-item>
        <el-form-item label="预留字段2" prop="spareField2">
          <el-input v-model="form.spareField2" placeholder="请输入预留字段2" />
        </el-form-item>
        <el-form-item label="创建用户" prop="createUser">
          <el-input v-model="form.createUser" placeholder="请输入创建用户" />
        </el-form-item>
        <el-form-item label="更改用户" prop="updateUser">
          <el-input v-model="form.updateUser" placeholder="请输入更改用户" />
        </el-form-item>
        <el-form-item label="状态" prop="state">
          <el-input v-model="form.state" placeholder="请输入状态" />
        </el-form-item>
        <el-form-item label="参数名称" prop="paramName">
          <el-input v-model="form.paramName" placeholder="请输入参数名称" />
        </el-form-item>
        <el-form-item label="单位" prop="unit">
          <el-input v-model="form.unit" placeholder="请输入单位" />
        </el-form-item>
        <el-form-item label="参数集编码" prop="parameterSetCode">
          <el-input v-model="form.parameterSetCode" placeholder="请输入参数集编码" />
        </el-form-item>
        <el-form-item label="参数集名称" prop="parameterSetName">
          <el-input v-model="form.parameterSetName" placeholder="请输入参数集名称" />
        </el-form-item>
        <el-form-item label="工序编号" prop="processesCode">
          <el-input v-model="form.processesCode" placeholder="请输入工序编号" />
        </el-form-item>
        <el-form-item label="工序名称" prop="processesName">
          <el-input v-model="form.processesName" 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 { listParamCollectionTemp, getParamCollectionTemp, delParamCollectionTemp, addParamCollectionTemp, updateParamCollectionTemp } from "@/api/main/da/paramCollectionTemp/paramCollectionTemp";

export default {
  name: "ParamCollectionTemp",
  data() {
    return {
      // é®ç½©å±‚
      loading: true,
      titleName: "",
      // é€‰ä¸­æ•°ç»„
      ids: [],
      // éžå•ä¸ªç¦ç”¨
      single: true,
      // éžå¤šä¸ªç¦ç”¨
      multiple: true,
      // æ˜¾ç¤ºæœç´¢æ¡ä»¶
      showSearch: true,
      // æ€»æ¡æ•°
      total: 0,
      // è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表表格数据
      paramCollectionTempList: [],
      // å¼¹å‡ºå±‚标题
      title: "",
      // æ˜¯å¦æ˜¾ç¤ºå¼¹å‡ºå±‚
      open: false,
      // æŸ¥è¯¢å‚æ•°
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        workOrderNo: null,
        sfcCode: null,
        productCode: null,
        productionLine: null,
        locationCode: null,
        equipmentNo: null,
        paramCode: null,
        paramValue: null,
        paramUpper: null,
        paramLower: null,
        paramStandard: null,
        collectionTime: null,
        moduleCode: null,
        spareField2: null,
        createUser: null,
        updateUser: null,
        state: null,
        paramName: null,
        unit: null,
        type: null,
        parameterSetCode: null,
        parameterSetName: null,
        processesCode: null,
        processesName: null
      },
      // è¡¨å•å‚æ•°
      form: {},
      // è¡¨å•æ ¡éªŒ
      rules: {
        id: [
          { required: true, message: "主键id不能为空", trigger: "blur" }
        ],
      }
    };
  },
  created() {
    this.getList();
  },
  methods: {
    /** æŸ¥è¯¢è®¾å¤‡äº§å“è¿‡ç¨‹å‚数采集临时表列表 */
    getList() {
      this.loading = true;
      listParamCollectionTemp(this.queryParams).then(response => {
        this.paramCollectionTempList = response.rows;
        this.total = response.total;
        this.loading = false;
      });
    },
    // å–消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // è¡¨å•é‡ç½®
    reset() {
      this.form = {
        id: null,
        workOrderNo: null,
        sfcCode: null,
        productCode: null,
        productionLine: null,
        locationCode: null,
        equipmentNo: null,
        paramCode: null,
        paramValue: null,
        paramUpper: null,
        paramLower: null,
        paramStandard: null,
        collectionTime: null,
        moduleCode: null,
        spareField2: null,
        createUser: null,
        createTime: null,
        updateUser: null,
        updateTime: null,
        state: null,
        paramName: null,
        unit: null,
        type: null,
        parameterSetCode: null,
        parameterSetName: null,
        processesCode: null,
        processesName: 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.titleName = "添加设备产品过程参数采集临时表";
    },
    /** ä¿®æ”¹æŒ‰é’®æ“ä½œ */
    handleUpdate(row) {
      this.reset();
      const id = row.id || this.ids
      getParamCollectionTemp(id).then(response => {
        this.form = response.data;
        this.open = true;
        this.titleName = "修改设备产品过程参数采集临时表";
      });
    },
    /** æäº¤æŒ‰é’® */
    submitForm() {
      this.$refs["form"].validate(valid => {
        if (valid) {
          if (this.form.id != null) {
            updateParamCollectionTemp(this.form).then(response => {
              this.$modal.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addParamCollectionTemp(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 delParamCollectionTemp(ids);
      }).then(() => {
        this.getList();
        this.$modal.msgSuccess("删除成功");
      }).catch(() => {});
    },
    /** å¯¼å‡ºæŒ‰é’®æ“ä½œ */
    handleExport() {
      this.download('da/paramCollectionTemp/export', {
        ...this.queryParams
      }, `paramCollectionTemp_${new Date().getTime()}.xlsx`)
    }
  }
};
</script>