13

zhang

23 小时以前 d7c7cbbe2ba964b92e31e36d15c6941b4328b9b4

 src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java

@@ -2,6 +2,7 @@

import com.zy.asrs.task.AbstractHandler;
import com.zy.asrs.task.core.ReturnT;
import com.zy.system.timer.LoadingConfigTimer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
@@ -17,13 +18,20 @@
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Autowired
    private LoadingConfigTimer loadingConfigTimer;

    @Transactional
    public ReturnT<String> start() {
        Integer logDeleteDays = loadingConfigTimer.getLogDeleteDays();
        if (logDeleteDays == -1) {
            return SUCCESS;
        }
        try {
            // 删除半年以上的历史档
            jdbcTemplate.update("delete from asr_wrk_detl_log where dateadd(day,360,appe_time) <= getdate();");
            jdbcTemplate.update("delete from asr_wrk_mast_log where dateadd(day,360,appe_time) <= getdate();");
            jdbcTemplate.update("delete from cust_wait_pakin_log where dateadd(day,360,appe_time) <= getdate();");
            jdbcTemplate.update("delete from asr_wrk_detl_log where dateadd(day," + logDeleteDays + ",appe_time) <= getdate();");
            jdbcTemplate.update("delete from asr_wrk_mast_log where dateadd(day," + logDeleteDays + ",appe_time) <= getdate();");
            jdbcTemplate.update("delete from cust_wait_pakin_log where dateadd(day," + logDeleteDays + ",appe_time) <= getdate();");

        } catch (Exception e) {
            e.printStackTrace();