查询信息加stationName，powerType，stationType

whyclxw

2025-05-20 f81fdb2a20dfd6dfe8c897c4d115c488fd1f762b

查询信息加stationName，powerType，stationType

 src/main/java/com/whyc/dto/BattDto.java

@@ -8,6 +8,8 @@
    private String city;
    private String country;
    private String stationName;
    private Integer powerType;
    private String stationType;
    private String powerName;
    private String battgroupName;
    private Integer pageNum;

 src/main/resources/mapper/BattInfMapper.xml

@@ -29,15 +29,16 @@
        <if test="country!=null">
            and tb_station_inf.country=#{country}
        </if>
       <!-- <if test="stationName!=null">
       <if test="stationName!=null">
            and tb_station_inf.station_name like concat('%',#{stationName},'%')
        </if>
        <if test="powerName!=null">
            and tb_power_inf.power_name like concat('%',#{powerName},'%')
        <if test="stationType!=null">
            and tb_station_inf.station_type like concat('%',#{stationType},'%')
        </if>
        <if test="battgroupName!=null">
            and tb_batt_inf.battgroup_name like concat('%',#{battgroupName},'%')
        </if>-->
        <if test="powerType!=null">
            and tb_power_inf.power_type like concat('%',#{powerType},'%')
        </if>

        <if test="uid>100">
            and tb_power_inf.power_id in(
            select distinct power_id from db_user.tb_baojigroup_power,db_user.tb_baojigroup_usr