水库基础资料管理

guoshilong

2023-05-09 9e3f606d681111beb3dd424a5b0f6f7d53210818

水库基础资料管理

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/SmApplication.java

@@ -12,7 +12,7 @@

@BladeCloudApplication
@EnableFeignClients({"cn.gistack"})
@MapperScan({"org.springblade.**.mapper.**","cn.gistack.**.mapper.**"})
@MapperScan({"org.springblade.**.mapper.**","cn.gistack.sm.**.mapper.**"})
public class SmApplication {
    public static void main(String[] args) {
        BladeApplication.run("blade-sm", SmApplication.class, args);

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/AttResBaseController.java

New file
@@ -0,0 +1,53 @@
package cn.gistack.sm.sjztmd.controller;

import cn.gistack.sm.exam.vo.ExamPlanVO;
import cn.gistack.sm.sjztmd.entity.AttAdBase;
import cn.gistack.sm.sjztmd.entity.AttResBase;
import cn.gistack.sm.sjztmd.service.IAttAdBaseService;
import cn.gistack.sm.sjztmd.service.IAttResBaseService;
import cn.gistack.sm.sjztmd.vo.AttAdBaseVO;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.node.ForestNodeMerger;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import springfox.documentation.annotations.ApiIgnore;

import java.util.List;
import java.util.Map;

/**
 * @ClassName AttResBaseController
 * @Description TODO
 * @Author aix
 * @Date 2023/4/21 20:09
 * @Version 1.0
 */
@Slf4j
@Api(tags = "中台水库")
@RestController
@RequestMapping("/sjztmd/attRes")
@AllArgsConstructor
public class AttResBaseController extends BladeController {

    private final IAttResBaseService attResBaseService;

    @ApiOperation(value = "中台水库-分页列表查询", notes = "中台水库-分页列表查询")
    @GetMapping(value = "/list")
    public R queryPageList(AttResBase attResBase, Query query) {
//        IPage<AttResBase> pageList = attResBaseService.page(Condition.getPage(query), Condition.getQueryWrapper(attResBase));
        IPage<AttResBase> pageList = attResBaseService.selectAttResBasePage(Condition.getPage(query), attResBase);
        return R.data(pageList);
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/AttResStagCharController.java

New file
@@ -0,0 +1,62 @@
package cn.gistack.sm.sjztmd.controller;

import cn.gistack.sm.exam.entity.ExamPlan;
import cn.gistack.sm.patrol.entity.PatrolConfig;
import cn.gistack.sm.sjztmd.entity.AttResBase;
import cn.gistack.sm.sjztmd.entity.AttResStagChar;
import cn.gistack.sm.sjztmd.service.IAttResBaseService;
import cn.gistack.sm.sjztmd.service.IAttResStagCharService;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springframework.web.bind.annotation.*;

/**
 * @ClassName AttAdBaseController
 * @Description TODO
 * @Author aix
 * @Date 2023/4/21 20:09
 * @Version 1.0
 */
@Slf4j
@Api(tags = "中台水库特征水位")
@RestController
@RequestMapping("/sjztmd/attResStagChar")
@AllArgsConstructor
public class AttResStagCharController extends BladeController {

    private final IAttResStagCharService attResStagCharService;

    /**
     * 通过resGuid查询
     *
     * @param resGuid
     * @return
     */
    @ApiOperation(value="水库特征水位-通过id查询", notes="水库特征水位-通过id查询")
    @GetMapping(value = "/queryById")
    public R queryById(@RequestParam(name="resGuid",required=true) String resGuid) {
        AttResStagChar attResStagChar = attResStagCharService.getByResGuid(resGuid);
        return R.data(attResStagChar);
    }

    /**
     * 编辑
     *
     * @param attResStagChar
     * @return
     */
    @ApiOperation(value = "水库特征水位-编辑", notes = "水库特征水位-编辑")
    @PostMapping(value = "/edit")
    public R edit(@RequestBody AttResStagChar attResStagChar) {
        return R.data(attResStagCharService.customizeUpdateByGuid(attResStagChar));
//        return R.data(attResStagCharService.updateById(attResStagChar));
    }

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/AttResBase.java

New file
@@ -0,0 +1,334 @@
package cn.gistack.sm.sjztmd.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;

/**
 * 中台水库实体类
 *
 * @author Chill
 */
@Data
@TableName("\"att_res_base\"")
@ApiModel(value = "水库对象", description = "水库对象")
public class AttResBase implements Serializable {
    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @JsonSerialize(using = ToStringSerializer.class)
    @ApiModelProperty(value = "主键")
    @TableField("\"guid\"")
    private String guid;

    /**
     * 水库编码
     */
    @ApiModelProperty(value = "水库编码")
    @TableField("\"code\"")
    private String code;

    /**
     * 老库编码
     */
    @ApiModelProperty(value = "老库编码")
    @TableField("\"sk_code\"")
    private String skCode;

    /**
     * 水库名称
     */
    @ApiModelProperty(value = "水库名称")
    @TableField("\"name\"")
    private String name;

    /**
     * 曾用名
     */
    @ApiModelProperty(value = "曾用名")
    @TableField("\"alias_name\"")
    private String aliasName;

    /**
     * 注册登记码
     */
    @ApiModelProperty(value = "注册登记码")
    @TableField("\"res_reg_code\"")
    private String resRegCode;

    /**
     * 其他行业注册号
     */
    @ApiModelProperty(value = "其他行业注册号")
    @TableField("\"other_reg_code\"")
    private String otherRegCode;

    /**
     * 注册登记时间
     */
    @ApiModelProperty(value = "注册登记时间")
    @TableField("\"res_reg_date\"")
    private String resRegDate;

    /**
     * 水库类型
     */
    @ApiModelProperty(value = "水库类型")
    @TableField("\"res_type\"")
    private String resType;

    /**
     * 水库功能
     */
    @ApiModelProperty(value = "水库功能")
    @TableField("\"res_func\"")
    private String resFunc;

    /**
     * 水库类别
     */
    @ApiModelProperty(value = "水库类别")
    @TableField("\"res_category\"")
    private String resCategory;

    /**
     * 工程等别
     */
    @ApiModelProperty(value = "工程等别")
    @TableField("\"eng_grad\"")
    private String engGrad;

    /**
     * 工程规模
     */
    @ApiModelProperty(value = "工程规模")
    @TableField("\"eng_scal\"")
    private String engScal;

    /**
     * 工程建设情况
     */
    @ApiModelProperty(value = "工程建设情况")
    @TableField("\"eng_stat\"")
    private String engStat;

    /**
     * 开工时间
     */
    @ApiModelProperty(value = "开工时间 ")
    @TableField("\"start_date\"")
    private String startDate;

    /**
     * 完工时间
     */
    @ApiModelProperty(value = "完工时间 ")
    @TableField("\"finish_date\"")
    private String finishDate;

    /**
     * 建成时间
     */
    @ApiModelProperty(value = "建成时间 ")
    @TableField("\"comp_date\"")
    private String compDate;

    /**
     * 河流guid
     */
    @ApiModelProperty(value = "河流guid")
    @TableField("\"rv_guid\"")
    private String rvGuid;

    /**
     * 河流名称
     */
    @ApiModelProperty(value = "河流名称 ")
    @TableField("\"rv_name\"")
    private String rvName;

    /**
     * 流域guid
     */
    @ApiModelProperty(value = "流域guid ")
    @TableField("\"bas_guid\"")
    private String basGuid;

    /**
     * 流域名称
     */
    @ApiModelProperty(value = "流域名称 ")
    @TableField("\"bas_name\"")
    private String basName;

    /**
     * 行政区划guid
     */
    @ApiModelProperty(value = "行政区划guid ")
    @TableField("\"ad_guid\"")
    private String adGuid;

    /**
     * 主管部门行政区划guid
     */
    @ApiModelProperty(value = "主管部门行政区划guid  ")
    @TableField("\"mgr_ad_guid\"")
    private String mgrAdGuid;

    /**
     * 内部行政区划guid
     */
    @ApiModelProperty(value = "内部行政区划guid ")
    @TableField("\"interior_ad_guid\"")
    private String interiorAdGuid;

    /**
     * 水库所在位置
     */
    @ApiModelProperty(value = "水库所在位置 ")
    @TableField("\"res_loc\"")
    private String resLoc;

    /**
     * 中心点经度(度)
     */
    @ApiModelProperty(value = "中心点经度(度) ")
    @TableField("\"center_long\"")
    private String centerLong;

    /**
     * 中心点纬度(度)
     */
    @ApiModelProperty(value = "中心点纬度(度) ")
    @TableField("\"center_lat\"")
    private String centerLat;

    /**
     * 右上角经度(度)
     */
    @ApiModelProperty(value = "右上角经度(度)  ")
    @TableField("\"up_right_long\"")
    private String upRightLong;

    /**
     * 右上角纬度(度)
     */
    @ApiModelProperty(value = "右上角纬度(度) ")
    @TableField("\"up_right_lat\"")
    private String upRightLat;

    /**
     * 左下角经度(度)
     */
    @ApiModelProperty(value = "左下角经度(度) ")
    @TableField("\"low_left_long\"")
    private String lowLeftLong;

    /**
     * 左下角纬度(度)
     */
    @ApiModelProperty(value = "左下角纬度(度) ")
    @TableField("\"low_left_lat\"")
    private String lowLeftLat;

    /**
     * 所属行业部门
     */
    @ApiModelProperty(value = "所属行业部门 ")
    @TableField("\"industry_dept\"")
    private String industryDept;

    /**
     * 抗震设计烈度
     */
    @ApiModelProperty(value = "抗震设计烈度 ")
    @TableField("\"base_eq_intensity\"")
    private String baseEqIntensity;

    /**
     * 地震基本烈度
     */
    @ApiModelProperty(value = "地震基本烈度 ")
    @TableField("\"seismic_design_intensity\"")
    private String seismicDesignIntensity;

    /**
     * 地震动峰值加速度
     */
    @ApiModelProperty(value = "地震动峰值加速度 ")
    @TableField("\"acceleration\"")
    private String acceleration;

    /**
     * 地震反应谱特征周期
     */
    @ApiModelProperty(value = "地震反应谱特征周期 ")
    @TableField("\"characteristic_period\"")
    private String characteristicPeriod;

    /**
     * 主要建筑物级别
     */
    @ApiModelProperty(value = "主要建筑物级别 ")
    @TableField("\"major_level\"")
    private String majorLevel;

    /**
     * 水库简介
     */
    @ApiModelProperty(value = "水库简介 ")
    @TableField("\"summary\"")
    private String summary;

    /**
     * 备注
     */
    @ApiModelProperty(value = "备注 ")
    @TableField("\"note\"")
    private String note;

    /**
     * 是否失效
     */
    @ApiModelProperty(value = "是否失效  ")
    @TableField("\"is_deleted\"")
    private String isDeleted;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间 ")
    @TableField("\"create_time\"")
    private String createTime;

    /**
     * 更新时间
     */
    @ApiModelProperty(value = "更新时间 ")
    @TableField("\"update_time\"")
    private String updateTime;

    /**
     * 采集时间
     */
    @ApiModelProperty(value = "采集时间 ")
    @TableField("\"collect_time\"")
    private String collectTime;

    /**
     * 来源系统
     */
    @ApiModelProperty(value = "来源系统 ")
    @TableField("\"sys_resource\"")
    private String sysResource;


}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/AttResStagChar.java

New file
@@ -0,0 +1,247 @@
package cn.gistack.sm.sjztmd.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.util.Date;

/**
 * 中台水库特征水位实体类
 *
 * @author Chill
 */
@Data
@TableName("\"att_res_stag_char\"")
@ApiModel(value = "水库特征水位对象", description = "水库特征水位对象")
public class AttResStagChar implements Serializable {
    private static final long serialVersionUID = 1L;

    /**
     * 主键
     */
    @JsonSerialize(using = ToStringSerializer.class)
    @ApiModelProperty(value = "主键")
    @TableField("\"guid\"")
    private String guid;

    /**
     * 水库GUID
     */
    @ApiModelProperty(value = "水库GUID")
    @TableField("\"res_guid\"")
    private String resGuid;

    /**
     * 死水位(米)
     */
    @ApiModelProperty(value = "死水位(米)")
    @TableField("\"dead_stag\"")
    private String deadStag;

    /**
     * 兴利水位
     */
    @ApiModelProperty(value = "兴利水位")
    @TableField("\"ben_res_stag\"")
    private String benResStag;

    /**
     * 校核洪水位(米)
     */
    @ApiModelProperty(value = "校核洪水位(米)")
    @TableField("\"chec_fl_stag\"")
    private String checFlStag;

    /**
     * 校核洪水流量(m3/s)
     */
    @ApiModelProperty(value = "校核洪水流量(m3/s)")
    @TableField("\"chec_fl_flow\"")
    private String checFlFlow;

    /**
     * 历史最大校核洪水流量(m3/s)
     */
    @ApiModelProperty(value = "历史最大校核洪水流量(m3/s)")
    @TableField("\"chec_fl_flow_max\"")
    private String checFlFlowMax;

    /**
     * 校核洪水标准
     */
    @ApiModelProperty(value = "校核洪水标准")
    @TableField("\"chec_fl_stand\"")
    private String checFlStand;

    /**
     * 设计洪水位(米)
     */
    @ApiModelProperty(value = "设计洪水位(米)")
    @TableField("\"des_fl_stag\"")
    private String desFlStag;

    /**
     * 设计洪水流量(m3/s)
     */
    @ApiModelProperty(value = "设计洪水流量(m3/s)")
    @TableField("\"des_fl_flow\"")
    private String desFlFlow;

    /**
     * 历史最大设计洪水流量(m3/s)
     */
    @ApiModelProperty(value = "历史最大设计洪水流量(m3/s)")
    @TableField("\"des_fl_flow_max\"")
    private String desFlFlowMax;

    /**
     * 设计洪水标准
     */
    @ApiModelProperty(value = "设计洪水标准")
    @TableField("\"des_fl_stand\"")
    private String desFlStand;

    /**
     * 防洪高水位(米)
     */
    @ApiModelProperty(value = "防洪高水位(米)")
    @TableField("\"flpr_high_stag\"")
    private String flprHighStag;

    /**
     * 低水位告警值(米)
     */
    @ApiModelProperty(value = "低水位告警值(米) ")
    @TableField("\"low_stag_ale_val\"")
    private String lowStagAleVal;

    /**
     * 防洪高水位相应洪水标准(重现期[年])
     */
    @ApiModelProperty(value = "防洪高水位相应洪水标准(重现期[年]) ")
    @TableField("\"flpr_high_stag_stand\"")
    private String flprHighStagStand;

    /**
     * 正常蓄水位对应水面面积(万立方米)
     */
    @ApiModelProperty(value = "正常蓄水位对应水面面积(万立方米)  ")
    @TableField("\"norm_pool_area\"")
    private String normPoolArea;

    /**
     * 正常蓄水位(米)
     */
    @ApiModelProperty(value = "正常蓄水位(米)  ")
    @TableField("\"norm_pool_stag\"")
    private String normPoolStag;

    /**
     * 兴利库容(万立方米)
     */
    @ApiModelProperty(value = "兴利库容(万立方米)")
    @TableField("\"ben_res_cap\"")
    private String benResCap;

    /**
     * 库容系数
     */
    @ApiModelProperty(value = "库容系数 ")
    @TableField("\"cap_coef\"")
    private String capCoef;

    /**
     * 死库容(万立方米)
     */
    @ApiModelProperty(value = "死库容(万立方米) ")
    @TableField("\"dead_cap\"")
    private String deadCap;

    /**
     * 防洪库容(万立方米)
     */
    @ApiModelProperty(value = "防洪库容(万立方米) ")
    @TableField("\"flco_cap\"")
    private String flcoCap;

    /**
     * 正常蓄水位对应库容(万立方米)
     */
    @ApiModelProperty(value = "正常蓄水位对应库容(万立方米) ")
    @TableField("\"norm_pool_cap\"")
    private String normPoolCap;

    /**
     * 防洪限制水位库容(万立方米)
     */
    @ApiModelProperty(value = "防洪限制水位库容(万立方米)  ")
    @TableField("\"flse_lim_cap\"")
    private String flseLimCap;

    /**
     * 淤积库容(万立方米)
     */
    @ApiModelProperty(value = "淤积库容(万立方米) ")
    @TableField("\"silt_storage_capacity\"")
    private String siltStorageCapacity;

    /**
     * 调洪库容(万立方米)
     */
    @ApiModelProperty(value = "调洪库容(万立方米) ")
    @TableField("\"stor_fl_cap\"")
    private String storFlCap;

    /**
     * 总库容(万立方米)
     */
    @ApiModelProperty(value = "总库容(万立方米) ")
    @TableField("\"tot_cap\"")
    private String totCap;

    /**
     * 坝址以上控制流域面积
     */
    @ApiModelProperty(value = "坝址以上控制流域面积 ")
    @TableField("\"con_area\"")
    private String conArea;

    /**
     * 多年平均径流量(m3)
     */
    @ApiModelProperty(value = "多年平均径流量(m3) ")
    @TableField("\"moyear_fl_age\"")
    private String moyearFlAge;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间 ")
    @TableField("\"create_time\"")
    private String createTime;

    /**
     * 更新时间
     */
    @ApiModelProperty(value = "更新时间 ")
    @TableField("\"update_time\"")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date updateTime;

    /**
     * 采集时间
     */
    @ApiModelProperty(value = "采集时间 ")
    @TableField("\"collect_time\"")
    private String collectTime;

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java

New file
@@ -0,0 +1,20 @@
package cn.gistack.sm.sjztmd.mapper;

import cn.gistack.sm.sjztmd.entity.AttResBase;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * AttResBaseMapper 接口
 *
 * @author Chill
 */
public interface AttResBaseMapper extends BaseMapper<AttResBase> {


    List<AttResBase> selectAttResBasePage(IPage<AttResBase> page, @Param("attResBase") AttResBase attResBase);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml

New file
@@ -0,0 +1,13 @@
<?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="cn.gistack.sm.sjztmd.mapper.AttResBaseMapper">


    <select id="selectAttResBasePage" resultType="cn.gistack.sm.sjztmd.entity.AttResBase">
        SELECT * FROM "SJZT_MD"."att_res_base"
        WHERE "is_deleted"=0
        <if test="attResBase.name !=null and attResBase.name !=''">
            AND "name" LIKE CONCAT('%',#{attResBase.name},'%')
        </if>
    </select>
</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResStagCharMapper.java

New file
@@ -0,0 +1,21 @@
package cn.gistack.sm.sjztmd.mapper;

import cn.gistack.sm.sjztmd.entity.AttResBase;
import cn.gistack.sm.sjztmd.entity.AttResStagChar;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * AttResStagCharMapper 接口
 *
 * @author Chill
 */
public interface AttResStagCharMapper extends BaseMapper<AttResStagChar> {

    AttResStagChar getByResGuid(@Param("resGuid") String resGuid);

    Integer customizeUpdateByGuid(@Param("attResStagChar") AttResStagChar attResStagChar);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResStagCharMapper.xml

New file
@@ -0,0 +1,91 @@
<?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="cn.gistack.sm.sjztmd.mapper.AttResStagCharMapper">
    <update id="customizeUpdateByGuid">
        UPDATE "att_res_stag_char" SET
        <if test="attResStagChar.deadStag !=null ">
            "dead_stag" = #{attResStagChar.deadStag},
        </if>
        <if test="attResStagChar.benResStag !=null ">
            "ben_res_stag" = #{attResStagChar.benResStag},
        </if>
        <if test="attResStagChar.checFlStag !=null ">
            "chec_fl_stag" = #{attResStagChar.checFlStag},
        </if>
        <if test="attResStagChar.checFlFlow !=null ">
            "chec_fl_flow" = #{attResStagChar.checFlFlow},
        </if>
        <if test="attResStagChar.checFlFlowMax !=null ">
            "chec_fl_flow_max" = #{attResStagChar.checFlFlowMax},
        </if>
        <if test="attResStagChar.checFlStand !=null ">
            "chec_fl_stand" = #{attResStagChar.checFlStand},
        </if>
        <if test="attResStagChar.desFlStag !=null ">
            "des_fl_stag" = #{attResStagChar.desFlStag},
        </if>
        <if test="attResStagChar.desFlFlow !=null">
            "des_fl_flow" = #{attResStagChar.desFlFlow},
        </if>
        <if test="attResStagChar.desFlFlowMax !=null ">
            "des_fl_flow_max" = #{attResStagChar.desFlFlowMax},
        </if>
        <if test="attResStagChar.desFlStand !=null ">
            "des_fl_stand" = #{attResStagChar.desFlStand},
        </if>
        <if test="attResStagChar.flprHighStag !=null ">
            "flpr_high_stag" = #{attResStagChar.flprHighStag},
        </if>
        <if test="attResStagChar.lowStagAleVal !=null ">
            "low_stag_ale_val" = #{attResStagChar.lowStagAleVal},
        </if>
        <if test="attResStagChar.flprHighStagStand !=null ">
            "flpr_high_stag_stand" = #{attResStagChar.flprHighStagStand},
        </if>
        <if test="attResStagChar.normPoolArea !=null ">
            "norm_pool_area" = #{attResStagChar.normPoolArea},
        </if>
        <if test="attResStagChar.normPoolStag !=null ">
            "norm_pool_stag" = #{attResStagChar.normPoolStag},
        </if>
        <if test="attResStagChar.benResCap !=null ">
            "ben_res_cap" = #{attResStagChar.benResCap},
        </if>
        <if test="attResStagChar.capCoef !=null">
            "cap_coef" = #{attResStagChar.capCoef},
        </if>
        <if test="attResStagChar.deadCap !=null ">
            "dead_cap" = #{attResStagChar.deadCap},
        </if>
        <if test="attResStagChar.flcoCap !=null ">
            "flco_cap" = #{attResStagChar.flcoCap},
        </if>
        <if test="attResStagChar.normPoolCap !=null ">
            "norm_pool_cap" = #{attResStagChar.normPoolCap},
        </if>
        <if test="attResStagChar.flseLimCap !=null ">
            "flse_lim_cap" = #{attResStagChar.flseLimCap},
        </if>
        <if test="attResStagChar.siltStorageCapacity !=null ">
            "silt_storage_capacity" = #{attResStagChar.siltStorageCapacity},
        </if>
        <if test="attResStagChar.storFlCap !=null ">
            "stor_fl_cap" = #{attResStagChar.storFlCap},
        </if>
        <if test="attResStagChar.totCap !=null ">
            "tot_cap" = #{attResStagChar.totCap},
        </if>
        <if test="attResStagChar.conArea !=null ">
            "con_area" = #{attResStagChar.conArea},
        </if>
        <if test="attResStagChar.moyearFlAge !=null ">
            "moyear_fl_age" = #{attResStagChar.moyearFlAge},
        </if>
            "update_time" = #{attResStagChar.updateTime}
            WHERE "guid" = #{attResStagChar.guid}
    </update>

    <select id="getByResGuid" resultType="cn.gistack.sm.sjztmd.entity.AttResStagChar">
        SELECT * FROM "SJZT_MD"."att_res_stag_char" WHERE "res_guid" = #{resGuid}
    </select>
</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResBaseService.java

New file
@@ -0,0 +1,22 @@
package cn.gistack.sm.sjztmd.service;

import cn.gistack.sm.sjztmd.entity.AttAdBase;
import cn.gistack.sm.sjztmd.entity.AttResBase;
import cn.gistack.sm.sjztmd.vo.AttAdBaseVO;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.List;
import java.util.Map;

/**
 * @ClassName IAttResBaseService
 * @Description TODO
 * @Author aix
 * @Date 2023/4/21 19:55
 * @Version 1.0
 */
public interface IAttResBaseService extends IService<AttResBase> {

    IPage<AttResBase> selectAttResBasePage(IPage<AttResBase> page, AttResBase attResBase);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResStagCharService.java

New file
@@ -0,0 +1,20 @@
package cn.gistack.sm.sjztmd.service;

import cn.gistack.sm.sjztmd.entity.AttResBase;
import cn.gistack.sm.sjztmd.entity.AttResStagChar;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.IService;

/**
 * @ClassName IAttResStagCharService
 * @Description TODO
 * @Author aix
 * @Date 2023/4/21 19:55
 * @Version 1.0
 */
public interface IAttResStagCharService extends IService<AttResStagChar> {

    AttResStagChar getByResGuid(String resGuid);

    Boolean customizeUpdateByGuid(AttResStagChar attResStagChar);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java

New file
@@ -0,0 +1,29 @@
package cn.gistack.sm.sjztmd.service.impl;

import cn.gistack.sm.sjztmd.entity.AttResBase;
import cn.gistack.sm.sjztmd.mapper.AttResBaseMapper;
import cn.gistack.sm.sjztmd.service.IAttResBaseService;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;

/**
 * @ClassName AttResBaseServiceImpl
 * @Description TODO
 * @Author aix
 * @Date 2023/4/21 20:01
 * @Version 1.0
 */
@Service
@DS("zt")
public class AttResBaseServiceImpl extends ServiceImpl<AttResBaseMapper, AttResBase> implements IAttResBaseService {

    @Override
    public IPage<AttResBase> selectAttResBasePage(IPage<AttResBase> page, AttResBase attResBase) {
        return page.setRecords(baseMapper.selectAttResBasePage(page,attResBase));
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResStagCharServiceImpl.java

New file
@@ -0,0 +1,33 @@
package cn.gistack.sm.sjztmd.service.impl;

import cn.gistack.sm.sjztmd.entity.AttResStagChar;
import cn.gistack.sm.sjztmd.mapper.AttResStagCharMapper;
import cn.gistack.sm.sjztmd.service.IAttResStagCharService;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.baomidou.mybatisplus.extension.toolkit.SqlHelper;
import org.springblade.core.tool.utils.DateUtil;
import org.springframework.stereotype.Service;

/**
 * @ClassName AttResStagCharServiceImpl
 * @Description TODO
 * @Author aix
 * @Date 2023/4/21 20:01
 * @Version 1.0
 */
@Service
@DS("zt")
public class AttResStagCharServiceImpl extends ServiceImpl<AttResStagCharMapper, AttResStagChar> implements IAttResStagCharService {

    @Override
    public AttResStagChar getByResGuid(String resGuid) {
        return baseMapper.getByResGuid(resGuid);
    }

    @Override
    public Boolean customizeUpdateByGuid(AttResStagChar attResStagChar) {
        attResStagChar.setUpdateTime(DateUtil.now());
        return SqlHelper.retBool(baseMapper.customizeUpdateByGuid(attResStagChar));
    }
}