From 62119cda566bdbba6e831067efcdb871d844fb43 Mon Sep 17 00:00:00 2001
From: dy <dingyang@lnfxkj.tech>
Date: 星期四, 17 四月 2025 15:34:39 +0800
Subject: [PATCH] 工厂管理后台查询调整
---
aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml
index 6af672a..0422ad4 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml
@@ -22,8 +22,8 @@
<select id="selectApsPlantList" parameterType="ApsPlant" resultMap="ApsPlantResult">
<include refid="selectApsPlantVo"/>
<where>
- <if test="plantName != null and plantName != ''"> and plant_name like concat('%', #{plantName}, '%')</if>
- <if test="plantCode != null and plantCode != ''"> and plant_code like concat('%', #{plantCode}, '%')</if>
+ <if test="plantName != null and plantName != ''"> and plant_name like '%' || #{plantName} || '%'</if>
+ <if test="plantCode != null and plantCode != ''"> and plant_code like '%' || #{plantCode} || '%'</if>
<if test="status != null and status != ''"> and status = #{status}</if>
</where>
</select>
--
Gitblit v1.9.3