| | |
|---|
| | | @Update("update glassinfo set finishnumber=finishnumber+1 where flowcard=#{flowcard} and mateid=#{mateid} and tier=#{tier};") |
|---|
| | | void AddFinishNumber(String flowcard,int mateid,int tier); |
|---|
| | | //获取当前任务的id |
|---|
| | | @Select("select id from storage_task where task_state=0 and glass_id=#{glassid} LIMIT 1") |
|---|
| | | @Select("select id from storage_task where task_state=0 and glass_id=#{glassid} ORDER BY id desc LIMIT 1") |
|---|
| | | GlassInfo SelectTaskId(String glassid); |
|---|
| | | //删除测量表的信息 |
|---|
| | | @Delete("delete from queue where glassid=#{glassid}") |
|---|
| | |
|---|
| | | @Select("select method from flowcard where state=1 and line=#{line} ORDER BY starttime LIMIT 1;") |
|---|
| | | GlassInfo SelectMethod(int line); |
|---|
| | | //直出模式任务查询 |
|---|
| | | @Select("select b.flowcard,b.glassid,b.glasstype,b.mateid,b.width,b.tier,a.totaltier as id,IFNULL(c.number,0)as number,b.glassid from flowcard a left join glassinfo b on a.flowcard=b.flowcard left join(select sum(number)as number,glasstype from storage_cage GROUP BY glasstype)c on b.glasstype=c.glasstype where a.line=#{line} and c.number>0 limit 1") |
|---|
| | | @Select("select b.flowcard,b.glassid,b.glasstype,b.mateid,b.width,b.tier,a.totaltier as id,IFNULL(c.number,0)as number,b.glassid from flowcard a left join glassinfo b on a.flowcard=b.flowcard left join(select sum(number)as number,glasstype from storage_cage GROUP BY glasstype)c on b.glasstype=c.glasstype where a.line=1 and c.number>0 limit 1") |
|---|
| | | GlassInfo SelectOutGlass2(int line); |
|---|
| | | //查询直通模式下最后一块 |
|---|
| | | @Select("select b.tier from flowcard a left join glassinfo b on a.flowcard=b.flowcard left join(select sum(number)as number,glasstype from storage_cage GROUP BY glasstype)c on b.glasstype=c.glasstype where a.line=2 and c.number>0 ORDER BY b.tier desc LIMIT 1") |
|---|
| | | @Select("select b.tier from flowcard a left join glassinfo b on a.flowcard=b.flowcard left join(select sum(number)as number,glasstype from storage_cage GROUP BY glasstype)c on b.glasstype=c.glasstype where a.line=#{line} and c.number>0 ORDER BY b.tier desc LIMIT 1") |
|---|
| | | int SelectOutGlassend(int line); |
|---|
| | | //增加笼子表宽高 |
|---|
| | | @Select("update storage_cage a set a.glasswidth=#{width},a.glassheight=#{height} where id=#{id} ") |
|---|
