| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="getDevNum" resultType="java.lang.Integer"> |
|---|
| | | select count(distinct FBSDeviceIp) from db_battinf.tb_battinf where StationId in(select distinct db_battinf.tb_battinf.StationId |
|---|
| | | select count(distinct FBSDeviceIp,comm_port) from db_battinf.tb_battinf where StationId in(select distinct db_battinf.tb_battinf.StationId |
|---|
| | | from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf |
|---|
| | | where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId |
|---|
| | | and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id |
|---|
