电源查询增加站点字段

whycxzp

2025-03-27 4b3d8d360638073683eef4260be228dd2a9f541b

 src/main/java/com/whyc/mapper/PowerInfMapper.java

@@ -12,4 +12,13 @@

    @Select("select distinct producer from db_batt.power_inf where producer is not null")
    List<String> getProducerList();

    @Select("SELECT s.sinf_name as station_name,p.*,p.binf_id as battGroupId,p.binf_name as battGroupName from db_batt.power_inf p,db_batt.sinf_pinf sp,db_batt.station_inf s\n" +
            "where p.power_id = sp.pinf_id and sp.sinf_id = s.sinf_id")
    List<PowerInf> getList();

    @Select("SELECT s.sinf_name as station_name,p.*,p.binf_id as battGroupId,p.binf_name as battGroupName from db_batt.power_inf p,db_batt.sinf_pinf sp,db_batt.station_inf s\n" +
            "where p.power_id = sp.pinf_id and sp.sinf_id = s.sinf_id and power_id = #{powerId}")
    PowerInf getById(int powerId);

}