| | |
| | | @Select("SELECT * FROM queue where state<2 order by time desc limit 1") |
| | | Queue selectLastQueue2(); |
| | | |
| | | @Select("SELECT * FROM queue where state=1 order by time desc limit 1") |
| | | Queue selectLastQueue3(); |
| | | |
| | | @Select("SELECT * FROM queue where state<=0") |
| | | List<Queue> selectErrorQueues(); |
| | | |
| | |
| | | |
| | | @Delete("delete from queue where state<=0") |
| | | void DeleteErrorQueue(); |
| | | |
| | | @Delete("delete from queue where state<2") |
| | | void DeletefromQueue(); |
| | | @Delete("delete from queue where state<1") |
| | | void DeleteQueue(); |
| | | @Insert("INSERT into queue (flowcard,glassId,mateid,glasstype,glasswidth,glassheight,thickness,state,time) VALUES (#{flowcard},#{glassId},#{mateid},#{glasstype},#{glasswidth},#{glassheight},#{thickness},1,NOW())") |