whyclxw
2025-05-17 13889d0a30f219fac861b8b1df1fd742071f2141
标记包机组修改添加电源名称
2个文件已修改
8 ■■■■ 已修改文件
src/main/java/com/whyc/pojo/db_user/BaojigroupPower.java 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/BaojigroupPowerMapper.xml 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/whyc/pojo/db_user/BaojigroupPower.java
@@ -49,5 +49,8 @@
    @TableField(exist = false)
    private String stationName;
    @TableField(exist = false)
    private String powerName;
}
src/main/resources/mapper/BaojigroupPowerMapper.xml
@@ -50,9 +50,10 @@
        order by s.station_name
    </select>
    <select id="getStationIdListWithDischargePlanFlag" resultType="com.whyc.pojo.db_user.BaojigroupPower">
        SELECT gb.baoji_group_id,gb.station_id,g.baoji_group_name,b.provice,b.city,b.country,b.station_name
        FROM db_user.tb_baojigroup g,db_user.tb_baojigroup_power gb,db_station.tb_station_inf b
        SELECT gb.baoji_group_id,gb.station_id,g.baoji_group_name,b.provice,b.city,b.country,b.station_name,p.power_name
        FROM db_user.tb_baojigroup g,db_user.tb_baojigroup_power gb,db_station.tb_station_inf b,db_station.tb_power_inf p
        where g.baoji_group_id = gb.baoji_group_id and gb.station_id = b.station_id
          and gb.power_id = p.power_id
          and g.team_flag = 1
    </select>
</mapper>