社区党委模糊查询

huanghongfa

2021-01-15 2133506997c6b7d427f6c9d0c82a2a3394786fe2

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberRoleDAO.java

@@ -49,7 +49,7 @@
            "WHERE\n" +
            "mr.community_id = #{partyCommitteeVO.communityId} \n" +
            "<if test='partyCommitteeVO.name != null and partyCommitteeVO.name.trim() != &quot;&quot;'>" +
            "AND m.`name` = #{partyCommitteeVO.name} \n" +
            "AND m.`name` like concat(#{partyCommitteeVO.name},'%')  \n" +
            " </if> " +
            "<if test='partyCommitteeVO.roleId != null and partyCommitteeVO.roleId != 0'>" +
            "AND r.role_id =#{partyCommitteeVO.roleId}" +