堰顶高程新增insert mappersql

xieb

2023-06-19 12e69d4ba0716f4657e8636b280fb86fff01e4b4

堰顶高程新增insert mappersql

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

@@ -16,5 +16,6 @@
public interface AttResRsbNorspiMapper extends BaseMapper<AttResRsbNorspi> {

    Integer updateAttResRsbNorspiByResId(@Param("attResRsbNorspi")AttResRsbNorspi attResRsbNorspi);
    Integer addAttResRsbNorspi(@Param("attResRsbNorspi")AttResRsbNorspi attResRsbNorspi);

}

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

@@ -11,4 +11,15 @@
        "update_time" = #{attResRsbNorspi.updateTime}
        WHERE "res_guid" = #{attResRsbNorspi.resGuid}
    </update>

    <insert id="addAttResRsbNorspi">
        insert into "att_res_rsb_norspi"("guid", "tb_weir_top_elevation", "res_guid", "create_time", "update_time",
                                         "update_by")
        VALUES (rawtohex(sys_guid()),
                #{attResRsbNorspi.tbWeirTopElevation},
                #{attResRsbNorspi.resGuid},
                #{attResRsbNorspi.updateTime},
                #{attResRsbNorspi.updateTime},
                #{attResRsbNorspi.updateBy})
    </insert>
</mapper>

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

@@ -44,7 +44,14 @@
        paramJson.put("phone", userClient.userInfoById(AuthUtil.getUserId()).getData().getPhone());
        attResRsbNorspi.setUpdateBy(paramJson.toJSONString());

        return SqlHelper.retBool(baseMapper.updateAttResRsbNorspiByResId(attResRsbNorspi));
        Integer ret = baseMapper.updateAttResRsbNorspiByResId(attResRsbNorspi);

        //如果修改影响行数为0 需要添加数据
        if (ret == 0) {
            baseMapper.addAttResRsbNorspi(attResRsbNorspi);
        }

        return SqlHelper.retBool(ret);

    }