| | |
|---|
| | |
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | // 3.1电池告警实时查询<***********跨域专用**************>
|
|---|
| | | public List serchByCondition_ky(Object obj) {
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
| | | String sql="";
|
|---|
| | | String baseSql = "select distinct db_alarm.tb_battalarm_data.BattGroupId,db_alarm.tb_battalarm_data.num,alm_signal_id,db_alarm.tb_battalarm_data.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time "
|
|---|
| | | + " ,stationname,stationname5,battgroupname"
|
|---|
| | | + " from db_alarm.tb_battalarm_data,db_battinf.tb_battinf "
|
|---|
| | | + " where alm_cleared_type=0 ";
|
|---|
| | | //用于电池组条件
|
|---|
| | | String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? and db_alarm.tb_battalarm_data.battgroupid=db_battinf.tb_battinf.battgroupid ";//全部
|
|---|
| | | String idSqlF=" and db_battinf.tb_battinf.battgroupid=? and db_alarm.tb_battalarm_data.battgroupid=db_battinf.tb_battinf.battgroupid ";
|
|---|
| | | if(binf.getBattGroupId()==0){
|
|---|
| | | baseSql+=idSqlT;
|
|---|
| | | }else{
|
|---|
| | | baseSql+=idSqlF;
|
|---|
| | | }
|
|---|
| | | String endSql="order by db_alarm.tb_battalarm_data.BattGroupId,db_alarm.tb_battalarm_data.alm_start_time desc,db_alarm.tb_battalarm_data.monnum asc ";
|
|---|
| | | sql=baseSql+endSql;
|
|---|
| | | List list = DAOHelper.executeQuery(sql,DBUtil.getConn(),new Object[] {binf.getBattGroupId()}, new CallBack() {
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list = new ArrayList();
|
|---|
| | | try {
|
|---|
| | | while (rs.next()) {
|
|---|
| | | String name="未知"; //存放告警名称
|
|---|
| | | String type="未知"; //存放告警等级
|
|---|
| | | |
|---|
| | | Battalarm_data adata = new Battalarm_data();
|
|---|
| | | adata.setNum(rs.getInt("num"));
|
|---|
| | | adata.setBattGroupId(rs.getInt("battGroupId"));
|
|---|
| | | adata.setAlm_signal_id(rs.getInt("alm_signal_id"));
|
|---|
| | | adata.setMonNum(rs.getInt("monNum"));
|
|---|
| | | adata.setAlm_value(rs.getFloat("alm_value"));
|
|---|
| | | adata.setAlm_level(rs.getInt("alm_level"));
|
|---|
| | | adata.setAlm_is_confirmed(rs.getInt("alm_is_confirmed"));
|
|---|
| | | adata.setAlm_confirmed_time(rs.getTimestamp("alm_confirmed_time"));
|
|---|
| | | adata.setAlm_start_time(rs.getTimestamp("alm_start_time"));
|
|---|
| | | adata.setAlm_end_time(rs.getTimestamp("alm_end_time")); |
|---|
| | | |
|---|
| | | adata.setStationname(rs.getString("stationName"));
|
|---|
| | | adata.setBattGroupName(rs.getString("battGroupName"));
|
|---|
| | | //battinf中的StationName8，StationName9存放告警名称和等级
|
|---|
| | | name=AlarmDaoFactory.getAlarmName(adata.getAlm_signal_id());
|
|---|
| | | adata.setAlarmname(name);
|
|---|
| | | type=AlarmDaoFactory.getAlarmType(adata.getAlm_level());
|
|---|
| | | adata.setAlarmtype(type);
|
|---|
| | | list.add(adata);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | // TODO Auto-generated catch block
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | // 3.2电池告警
|
|---|
| | | /*
|
|---|
| | | * 条件所存放的位置前台：tb_batt_maint_inf
|
|---|
| | |
|---|
| | | }*/
|
|---|
| | | //List list=bimp.serchIn30(uinf);
|
|---|
| | | //System.out.println(list.size());
|
|---|
| | | int nums=bimp.searchAlarmInStation(uinf);
|
|---|
| | | System.out.println(nums);
|
|---|
| | | /*int nums=bimp.searchAlarmInStation(uinf);
|
|---|
| | | System.out.println(nums);*/
|
|---|
| | | List<Battalarm_data> list = bimp.serchByCondition_ky(binf);
|
|---|
| | | for (Battalarm_data b : list) {
|
|---|
| | | System.out.println(b);
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | }
|
|---|
