From fd435cf8df2be1c6f13f28c85a63747ee2465940 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期二, 14 二月 2023 10:27:13 +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 8b0c3c5..088dbb9 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 from ERP_PRDT where 1=1";
+ String sqlSelectPrdt = "select prd_no as prdNo,name,ut,spc,status,type from ERP_PRDT where 1=1";
String sqlUpDatePrdtOne = "update ERP_PRDT set status=1 where prd_no=";
String sqlUpDatePrdtTwo = "update ERP_PRDT set status=2 ";
try {
--
Gitblit v1.9.1