| | |
| | | |
| | | //9.1根据stationid查询机房的落后单体总数 |
| | | @Select("select count(num) as nums from web_site.tb_badbatt_mon " + |
| | | "where battgroupid in (select distinct battgroupid from db_battinf.tb_battinf where stationid=#{StationId} ) limit 1 ") |
| | | "where battgroupid in (select distinct battgroupid from db_battinf.tb_battinf where stationid=#{stationId} ) limit 1 ") |
| | | public int serchByStationId(BattMap_information obj); |
| | | |
| | | //9.1根据stationName3查询站点的落后单体总数 |
| | |
| | | " 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 " + |
| | | " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " + |
| | | " and db_user.tb_user_inf.uid=#{UId} ) ") |
| | | " and db_user.tb_user_inf.uid=#{uId} ) ") |
| | | public int searchNums(User_inf userInf); |
| | | |
| | | //落后单体查询:根据条件查询落后单体(用户管理的电池组) |
| | |
| | | page.setPageCurr(1); |
| | | page.setPageSize(10); |
| | | User_inf uinf=new User_inf(); |
| | | uinf.setUId(1002); |
| | | uinf.setuId(1002); |
| | | Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm(); |
| | | bmd.setBinf(binf); |
| | | bmd.setPage(page); |