Lius
2024-06-18 1279d6eee2934b2765ce4ea1bf3a4d45d931760d
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();
}