| | |
|---|
| | | |
|---|
| | | |
|---|
| | | //查询玻璃是否已存在于出片队列 |
|---|
| | | @Select("select * from out_slice where glassid=#{getbarcode} and (state=0 or state=1 or state=2)") |
|---|
| | | @Select("select * from out_slice where glassid=#{getbarcode} and (state=0 or state=1 or state=2 or state=3)") |
|---|
| | | Out_slice SelectQueueByglassid(String getbarcode); |
|---|
| | | |
|---|
| | | //添加出片队列 |
|---|
| | | @Insert("INSERT INTO out_slice( `glassId`, `barcode`, `glasswidth`, `glassheight`, `state`, `flip`, `sequence`, `time` ,`position`) VALUES ( #{glassid}, #{FrameNo}, #{glasslengthMm}, #{glassheightMm}, 0, #{flip}, #{sequence}, now(), #{position});") |
|---|
| | | void AddOutSliceS(String glassid, String flip, String FrameNo, String glasslengthMm, String glassheightMm, int sequence, String position); |
|---|
| | | @Insert("INSERT INTO out_slice( `glassId`, `barcode`, `glasswidth`, `glassheight`, `state`, `flip`, `sequence`, `time` ,`position`) VALUES ( #{glassid}, #{FrameNo}, #{glasslengthMm}, #{glassheightMm}, #{state}, #{flip}, #{sequence}, now(), #{position});") |
|---|
| | | void AddOutSliceS(String glassid, String flip, String FrameNo, String glasslengthMm, String glassheightMm, int sequence, String position, Short state); |
|---|
| | | |
|---|
| | | //出片队列调序 |
|---|
| | | @Update("update out_slice set sequence=#{sequence} where glassid=#{glassId}") |
|---|
