package com.zy.ints.task.scheduler;
|
|
import com.zy.ints.entity.LkDetTb;
|
import com.zy.ints.erp.ErpSqlServer;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Component;
|
|
import java.util.List;
|
|
/**
|
* erp任务控制器
|
* Created by vincent on 2020/11/27
|
*/
|
@Slf4j
|
@Component
|
public class LkDetTbScheduler {
|
/**
|
* ERP接口是否启用
|
*/
|
@Value("${erp.enabled}")
|
private Boolean erpEnabled;
|
@Autowired
|
private ErpSqlServer erpSqlServer;
|
/**
|
* 上报入出库完结订单信息
|
*/
|
@Scheduled(cron = "${erp.refreshtime}")
|
public void InOrOutOrder() {
|
if (!erpEnabled) return;
|
String sqlSelectLkDetTb = "select bill_no as billNo,prd_no as prdNo,iokindid,add_id as addId,qty,prd_mark as prdMark,wh,billdate,status,temp1,temp2,temp3 from lk_det_tb where 1=1";
|
String sqlUpDateLkDetTbOne = "update lk_det_tb set status=1 where prd_no=";
|
String sqlUpDateLkDetTbTwo = "update lk_det_tb set status=2 where prd_no=";
|
|
try {
|
List<LkDetTb> lkDetTbs = erpSqlServer.select(sqlSelectLkDetTb, LkDetTb.class);
|
if (lkDetTbs.size() > 0){
|
for (LkDetTb lkDetTb:lkDetTbs){
|
Integer status = lkDetTb.getStatus();
|
if (status == 0){
|
|
}else if (status == 1){
|
|
}else if (status == 2){
|
|
}else {
|
|
}
|
}
|
}
|
}catch (Exception e){
|
|
}
|
}
|
}
|
