| | |
| | | StorageCage SelectStorageByCell(String cell); |
| | | |
| | | // 手动完成任务 |
| | | @Select("update storage_task set task_state=1 where id=1429") |
| | | @Select("update storage_task set task_state=1 where id=#{id}") |
| | | void FinishTask(Integer id); |
| | | |
| | | @Select("select gi.* from glassinfo gi inner join flowcard fc on gi.flowcard=fc.flowcard where fc.state!=2 and position(#{width} in gi.width) and position(#{height} in gi.height) and position(#{thickness} in gi.thickness) and position(#{films} in gi.films) group by gi.id") |
| | |
| | | @Select("select * from storage_cage where cage=#{cage} order by id desc") |
| | | List<StorageCage> SelectStorageCageByCage(Integer cage); |
| | | |
| | | // 添加出片队列 |
| | | @Insert("INSERT INTO flowcard(`flowcard`, `totaltier`, `number`, `line`, `state`, `method`, `starttime`) " |
| | | +" select #{flowcard}, 0, #{number}, 0, 0, 0, now() where 0=( select count(*) from flowcard where flowcard=#{flowcard});") |
| | | void InsertFlowcard(String flowcard, Integer number); |
| | | } |