From 10df7e29b51d6a2efacc83d870856f57d97a9b66 Mon Sep 17 00:00:00 2001
From: yanghui <2536613402@qq.com>
Date: 星期一, 24 十月 2022 13:48:24 +0800
Subject: [PATCH] #feat 修改别名

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngCarDAO.java |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngCarDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngCarDAO.java
index 41f5c8e..1442d0a 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngCarDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngCarDAO.java
@@ -35,9 +35,9 @@
         + "<if test='pageComMngCarDTO.villageId != null and pageComMngCarDTO.villageId != &quot;&quot;'>"
         + " and t.area_id = #{pageComMngCarDTO.villageId} " + " </if> "
         + "<if test='pageComMngCarDTO.communityId != null and pageComMngCarDTO.communityId != 0'>"
-        + " and t.community_id = #{pageComMngCarDTO.communityId} " + " </if> "
+        + " and t.community_id = ${pageComMngCarDTO.communityId} " + " </if> "
         + "<if test='pageComMngCarDTO.areaName != null and pageComMngCarDTO.areaName != &quot;&quot;'>"
-        + " and t2.area_name LIKE concat( '%',#{pageComMngCarDTO.areaName}, '%' )  " + " </if> "
+        + " and t.area_name LIKE concat( '%',#{pageComMngCarDTO.areaName}, '%' )  " + " </if> "
         + " order by t.create_at desc" + "</script>")
     IPage<ComMngCarVO> pageQueryComMngCar(Page page,
         @Param(value = "pageComMngCarDTO") PageComMngCarDTO pageComMngCarDTO);
@@ -52,7 +52,7 @@
         + "<if test='exportComMngCarExcelDTO.areaName != null and exportComMngCarExcelDTO.areaName.trim() != &quot;&quot;'>"
         + " and t.area_name LIKE concat( #{exportComMngCarExcelDTO.areaName}, '%' )  " + " </if> "
         + "<if test='exportComMngCarExcelDTO.communityId != null and exportComMngCarExcelDTO.communityId != &quot;&quot;'>"
-        + " and t.community_id = #{exportComMngCarExcelDTO.communityId} " + " </if> "
+        + " and t.community_id = ${exportComMngCarExcelDTO.communityId} " + " </if> "
         + "<if test='exportComMngCarExcelDTO.villageId != null and exportComMngCarExcelDTO.villageId != &quot;&quot;'>"
         + " and t.area_id = #{exportComMngCarExcelDTO.villageId} " + " </if> "
         + "<if test='exportComMngCarExcelDTO.userName != null and exportComMngCarExcelDTO.userName.trim() != &quot;&quot;'>"

--
Gitblit v1.7.1