培训考试生成修改

Administrator

2021-09-14 183006b4732a104a439f26fbbfb116b00668ddd1

培训考试生成修改

 src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java

@@ -564,18 +564,22 @@
                examPaper.setExamName(examName);
                //待审核
                examPaper.setAuditStatus(3);
                //创建时间
                examPaper.setCreatorDate(new Date());
                //生成考试
                examPaperService.save(examPaper);

                Long sid = examPaper.getId();
                String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getStartTime());
                String endTimeFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getEndTime());
                String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time,end_time,audit_status) " +
                String creatorTimeFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPaper.getCreatorDate());
                String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time,end_time,creator_date,audit_status) " +
                    "values(" + "'" + sid + "'" +
                    "," + "'" + examPaper.getExamName() + "'" +
                    "," + "'" + examPaper.getExamType() +"'" +
                    "," + "'" + format +"'" +
                    "," + "'" + endTimeFormat +"'" +
                    "," + "'" + creatorTimeFormat +"'" +
                    ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
                FtpUtil.sqlFileUpload(s);