解析程度

whyclxw

2024-10-18 9aaf443fe1cb5ae2ca9fb85a755aaf2eceb6b60c

解析程度

 src/main/java/com/whyc/service/AnaysiService.java

@@ -33,7 +33,7 @@
    @Autowired(required = false)
    private BatttestdataInfService tinfService;

    public static int precent=0;



    //预估数据
@@ -43,10 +43,8 @@
        //1.查出需要预估的数据
        List<AnaysisData> list=subService.getAnaysisData(battGroupId,testRecordCount);
        String excelName="测试数据"+"_"+battGroupId+"_"+testRecordCount+".xlsx";
        precent=1;
        //2.生成解析的xls
        String root=exportDataToXls(uid,excelName,list);
        precent=2;
        String voltagePredictExePath=root+ File.separator+"10小时率电压预估\\voltage_predict_process\\main.exe";
        String excelOutPutPath=root+ File.separator+"analysis"+File.separator+uid+ File.separator+"outPath"+File.separator+battGroupId+File.separator+testRecordCount;
        String excelSourcePath=root+ File.separator+"analysis"+File.separator+uid+File.separator+excelName;
@@ -70,13 +68,10 @@
            if(insertFlag!=0){
                //3.生成预估的文件xls
                AnalysisUtil.analysisXlx(excelSourcePath,voltagePredictExePath,excelOutPutPath);
                precent=3;
                //补前面的数据
                subService.insertBeforeData(battGroupId,testRecordCount,list);
                precent=4;
                storeAnaysisToSql(battGroupId,testRecordCount,recordNum,excelOutPutPath,insertFlag);
            }
            precent++;
        }
        return voltagePredictExePath;
    }
@@ -99,12 +94,10 @@
                        List<AnaylsisId> idList=anaysisFileByNum(monNum,testRecordCount,recordNum,excelSourcePath+File.separator+fileName);
                        //将解析出的数据存入数据库表
                        subService.storeAnaysisToSqlWithNum(battGroupId,testRecordCount,idList);
                        precent++;
                    }
                }
                //将解析的组端电压修改到数据库
                subService.updateAnaysisToSqlWithNum(battGroupId,testRecordCount,groupVolList);
                precent++;
            }
        }
    }
@@ -369,6 +362,7 @@
    }
    //查询当前Ai解析数据的程度
    public Response getAnalysisSocket(AnalysisDto dto) {
        int precent=AnalysisUtil.getPrecent();
        //1.检测是否存在数据
        int sum=subService.getAnaysisIdByTestRecordCount(dto.getBattGroupId(),dto.getTestRecordCount());
        if(sum==0){

 src/main/java/com/whyc/util/AnalysisUtil.java

@@ -13,6 +13,8 @@
    public  static String excelOutPutPath="E:\\GitWorkSpace\\fg_v2.0\\target\\outPath";
    public  static String excelSourcePath="E:\\GitWorkSpace\\fg_v2.0\\target\\测试数据.xlsx";

    public static int precent=0;

    public static void analysisXlx(String excelSourcePath, String voltagePredictExePath, String excelOutPutPath){
        Process mProcess;
        BufferedReader successResult = null;
@@ -36,6 +38,7 @@
            while ((s = successResult.readLine()) != null) {
                if ((s.length() > 0) && !"\n".equals(s)) {
                    System.out.println(String.format("SuccessMsg：%s", s));
                    precent++;
                }
            }
            while ((s = errorResult.readLine()) != null) {
@@ -70,7 +73,12 @@
        }
    }

    public static int getPrecent(){
        return precent;
    }

    public static void main(String[] args) {
        analysisXlx(excelSourcePath,voltagePredictExePath,excelOutPutPath);
    }

}