From c262fa8719759f13dc67da733fdf73cff8e47127 Mon Sep 17 00:00:00 2001
From: shenyijian <1178253012@qq.com>
Date: Tue, 03 Dec 2024 16:54:32 +0800
Subject: [PATCH] 施工项目：注册码模糊查询
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml
index f6f3d8e..7cfe202 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml
@@ -92,7 +92,7 @@
and dria."county_cd" = #{dto.adCode}
</if>
<if test="dto.othRegCd != null and dto.othRegCd !=''">
- and dria."oth_reg_cd" = #{dto.othRegCd}
+ and dria."oth_reg_cd" like CONCAT(CONCAT('%', #{dto.othRegCd}), '%')
</if>
<if test="dto.projectSort == null">
ORDER BY TO_NUMBER(info.project_progress) desc NULLS LAST,info.status desc
--
Gitblit v1.9.3