1

zhang

4 天以前 e61c535e1a6999e0768217589d8168676c106730

 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,14 +18,22 @@
    @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_stk_hplc where dateadd(day,180,appe_time) <= getdate();");
            jdbcTemplate.update("delete from asr_wrk_detl_log where dateadd(day,1080,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,1080,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();
@@ -33,5 +42,4 @@
        }
        return SUCCESS;
    }

}