| | |
| | | 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); |
| | | |
| | | } |