package com.mes.upworkstation.mapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import java.util.List;
|
import org.apache.ibatis.annotations.*;
|
import com.mes.upworkstation.entity.UpWorkstation;
|
@Mapper
|
public interface LoadGlassMapper extends BaseMapper<UpWorkstation> {
|
//显示目前工位玻璃信息
|
@Select("SELECT * FROM up_workstation")
|
List<UpWorkstation> selectALL();
|
//删除工位的玻璃信息
|
@Update("UPDATE `hangzhoumes`.`up_workstation` SET `pattern_width` =NULL, `pattern_heigth` = NULL, `pattern_thickness` = NULL, `films_id` = NULL, `number` = NULL WHERE `workstation_id`=#{id}")
|
void deleteGlass(int id );
|
//增加上片信息
|
@Update ("UPDATE `hangzhoumes`.`up_workstation` SET `pattern_width` = #{upwork.patternwidth}, `pattern_heigth` = #{upwork.patternheigth}, `pattern_thickness` =#{upwork.patternthickness}, `films_id` =#{upwork.filmsid}, `number` = #{upwork.number} WHERE `id` = #{upwork.workstationid}; ")
|
void insertGlass(UpWorkstation upwork);
|
//是否发起吸片
|
@Select("SELECT * FROM up_workstation where workstation_id=#{id}")
|
UpWorkstation selectAdd(int id);
|
//判断优先工位吸片
|
@Select("select b.layout_sequence 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}")
|
int selectPriority(int id);
|
|
}
|
