| | |
| | | if (needCreateFlag) { |
| | | //生成工单 ,将参数信息备份 |
| | | PredictiveWorkOrder predictiveWorkOrder = this.createOrder(predictiveWorkPlan.getId(), predictiveWorkPlan.getEquipmentId()); |
| | | if(predictiveWorkOrder != null){ |
| | | this.backInfo(predictiveWorkPlan.getId(), predictiveWorkOrder.getId(),predictiveWorkPlanParameterList); |
| | | if (predictiveWorkOrder != null) { |
| | | this.backInfo(predictiveWorkPlan.getId(), predictiveWorkOrder.getId(), predictiveWorkPlanParameterList); |
| | | } |
| | | |
| | | } |
| | |
| | | @Override |
| | | public void removeByWorkPlanId(String predictiveWorkPlanId) { |
| | | LambdaUpdateChainWrapper<PredictiveWorkPlanParameter> lambdaUpdate = this.lambdaUpdate(); |
| | | lambdaUpdate.eq(PredictiveWorkPlanParameter::getWorkPlanId,predictiveWorkPlanId); |
| | | lambdaUpdate.eq(PredictiveWorkPlanParameter::getWorkPlanId, predictiveWorkPlanId); |
| | | lambdaUpdate.remove(); |
| | | } |
| | | |
| | | @Override |
| | | public void revise(String oldWorkPlanId, String workPlanId) { |
| | | LambdaQueryChainWrapper<PredictiveWorkPlanParameter> lambdaQuery = this.lambdaQuery(); |
| | | lambdaQuery.eq(PredictiveWorkPlanParameter::getWorkPlanId,oldWorkPlanId).eq(PredictiveWorkPlanParameter::getDelFlag,0); |
| | | lambdaQuery.eq(PredictiveWorkPlanParameter::getWorkPlanId, oldWorkPlanId).eq(PredictiveWorkPlanParameter::getDelFlag, 0); |
| | | List<PredictiveWorkPlanParameter> insertList = lambdaQuery.list(); |
| | | for(PredictiveWorkPlanParameter predictiveWorkPlanParameter:insertList){ |
| | | for (PredictiveWorkPlanParameter predictiveWorkPlanParameter : insertList) { |
| | | predictiveWorkPlanParameter.setWorkPlanId(workPlanId); |
| | | predictiveWorkPlanParameter.setId(UUIDGenerator.generate()); |
| | | } |
| | |
| | | return predictiveWorkOrder; |
| | | } |
| | | |
| | | private void backInfo(String workPlanId,String workOrderId, List<PredictiveWorkPlanParameter> predictiveWorkPlanParameterList) { |
| | | private void backInfo(String workPlanId, String workOrderId, List<PredictiveWorkPlanParameter> predictiveWorkPlanParameterList) { |
| | | List<PredictiveWorkPlanParameterHistory> list = new ArrayList<>(); |
| | | for (PredictiveWorkPlanParameter predictiveWorkPlanParameter : predictiveWorkPlanParameterList) { |
| | | PredictiveWorkPlanParameterHistory predictiveWorkPlanParameterHistory = new PredictiveWorkPlanParameterHistory(); |
| | |
| | | } |
| | | |
| | | private ParameterVo findParameterInfo(String saveTableName, float lowerLimitValue, float upperLimitValue, String parameterCode) { |
| | | return this.getBaseMapper().findParameterInfo(saveTableName, lowerLimitValue, upperLimitValue, parameterCode); |
| | | // String temp = "[" + saveTableName + "]"; |
| | | // return this.getBaseMapper().findParameterInfo(temp, lowerLimitValue, upperLimitValue, parameterCode); |
| | | Integer lowerLimitValueInt = (int) lowerLimitValue; |
| | | Integer upperLimitValueInt = (int)upperLimitValue; |
| | | String sql = "SELECT TOP 1 " + |
| | | " t1.CollectTime collectTime, " + |
| | | " t1." + parameterCode + " actualValue " + |
| | | " FROM " + |
| | | " [" + saveTableName + "] t1 " + |
| | | " WHERE " + |
| | | " t1." + parameterCode + " < " + lowerLimitValueInt + |
| | | " OR t1." + parameterCode + " > " + upperLimitValueInt + |
| | | " ORDER BY " + |
| | | " t1.CollectTime DESC"; |
| | | return this.getBaseMapper().findCommonParameterInfo(sql); |
| | | } |
| | | |
| | | private List<PredictiveWorkPlanParameter> listParameter(String predictiveWorkPlanId) { |