汛期填报为空修改

xieb

2023-07-27 ff44a3a0fd26538d00b59506d3cea77721095aeb

汛期填报为空修改

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

@@ -7,12 +7,21 @@
        <if test="attResFlseLim.tbFlseLimStag !=null and attResFlseLim.tbFlseLimStag != ''">
            "tb_flse_lim_stag" = #{attResFlseLim.tbFlseLimStag},
        </if>
        <if test="attResFlseLim.tbFloodSeasonStart !=null and attResFlseLim.tbFloodSeasonStart != ''">
        <if test="attResFlseLim.tbFlseLimStag == null or attResFlseLim.tbFlseLimStag == ''">
            "tb_flse_lim_stag" = '',
        </if>
        <if test="attResFlseLim.tbFloodSeasonStart != null and attResFlseLim.tbFloodSeasonStart != ''">
            "tb_flood_season_start" = #{attResFlseLim.tbFloodSeasonStart},
        </if>
        <if test="attResFlseLim.tbFloodSeasonStart == null or attResFlseLim.tbFloodSeasonStart == ''">
            "tb_flood_season_start" = '',
        </if>
        <if test="attResFlseLim.tbFloodSeasonEnd !=null and attResFlseLim.tbFloodSeasonEnd != ''">
            "tb_flood_season_end" = #{attResFlseLim.tbFloodSeasonEnd},
        </if>
        <if test="attResFlseLim.tbFloodSeasonEnd == null or attResFlseLim.tbFloodSeasonEnd == ''">
            "tb_flood_season_end" = '',
        </if>
        "update_by" = concat("update_by",',',#{attResFlseLim.updateBy}),
        "update_time" = #{attResFlseLim.updateTime}
        WHERE "res_guid" = #{attResFlseLim.resGuid} and "flood_season_name" = #{type}