webservice接口

Lius

2025-03-03 5ae1b71ab6b57140d46e6a8b9e606bb4a390ce27

 lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentMapper.java

@@ -6,6 +6,10 @@
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
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: 采集设备表
@@ -30,4 +34,10 @@

    @Insert(" CREATE TABLE ${tableName} AS SELECT * FROM ${lastTableName} WHERE CollectTime < '${date}' ")
    void insertNoTableData(@Param("tableName") String tableName, @Param("lastTableName") String lastTableName, @Param("date") String date);

    List<WsEquipmentStatus> selectEquipmentStatus();

    List<WsEquipmentUtilizationRate> selectEquipmentRate(@Param("date") String date);

    String selectOee(@Param("equipmentId") String equipmentId, @Param("date") String date);
}