package com.qianwen.smartman.modules.mdc.mapper;
|
|
import com.baomidou.dynamic.datasource.annotation.DS;
|
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
|
import com.qianwen.smartman.common.constant.FmsConstant;
|
import com.qianwen.smartman.modules.mdc.vo.StateVO;
|
import com.qianwen.smartman.modules.mdc.vo.StatusRecordVO;
|
import org.apache.ibatis.annotations.Param;
|
|
@DS("iotdb")
|
@InterceptorIgnore(tenantLine = FmsConstant.AUTOMATIC)
|
public interface StateMapper {
|
/**
|
* 最后一个不是指定值的数据
|
* @param workstationId 工位id
|
* @param value 指定值
|
* @param beforeTime 在指定时间之前
|
* @return 状态记录
|
*/
|
StateVO lastStateNotEqValueLtTime(@Param("workstationId")long workstationId, @Param("value")Integer value,@Param("beforeTime")long beforeTime);
|
|
/**
|
* 查询大于指定时间第一个状态值
|
* @param workstationId 工位id
|
* @param value 指定值
|
* @param time 时间戳(大于该时间的数据)
|
* @return 状态数据对象
|
*/
|
StateVO firstStateEqValueGtTime(@Param("workstationId")long workstationId, @Param("value")Integer value, @Param("time")Long time);
|
|
StateVO firstStateEqValue(@Param("workstationId")long workstationId, @Param("value")Integer value);
|
}
|
