物业查询报错问题

zhongrj

2023-12-21 a221c564aa5f3e6b22bed25d789b79c5d6c4e643

物业查询报错问题

 src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.xml

@@ -33,6 +33,9 @@
        <if test="gridman.gridId!=null">
            and jg.id = #{gridman.gridId}
        </if>
        <if test="gridman.communityCode!=null and gridman.communityCode!=''">
            and jg.community_code like concat('%',#{gridman.communityCode},'%')
        </if>
    </select>

    <!--自定义分页查询-->

 src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml

@@ -243,6 +243,7 @@
        LEFT JOIN jczz_property_company_district jpcd on jpcd.district_id=jd.id
        WHERE 1=1
        AND jda.address_code = #{household.houseCode}
        limit 1
    </select>

    <!--查询网格-->