package org.jeecg.modules.iot.mdc.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.jeecg.modules.iot.mdc.entity.EquipmentAlarm;
|
import org.jeecg.modules.iot.mdc.entity.EquipmentLog;
|
import org.springframework.stereotype.Component;
|
|
/**
|
* @author: LiuS
|
* @create: 2023-04-12 16:39
|
*/
|
@Component("iotEquipmentAlarmMapper")
|
public interface EquipmentAlarmMapper extends BaseMapper<EquipmentAlarm> {
|
@Select("SELECT TOP 1 * FROM EquipmentAlarm WHERE EquipmentID = #{ equipmentId } ORDER BY CollectTime DESC")
|
EquipmentAlarm selectEquipmentAlarmByEquipmentId(@Param("equipmentId") String equipmentId);
|
}
|
