水位填报添加insert

xieb

2023-06-21 6cf1db11ae2ed13212c328397e2b24d62b34fce1

水位填报添加insert

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

@@ -13,5 +13,6 @@
public interface AttResDangerManageSpecialMapper extends BaseMapper<AttResDangerManageSpecial> {

    Integer updateAttResDangerManageSpecialByResId(@Param("attResDangerManageSpecial") AttResDangerManageSpecial attResDangerManageSpecial );
    Integer addAttResDangerManageSpecialByResId(@Param("attResDangerManageSpecial") AttResDangerManageSpecial attResDangerManageSpecial );

}

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

@@ -12,4 +12,12 @@
        WHERE "res_guid" = #{attResDangerManageSpecial.resGuid}
    </update>

    <insert id="addAttResDangerManageSpecialByResId">
        insert into "SJZT_MD"."att_res_danger_manage_special"("guid", "res_guid", "tb_control_z", "update_by",
                                                              "create_time", "update_time")
        VALUES (rawtohex(sys_guid()), #{attResDangerManageSpecial.resGuid}, #{attResDangerManageSpecial.tbControlZ},
                #{attResDangerManageSpecial.updateBy}, #{attResDangerManageSpecial.updateTime},
                #{attResDangerManageSpecial.updateTime})
    </insert>

</mapper>

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

@@ -18,4 +18,5 @@
    AttResStagChar getByResGuid(@Param("resGuid") String resGuid);

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

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

@@ -32,7 +32,28 @@
        WHERE "res_guid" = #{attResStagChar.resGuid}
    </update>

    <insert id="addattResStagChar">
        insert into "att_res_stag_char"("guid", "res_guid", "tb_chec_fl_stag", "tb_dead_cap", "tb_dead_stag",
                                        "tb_des_fl_stag", "tb_flpr_high_stag", "tb_norm_pool_stag", "tb_tot_cap",
                                        "wat_shed_area", "update_by", "create_time", "update_time")
        VALUES (rawtohex(sys_guid()),
                #{attResStagChar.resGuid},
                #{attResStagChar.tbChecFlStag},
                #{attResStagChar.tbDeadCap},
                #{attResStagChar.tbDeadStag},
                #{attResStagChar.tbDesFlStag},
                #{attResStagChar.tbFlprHighStag},
                #{attResStagChar.tbNormPoolStag},
                #{attResStagChar.tbTotCap},
                #{attResStagChar.watShedArea},
                #{attResStagChar.updateBy},
                #{attResStagChar.updateTime},
                #{attResStagChar.updateTime})
    </insert>

    <select id="getByResGuid" resultType="cn.gistack.sm.sjztmd.entity.AttResStagChar">
        SELECT * FROM "SJZT_MD"."att_res_stag_char" WHERE "res_guid" = #{resGuid}
        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/mapper/AttResWaterBlockMapper.java

@@ -13,5 +13,6 @@
public interface AttResWaterBlockMapper extends BaseMapper<AttResWaterBlock> {

    Integer updateAttResWaterBlockByResId(@Param("attResWaterBlock")AttResWaterBlock attResWaterBlock);
    Integer addAttResWaterBlockByResId(@Param("attResWaterBlock")AttResWaterBlock attResWaterBlock);

}

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

@@ -12,4 +12,11 @@
        WHERE "res_guid" = #{attResWaterBlock.resGuid}
    </update>

    <insert id="addAttResWaterBlockByResId">
        insert into "SJZT_MD"."att_res_water_block"("guid", "res_guid", "tb_dam_top_elevation", "update_by",
                                                    "create_time", "update_time")
        VALUES (rawtohex(sys_guid()), #{attResWaterBlock.resGuid}, #{attResWaterBlock.tbDamTopElevation},
                #{attResWaterBlock.updateBy}, #{attResWaterBlock.updateTime}, #{attResWaterBlock.updateTime})
    </insert>

</mapper>

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

@@ -7,6 +7,7 @@
import com.alibaba.fastjson.JSONObject;
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.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.StringUtil;
@@ -44,6 +45,10 @@
        paramJson.put("phone", userClient.userInfoById(AuthUtil.getUserId()).getData().getPhone());
        attResDangerManageSpecial.setUpdateBy(paramJson.toJSONString());

        return baseMapper.updateAttResDangerManageSpecialByResId(attResDangerManageSpecial) > 0;
        Integer ret = baseMapper.updateAttResDangerManageSpecialByResId(attResDangerManageSpecial);
        if (ret == 0) {
            ret = baseMapper.addAttResDangerManageSpecialByResId(attResDangerManageSpecial);
        }
        return SqlHelper.retBool(ret);
    }
}

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

@@ -63,6 +63,11 @@
        paramJson.put("phone", userClient.userInfoById(AuthUtil.getUserId()).getData().getPhone());

        attResStagChar.setUpdateBy(paramJson.toJSONString());
        return SqlHelper.retBool(baseMapper.customizeUpdateByGuid(attResStagChar));
        Integer ret = baseMapper.customizeUpdateByGuid(attResStagChar);

        if (ret == 0) {
            ret = baseMapper.addattResStagChar(attResStagChar);
        }
        return SqlHelper.retBool(ret);
    }
}

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

@@ -41,7 +41,11 @@
        paramJson.put("phone", userClient.userInfoById(AuthUtil.getUserId()).getData().getPhone());
        attResWaterBlock.setUpdateBy(paramJson.toJSONString());

        return SqlHelper.retBool(baseMapper.updateAttResWaterBlockByResId(attResWaterBlock));
        Integer ret = baseMapper.updateAttResWaterBlockByResId(attResWaterBlock);
        if (ret == 0) {
            ret = baseMapper.addAttResWaterBlockByResId(attResWaterBlock);
        }
        return SqlHelper.retBool(ret);
    }

}