严智鑫
2024-04-16 e208aa1ef8e861dba168e8d83ab3066fc9f1e02d
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
package com.mes.workstation.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 
import java.util.Map;
 
import org.apache.ibatis.annotations.*;
import com.mes.workstation.entity.UpWorkstation;
@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);
    
}