培训审核查询修改

Administrator

2021-09-29 7c9742190965b22f4ea3864aa8588fad19e0be58

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

@@ -562,6 +562,7 @@
            int day = instance.get(Calendar.DAY_OF_MONTH);
            String examName = year + "年" + month+ "月"+ day +"日" +"保安员证培训考试";
            examPaper.setExamName(examName);
            examPaper.setCreator(trainingRegistrationVo.getCreator());
            //待审核
            examPaper.setAuditStatus(3);
            //创建时间
@@ -573,12 +574,13 @@
            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 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) " +
            String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time,end_time,creator,creator_date,audit_status) " +
               "values(" + "'" + sid + "'" +
               "," + "'" + examPaper.getExamName() + "'" +
               "," + "'" + examPaper.getExamType() +"'" +
               "," + "'" + format +"'" +
               "," + "'" + endTimeFormat +"'" +
               "," + "'" + examPaper.getCreator() +"'" +
               "," + "'" + creatorTimeFormat +"'" +
               ","  +"'" + examPaper.getAuditStatus() + "'" + ")";
            FtpUtil.sqlFileUpload(s);