jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/controller/BsOrderSchedulingController.java
@@ -41,7 +41,7 @@ @GetMapping("/list") public TableDataInfo list(BsOrderScheduling bsOrderScheduling) { startPage(); // startPage(); List<BsOrderScheduling> list = bsOrderSchedulingService.selectBsOrderSchedulingList(bsOrderScheduling); return getDataTable(list); } @@ -50,7 +50,7 @@ @GetMapping("/list2") public TableDataInfo list2(BsOrderScheduling bsOrderScheduling) { // startPage(); // startPage(); List<BsOrderScheduling> list = bsOrderSchedulingService.selectBsOrderSchedulingList(bsOrderScheduling); return getDataTable(list); } jcdm-main/src/main/java/com/jcdm/main/da/opcuaconfig/client/ClientHandler.java
@@ -166,7 +166,7 @@ .findAny() .orElse(null); try { Class<?> clazz = Class.forName(daOpcuaConfig.getrModule()); Class<?> clazz = Class.forName("com.jcdm.main.da.opcuaconfig.cert.MethodName"); Method method = clazz.getMethod(daOpcuaConfig.getrFunction(), new Class[] { String.class, String.class }); method.invoke(clazz.newInstance(),new Object[] { new String(id.getIdentifier().toString()), new String(value.getValue().toString()) }); @@ -219,29 +219,6 @@ return statusCode.isGood(); } /** * æ¹æ³æè¿°: 读åå¤ä¸ªç¹ä½çå¼ * * @param keys ç¹ä½éå * @return {@link List<DataValue>} * @throws */ // public static List<DataValue> readValues2(Set<String> keys){ // List<NodeId> nodeIdList=new ArrayList<>(500); // keys.forEach(e->{ // NodeId nodeId = new NodeId(2, e); // nodeIdList.add(nodeId); // }); // try { // List<DataValue> dataValues=client.readValues(0.0, TimestampsToReturn.Both,nodeIdList).get(); // return dataValues; // } catch (InterruptedException | ExecutionException e) { // e.printStackTrace(); // } // return null; // } /** * æ¹æ³æè¿°: 读åå¤ä¸ªç¹ä½çå¼ jcdm-main/src/main/java/com/jcdm/main/da/opcuaconfig/controller/DaOpcuaConfigController.java
@@ -1,26 +1,32 @@ package com.jcdm.main.da.opcuaconfig.controller; import java.util.List; import javax.servlet.http.HttpServletResponse; import com.jcdm.main.da.opcuaconfig.domain.DaOpcuaConfig; import com.jcdm.main.da.opcuaconfig.service.IDaOpcuaConfigService; 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.core.page.TableDataInfo; import com.jcdm.common.enums.BusinessType; import com.jcdm.common.utils.poi.ExcelUtil; import com.jcdm.main.da.opcuaconfig.domain.DaOpcuaConfig; import com.jcdm.main.da.opcuaconfig.service.IDaOpcuaConfigService; import com.jcdm.main.da.paramCollection.service.IDaParamCollectionService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.util.List; import com.jcdm.common.core.page.TableDataInfo; /** * OPCUAåæ°è®¾ç½®Controller * 交äºä¿¡å·é ç½®Controller * * @author yyt * @date 2023-12-22 * @date 2024-01-22 */ @RestController @RequestMapping("/da/opcuaconfig") @@ -29,11 +35,8 @@ @Autowired private IDaOpcuaConfigService daOpcuaConfigService; @Autowired private IDaParamCollectionService daParamCollectionService; /** * æ¥è¯¢OPCUAåæ°è®¾ç½®å表 * æ¥è¯¢äº¤äºä¿¡å·é ç½®å表 */ @PreAuthorize("@ss.hasPermi('da:opcuaconfig:list')") @GetMapping("/list") @@ -44,28 +47,21 @@ return getDataTable(list); } @PreAuthorize("@ss.hasPermi('da:opcuaconfig:getconfig')") @GetMapping("/getconfig") public List<DaOpcuaConfig> getconfig(DaOpcuaConfig daOpcuaConfig) { return daOpcuaConfigService.selectDaOpcuaConfigList(daOpcuaConfig); } /** * 导åºOPCUAåæ°è®¾ç½®å表 * 导åºäº¤äºä¿¡å·é ç½®å表 */ @PreAuthorize("@ss.hasPermi('da:opcuaconfig:export')") @Log(title = "OPCUAåæ°è®¾ç½®", businessType = BusinessType.EXPORT) @Log(title = "交äºä¿¡å·é ç½®", businessType = BusinessType.EXPORT) @PostMapping("/export") public void export(HttpServletResponse response, DaOpcuaConfig daOpcuaConfig) { List<DaOpcuaConfig> list = daOpcuaConfigService.selectDaOpcuaConfigList(daOpcuaConfig); ExcelUtil<DaOpcuaConfig> util = new ExcelUtil<DaOpcuaConfig>(DaOpcuaConfig.class); util.exportExcel(response, list, "OPCUAåæ°è®¾ç½®æ°æ®"); util.exportExcel(response, list, "交äºä¿¡å·é ç½®æ°æ®"); } /** * è·åOPCUAåæ°è®¾ç½®è¯¦ç»ä¿¡æ¯ * è·å交äºä¿¡å·é 置详ç»ä¿¡æ¯ */ @PreAuthorize("@ss.hasPermi('da:opcuaconfig:query')") @GetMapping(value = "/{id}") @@ -75,10 +71,10 @@ } /** * æ°å¢OPCUAåæ°è®¾ç½® * æ°å¢äº¤äºä¿¡å·é ç½® */ @PreAuthorize("@ss.hasPermi('da:opcuaconfig:add')") @Log(title = "OPCUAåæ°è®¾ç½®", businessType = BusinessType.INSERT) @Log(title = "交äºä¿¡å·é ç½®", businessType = BusinessType.INSERT) @PostMapping public AjaxResult add(@RequestBody DaOpcuaConfig daOpcuaConfig) { @@ -86,10 +82,10 @@ } /** * ä¿®æ¹OPCUAåæ°è®¾ç½® * ä¿®æ¹äº¤äºä¿¡å·é ç½® */ @PreAuthorize("@ss.hasPermi('da:opcuaconfig:edit')") @Log(title = "OPCUAåæ°è®¾ç½®", businessType = BusinessType.UPDATE) @Log(title = "交äºä¿¡å·é ç½®", businessType = BusinessType.UPDATE) @PutMapping public AjaxResult edit(@RequestBody DaOpcuaConfig daOpcuaConfig) { @@ -97,10 +93,10 @@ } /** * å é¤OPCUAåæ°è®¾ç½® * å é¤äº¤äºä¿¡å·é ç½® */ @PreAuthorize("@ss.hasPermi('da:opcuaconfig:remove')") @Log(title = "OPCUAåæ°è®¾ç½®", businessType = BusinessType.DELETE) @Log(title = "交äºä¿¡å·é ç½®", businessType = BusinessType.DELETE) @DeleteMapping("/{ids}") public AjaxResult remove(@PathVariable Long[] ids) { jcdm-main/src/main/java/com/jcdm/main/da/opcuaconfig/domain/DaOpcuaConfig.java
@@ -1,15 +1,15 @@ package com.jcdm.main.da.opcuaconfig.domain; import com.jcdm.common.annotation.Excel; import com.jcdm.common.core.domain.BaseEntity; 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; /** * OPCUAåæ°è®¾ç½®å¯¹è±¡ da_opcua_config * 交äºä¿¡å·é 置对象 da_opcua_config * * @author yyt * @date 2023-12-22 * @date 2024-01-22 */ public class DaOpcuaConfig extends BaseEntity { @@ -18,41 +18,46 @@ /** ID */ private Long id; /** æå±æ¨¡å */ @Excel(name = "æå±æ¨¡å") private String module; /** $column.columnComment */ /** èç¹ */ @Excel(name = "èç¹") private String node; /** é¿åº¦ */ @Excel(name = "é¿åº¦") /** $column.columnComment */ private Long length; /** ç±»å */ @Excel(name = "ç±»å") /** æ°æ®ç±»å */ @Excel(name = "æ°æ®ç±»å") private String sysTypes; /** åè½è¯´æ */ @Excel(name = "åè½è¯´æ") /** $column.columnComment */ private String functionality; /** æ¯å¦è®¢é */ @Excel(name = "æ¯å¦è®¢é ") private Long subscribe; /** 订é ååºæ¨¡å */ @Excel(name = "订é ååºæ¨¡å") private String rModule; /** 订é ååºå½æ° */ @Excel(name = "订é ååºå½æ°") /** 订é ç±»å */ @Excel(name = "订é ç±»å") private String rFunction; /** å¤æ³¨ */ @Excel(name = "å¤æ³¨") private String remarks; /** å·¥åºç¼ç */ @Excel(name = "å·¥åºç¼ç ") private String process; /** å·¥åºå称 */ @Excel(name = "å·¥åºå称") private String processName; /** ç¶æ */ @Excel(name = "ç¶æ") private Long state; public void setId(Long id) { @@ -63,15 +68,7 @@ { return id; } public void setModule(String module) { this.module = module; } public String getModule() { return module; } public void setNode(String node) { this.node = node; @@ -81,33 +78,12 @@ { return node; } public void setLength(Long length) { this.length = length; } public Long getLength() { return length; } public void setSysTypes(String sysTypes) { this.sysTypes = sysTypes; } public String getSysTypes() { return sysTypes; } public void setFunctionality(String functionality) { this.functionality = functionality; } public String getFunctionality() { return functionality; } public void setSubscribe(Long subscribe) { this.subscribe = subscribe; @@ -116,19 +92,6 @@ public Long getSubscribe() { return subscribe; } public void setrModule(String rModule) { this.rModule = rModule; } public String getrModule() { return rModule; } public void setrFunction(String rFunction) { this.rFunction = rFunction; } public String getrFunction() @@ -144,20 +107,46 @@ { return remarks; } public void setProcess(String process) { this.process = process; } public String getProcess() { return process; } public void setProcessName(String processName) { this.processName = processName; } public String getProcessName() { return processName; } public void setState(Long state) { this.state = state; } public Long getState() { return state; } @Override public String toString() { return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) .append("id", getId()) .append("module", getModule()) .append("node", getNode()) .append("length", getLength()) .append("sysTypes", getSysTypes()) .append("functionality", getFunctionality()) .append("subscribe", getSubscribe()) .append("rModule", getrModule()) .append("rFunction", getrFunction()) .append("remarks", getRemarks()) .append("process", getProcess()) .append("processName", getProcessName()) .append("state", getState()) .toString(); } } jcdm-main/src/main/java/com/jcdm/main/da/opcuaconfig/domain/OpcuaConf.java
ÎļþÒÑɾ³ý jcdm-main/src/main/java/com/jcdm/main/da/opcuaconfig/mapper/DaOpcuaConfigMapper.java
@@ -5,55 +5,55 @@ import java.util.List; /** * OPCUAåæ°è®¾ç½®Mapperæ¥å£ * 交äºä¿¡å·é ç½®Mapperæ¥å£ * * @author yyt * @date 2023-12-22 * @date 2024-01-22 */ public interface DaOpcuaConfigMapper { /** * æ¥è¯¢OPCUAåæ°è®¾ç½® * æ¥è¯¢äº¤äºä¿¡å·é ç½® * * @param id OPCUAåæ°è®¾ç½®ä¸»é® * @return OPCUAåæ°è®¾ç½® * @param id 交äºä¿¡å·é ç½®ä¸»é® * @return 交äºä¿¡å·é ç½® */ public DaOpcuaConfig selectDaOpcuaConfigById(Long id); /** * æ¥è¯¢OPCUAåæ°è®¾ç½®å表 * æ¥è¯¢äº¤äºä¿¡å·é ç½®å表 * * @param daOpcuaConfig OPCUAåæ°è®¾ç½®1 * @return OPCUAåæ°è®¾ç½®éå * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return 交äºä¿¡å·é ç½®éå */ public List<DaOpcuaConfig> selectDaOpcuaConfigList(DaOpcuaConfig daOpcuaConfig); /** * æ°å¢OPCUAåæ°è®¾ç½®99 * æ°å¢äº¤äºä¿¡å·é ç½® * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return ç»æ */ public int insertDaOpcuaConfig(DaOpcuaConfig daOpcuaConfig); /** * ä¿®æ¹OPCUAåæ°è®¾ç½® * ä¿®æ¹äº¤äºä¿¡å·é ç½® * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return ç»æ */ public int updateDaOpcuaConfig(DaOpcuaConfig daOpcuaConfig); /** * å é¤OPCUAåæ°è®¾ç½® * å é¤äº¤äºä¿¡å·é ç½® * * @param id OPCUAåæ°è®¾ç½®ä¸»é® * @param id 交äºä¿¡å·é ç½®ä¸»é® * @return ç»æ */ public int deleteDaOpcuaConfigById(Long id); /** * æ¹éå é¤OPCUAåæ°è®¾ç½® * æ¹éå é¤äº¤äºä¿¡å·é ç½® * * @param ids éè¦å é¤çæ°æ®ä¸»é®éå * @return ç»æ jcdm-main/src/main/java/com/jcdm/main/da/opcuaconfig/service/IDaOpcuaConfigService.java
@@ -5,57 +5,57 @@ import java.util.List; /** * OPCUAåæ°è®¾ç½®Serviceæ¥å£ * 交äºä¿¡å·é ç½®Serviceæ¥å£ * * @author yyt * @date 2023-12-22 * @date 2024-01-22 */ public interface IDaOpcuaConfigService { /** * æ¥è¯¢OPCUAåæ°è®¾ç½® * æ¥è¯¢äº¤äºä¿¡å·é ç½® * * @param id OPCUAåæ°è®¾ç½®ä¸»é® * @return OPCUAåæ°è®¾ç½® * @param id 交äºä¿¡å·é ç½®ä¸»é® * @return 交äºä¿¡å·é ç½® */ public DaOpcuaConfig selectDaOpcuaConfigById(Long id); /** * æ¥è¯¢OPCUAåæ°è®¾ç½®å表 * æ¥è¯¢äº¤äºä¿¡å·é ç½®å表 * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @return OPCUAåæ°è®¾ç½®éå * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return 交äºä¿¡å·é ç½®éå */ public List<DaOpcuaConfig> selectDaOpcuaConfigList(DaOpcuaConfig daOpcuaConfig); /** * æ°å¢OPCUAåæ°è®¾ç½® * æ°å¢äº¤äºä¿¡å·é ç½® * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return ç»æ */ public int insertDaOpcuaConfig(DaOpcuaConfig daOpcuaConfig); /** * ä¿®æ¹OPCUAåæ°è®¾ç½® * ä¿®æ¹äº¤äºä¿¡å·é ç½® * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return ç»æ */ public int updateDaOpcuaConfig(DaOpcuaConfig daOpcuaConfig); /** * æ¹éå é¤OPCUAåæ°è®¾ç½® * æ¹éå é¤äº¤äºä¿¡å·é ç½® * * @param ids éè¦å é¤çOPCUAåæ°è®¾ç½®ä¸»é®éå * @param ids éè¦å é¤ç交äºä¿¡å·é 置主é®éå * @return ç»æ */ public int deleteDaOpcuaConfigByIds(Long[] ids); /** * å é¤OPCUAåæ°è®¾ç½®ä¿¡æ¯ * å é¤äº¤äºä¿¡å·é ç½®ä¿¡æ¯ * * @param id OPCUAåæ°è®¾ç½®ä¸»é® * @param id 交äºä¿¡å·é ç½®ä¸»é® * @return ç»æ */ public int deleteDaOpcuaConfigById(Long id); jcdm-main/src/main/java/com/jcdm/main/da/opcuaconfig/service/impl/DaOpcuaConfigServiceImpl.java
@@ -1,18 +1,18 @@ package com.jcdm.main.da.opcuaconfig.service.impl; import java.util.List; import com.jcdm.main.da.opcuaconfig.domain.DaOpcuaConfig; import com.jcdm.main.da.opcuaconfig.mapper.DaOpcuaConfigMapper; import com.jcdm.main.da.opcuaconfig.service.IDaOpcuaConfigService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; /** * OPCUAåæ°è®¾ç½®Serviceä¸å¡å±å¤ç * 交äºä¿¡å·é ç½®Serviceä¸å¡å±å¤ç * * @author yyt * @date 2023-12-22 * @date 2024-01-22 */ @Service public class DaOpcuaConfigServiceImpl implements IDaOpcuaConfigService @@ -21,10 +21,10 @@ private DaOpcuaConfigMapper daOpcuaConfigMapper; /** * æ¥è¯¢OPCUAåæ°è®¾ç½® * æ¥è¯¢äº¤äºä¿¡å·é ç½® * * @param id OPCUAåæ°è®¾ç½®ä¸»é® * @return OPCUAåæ°è®¾ç½® * @param id 交äºä¿¡å·é ç½®ä¸»é® * @return 交äºä¿¡å·é ç½® */ @Override public DaOpcuaConfig selectDaOpcuaConfigById(Long id) @@ -33,10 +33,10 @@ } /** * æ¥è¯¢OPCUAåæ°è®¾ç½®å表 * æ¥è¯¢äº¤äºä¿¡å·é ç½®å表 * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @return OPCUAåæ°è®¾ç½® * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return 交äºä¿¡å·é ç½® */ @Override public List<DaOpcuaConfig> selectDaOpcuaConfigList(DaOpcuaConfig daOpcuaConfig) @@ -45,9 +45,9 @@ } /** * æ°å¢OPCUAåæ°è®¾ç½® * æ°å¢äº¤äºä¿¡å·é ç½® * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return ç»æ */ @Override @@ -57,9 +57,9 @@ } /** * ä¿®æ¹OPCUAåæ°è®¾ç½® * ä¿®æ¹äº¤äºä¿¡å·é ç½® * * @param daOpcuaConfig OPCUAåæ°è®¾ç½® * @param daOpcuaConfig 交äºä¿¡å·é ç½® * @return ç»æ */ @Override @@ -69,9 +69,9 @@ } /** * æ¹éå é¤OPCUAåæ°è®¾ç½® * æ¹éå é¤äº¤äºä¿¡å·é ç½® * * @param ids éè¦å é¤çOPCUAåæ°è®¾ç½®ä¸»é® * @param ids éè¦å é¤ç交äºä¿¡å·é ç½®ä¸»é® * @return ç»æ */ @Override @@ -81,9 +81,9 @@ } /** * å é¤OPCUAåæ°è®¾ç½®ä¿¡æ¯ * å é¤äº¤äºä¿¡å·é ç½®ä¿¡æ¯ * * @param id OPCUAåæ°è®¾ç½®ä¸»é® * @param id 交äºä¿¡å·é ç½®ä¸»é® * @return ç»æ */ @Override jcdm-main/src/main/resources/mapper/da/opcuaconfig/DaOpcuaConfigMapper.xml
@@ -6,32 +6,29 @@ <resultMap type="DaOpcuaConfig" id="DaOpcuaConfigResult"> <result property="id" column="id" /> <result property="module" column="module" /> <result property="node" column="node" /> <result property="length" column="length" /> <result property="sysTypes" column="sys_types" /> <result property="functionality" column="functionality" /> <result property="subscribe" column="subscribe" /> <result property="rModule" column="r_module" /> <result property="rFunction" column="r_function" /> <result property="remarks" column="remarks" /> <result property="process" column="process" /> <result property="processName" column="process_name" /> <result property="state" column="state" /> </resultMap> <sql id="selectDaOpcuaConfigVo"> select id, module, node, length, sys_types, functionality, subscribe, r_module, r_function, remarks from da_opcua_config select id, node,sys_types, subscribe, r_function, remarks, process, process_name, state from da_opcua_config </sql> <select id="selectDaOpcuaConfigList" parameterType="DaOpcuaConfig" resultMap="DaOpcuaConfigResult"> <include refid="selectDaOpcuaConfigVo"/> <where> <if test="module != null and module != ''"> and module like concat('%', #{module}, '%')</if> <if test="node != null and node != ''"> and node like concat('%', #{node}, '%')</if> <if test="length != null "> and length = #{length}</if> <if test="node != null and node != ''"> and node = #{node}</if> <if test="sysTypes != null and sysTypes != ''"> and sys_types = #{sysTypes}</if> <if test="functionality != null and functionality != ''"> and functionality like concat('%', #{functionality}, '%')</if> <if test="subscribe != null "> and subscribe = #{subscribe}</if> <if test="rModule != null and rModule != ''"> and r_module like concat('%', #{rModule}, '%')</if> <if test="rFunction != null and rFunction != ''"> and r_function like concat('%', #{rFunction}, '%')</if> <if test="rFunction != null and rFunction != ''"> and r_function = #{rFunction}</if> <if test="process != null and process != ''"> and process = #{process}</if> <if test="processName != null and processName != ''"> and process_name like concat('%', #{processName}, '%')</if> <if test="state != null "> and state = #{state}</if> </where> </select> @@ -40,46 +37,41 @@ where id = #{id} </select> <insert id="insertDaOpcuaConfig" parameterType="DaOpcuaConfig"> <insert id="insertDaOpcuaConfig" parameterType="DaOpcuaConfig" useGeneratedKeys="true" keyProperty="id"> insert into da_opcua_config <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id != null">id,</if> <if test="module != null">module,</if> <if test="node != null">node,</if> <if test="length != null">length,</if> <if test="sysTypes != null">sys_types,</if> <if test="functionality != null">functionality,</if> <if test="node != null and node != ''">node,</if> <if test="sysTypes != null and sysTypes != ''">sys_types,</if> <if test="subscribe != null">subscribe,</if> <if test="rModule != null">r_module,</if> <if test="rFunction != null">r_function,</if> <if test="rFunction != null and rFunction != ''">r_function,</if> <if test="remarks != null">remarks,</if> <if test="process != null">process,</if> <if test="processName != null">process_name,</if> <if test="state != null">state,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="id != null">#{id},</if> <if test="module != null">#{module},</if> <if test="node != null">#{node},</if> <if test="length != null">#{length},</if> <if test="sysTypes != null">#{sysTypes},</if> <if test="functionality != null">#{functionality},</if> <if test="node != null and node != ''">#{node},</if> <if test="sysTypes != null and sysTypes != ''">#{sysTypes},</if> <if test="subscribe != null">#{subscribe},</if> <if test="rModule != null">#{rModule},</if> <if test="rFunction != null">#{rFunction},</if> <if test="rFunction != null and rFunction != ''">#{rFunction},</if> <if test="remarks != null">#{remarks},</if> <if test="process != null">#{process},</if> <if test="processName != null">#{processName},</if> <if test="state != null">#{state},</if> </trim> </insert> <update id="updateDaOpcuaConfig" parameterType="DaOpcuaConfig"> update da_opcua_config <trim prefix="SET" suffixOverrides=","> <if test="module != null">module = #{module},</if> <if test="node != null">node = #{node},</if> <if test="length != null">length = #{length},</if> <if test="sysTypes != null">sys_types = #{sysTypes},</if> <if test="functionality != null">functionality = #{functionality},</if> <if test="node != null and node != ''">node = #{node},</if> <if test="sysTypes != null and sysTypes != ''">sys_types = #{sysTypes},</if> <if test="subscribe != null">subscribe = #{subscribe},</if> <if test="rModule != null">r_module = #{rModule},</if> <if test="rFunction != null">r_function = #{rFunction},</if> <if test="rFunction != null and rFunction != ''">r_function = #{rFunction},</if> <if test="remarks != null">remarks = #{remarks},</if> <if test="process != null">process = #{process},</if> <if test="processName != null">process_name = #{processName},</if> <if test="state != null">state = #{state},</if> </trim> where id = #{id} </update> jcdm-ui/src/api/main/da/opcuaconfig/opcuaconfig.js
@@ -1,6 +1,6 @@ import request from '@/utils/request' // æ¥è¯¢OPCUAåæ°è®¾ç½®å表 // æ¥è¯¢äº¤äºä¿¡å·é ç½®å表 export function listOpcuaconfig(query) { return request({ url: '/da/opcuaconfig/list', @@ -9,7 +9,7 @@ }) } // æ¥è¯¢OPCUAåæ°è®¾ç½®è¯¦ç» // æ¥è¯¢äº¤äºä¿¡å·é ç½®è¯¦ç» export function getOpcuaconfig(id) { return request({ url: '/da/opcuaconfig/' + id, @@ -17,7 +17,7 @@ }) } // æ°å¢OPCUAåæ°è®¾ç½® // æ°å¢äº¤äºä¿¡å·é ç½® export function addOpcuaconfig(data) { return request({ url: '/da/opcuaconfig', @@ -26,7 +26,7 @@ }) } // ä¿®æ¹OPCUAåæ°è®¾ç½® // ä¿®æ¹äº¤äºä¿¡å·é ç½® export function updateOpcuaconfig(data) { return request({ url: '/da/opcuaconfig', @@ -35,7 +35,7 @@ }) } // å é¤OPCUAåæ°è®¾ç½® // å é¤äº¤äºä¿¡å·é ç½® export function delOpcuaconfig(id) { return request({ url: '/da/opcuaconfig/' + id, jcdm-ui/src/components/itemSelect/index.vue
@@ -220,4 +220,4 @@ } } }; </script> </script> jcdm-ui/src/views/main/cfkb/Instructions/index.vue
@@ -74,13 +74,12 @@ title="å·¥èºæ件" :visible.sync="dialogVisible" width="70%" lock-scroll="false" @close="closeMethod" > <div><el-image style="height: 1090px;width: 960px;margin-left: 33px" :src="mainProcessSrc"></el-image></div> <span slot="footer" class="dialog-footer"> <el-button type="primary" @click="dialogVisible = false">ç¡® å®</el-button> <el-button type="primary" @click="dialogVisible = false" style="margin-right: 80px">ç¡® å®</el-button> </span> </el-dialog> </div> jcdm-ui/src/views/main/da/opcuaconfig/index.vue
@@ -1,206 +1,173 @@ <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="module"> <el-input v-model="queryParams.module" placeholder="请è¾å ¥æå±æ¨¡å" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="èç¹" prop="node"> <el-input v-model="queryParams.node" placeholder="请è¾å ¥èç¹" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="é¿åº¦" prop="length"> <el-input v-model="queryParams.length" placeholder="请è¾å ¥é¿åº¦" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="ç±»å" prop="sysTypes"> <el-select v-model="queryParams.sysTypes" 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 style="float: right"> <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">æç´¢</el-button> <el-button type="warning" icon="el-icon-copy-document" size="mini" @click="advancedQuery">é«çº§æ¥è¯¢</el-button> <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">éç½®</el-button> </el-form-item> </el-form> <el-form :model="queryParams" ref="queryParams" size="small" :inline="true" v-show="advancedShowSearch" label-width="68px"> <el-form-item label="订é ååºæ¨¡å" prop="rModule"> <el-input v-model="queryParams.rModule" placeholder="请è¾å ¥è®¢é ååºæ¨¡å" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="订é ååºå½æ°" prop="rFunction"> <el-input v-model="queryParams.rFunction" placeholder="请è¾å ¥è®¢é ååºå½æ°" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="åè½è¯´æ" prop="functionality"> <el-input v-model="queryParams.functionality" placeholder="请è¾å ¥åè½è¯´æ" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="æ¯å¦è®¢é " prop="subscribe"> <el-select v-model="queryParams.subscribe" 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> <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px"> <el-form-item label="èç¹" prop="node"> <el-input v-model="queryParams.node" placeholder="请è¾å ¥èç¹" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="订é ç±»å" prop="rFunction"> <el-select v-model="queryParams.rFunction" placeholder="请éæ©è®¢é ç±»å" clearable> <el-option v-for="dict in dict.type.subscription_type" :key="dict.value" :label="dict.label" :value="dict.value" /> </el-select> </el-form-item> <el-form-item label="å·¥åºç¼ç " prop="process"> <el-select v-model="queryParams.process" 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="processName"> <el-input v-model="queryParams.processName" placeholder="请è¾å ¥å·¥åºå称" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="ç¶æ" prop="state"> <el-select v-model="queryParams.state" placeholder="请éæ©ç¶æ" clearable> <el-option v-for="dict in dict.type.sys_normal_disable" :key="dict.value" :label="dict.label" :value="dict.value" /> </el-select> </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:opcuaconfig: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:opcuaconfig: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:opcuaconfig: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:opcuaconfig:export']" >导åº</el-button> </el-col> <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> </el-row> <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="['main:opcuaconfig: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="['main:opcuaconfig: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="['main:opcuaconfig: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="['main:opcuaconfig:export']" >导åº</el-button> </el-col> <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> </el-row> <el-table v-loading="loading" border :data="opcuaconfigList" @selection-change="handleSelectionChange" v-if="opcuaconfigList.length > 0"> <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="module"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.module"/>--> <!-- </template>--> </el-table-column> <el-table-column label="èç¹" align="center" prop="node"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.node"/>--> <!-- </template>--> </el-table-column> <el-table-column label="é¿åº¦" align="center" prop="length"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.length"/>--> <!-- </template>--> </el-table-column> <el-table-column label="ç±»å" align="center" prop="sysTypes"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.sysTypes"/>--> <!-- </template>--> </el-table-column> <el-table-column label="åè½è¯´æ" align="center" prop="functionality"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.functionality"/>--> <!-- </template>--> </el-table-column> <el-table-column label="æ¯å¦è®¢é " align="center" prop="subscribe"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.subscribe"/>--> <!-- </template>--> </el-table-column> <el-table-column label="订é ååºæ¨¡å" align="center" prop="rModule"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.rModule"/>--> <!-- </template>--> </el-table-column> <el-table-column label="订é ååºå½æ°" align="center" prop="rFunction"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.rFunction"/>--> <!-- </template>--> </el-table-column> <el-table-column label="å¤æ³¨" align="center" prop="remarks"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.remarks"/>--> <!-- </template>--> </el-table-column> <el-table-column fixed="right" label="æä½" width="200" 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:opcuaconfig:edit']" >ä¿®æ¹</el-button> <el-button size="mini" type="danger" plain style="width: 72px" icon="el-icon-delete" @click="handleDelete(scope.row)" v-hasPermi="['da:opcuaconfig:remove']" >å é¤</el-button> </template> </el-table-column> </el-table> <el-empty v-else> <span slot="description">ææ æ°æ®</span> </el-empty> <el-table border v-loading="loading" :data="opcuaconfigList" @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="process"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.process"/>--> <!-- </template>--> </el-table-column> <el-table-column label="å·¥åºå称" align="center" prop="processName"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.processName"/>--> <!-- </template>--> </el-table-column> <el-table-column label="èç¹" align="center" prop="node"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.node"/>--> <!-- </template>--> </el-table-column> <el-table-column label="æ°æ®ç±»å" align="center" prop="sysTypes"> <template slot-scope="scope"> <dict-tag :options="dict.type.data_type" :value="scope.row.sysTypes"/> </template> </el-table-column> <el-table-column label="æ¯å¦è®¢é " align="center" prop="subscribe"> <template slot-scope="scope"> <dict-tag :options="dict.type.sys_yes_no" :value="scope.row.subscribe"/> </template> </el-table-column> <el-table-column label="订é ç±»å" align="center" prop="rFunction"> <template slot-scope="scope"> <dict-tag :options="dict.type.subscription_type" :value="scope.row.rFunction"/> </template> </el-table-column> <el-table-column label="å¤æ³¨" align="center" prop="remarks"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.${column.dictType}" :value="scope.row.remarks"/>--> <!-- </template>--> </el-table-column> <el-table-column label="ç¶æ" align="center" prop="state"> <template slot-scope="scope"> <dict-tag :options="dict.type.sys_normal_disable" :value="scope.row.state"/> </template> </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:opcuaconfig:edit']" >ä¿®æ¹</el-button> <el-button size="mini" type="danger" plain style="width: 72px" icon="el-icon-delete" @click="handleDelete(scope.row)" v-hasPermi="['main:opcuaconfig:remove']" >å é¤</el-button> </template> </el-table-column> </el-table> </el-card> <pagination @@ -211,49 +178,70 @@ @pagination="getList" /> <!-- æ·»å æä¿®æ¹OPCUAåæ°è®¾ç½®å¯¹è¯æ¡ --> <!-- æ·»å æä¿®æ¹äº¤äºä¿¡å·é 置对è¯æ¡ --> <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="module"> <el-input v-model="form.module" placeholder="请è¾å ¥æå±æ¨¡å" /> </el-form-item> <el-form-item label="èç¹" prop="node"> <el-input v-model="form.node" placeholder="请è¾å ¥èç¹" /> </el-form-item> <el-form-item label="é¿åº¦" prop="length"> <el-input v-model="form.length" placeholder="请è¾å ¥é¿åº¦" /> </el-form-item> <el-form-item label="ç±»å" prop="sysTypes"> <el-select v-model="form.sysTypes" placeholder="请éæ©ç±»å"> <!-- <el-option--> <!-- v-for="dict in dict.type.${dictType}"--> <!-- :key="dict.value"--> <!-- :label="dict.label"--> <!-- :value="dict.value"--> <!-- ></el-option>--> <el-form-item label="æ°æ®ç±»å" prop="sysTypes"> <el-select v-model="form.sysTypes" placeholder="请éæ©æ°æ®ç±»å"> <el-option v-for="dict in dict.type.data_type" :key="dict.value" :label="dict.label" :value="dict.value" ></el-option> </el-select> </el-form-item> <el-form-item label="åè½è¯´æ" prop="functionality"> <el-input v-model="form.functionality" placeholder="请è¾å ¥åè½è¯´æ" /> </el-form-item> <el-form-item label="æ¯å¦è®¢é " prop="subscribe"> <el-select v-model="form.subscribe" placeholder="请éæ©æ¯å¦è®¢é "> <!-- <el-option--> <!-- v-for="dict in dict.type.${dictType}"--> <!-- :key="dict.value"--> <!-- :label="dict.label"--> <!-- :value="parseInt(dict.value)"--> <!-- ></el-option>--> <el-option v-for="dict in dict.type.sys_yes_no" :key="dict.value" :label="dict.label" :value="parseInt(dict.value)" ></el-option> </el-select> </el-form-item> <el-form-item label="订é ååºæ¨¡å" prop="rModule"> <el-input v-model="form.rModule" placeholder="请è¾å ¥è®¢é ååºæ¨¡å" /> </el-form-item> <el-form-item label="订é ååºå½æ°" prop="rFunction"> <el-input v-model="form.rFunction" placeholder="请è¾å ¥è®¢é ååºå½æ°" /> <el-form-item label="订é ç±»å" prop="rFunction"> <el-select v-model="form.rFunction" placeholder="请éæ©è®¢é ç±»å"> <el-option v-for="dict in dict.type.subscription_type" :key="dict.value" :label="dict.label" :value="dict.value" ></el-option> </el-select> </el-form-item> <el-form-item label="å¤æ³¨" prop="remarks"> <el-input v-model="form.remarks" placeholder="请è¾å ¥å¤æ³¨" /> </el-form-item> <el-form-item label="å·¥åºç¼ç " prop="process"> <el-radio-group v-model="form.process"> <!-- <el-radio--> <!-- v-for="dict in dict.type.${dictType}"--> <!-- :key="dict.value"--> <!-- :label="dict.value"--> <!-- >{{dict.label}}</el-radio>--> </el-radio-group> </el-form-item> <el-form-item label="å·¥åºå称" prop="processName"> <el-input v-model="form.processName" placeholder="请è¾å ¥å·¥åºå称" /> </el-form-item> <el-form-item label="ç¶æ" prop="state"> <el-select v-model="form.state" placeholder="请éæ©ç¶æ"> <el-option v-for="dict in dict.type.sys_normal_disable" :key="dict.value" :label="dict.label" :value="parseInt(dict.value)" ></el-option> </el-select> </el-form-item> </el-form> <div slot="footer" class="dialog-footer"> @@ -269,10 +257,12 @@ export default { name: "Opcuaconfig", dicts: ['subscription_type', 'sys_yes_no', 'sys_normal_disable', 'data_type'], data() { return { // é®ç½©å± loading: true, titleName: "", // éä¸æ°ç» ids: [], // éå个ç¦ç¨ @@ -283,9 +273,8 @@ showSearch: true, // æ»æ¡æ° total: 0, // OPCUAåæ°è®¾ç½®è¡¨æ ¼æ°æ® // 交äºä¿¡å·é ç½®è¡¨æ ¼æ°æ® opcuaconfigList: [], advancedShowSearch: false, // å¼¹åºå±æ é¢ title: "", // æ¯å¦æ¾ç¤ºå¼¹åºå± @@ -294,14 +283,12 @@ queryParams: { pageNum: 1, pageSize: 10, module: null, node: null, length: null, sysTypes: null, functionality: null, subscribe: null, rModule: null, rFunction: null, process: null, processName: null, state: null }, // 表ååæ° form: {}, @@ -310,6 +297,18 @@ id: [ { required: true, message: "IDä¸è½ä¸ºç©º", trigger: "blur" } ], node: [ { required: true, message: "èç¹ä¸è½ä¸ºç©º", trigger: "blur" } ], sysTypes: [ { required: true, message: "æ°æ®ç±»åä¸è½ä¸ºç©º", trigger: "change" } ], subscribe: [ { required: true, message: "æ¯å¦è®¢é ä¸è½ä¸ºç©º", trigger: "change" } ], rFunction: [ { required: true, message: "订é ç±»åä¸è½ä¸ºç©º", trigger: "change" } ], } }; }, @@ -317,10 +316,7 @@ this.getList(); }, methods: { advancedQuery(){ this.advancedShowSearch = (this.advancedShowSearch) ? this.advancedShowSearch = false : this.advancedShowSearch = true; }, /** æ¥è¯¢OPCUAåæ°è®¾ç½®å表 */ /** æ¥è¯¢äº¤äºä¿¡å·é ç½®å表 */ getList() { this.loading = true; listOpcuaconfig(this.queryParams).then(response => { @@ -346,7 +342,10 @@ subscribe: null, rModule: null, rFunction: null, remarks: null remarks: null, process: null, processName: null, state: null }; this.resetForm("form"); }, @@ -370,7 +369,7 @@ handleAdd() { this.reset(); this.open = true; this.title = "æ·»å OPCUAåæ°è®¾ç½®"; this.titleName = "æ·»å 交äºä¿¡å·é ç½®"; }, /** ä¿®æ¹æé®æä½ */ handleUpdate(row) { @@ -379,7 +378,7 @@ getOpcuaconfig(id).then(response => { this.form = response.data; this.open = true; this.title = "ä¿®æ¹OPCUAåæ°è®¾ç½®"; this.titleName = "ä¿®æ¹äº¤äºä¿¡å·é ç½®"; }); }, /** æ交æé® */ @@ -405,7 +404,7 @@ /** å é¤æé®æä½ */ handleDelete(row) { const ids = row.id || this.ids; this.$modal.confirm('æ¯å¦ç¡®è®¤å é¤OPCUAåæ°è®¾ç½®ç¼å·ä¸º"' + ids + '"çæ°æ®é¡¹ï¼').then(function() { this.$modal.confirm('æ¯å¦ç¡®è®¤å é¤äº¤äºä¿¡å·é ç½®ç¼å·ä¸º"' + ids + '"çæ°æ®é¡¹ï¼').then(function() { return delOpcuaconfig(ids); }).then(() => { this.getList();