| | |
| | | @Autowired |
| | | private RmAutoReportHistoryMapper rmAutoReportHistoryMapperDao ;//控制器历史上报数据DAO |
| | | |
| | | @Autowired |
| | | @Lazy |
| | | private DbSv sv ; |
| | | |
| | | //@Autowired |
| | | //@Lazy |
| | | //private DbSv sv ; |
| | | |
| | | /** |
| | | * 通过控制器地址从数据库表中查询控制器 |
| | | * @param rtuAddr 控制器地址 |
| | | * @return 控制器 |
| | | */ |
| | | public PrController getPrControllerByRtuAddr(String rtuAddr){ |
| | | public PrController getControllersByRtuAddrAndIntakeNotNull(String rtuAddr){ |
| | | List<PrController> list = this.prControllerMapperDao.getControllersByRtuAddrAndIntakeNotNull(rtuAddr) ; |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | |
| | | private void saveOrUpdateLast(DbSv sv, PrController controller, String rtuAddr, DataAlarmVo alarmVo, DataStateVo stateVo){ |
| | | RmAlarmStateLast po = sv.getRmLastAlarmState(rtuAddr) ; |
| | | if(po == null){ |
| | | po = new RmAlarmStateLast(null, controller==null?null:controller.getId(), controller.getId(), |
| | | po = new RmAlarmStateLast(null, controller==null?null:controller.getId(), controller==null?null:controller.getIntakeId(), |
| | | rtuAddr, |
| | | new Date(), |
| | | alarmVo==null?null:alarmVo.batteryVolt, alarmVo==null?null:alarmVo.loss, alarmVo==null?null:alarmVo.meter, alarmVo==null?null:alarmVo.valve, |
| | |
| | | * @param stateVo 状态对象 |
| | | */ |
| | | private void saveHistory(DbSv sv, PrController controller, String rtuAddr, DataAlarmVo alarmVo, DataStateVo stateVo){ |
| | | RmAlarmStateHistory po = new RmAlarmStateHistory(null, controller==null?null:controller.getId(), controller.getId(), |
| | | RmAlarmStateHistory po = new RmAlarmStateHistory(null, controller==null?null:controller.getId(), controller==null?null:controller.getIntakeId(), |
| | | rtuAddr, |
| | | new Date(), |
| | | alarmVo==null?null:alarmVo.batteryVolt, alarmVo==null?null:alarmVo.loss, alarmVo==null?null:alarmVo.meter, alarmVo==null?null:alarmVo.valve, |
| | |
| | | |
| | | |
| | | private RmAlarmStateLast update(PrController controller, RmAlarmStateLast po, DataAlarmVo alarmVo, DataStateVo stateVo){ |
| | | if(controller != null){ |
| | | po.controllerid = controller.getId() ; |
| | | } |
| | | po.controllerid = controller==null?null:controller.getId() ; |
| | | |
| | | po.dt = new Date() ; |
| | | if(alarmVo != null){ |
| | | po.bateryvolt = alarmVo.batteryVolt ; |
| | |
| | | private void saveOrUpdateLast(DbSv sv, PrController controller, String rtuAddr, DataCdC0Vo dataCdC0Vo) throws Exception { |
| | | RmAutoReportLast po = sv.getRmLastAutoReport(rtuAddr) ; |
| | | if(po == null){ |
| | | po = new RmAutoReportLast(null, controller.getId(), controller.getId(), |
| | | po = new RmAutoReportLast(null, controller==null?null:controller.getId(), controller==null?null:controller.getId(), |
| | | rtuAddr, |
| | | new Date(), |
| | | DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCdC0Vo.rtuDt), |
| | |
| | | * @param dataCdC0Vo 自报数据对象 |
| | | */ |
| | | private void saveHistory(DbSv sv, PrController controller, String rtuAddr, DataCdC0Vo dataCdC0Vo) throws Exception { |
| | | RmAutoReportHistory po = new RmAutoReportHistory(null, controller.getId(), controller.getId(), |
| | | RmAutoReportHistory po = new RmAutoReportHistory(null, controller==null?null:controller.getId(), controller==null?null:controller.getIntakeId(), |
| | | rtuAddr, |
| | | new Date(), |
| | | DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCdC0Vo.rtuDt), |
| | |
| | | String rtuAddr = d.getRtuAddr() ;//TkRtuData里判断了rtuAddr为空 |
| | | DbSv sv = (DbSv)SpringContextUtil.getBean(DbSv.class) ; |
| | | if(sv != null){ |
| | | PrController controller = sv.getPrControllerByRtuAddr(rtuAddr) ; |
| | | PrController controller = sv.getControllersByRtuAddrAndIntakeNotNull(rtuAddr) ; |
| | | if(controller == null){ |
| | | //数据库中未查询到控制器(RTU实体) |
| | | //数据库中未查询(已经绑定且控制器地址相符)到控制器(RTU实体) |
| | | //流浪者控制器 |
| | | PrControllerTramp rtuTramp = sv.getPrControllerTrampByRtuAddr(rtuAddr); |
| | | if(rtuTramp == null){ |