新增数据同步方式及配置，当选择为sql时则为数据库直连同步，全局替换所有的同步方法，用户修改，离职，注销修改调整，文件上传去除同步推送上传

zhongrj

2022-08-22 3c607f075990d6d3238daa7db1c68eaae8126424

 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java

@@ -184,10 +184,10 @@
               "update sys_apply set is_exam = " + apply1.getIsExam() + " " + "where id = " + "'" + apply1.getId() + "';" +
                  "update blade_user set is_apply = " + user.getIsApply() + " " + "where id = " + "'" + user.getId() + "'";
            //FtpUtil.sqlFileUpload(s);
            myAsyncService.FTP(s);
            myAsyncService.dataSync(s);

         }
         //模拟考试
         //培训考试
         if (paper.getExamType() == 2) {
            TrainingRegistration trainingRegistration = new TrainingRegistration();
            trainingRegistration.setCandidateNo(examScore.getCandidateNo());
@@ -208,9 +208,10 @@
               "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() + " " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
                  "update blade_user set is_train = " + user.getIsTrain() + " " + "where id = " + "'" + user.getId() + "'";
            //FtpUtil.sqlFileUpload(s);
            myAsyncService.FTP(s);
            myAsyncService.dataSync(s);
         }

         //设置提交时间
         examScore.setExamEndTime(new Date());
         //设置考试ID
         examScore.setExamId(examScore.getPapersId().toString());
         //设置理论得分
@@ -239,7 +240,7 @@
               ",qualified = " + "'" + examScore.getQualified() + "'" +
               " " + "where id = " + "'" + examScore.getId() + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.FTP(s1);
         myAsyncService.dataSync(s1);

         if (i > 0) {
            //返回结果
@@ -329,6 +330,7 @@
                                 securityPaper.setPeopleName(user.getRealName());
                                 securityPaper.setExamId(Long.parseLong(examScore.getExamId()));
                                 securityPaper.setApplyId(examScore.getApplyId());
                                 securityPaper.setSource(1);
                                 //新增保安员证信息
                                 securityPaperService.save(securityPaper);

@@ -355,7 +357,7 @@
//                                       ",user_type = " + "'" + user.getUserType() + "'" +
//                                       " " + "where id = " + "'" + user.getId() + "'";
                                 //FtpUtil.sqlFileUpload(s1);
                                 myAsyncService.FTP(s1);
                                 myAsyncService.dataSync(s1);
                              }
                           }
                        } else {
@@ -386,7 +388,7 @@
                              ",qualified = " + "'" + examScore.getQualified() + "'" +
                              " " + "where id = " + "'" + examScore.getId() + "'";
                        //FtpUtil.sqlFileUpload(s1);
                        myAsyncService.FTP(s1);
                        myAsyncService.dataSync(s1);
                        //更新成绩数据
                        baseMapper.updateById(examScore);
                     } else {
@@ -655,7 +657,7 @@
                     " " + "where id = " + "'" + user.getId() + "';" +
                     "delete from exam_score where id = " + "'" + updateParamVo.getScoreId() + "'";
               //FtpUtil.sqlFileUpload(s1);
               myAsyncService.FTP(s1);
               myAsyncService.dataSync(s1);

               return true;
            }
@@ -686,7 +688,7 @@
                     " " + "where id = " + "'" + user.getId() + "';" +
                     "delete from exam_score where id = " + "'" + updateParamVo.getScoreId() + "'";
               //FtpUtil.sqlFileUpload(s1);
               myAsyncService.FTP(s1);
               myAsyncService.dataSync(s1);

               return true;
            }
@@ -818,7 +820,7 @@
         "update sys_training_registration set is_exam = " + trainingRegistration1.getIsExam() + " " + "where id = " + "'" + trainingRegistration1.getId() + "';" +
            "update blade_user set is_train = " + user.getIsTrain() + " " + "where id = " + "'" + user.getId() + "'";
      //FtpUtil.sqlFileUpload(s);
      myAsyncService.FTP(s);
      myAsyncService.dataSync(s);

      //设置理论得分
      score.setTheoryGrade(count);
@@ -846,7 +848,7 @@
            ",qualified = " + "'" + score.getQualified() + "'" +
            " " + "where id = " + "'" + score.getId() + "'";
      //FtpUtil.sqlFileUpload(s1);
      myAsyncService.FTP(s1);
      myAsyncService.dataSync(s1);

      if (i > 0) {
         //返回结果