门牌详情查询

guoshilong

2023-11-03 b28a55d9ee9223d945c5c0236e26a3b238fc9431

门牌详情查询

 src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.java

@@ -118,4 +118,6 @@
    List<FuncNode> getDoorplateNameList(@Param("name") String name,@Param("code") String code);

    DoorplateAddressVO getDoorplateAddressDetail(@Param("vo") DoorplateAddressVO doorplateAddressVO);

    List<DoorplateAddressVO> getDoorplateAddressList(@Param("vo") DoorplateAddressVO doorplateAddressVO);
}

 src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml

@@ -187,5 +187,16 @@
        AND building_code = #{vo.buildingCode}
    </if>
    </select>
    <select id="getDoorplateAddressList"
            resultType="org.springblade.modules.doorplateAddress.vo.DoorplateAddressVO">
        SELECT * FROM jczz_doorplate_address
        WHERE 1=1
        <if test="vo.stdId != null and vo.stdId != ''">
            AND address_code = #{vo.stdId}
        </if>
        <if test="vo.buildingCode != null and vo.buildingCode !='' ">
            AND building_code = #{vo.buildingCode}
        </if>
    </select>

</mapper>

 src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java

@@ -308,8 +308,12 @@
    @Override
    public DoorplateAddressVO getDoorplateAddressDetail(DoorplateAddressVO doorplateAddressVO) {

        DoorplateAddressVO detail = baseMapper.getDoorplateAddressDetail(doorplateAddressVO);
        List<DoorplateAddressVO> list = baseMapper.getDoorplateAddressList(doorplateAddressVO);

        return detail;
        if (list.size()>0){
            return list.get(0);
        }else {
            return null;
        }
    }
}