预测性维护方案生成工单bug修改

“linengliang”

2023-09-19 8aa74635a762bbb5a49253b055eb69db5ebaab2d

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/PredictiveWorkPlanParameterServiceImpl.java

@@ -150,7 +150,21 @@
    }

    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) {