ansteel-biz/db/mysql.sql
@@ -1003,3 +1003,23 @@ create_date datetime COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '同步日志'; CREATE TABLE `t_page_param` ( `id` varchar(36) NOT NULL COMMENT 'id', `param_type` varchar(50) NULL DEFAULT NULL COMMENT '参数类型', `param_code` varchar(50) NULL DEFAULT NULL COMMENT '参数编码', `param_name` varchar(50) NULL DEFAULT NULL COMMENT '参数名称', `param_value` varchar(50) NULL DEFAULT NULL COMMENT '参数值', `point_no` varchar(50) NULL DEFAULT NULL COMMENT '测点编码', `chart_code` varchar(50) NULL DEFAULT NULL COMMENT '图表编码', `chart_param` varchar(50) NULL DEFAULT NULL COMMENT '图表参数', `model_id` varchar(50) NULL DEFAULT NULL COMMENT '模型ID', `model_param` varchar(50) NULL DEFAULT NULL COMMENT '模型参数', `sort` int DEFAULT NULL COMMENT '排序', `update_date` datetime COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, KEY `idx_param_type` (`param_type`), UNIQUE KEY `idx_param_code` (`param_code`) ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '参数设置'; ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PageParamController.java
对比新文件 @@ -0,0 +1,41 @@ package com.iailab.module.ansteel.api.controller.admin; import com.iailab.framework.common.pojo.CommonResult; import com.iailab.module.ansteel.page.service.PageParamService; import com.iailab.module.ansteel.page.vo.PageParamRespVO; import com.iailab.module.ansteel.page.vo.PageParamValueReqVO; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.List; import java.util.Map; /** * 参数设置 * * @author PanZhibao * @Description * @createTime 2025年06月19日 */ @Slf4j @RestController @RequestMapping("/ansteel/api/param") public class PageParamController { @Autowired private PageParamService pageParamService; @GetMapping("/list") public CommonResult<List<PageParamRespVO>> list(@RequestParam Map<String, Object> params) { String type = (String) params.get("type"); List<PageParamRespVO> list = pageParamService.list(type); return CommonResult.success(list); } @PostMapping("/update-value") public CommonResult<Boolean> updateValue(@RequestBody PageParamValueReqVO reqVO) { pageParamService.updateValue(reqVO); return CommonResult.success(true); } } ansteel-biz/src/main/java/com/iailab/module/ansteel/page/dao/PageParamDao.java
对比新文件 @@ -0,0 +1,14 @@ package com.iailab.module.ansteel.page.dao; import com.iailab.framework.common.dao.BaseDao; import com.iailab.module.ansteel.page.entity.PageParamEntity; import org.apache.ibatis.annotations.Mapper; /** * @author PanZhibao * @Description * @createTime 2025年06月19日 */ @Mapper public interface PageParamDao extends BaseDao<PageParamEntity> { } ansteel-biz/src/main/java/com/iailab/module/ansteel/page/entity/PageParamEntity.java
对比新文件 @@ -0,0 +1,49 @@ package com.iailab.module.ansteel.page.entity; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * 参数设置 * * @author PanZhibao * @Description * @createTime 2025年06月19日 */ @Data @TableName("t_page_param") public class PageParamEntity implements Serializable { private static final long serialVersionUID = 1L; /** * id */ @TableId private String id; private String paramType; private String paramCode; private String paramName; private String paramValue; private String pointNo; private String chartCode; private String chartParam; private String modelId; private String modelParam; private Integer sort; private Date updateDate; } ansteel-biz/src/main/java/com/iailab/module/ansteel/page/package-info.java
对比新文件 @@ -0,0 +1 @@ package com.iailab.module.ansteel.page; ansteel-biz/src/main/java/com/iailab/module/ansteel/page/service/PageParamService.java
对比新文件 @@ -0,0 +1,19 @@ package com.iailab.module.ansteel.page.service; import com.iailab.module.ansteel.page.entity.PageParamEntity; import com.iailab.module.ansteel.page.vo.PageParamRespVO; import com.iailab.module.ansteel.page.vo.PageParamValueReqVO; import java.util.List; /** * @author PanZhibao * @Description * @createTime 2025年06月19日 */ public interface PageParamService { List<PageParamRespVO> list(String paramType); void updateValue(PageParamValueReqVO reqVO); } ansteel-biz/src/main/java/com/iailab/module/ansteel/page/service/impl/PageParamServiceImpl.java
对比新文件 @@ -0,0 +1,56 @@ package com.iailab.module.ansteel.page.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.iailab.framework.common.util.object.ConvertUtils; import com.iailab.module.ansteel.page.dao.PageParamDao; import com.iailab.module.ansteel.page.entity.PageParamEntity; import com.iailab.module.ansteel.page.service.PageParamService; import com.iailab.module.ansteel.page.vo.PageParamRespVO; import com.iailab.module.ansteel.page.vo.PageParamValueReqVO; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.ArrayList; import java.util.List; /** * @author PanZhibao * @Description * @createTime 2025年06月19日 */ @Slf4j @Service public class PageParamServiceImpl implements PageParamService { @Resource private PageParamDao pageParamDao; @Override public List<PageParamRespVO> list(String paramType) { if (StringUtils.isBlank(paramType)) { return new ArrayList<>(); } QueryWrapper<PageParamEntity> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("param_type", paramType).orderByAsc("sort"); List<PageParamEntity> list = pageParamDao.selectList(queryWrapper); return ConvertUtils.sourceToTarget(list, PageParamRespVO.class); } @Override public void updateValue(PageParamValueReqVO reqVO) { QueryWrapper<PageParamEntity> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("param_code", reqVO.getParamCode()); PageParamEntity entity = pageParamDao.selectOne(queryWrapper); if (entity == null) { log.info("PageParamEntity is null"); return; } PageParamEntity entityUpdate = new PageParamEntity(); entityUpdate.setId(entity.getId()); entityUpdate.setParamValue(reqVO.getParamValue()); pageParamDao.updateById(entity); } } ansteel-biz/src/main/java/com/iailab/module/ansteel/page/vo/PageParamRespVO.java
对比新文件 @@ -0,0 +1,21 @@ package com.iailab.module.ansteel.page.vo; import lombok.Data; /** * @author PanZhibao * @Description * @createTime 2025年06月19日 */ @Data public class PageParamRespVO { private String paramType; private String paramCode; private String paramName; private String paramValue; } ansteel-biz/src/main/java/com/iailab/module/ansteel/page/vo/PageParamValueReqVO.java
对比新文件 @@ -0,0 +1,16 @@ package com.iailab.module.ansteel.page.vo; import lombok.Data; /** * @author PanZhibao * @Description * @createTime 2025年06月19日 */ @Data public class PageParamValueReqVO { private String paramCode; private String paramValue; } ansteel-biz/src/main/resources/application.yaml
@@ -189,6 +189,7 @@ - t_power_factor_control - t_xxb_duty_report - t_plant_conf - t_page_param swagger: title: 鞍钢鲅鱼圈能源管控系统 description: 鞍钢鲅鱼圈能源管控系统