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

zhongrj

2022-08-22 3c607f075990d6d3238daa7db1c68eaae8126424

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

@@ -184,7 +184,7 @@
               "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);

         }
         //培训考试
@@ -208,7 +208,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);
         }
         //设置提交时间
         examScore.setExamEndTime(new Date());
@@ -240,7 +240,7 @@
               ",qualified = " + "'" + examScore.getQualified() + "'" +
               " " + "where id = " + "'" + examScore.getId() + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.FTP(s1);
         myAsyncService.dataSync(s1);

         if (i > 0) {
            //返回结果
@@ -357,7 +357,7 @@
//                                       ",user_type = " + "'" + user.getUserType() + "'" +
//                                       " " + "where id = " + "'" + user.getId() + "'";
                                 //FtpUtil.sqlFileUpload(s1);
                                 myAsyncService.FTP(s1);
                                 myAsyncService.dataSync(s1);
                              }
                           }
                        } else {
@@ -388,7 +388,7 @@
                              ",qualified = " + "'" + examScore.getQualified() + "'" +
                              " " + "where id = " + "'" + examScore.getId() + "'";
                        //FtpUtil.sqlFileUpload(s1);
                        myAsyncService.FTP(s1);
                        myAsyncService.dataSync(s1);
                        //更新成绩数据
                        baseMapper.updateById(examScore);
                     } else {
@@ -657,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;
            }
@@ -688,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;
            }
@@ -820,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);
@@ -848,7 +848,7 @@
            ",qualified = " + "'" + score.getQualified() + "'" +
            " " + "where id = " + "'" + score.getId() + "'";
      //FtpUtil.sqlFileUpload(s1);
      myAsyncService.FTP(s1);
      myAsyncService.dataSync(s1);

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