wu
2024-04-09 e732551f469fd8479076629d69dfa196693b19ef
LoadGlassModule/src/main/java/com/mes/mapper/LoadGlassMapper.java
@@ -7,18 +7,18 @@
public interface LoadGlassMapper extends BaseMapper<UpWorkstation> {
    //显示目前工位玻璃信息
    @Select("SELECT * FROM up_workstation")
    List<UpWorkstation> SelectALL();
    List<UpWorkstation> selectALL();
    //删除工位的玻璃信息
    @Delete("DELETE FROM up_workstation where  workstation_id=#{id}")
    void deleteGlass(int id );
    //增加上片信息
    @Insert ("INSERT INTO up_workstation (pattern_width,pattern_heigth,pattern_thickness)value(#{patternwidth},#{patternheigth},#{patternthickness}where workstation_id=#{workstationid) ")
    void insertGlass(Double patternwidth,Double patternheigth,Double patternthickness,int workstationid);
    @Insert ("INSERT INTO up_workstation (pattern_width,pattern_heigth,pattern_thickness,films_id,number,workstationid)value(#{upwork.patternwidth},#{upwork.patternheigth},#{upwork.patternthickness},#{upwork.filmsid},#{upwork.number},#{upwork.workstationid) ")
    void insertGlass(UpWorkstation upwork,Double patternwidth,Double patternheigth,Double patternthickness,int workstationid,String filmsid,int number);
    //是否发起吸片
    @Select("SELECT * FROM up_workstation where  workstation_id=#{id}")
    UpWorkstation SelectAdd(int 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);
    int selectPriority(int id);
    
}