package org.jeecg.modules.mdc.service;
|
|
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: 采集设备表
|
* @Author: liuS
|
* @Date: 2023-03-23
|
* @Version: V1.0
|
*/
|
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();
|
|
}
|
