| | |
| | | @TableField(exist = false) |
| | | private String stationName; |
| | | |
| | | @TableField(exist = false) |
| | | private String powerName; |
| | | |
| | | |
| | | } |
| | |
| | | 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> |