湖北水库项目
parent: 8d5f3db4 | patch | commit | ignore whitespace
guoshilong
2024-03-20 1829f6450f43e5b90190298fba4f08545a73cf38 
普查填报列表查询逻辑修改
2 files modified
6 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml 3 ●●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResDykeMapper.xml 3 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml


@@ -48,9 +48,6 @@


        ) tmp on tmp."tb_state_id" = b."guid"




        where 1 = 1


        <if test="attResBase.tbYear !=null and attResBase.tbYear !=''">


            AND b."tb_year" = #{attResBase.tbYear}


        </if>


        <if test="attResBase.tbQuarter !=null and attResBase.tbQuarter !=''">


            AND b."tb_quarter" = #{attResBase.tbQuarter}


        </if>




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


@@ -118,9 +118,6 @@




        ) tmp on tmp."tb_state_id" = tdis."guid"


        where 1 = 1


        <if test="vo.tbYear !=null and vo.tbYear !=''">


            AND tdis."tb_year" = #{vo.tbYear}


        </if>


        <if test="vo.name !=null and vo.name !=''">


            AND trd."name" LIKE CONCAT('%',#{vo.name},'%')


        </if>