package com.zy.third.erp.task;
|
|
import com.core.common.Cools;
|
import com.zy.common.service.erp.ErpSqlServer;
|
import com.zy.third.erp.entity.OutDetTB;
|
import com.zy.third.erp.entity.OutHedTB;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.scheduling.annotation.Async;
|
import org.springframework.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Component;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
|
/**
|
* 入库单据
|
*/
|
@Slf4j
|
@Component
|
public class ERPOutHedTBScheduler {
|
|
@Value("${erp.enabled}")
|
private Boolean erpEnabled;
|
|
|
@Autowired
|
private ERPInOrOutService inMS;
|
|
|
@Autowired
|
private ErpSqlServer erpSqlServer;
|
|
|
//@Transactional(rollbackFor = Throwable.class)
|
@Scheduled(cron = "${erp.refreshtime}")
|
@Async("orderThreadPool")
|
public void OutHedTBScheduler() {
|
//log.info("OutHedTBScheduler开始了");
|
if (!erpEnabled) return;
|
String sqlInHed = "select * from erp_OutHedTB where LKName='高霖立库'";
|
List<OutHedTB> inHeds = erpSqlServer.select(sqlInHed, OutHedTB.class);
|
if (!inHeds.isEmpty()) {
|
for (OutHedTB inHed : inHeds) {
|
if (!Cools.isEmpty(inHed.getTemp3()) && inHed.getTemp3().equals("fault")) {
|
//continue;
|
}
|
HashMap<String, String> condition = new HashMap<>();
|
condition.put("bill_no", "'" + inHed.getBillNo() + "'");
|
List<OutDetTB> inDetTBS = erpSqlServer.selectList(OutDetTB.class, condition);
|
HashMap<String, Object> hedAndDet = new HashMap<>();
|
hedAndDet.put("hed", inHed);
|
hedAndDet.put("det", inDetTBS);
|
if (inDetTBS == null || inDetTBS.isEmpty()) {
|
continue;
|
}
|
try {
|
inMS.createOutOrder(inHed, inDetTBS);
|
log.info("出库单据成功,{}", inHed);
|
move(hedAndDet);
|
} catch (Exception e) {
|
log.info(e.getMessage());
|
// e.printStackTrace();
|
String sql = "UPDATE erp_OutHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
|
erpSqlServer.update(sql);
|
//
|
}
|
}
|
}
|
}
|
|
|
public void OutHedTBScheduler(String orderNo) {
|
//log.info("OutHedTBScheduler开始了");
|
if (!erpEnabled) return;
|
String sqlInHed = "select * from erp_OutHedTB where LKName='高霖立库' and BillNo = '" + orderNo + "'";
|
List<OutHedTB> inHeds = erpSqlServer.select(sqlInHed, OutHedTB.class);
|
if (!inHeds.isEmpty()) {
|
for (OutHedTB inHed : inHeds) {
|
if (!Cools.isEmpty(inHed.getTemp3()) && inHed.getTemp3().equals("fault")) {
|
//continue;
|
}
|
HashMap<String, String> condition = new HashMap<>();
|
condition.put("BillNo", "'" + inHed.getBillNo() + "'");
|
List<OutDetTB> inDetTBS = erpSqlServer.selectList(OutDetTB.class, condition);
|
HashMap<String, Object> hedAndDet = new HashMap<>();
|
hedAndDet.put("hed", inHed);
|
hedAndDet.put("det", inDetTBS);
|
try {
|
inMS.createOutOrder(inHed, inDetTBS);
|
log.info("出库单据成功,{}", inHed);
|
move(hedAndDet);
|
} catch (Exception e) {
|
log.info(e.getMessage());
|
// e.printStackTrace();
|
String sql = "UPDATE erp_OutHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
|
erpSqlServer.update(sql);
|
//
|
}
|
}
|
}
|
}
|
|
@Transactional(rollbackFor = Throwable.class)
|
public void move(HashMap<String, Object> hedAndDet) {
|
OutHedTB hed = (OutHedTB) hedAndDet.get("hed");
|
ArrayList<OutDetTB> dets = (ArrayList<OutDetTB>) hedAndDet.get("det");
|
HashMap<String, String> condition = new HashMap<>();
|
condition.put("bill_no", "'" + hed.getBillNo() + "'");
|
erpSqlServer.delete(OutHedTB.class, condition);
|
for (OutDetTB det : dets) {
|
HashMap<String, String> condition2 = new HashMap<>();
|
condition2.put("bill_no", "'" + det.getBillNo() + "'");
|
condition2.put("i_no", String.valueOf(det.getINO()));
|
erpSqlServer.delete(OutDetTB.class, condition2);
|
}
|
|
}
|
}
|
