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_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbServiceTeamDAO.java | 59 ++++++++++++++++++++++------------------------------------- 1 files changed, 22 insertions(+), 37 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbServiceTeamDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbServiceTeamDAO.java index 4f2cbec..1d55a4e 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbServiceTeamDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbServiceTeamDAO.java @@ -1,18 +1,17 @@ package com.panzhihua.service_dangjian.dao; -import com.baomidou.mybatisplus.core.mapper.BaseMapper; -import com.baomidou.mybatisplus.core.metadata.IPage; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; -import com.panzhihua.common.model.dtos.partybuilding.PageComPbServiceTeamDTO; -import com.panzhihua.common.model.vos.community.ComActEasyPhotoCommentVO; -import com.panzhihua.common.model.vos.partybuilding.ComPbServiceTeamVO; -import com.panzhihua.common.model.vos.partybuilding.PartyCommitteeVO; -import com.panzhihua.service_dangjian.model.dos.ComPbServiceTeamDO; +import java.util.List; + import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; -import java.util.List; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.panzhihua.common.model.dtos.partybuilding.PageComPbServiceTeamDTO; +import com.panzhihua.common.model.vos.partybuilding.ComPbServiceTeamVO; +import com.panzhihua.service_dangjian.model.dos.ComPbServiceTeamDO; /** * @program: springcloud_k8s_panzhihuazhihuishequ @@ -23,34 +22,20 @@ @Mapper public interface ComPbServiceTeamDAO extends BaseMapper<ComPbServiceTeamDO> { - @Select("<script> " + - "SELECT\n" + - "* \n" + - "FROM\n" + - "com_pb_service_team \n" + - " where community_id=#{pageComPbServiceTeamDTO.communityId}" + - "<if test='pageComPbServiceTeamDTO.name != null and pageComPbServiceTeamDTO.name.trim() != ""'>" + - " and name LIKE concat( #{pageComPbServiceTeamDTO.name}, '%' ) \n" + - " </if> " + - "<if test='pageComPbServiceTeamDTO.job != null and pageComPbServiceTeamDTO.job.trim() != ""'>" + - "AND job LIKE concat(\n" + - "#{pageComPbServiceTeamDTO.job},\n" + - "'%')" + - " </if> " + - "</script>") - IPage<ComPbServiceTeamVO> PageComPbServiceTeamDTO(Page page, @Param("pageComPbServiceTeamDTO") PageComPbServiceTeamDTO pageComPbServiceTeamDTO); - @Select("select * from com_pb_service_team where id=#{id}") - ComPbServiceTeamDO selectComPbServiceTeamById(@Param("id")Long id); + @Select("<script> " + "SELECT\n" + "* \n" + "FROM\n" + "com_pb_service_team \n" + + " where community_id = ${pageComPbServiceTeamDTO.communityId}" + + "<if test='pageComPbServiceTeamDTO.name != null and pageComPbServiceTeamDTO.name.trim() != ""'>" + + " and name LIKE concat( #{pageComPbServiceTeamDTO.name}, '%' ) \n" + " </if> " + + "<if test='pageComPbServiceTeamDTO.job != null and pageComPbServiceTeamDTO.job.trim() != ""'>" + + "AND job LIKE concat(\n" + "#{pageComPbServiceTeamDTO.job},\n" + "'%')" + " </if> " + "</script>") + IPage<ComPbServiceTeamVO> PageComPbServiceTeamDTO(Page page, + @Param("pageComPbServiceTeamDTO") PageComPbServiceTeamDTO pageComPbServiceTeamDTO); - @Select("<script> " + - "SELECT\n" + - "* \n" + - "FROM\n" + - "com_pb_service_team \n" + - " where community_id=#{communityId}" + - "<if test='param != null and param != ""'>" + - " and name LIKE concat( #{param}, '%' ) \n" + - " </if> " + - "</script>") + @Select("select * from com_pb_service_team where id=#{id}") + ComPbServiceTeamDO selectComPbServiceTeamById(@Param("id") Long id); + + @Select("<script> " + "SELECT\n" + "* \n" + "FROM\n" + "com_pb_service_team \n" + + " where community_id = ${communityId}" + "<if test='param != null and param != ""'>" + + " and name LIKE concat( #{param}, '%' ) \n" + " </if> " + "</script>") List<ComPbServiceTeamVO> getTotlePerson(@Param("param") String param, @Param("communityId") Long communityId); } -- Gitblit v1.7.1