| | |
|---|
| | | //计算成绩 |
|---|
| | | int sum = examAnswerRecordList.stream().mapToInt(ExamAnswerRecord::getAnswerScore).sum(); |
|---|
| | | examScore1.setTheoryGrade(sum); |
|---|
| | | examScore1.setExamEndTime(examAnswerRecordList.get(examAnswerRecordList.size()).getAnswerTime()); |
|---|
| | | examScore.setAllGrade(Math.round(sum/2)); |
|---|
| | | if (sum>=60){ |
|---|
| | | //暂未录入实操成绩 |
|---|
| | | examScore1.setQualified(2); |
|---|
| | | }else { |
|---|
| | | examScore1.setQualified(1); |
|---|
| | | } |
|---|
| | | //更新成绩数据 |
|---|
| | | examScoreService.updateById(examScore1); |
|---|
| | | //数据同步 |
|---|
| | | String s = |
|---|
| | | "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() + |
|---|
| | | " " + "where id = " + "'" + trainingRegistration1.getId() + "';" + |
|---|
| | | "update exam_score set theory_grade = " + examScore1.getTheoryGrade() + |
|---|
| | | ",qualified = " + "'" + examScore1.getQualified() + "'" + |
|---|
| | | ",exam_end_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:dd").format(examScore.getExamEndTime()) + "'" + |
|---|
| | | ",all_grade = " + "'" + examScore.getAllGrade() + "'" + |
|---|
| | | " " + "where id = " + "'" + examScore1.getId() + "'"; |
|---|
| | | myAsyncService.FTP(s); |
|---|
| | | }else { |
|---|
| | | //理论成绩设置为0 |
|---|
| | | examScore1.setTheoryGrade(0); |
|---|
| | | examScore1.setAllGrade(0); |
|---|
| | | //不合格 |
|---|
| | | examScore1.setQualified(1); |
|---|
| | | //更新成绩数据 |
|---|
| | | examScoreService.updateById(examScore1); |
|---|
| | | //数据同步 |
|---|
| | | String s = |
|---|
| | | "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() + |
|---|
| | | " " + "where id = " + "'" + trainingRegistration1.getId() + "';" + |
|---|
| | | "update exam_score set theory_grade = " + examScore1.getTheoryGrade() + |
|---|
| | | ",qualified = " + "'" + examScore1.getQualified() + "'" + |
|---|
| | | ",all_grade = " + "'" + examScore.getAllGrade() + "'" + |
|---|
| | | " " + "where id = " + "'" + examScore1.getId() + "'"; |
|---|
| | | myAsyncService.FTP(s); |
|---|
| | | } |
|---|
| | | //更新成绩数据 |
|---|
| | | examScoreService.updateById(examScore1); |
|---|
| | | |
|---|
| | | //数据同步 |
|---|
| | | String s = |
|---|
| | | "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() + |
|---|
| | | " " + "where id = " + "'" + trainingRegistration1.getId() + "';" + |
|---|
| | | "update exam_score set theory_grade = " + examScore1.getTheoryGrade() + |
|---|
| | | ",qualified = " + "'" + examScore1.getQualified() + "'" + |
|---|
| | | " " + "where id = " + "'" + examScore1.getId() + "'"; |
|---|
| | | myAsyncService.FTP(s); |
|---|
| | | }); |
|---|
| | | }else { |
|---|
| | | //数据同步 |
|---|
