| | |
|---|
| | | void updateStroageCageByCell(Integer cell, Integer num); |
|---|
| | | |
|---|
| | | // 计算格子内剩余宽度 |
|---|
| | | @Update("update storage_cage set width=5000-(glasswidth+100)*number where cell=#{cell}") |
|---|
| | | @Update("update storage_cage set width=5000-if(glasswidth is null,0,glasswidth+50)*number where cell=#{cell}") |
|---|
| | | void UpdateStroageCageWidthByCell(Integer cell); |
|---|
| | | |
|---|
| | | // 根据任务类型获取任务 |
|---|
| | |
|---|
| | | @Update("update flowcard set method=#{method} where flowcard=#{flowcard}") |
|---|
| | | void ModeChange(String flowcard, int method); |
|---|
| | | |
|---|
| | | @Update("update queue set glassid=concat(#P{flowcard},'-',#{tier}),flowcard=#{flowcard},glasswidth=#{width},glassheight=#{height},glasstype=#{glasstype},thickness=#{thickness},state=1 where state<=0") |
|---|
| | | void UpdateQueue(String flowcard, double width, double height, Integer glasstype, Double thickness); |
|---|
| | | @Update("update queue set glassid=concat(#{flowcard},'-',#{tier}),flowcard=#{flowcard},glasswidth=#{width},glassheight=#{height},glasstype=#{glasstype},thickness=#{thickness},state=1 where state<=0") |
|---|
| | | void UpdateQueue(String flowcard, double width, double height, Integer glasstype, Double thickness, Integer tier); |
|---|
| | | |
|---|
| | | @Update("update glassinfo set finishnumber=ifnull(finishnumber,0)+1 where flowcard=#{flowcard} and mateid=#{mateid} and tier=#{geTier}") |
|---|
| | | void AddGlassNo(String flowcard, Integer mateid, Integer geTier); |
|---|
| | |
|---|
| | | @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); |
|---|
| | | |
|---|
| | | @Select("Delete from queue where glassid=#{glassId}") |
|---|
| | | void DeletequeueByGlassid(String glassId); |
|---|
| | | } |
|---|
