| | |
| | | @Autowired |
| | | private RmOnHourReportLastMapper rmOnHourReportLastDao; // 整点上报最新数据DAO |
| | | |
| | | @Autowired |
| | | private RmOpenCloseHistoryMapper rmOpenCloseHistoryDao; |
| | | @Autowired |
| | | private RmOpenCloseLastMapper rmOpenCloseLastDao; |
| | | |
| | | //@Autowired |
| | | //@Lazy |
| | | //private DbSv sv ; |
| | |
| | | //////////////////////////////////////////////// |
| | | /** |
| | | * 得到控制器报警与状态最新记录 |
| | | * @param rtuAddr |
| | | * @param intakeId |
| | | * @return |
| | | */ |
| | | public RmAlarmStateLast getRmAlarmStateLast(String rtuAddr){ |
| | | List<RmAlarmStateLast> list = rmAlarmStateLastMapperDao.selectByRtuAddr(rtuAddr) ; |
| | | public RmAlarmStateLast getRmAlarmStateLast(Long intakeId){ |
| | | List<RmAlarmStateLast> list = rmAlarmStateLastMapperDao.selectByIntakeId(intakeId) ; |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | | } |
| | |
| | | |
| | | /** |
| | | * 根据阀控器地址获取定点上报最新数据 |
| | | * @param rtuAddr |
| | | * @param intakeId |
| | | * @return |
| | | */ |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public RmTimingReportLast getRmTimingReportLast(String rtuAddr) { |
| | | List<RmTimingReportLast> list = this.rmTimingReportLastDao.getRmTimingReportLast(rtuAddr) ; |
| | | public RmTimingReportLast getRmTimingReportLast(Long intakeId) { |
| | | List<RmTimingReportLast> list = this.rmTimingReportLastDao.getRmTimingReportLast(intakeId) ; |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | | } |
| | |
| | | |
| | | /** |
| | | * 根据阀控器地址获取整点上报最新数据 |
| | | * @param rtuAddr |
| | | * @param intakeId |
| | | * @return |
| | | */ |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public RmOnHourReportLast getRmOnHourReportLast(String rtuAddr) { |
| | | List<RmOnHourReportLast> list = this.rmOnHourReportLastDao.getRmOnHourReportLast(rtuAddr) ; |
| | | public RmOnHourReportLast getRmOnHourReportLast(Long intakeId) { |
| | | List<RmOnHourReportLast> list = this.rmOnHourReportLastDao.getRmOnHourReportLast(intakeId) ; |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | | } |
| | |
| | | //////////////////////////////////////////////// |
| | | /** |
| | | * 得到控制器开关阀上报数据最新记录 |
| | | * @param rtuAddr |
| | | * @param intakeId |
| | | * @return |
| | | */ |
| | | public RmOpenCloseValveLast getRmOpenCloseValveLast(String rtuAddr){ |
| | | List<RmOpenCloseValveLast> list = rmOpenCloseValveLastMapperDao.selectByRtuAddr(rtuAddr) ; |
| | | public RmOpenCloseValveLast getRmOpenCloseValveLast(Long intakeId){ |
| | | List<RmOpenCloseValveLast> list = rmOpenCloseValveLastMapperDao.selectByIntakeId(intakeId) ; |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | | } |
| | |
| | | this.rmOpenCloseValveHistoryMapperDao.updateByPrimaryKeySelective(po) ; |
| | | } |
| | | |
| | | /** |
| | | * 保存控制器开关阀上报数据最新记录(202404) |
| | | * @param po |
| | | */ |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public void saveRmOpenCloseLast(RmOpenCloseLast po){ |
| | | this.rmOpenCloseLastDao.insert(po) ; |
| | | } |
| | | |
| | | /** |
| | | * 保存控制器开关阀上报数据历史记录(202404) |
| | | * @param po |
| | | */ |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public void saveRmOpenCloseHistory(RmOpenCloseHistory po){ |
| | | this.rmOpenCloseHistoryDao.insert(po) ; |
| | | } |
| | | |
| | | /** |
| | | * 得到控制器开关阀上报数据最新记录(202404) |
| | | * @param rtuAddr |
| | | * @return |
| | | */ |
| | | public RmOpenCloseLast getRmOpenCloseLast(String rtuAddr){ |
| | | List<RmOpenCloseLast> list = rmOpenCloseLastDao.getRmOpenCloseReportLast(rtuAddr); |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | | } |
| | | return null ; |
| | | } |
| | | |
| | | /** |
| | | * 保存控制器开关阀上报数据最新记录(202404) |
| | | * @param po |
| | | */ |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public void updateRmOpenCloseLast(RmOpenCloseLast po){ |
| | | this.rmOpenCloseLastDao.updateByPrimaryKeySelective(po); |
| | | } |
| | | |
| | | ///////////////////////////////////////////////// |
| | | // |
| | | // 工作报数据功能 |
| | |
| | | //////////////////////////////////////////////// |
| | | /** |
| | | * 得到控制器上报数据最新记录 |
| | | * @param rtuAddr |
| | | * @param intakeId |
| | | * @return |
| | | */ |
| | | public RmWorkReportLast getRmWorkReportLast(String rtuAddr){ |
| | | List<RmWorkReportLast> list = rmWorkReportLastMapperDao.selectByRtuAddr(rtuAddr) ; |
| | | public RmWorkReportLast getRmWorkReportLast(Long intakeId){ |
| | | List<RmWorkReportLast> list = rmWorkReportLastMapperDao.selectByIntakeId(intakeId) ; |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | | } |
| | |
| | | //////////////////////////////////////////////// |
| | | /** |
| | | * 得到控制器漏损水量统计最新记录 |
| | | * @param rtuAddr |
| | | * @param intakeId |
| | | * @return |
| | | */ |
| | | public RmLossLast getRmLossLast(String rtuAddr){ |
| | | List<RmLossLast> list = rmLossLastMapperDao.selectByRtuAddr(rtuAddr) ; |
| | | public RmLossLast getRmLossLast(Long intakeId){ |
| | | List<RmLossLast> list = rmLossLastMapperDao.selectByIntakeId(intakeId) ; |
| | | if(list != null && list.size() > 0){ |
| | | return list.get(0) ; |
| | | } |