package org.jeecg.modules.mdc.mapper;
|
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author: LiuS
|
* @create: 2023-04-07 14:57
|
*/
|
@Mapper
|
@Repository
|
public interface EquipmentTemperatureMapper {
|
|
@Select("select top 1 X,Y,Z,A,B from EquipmentTemperature where EquipmentID= #{equipmentId} order by CollectTime desc")
|
List<Map<String, Object>> getEquipmentTemperature(String equipmentId);
|
|
@Select("select top 1 X,Y,Z,A,B from EquipmentLagError where EquipmentID=#{equipmentId} order by CollectTime desc")
|
List<Map<String, Object>> getEquipmentLagError(String equipmentId);
|
|
@Select("select top 1 X,Y,Z,A,B from EquipmentCurrent where EquipmentID=#{equipmentId} order by CollectTime desc")
|
List<Map<String, Object>> getEquipmentCurrent(String equipmentId);
|
}
|
