package com.zy.asrs.task.handler; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.core.common.Cools; import com.zy.asrs.entity.WrkCharge; import com.zy.asrs.service.WrkChargeService; import com.zy.asrs.task.AbstractHandler; import com.zy.asrs.task.core.ReturnT; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.transaction.interceptor.TransactionAspectSupport; import java.util.List; /** * Created by vincent on 2020/7/7 */ @Service public class WrkChargeHandler extends AbstractHandler { @Autowired private JdbcTemplate jdbcTemplate; @Autowired private WrkChargeService wrkChargeService; @Transactional public ReturnT start() { try { List wrkCharges = wrkChargeService.findTimeoutData(); if (!Cools.isEmpty(wrkCharges)) { for (WrkCharge wrkCharge : wrkCharges) { wrkChargeService.delete(new EntityWrapper() .eq("wrk_no", wrkCharge.getWrkNo()) .eq("wrk_sts", wrkCharge.getWrkSts()) .eq("ste_no", wrkCharge.getSteNo()) ); } } } catch (Exception e) { e.printStackTrace(); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return FAIL.setMsg(e.getMessage()); } return SUCCESS; } }