From 5e2f29df57b36982660d5560a9ce6cdee9e40754 Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期五, 16 六月 2023 11:22:08 +0800
Subject: [PATCH] 增加111库位移存(原)定时任务
---
src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java b/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java
index fa38275..7992a73 100644
--- a/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java
+++ b/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java
@@ -51,7 +51,7 @@
@Scheduled(cron = "${erp.refreshtime}")
public void obtainPedt() {
if (!enabledErpPrdt) return;
- String sqlSelectPrdt = "select prd_no as prdNo,name,ut,spc,status,type,temp1 from ERP_PRDT where 1=1 and temp1 is null";
+ String sqlSelectPrdt = "select prd_no as prdNo,name,ut,spc,status,type,temp1,temp2,temp3 from ERP_PRDT where 1=1 and temp1 is null";
String sqlUpDatePrdtOne = "update ERP_PRDT set status=1 where prd_no=";
String sqlUpDatePrdtTwo = "update ERP_PRDT set status=2 ";
try {
--
Gitblit v1.9.1