From 8d43111bd0e598bc0b2014cbfa69a32e74959dff Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 15 Dec 2021 19:24:05 +0800
Subject: [PATCH] ftp sql 同步封装
---
src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java | 27 ++++++++++++++-------------
1 files changed, 14 insertions(+), 13 deletions(-)
diff --git a/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java b/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java
index 7828ad8..ff0cb57 100644
--- a/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java
+++ b/src/main/java/org/springblade/modules/apply/service/impl/ApplyServiceImpl.java
@@ -30,6 +30,7 @@
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.service.TrainingRegistrationService;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -40,22 +41,21 @@
import java.text.SimpleDateFormat;
import java.util.*;
-import static org.springblade.common.constant.FtpConstant.*;
-
/**
* 考试报名服务实现类
* @author zhongrj
*/
@Service
-@AllArgsConstructor
public class ApplyServiceImpl extends ServiceImpl<ApplyMapper, Apply> implements ApplyService {
+ @Autowired
+ private ExamPaperService examPaperService;
- private final ExamPaperService examPaperService;
+ @Autowired
+ private IUserService userService;
- private final IUserService userService;
-
- private final TrainingRegistrationService trainingRegistrationService;
+ @Autowired
+ private TrainingRegistrationService trainingRegistrationService;
/**
* 自定义分页数据
@@ -463,9 +463,9 @@
apply1.setIsExam(3);
baseMapper.updateById(apply1);
-// String s1 =
-// "update sys_apply set is_exam = " + apply1.getIsExam() + " " +"where id = " + "'" + apply1.getId() + "'";
-// FtpUtil.sqlFileUpload(s1);
+ String s1 =
+ "update sys_apply set is_exam = " + apply1.getIsExam() + " " +"where id = " + "'" + apply1.getId() + "'";
+ FtpUtil.sqlFileUpload(s1);
}
//模拟考
if (apply.getExamType()==2){
@@ -473,11 +473,12 @@
trainingRegistration.setId(apply.getId());
//考试中
trainingRegistration.setIsExam(3);
+// trainingRegistration.setIsExam(1);
trainingRegistrationService.updateById(trainingRegistration);
-// String s1 =
-// "update sys_training_registration set is_exam = " + trainingRegistration.getIsExam() + " " +"where id = " + "'" + trainingRegistration.getId() + "'";
-// FtpUtil.sqlFileUpload(s1);
+ String s1 =
+ "update sys_training_registration set is_exam = " + trainingRegistration.getIsExam() + " " +"where id = " + "'" + trainingRegistration.getId() + "'";
+ FtpUtil.sqlFileUpload(s1);
}
}
--
Gitblit v1.9.3