From 508aac599c24711a3c1f7cfa76d9025c8e73b89f Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期六, 25 二月 2023 17:04:05 +0800
Subject: [PATCH] #
---
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