| | |
|---|
| | | // desc,tier desc,cell desc LIMIT 1") |
|---|
| | | // StorageCage selectOut(String orderId); |
|---|
| | | // 按玻璃ID出片任务查询 |
|---|
| | | @Select("select cage,cell,tier,glasswidth,ROUND(id/2)as prcId,id from storage_cage as a where a.glass_id=#{glassid} and state=1 and disabled=0 order by cage desc,tier desc,cell desc LIMIT 1") |
|---|
| | | @Select("select cage,cell,tier,glasswidth,glassheight,ROUND(id/2)as prcId,id from storage_cage as a where a.glass_id=#{glassid} and state=1 and disabled=0 order by cage desc,tier desc,cell desc LIMIT 1") |
|---|
| | | StorageCage selectOut2(String glassid); |
|---|
| | | |
|---|
| | | // 判断出片为1时，是否可直接出片 |
|---|
| | |
|---|
| | | @Update("update storage_cage set state=#{state},glass_id=#{glassid},order_id=#{orderid},glasswidth=#{width} where id=#{id};") |
|---|
| | | void UpdataAddCage(String orderid, String glassid, double width, int cage, int cell, int id, int state); |
|---|
| | | |
|---|
| | | @Update("update storage_cage set state=#{state},glass_id=#{glassid},order_id=#{glass.ordernumber},glasswidth=#{glass.glasslengthmm},glassheight=#{glass.glassheightmm},glasswidthmm=#{glass.glasslength},glassheightmm=#{glass.glassheight},listid=#{glass.listnumber},boxid=#{glass.boxnumber},FrameBarcode=#{glass.frameBarcode} where id=#{id};") |
|---|
| | | @Update("update storage_cage set state=#{state},glass_id=#{glassid},order_id=#{glass.ordernumber},glasswidth=#{widths},glassheight=#{glass.glassheightmm},glasswidthmm=#{glass.glasslength},glassheightmm=#{glass.glassheight},listid=#{glass.listnumber},boxid=#{glass.boxnumber},FrameBarcode=#{glass.frameBarcode} where id=#{id};") |
|---|
| | | void UpdataAddCage2(String orderid, String glassid, north_glass_buffer1 glass, int cage, int cell, int id,int state,Double widths); |
|---|
| | | |
|---|
| | | // 修改笼子信息(多片进片) |
|---|
| | |
|---|
| | | String SelectBarcode(String glassId); |
|---|
| | | |
|---|
| | | // 获取出片队列的铝框是否全部完成 |
|---|
| | | @Select("select count(*) from out_slice where barcode=#{barcode} and (state=1 or state=0 or state=3);") |
|---|
| | | @Select("select count(*) from out_slice where barcode=#{barcode} and (state=1 or state=0);") |
|---|
| | | int SelectOverState(String barcode); |
|---|
| | | |
|---|
| | | // 删除出片队列该铝框的id |
|---|
