From ff44a3a0fd26538d00b59506d3cea77721095aeb Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 27 Jul 2023 11:11:26 +0800
Subject: [PATCH] 汛期填报为空修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResFlseLimMapper.xml | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResFlseLimMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResFlseLimMapper.xml
index b93a821..ef19c4b 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResFlseLimMapper.xml
+++ b/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}
--
Gitblit v1.9.3