From 9b015b51b72ba050b4c38a6ba79eb45b7065e67d Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期四, 25 七月 2024 10:11:52 +0800
Subject: [PATCH] 调整sql
---
lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IEquipmentService.java | 56 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 55 insertions(+), 1 deletions(-)
diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IEquipmentService.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IEquipmentService.java
index 02dbaa7..a5621e8 100644
--- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IEquipmentService.java
+++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/IEquipmentService.java
@@ -1,7 +1,11 @@
package org.jeecg.modules.mdc.service;
-import org.jeecg.modules.mdc.entity.Equipment;
import com.baomidou.mybatisplus.extension.service.IService;
+import org.jeecg.modules.mdc.entity.Equipment;
+import org.jeecg.modules.mdc.vo.WsEquipmentStatus;
+import org.jeecg.modules.mdc.vo.WsEquipmentUtilizationRate;
+
+import java.util.List;
/**
* @Description: 閲囬泦璁惧琛�
@@ -11,4 +15,54 @@
*/
public interface IEquipmentService extends IService<Equipment> {
+ /**
+ * 鏍规嵁鏁版嵁琛ㄥ悕绉版煡璇㈡暟鎹〃鏄惁瀛樺湪
+ * @param saveTableName
+ * @return
+ */
+ String checkTableExists(String saveTableName);
+
+ /**
+ * 鏌ヨ闇�澶囦唤鏁版嵁閲�
+ * @param saveTableName
+ * @param day
+ * @return
+ */
+ Integer checkTableDataNum(String saveTableName, String day);
+
+ /**
+ * 鏁版嵁杩佺Щ
+ * @param backupTableName
+ * @param tableName
+ * @param day
+ */
+ void insertTableData(String backupTableName, String tableName, String day);
+
+ /**
+ * 鍒犻櫎鍘熸暟鎹〃鏁版嵁
+ * @param tableName
+ * @param day
+ */
+ void deleteTableData(String tableName, String day);
+
+ /**
+ * 鍒涘缓澶囦唤琛�
+ * @param backupTableName
+ * @param tableName
+ * @param day
+ */
+ void insertNoTableData(String backupTableName, String tableName, String day);
+
+ /**
+ * 鏌ヨ璁惧鐘舵��
+ * @return
+ */
+ List<WsEquipmentStatus> selectEquipmentStatus();
+
+ /**
+ * 鏌ヨ璁惧鍒╃敤鐜�
+ * @return
+ */
+ List<WsEquipmentUtilizationRate> selectEquipmentRate();
+
}
--
Gitblit v1.9.3