package com.mes.workstation.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.mes.workstation.entity.UpWorkstation;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.Map;
|
|
@Mapper
|
public interface LoadGlassMapper extends BaseMapper<UpWorkstation> {
|
//判断优先工位吸片
|
@Select("select b.layout_sequence,a.number from up_workstation a left join up_patten_usage b " +
|
"on a.pattern_width=b.width and a.pattern_heigth=b.width " +
|
"and a.pattern_thickness=b.thickness where a.workstation_id=#{id}")
|
Map<String, Object> selectPriority(int id);
|
|
}
|
