From fa8ac2c8675f3b461d518a19b9f9da184363930c Mon Sep 17 00:00:00 2001
From: lsh <1>
Date: 星期日, 20 八月 2023 23:44:35 +0800
Subject: [PATCH] #5、7堆垛机空库位限制
---
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