package com.mes.mapper;
|
|
import com.baomidou.dynamic.datasource.annotation.DS;
|
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.mes.entity.DownGlassInfo;
|
import org.apache.ibatis.annotations.*;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
|
@Mapper
|
@Repository
|
@InterceptorIgnore(tenantLine = "true")
|
@DS("hangzhoumes") // 指定使用 hangzhoumes 数据源
|
public interface DownGlassInfoMapper extends BaseMapper<DownGlassInfo> {
|
|
// 查询下片任务表中状态为1的下片信息
|
@Select("SELECT flow_card_id,filmsid,width,height,thickness FROM down_glass_task WHERE task_stauts = 1;")
|
List<DownGlassInfo> selectunloadingtaskstate();
|
|
@Update("UPDATE down_glass_task SET task_stauts = 0 WHERE flow_card_id = #{flowCardId}")
|
void updateTaskStateToZero(@Param("flowCardId") String flowCardId);
|
|
@Select("SELECT MAX(sequence) FROM down_glass_info WHERE flow_card_id = #{flowCardId} LIMIT 1")
|
Integer getMaxSequenceByFlowCardId(@Param("flowCardId") String flowCardId);
|
|
@Delete("delete from down_glass_task where flow_card_id = #{flowCardId}")
|
void deletetask(@Param("flowCardId") String flowCardId);
|
}
|
