| | |
| | | * @param dataCd83OpenVo 开阀上报数据对象 |
| | | */ |
| | | private void doDeal(DbSv sv, PrController controller, String rtuAddr, DataV1_0_1 dV1_0_1, DataCd83OpenVo dataCd83OpenVo) throws Exception { |
| | | RmOpenCloseValveLast poLast = sv.getRmOpenCloseValveLast(rtuAddr) ; |
| | | RmOpenCloseValveLast poLast = sv.getRmOpenCloseValveLast(controller.getIntakeId()) ; |
| | | if(poLast == null){ |
| | | //数据库中不存在该控制器的开关阀数据 |
| | | //首先生成开关阀的最新数据及历史数据,并先保存 |
| | |
| | | sv.saveRmOpenCloseValveLast(poLast); |
| | | }else{ |
| | | //数据库中存在该控制器的开关阀数据 |
| | | if(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt).equals(poLast.openDt)){ |
| | | //时间一致,重复上报数据,不进行任何处理 |
| | | }else{ |
| | | if(poLast.opType != null){ |
| | | //原记录存在开阀数据,首先进行时间对比 |
| | | if(poLast.openDt != null && poLast.openDt.after(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //补报的许久之前的开阀数据,不进行处理 |
| | | }else if(poLast.openDt != null && poLast.openDt.equals(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //重复上报的开阀数据,不进行处理 |
| | | }else{ |
| | | //当前开阀上报是新的一次开阀,不管原记录是否存在关阀数据,一律清空关阀数据 |
| | | this.updateOpenValve(controller, poLast, null, dV1_0_1, dataCd83OpenVo, true) ; |
| | | //生成并保存新的开阀上报历史数据记录 |
| | | this.newHistoryDataDeal(sv, controller, rtuAddr, dV1_0_1, dataCd83OpenVo, poLast); |
| | | } |
| | | }else if(poLast.clType != null){ |
| | | //原记录不存在开阀数据,但存在关阀数据,首先进行时间比对 |
| | | if(poLast.closeDt != null && poLast.closeDt.after(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //当前上报是补报的开阀数据 |
| | | RmOpenCloseValveHistory poHistory = null ; |
| | | if(poLast.lastHistoryId != null){ |
| | | poHistory = sv.getRmOpenCloseValveHistory(poLast.lastHistoryId) ; |
| | | } |
| | | this.updateOpenValve(controller, poLast, poHistory, dV1_0_1, dataCd83OpenVo, false) ; |
| | | if(poHistory != null){ |
| | | sv.updateRmOpenCloseValveHistory(poHistory); |
| | | } |
| | | }else if(poLast.closeDt != null && poLast.closeDt.before(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //当前上报是新的开阀数据,把最新数据中的关阀内容清空 |
| | | this.updateOpenValve(controller, poLast, null, dV1_0_1, dataCd83OpenVo, true) ; |
| | | //生成并保存新的开阀上报历史数据记录 |
| | | this.newHistoryDataDeal(sv, controller, rtuAddr, dV1_0_1, dataCd83OpenVo, poLast); |
| | | }else { |
| | | //当前上报的开阀数据与原来的关阀数据同一时间,这种情况应该不存在,但也处理 |
| | | RmOpenCloseValveHistory poHistory = null ; |
| | | if(poLast.lastHistoryId != null){ |
| | | poHistory = sv.getRmOpenCloseValveHistory(poLast.lastHistoryId) ; |
| | | } |
| | | this.updateOpenValve(controller, poLast, poHistory, dV1_0_1, dataCd83OpenVo, false) ; |
| | | if(poHistory != null){ |
| | | sv.updateRmOpenCloseValveHistory(poHistory); |
| | | } |
| | | } |
| | | if(poLast.opType != null){ |
| | | //原记录存在开阀数据,首先进行时间对比 |
| | | if(poLast.openDt != null && poLast.openDt.after(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //补报的许久之前的开阀数据,不进行处理 |
| | | }else if(poLast.openDt != null && poLast.openDt.equals(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //重复上报的开阀数据,不进行处理 |
| | | }else{ |
| | | //if(po.clType == null) |
| | | //原记录不存在开阀数据也不存在关阀数据,这种情况不存在,但为安全也进行处理 |
| | | //当前开阀上报是新的一次开阀,不管原记录是否存在关阀数据,一律清空关阀数据 |
| | | this.updateOpenValve(controller, poLast, null, dV1_0_1, dataCd83OpenVo, true) ; |
| | | //生成并保存新的开阀上报历史数据记录 |
| | | this.newHistoryDataDeal(sv, controller, rtuAddr, dV1_0_1, dataCd83OpenVo, poLast); |
| | | } |
| | | |
| | | sv.updateRmOpenCloseValveLast(poLast); |
| | | }else if(poLast.clType != null){ |
| | | //原记录不存在开阀数据,但存在关阀数据,首先进行时间比对 |
| | | if(poLast.clOpenDt != null && poLast.clOpenDt.after(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //补报的许久之前的开阀报数据,不进行处理 |
| | | }else if(poLast.clOpenDt != null && poLast.clOpenDt.before(DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt))){ |
| | | //当前上报是新的开阀数据,把最新(last)数据中的关阀内容清空 |
| | | this.updateOpenValve(controller, poLast, null, dV1_0_1, dataCd83OpenVo, true) ; |
| | | //生成并保存新的开阀上报历史数据记录 |
| | | this.newHistoryDataDeal(sv, controller, rtuAddr, dV1_0_1, dataCd83OpenVo, poLast); |
| | | }else { |
| | | //当前上报的开阀数据与原来的关阀数据同一时间,这种情况应该不存在,但也处理 |
| | | RmOpenCloseValveHistory poHistory = null ; |
| | | if(poLast.lastHistoryId != null){ |
| | | poHistory = sv.getRmOpenCloseValveHistory(poLast.lastHistoryId) ; |
| | | } |
| | | this.updateOpenValve(controller, poLast, poHistory, dV1_0_1, dataCd83OpenVo, false) ; |
| | | if(poHistory != null){ |
| | | sv.updateRmOpenCloseValveHistory(poHistory); |
| | | } |
| | | } |
| | | }else{ |
| | | //if(poLast.opType == null && po.clType == null) |
| | | //原记录不存在开阀数据也不存在关阀数据,这种情况不存在,但为安全也进行处理 |
| | | this.updateOpenValve(controller, poLast, null, dV1_0_1, dataCd83OpenVo, true) ; |
| | | //生成并保存新的开阀上报历史数据记录 |
| | | this.newHistoryDataDeal(sv, controller, rtuAddr, dV1_0_1, dataCd83OpenVo, poLast); |
| | | } |
| | | |
| | | sv.updateRmOpenCloseValveLast(poLast); |
| | | } |
| | | } |
| | | |
| | |
| | | * @throws Exception |
| | | */ |
| | | private RmOpenCloseValveLast newRmOpenCloseValveLast(PrController controller, String rtuAddr, DataV1_0_1 dV1_0_1, DataCd83OpenVo dataCd83OpenVo)throws Exception { |
| | | RmOpenCloseValveLast po = new RmOpenCloseValveLast(null, null, controller==null?null:controller.getId(), controller==null?null:controller.getIntakeId(), |
| | | rtuAddr, |
| | | DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dV1_0_1.dt), |
| | | dataCd83OpenVo.type, |
| | | dataCd83OpenVo.totalAmount, |
| | | dataCd83OpenVo.icCardNo, |
| | | dataCd83OpenVo.icCardAddr, |
| | | dataCd83OpenVo.remainMoney, |
| | | DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt), |
| | | null, null, null, null, null, null, null, null, null, null, null) ; |
| | | RmOpenCloseValveLast po = new RmOpenCloseValveLast() ; |
| | | po.controllerId = controller==null?null:controller.getId() ; |
| | | po.intakeId = controller==null?null:controller.getIntakeId() ; |
| | | po.rtuAddr = rtuAddr ; |
| | | po.valueFrom(dV1_0_1, dataCd83OpenVo); |
| | | return po ; |
| | | } |
| | | |
| | |
| | | * @throws Exception |
| | | */ |
| | | private RmOpenCloseValveHistory newRmOpenCloseValveHistory(PrController controller, String rtuAddr, DataV1_0_1 dV1_0_1, DataCd83OpenVo dataCd83OpenVo)throws Exception { |
| | | RmOpenCloseValveHistory po = new RmOpenCloseValveHistory(null, controller==null?null:controller.getId(), controller==null?null:controller.getIntakeId(), |
| | | rtuAddr, |
| | | DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dV1_0_1.dt), |
| | | dataCd83OpenVo.type, |
| | | dataCd83OpenVo.totalAmount, |
| | | dataCd83OpenVo.icCardNo, |
| | | dataCd83OpenVo.icCardAddr, |
| | | dataCd83OpenVo.remainMoney, |
| | | DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt), |
| | | null, null, null, null, null, null, null, null, null, null, null) ; |
| | | RmOpenCloseValveHistory po = new RmOpenCloseValveHistory() ; |
| | | po.controllerId = controller==null?null:controller.getId() ; |
| | | po.intakeId = controller==null?null:controller.getIntakeId() ; |
| | | po.rtuAddr = rtuAddr ; |
| | | po.valueFrom(dV1_0_1, dataCd83OpenVo); |
| | | return po ; |
| | | } |
| | | |
| | |
| | | private void updateOpenValve(PrController controller, RmOpenCloseValveLast poLast, RmOpenCloseValveHistory poHistory, DataV1_0_1 dV1_0_1, DataCd83OpenVo dataCd83OpenVo, boolean clearCloseValve) throws Exception { |
| | | poLast.controllerId = controller==null?null:controller.getId(); |
| | | poLast.intakeId = controller==null?null:controller.getIntakeId(); |
| | | |
| | | poLast.opDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dV1_0_1.dt); |
| | | poLast.opType = dataCd83OpenVo.type ; |
| | | poLast.opTotalAmount = dataCd83OpenVo.totalAmount ; |
| | | poLast.opIcCardNo = dataCd83OpenVo.icCardNo ; |
| | | poLast.opIcCardAddr = dataCd83OpenVo.icCardAddr ; |
| | | poLast.opRemainMoney = dataCd83OpenVo.remainMoney ; |
| | | poLast.openDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataCd83OpenVo.openDt) ; |
| | | poLast.updateFrom(dV1_0_1, dataCd83OpenVo, clearCloseValve); |
| | | |
| | | if(poHistory != null){ |
| | | poHistory.controllerId = controller==null?null:controller.getId(); |
| | | poHistory.intakeId = controller==null?null:controller.getIntakeId(); |
| | | |
| | | poHistory.opDt = poLast.opDt; |
| | | poHistory.opType = dataCd83OpenVo.type ; |
| | | poHistory.opTotalAmount = dataCd83OpenVo.totalAmount ; |
| | | poHistory.opIcCardNo = dataCd83OpenVo.icCardNo ; |
| | | poHistory.opIcCardAddr = dataCd83OpenVo.icCardAddr ; |
| | | poHistory.opRemainMoney = dataCd83OpenVo.remainMoney ; |
| | | poHistory.openDt = poLast.openDt ; |
| | | poHistory.updateFrom(dV1_0_1, dataCd83OpenVo, clearCloseValve); |
| | | } |
| | | |
| | | if(clearCloseValve){ |
| | | poLast.clDt = null ; |
| | | poLast.clType = null ; |
| | | poLast.clTotalAmount = null ; |
| | | poLast.clIcCardNo = null ; |
| | | poLast.clIcCardAddr = null ; |
| | | poLast.clRemainMoney = null ; |
| | | poLast.clThisAmount = null ; |
| | | poLast.clThisMoney = null ; |
| | | poLast.clThisTime = null ; |
| | | poLast.clOpenDt = null ; |
| | | poLast.closeDt = null ; |
| | | |
| | | if(poHistory != null) { |
| | | poHistory.clDt = null; |
| | | poHistory.clType = null; |
| | | poHistory.clTotalAmount = null; |
| | | poHistory.clIcCardNo = null; |
| | | poHistory.clIcCardAddr = null; |
| | | poHistory.clRemainMoney = null; |
| | | poHistory.clThisAmount = null; |
| | | poHistory.clThisMoney = null; |
| | | poHistory.clThisTime = null; |
| | | poHistory.clOpenDt = null; |
| | | poHistory.closeDt = null; |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | | } |