| | |
|---|
| | | @Update("update storage_cage set state=1 where glass_id=#{glassid} and state=2") |
|---|
| | | void UpdateCageTask1(@Param("glassid") String glassid); |
|---|
| | | |
|---|
| | | // 手动完成出片任务修改笼子数据 |
|---|
| | | @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null where glass_id=#{glassid} and state=3") |
|---|
| | | void UpdateCageTask2(@Param("glassid") String glassid); |
|---|
| | | |
|---|
| | | //获取报警信息 |
|---|
| | | @Select("select id,content,timeon as timeons,endTime from alarmmg where endTime is null") |
|---|
| | | List<alarmmg> SelectAlarmmgInfo(); |
|---|
| | |
|---|
| | | @Select("select * from storage_cage where position(#{cage} in ifnull(glass_id,\"\"))") |
|---|
| | | List<StorageCage> SelectCageInfo(String cage); |
|---|
| | | |
|---|
| | | // 手动完成出片任务修改笼子数据 |
|---|
| | | @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null,glasswidthmm=null,glassheightmm=null,listid=null,boxid=null where glass_id=#{glassid}") |
|---|
| | | void DeleteByGlassID(String glassid); |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | //查询玻璃是否已存在于出片队列 |
|---|
| | | @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); |
|---|
| | | |
|---|
| | | //添加出片队列 |
|---|
