| | |
|---|
| | | @Select("select * from north_glass_buffer1 where FrameBarcode=#{FrameBarcode}") |
|---|
| | | List<north_glass_buffer1> SelectAluminumFrameInfoById(String FrameBarcode); |
|---|
| | | |
|---|
| | | //查询根据id查询 |
|---|
| | | @Select("select b.* from storage_cage a inner join out_slice b on a.glass_id=b.glassId where b.glassId=#{glassId}") |
|---|
| | | List<Out_slice> SelectOutSliceById(String glassId); |
|---|
| | | |
|---|
| | | //查询玻璃id是否 |
|---|
| | | @Select("select Flip from north_glass_buffer1_frames where Barcode=#{frameBarcode} limit 1") |
|---|
| | | String SelectFlipByFrameBarcode(String frameBarcode); |
|---|
| | | |
|---|
| | | //查询玻璃是否已存在于出片队列 |
|---|
| | | @Select("select * from out_slice where glassid=#{getbarcode} and (state=0 or state=1)") |
|---|
| | | Out_slice SelectQueueByglassid(String getbarcode); |
|---|
| | | |
|---|
| | | //查询玻璃是否已存在于出片队列 |
|---|
| | | //添加出片队列 |
|---|
| | | @Select("INSERT INTO out_slice( `glassId`, `barcode`, `glasswidth`, `glassheight`, `state`, `flip`) VALUES ( #{glassid}, #{FrameNo}, #{glasslengthMm}, #{glassheightMm}, 0, #{flip});") |
|---|
| | | void AddOutSliceS(String glassid, String flip, String FrameNo, String glasslengthMm, String glassheightMm); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
