1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
| package com.example.springboot.mapper;
| import org.apache.ibatis.annotations.Insert;
| import org.apache.ibatis.annotations.Mapper;
| import org.apache.ibatis.annotations.Select;
| import org.apache.ibatis.annotations.Update;
| import org.springframework.stereotype.Repository;
| import com.example.springboot.entity.GlassInfo;
|
| @Mapper
| @Repository
| public interface AlbaniaMapper {
| //判断笼内是否有合适的类型空格
| @Select("select id from storage_cage where glasstype=#{glasstype} and width>=#{width}+#{widths} order by id limit 1")
| int SelectCage(int glasstype,Double width,int widths);
| //判断笼内没有玻璃的空格
| @Select("select id from storage_cage where number=0 and cage>#{cage} and cage<#{cage2} order by id limit 1")
| int SelectNewCell(int cage,int cage2);
| //增加玻璃数
| @Update("update storage_cage set number=number+1,width=width-glasswidth where id=#{id}")
| void UpdateCageNumberAdd(int id);
| //减少玻璃数
| @Update("update storage_cage set number=number-1,width=width+glasswidth where id=#{id}")
| void UpdateCageNumberOut(int id);
| //增加任务记录
| @Insert("INSERT INTO `canadames`.`storage_task`(`task_type`, `task_state`, `shelf_rack`, `load_rack`,start_time,glass_id,count,finsh_time) VALUES (#{tasktype},#{taskstate},#{shelfrack},#{loadrack},now(),#{glassid},#{count},#{qidong});")
| void Inserttask(int tasktype, int taskstate, int shelfrack, int loadrack, String glassid, int count,int qidong);
| //新增一条笼子数据
| @Update("UPDATE `albania`.`storage_cage` SET `glass_id` =#{glassid}, `width` =width-#{glasswidth}, `glasswidth` =#{glasswidth}, `glassheight` =#{glassheight}, `glasswidthmm` =#{glasswidthmm}, `glassheightmm` = #{glassheightmm}, `state` = #{state}, `glasstype` = #{glasstype}, `number` = #{number} WHERE `id` =#{id};")
| void AddCage(int id,String glassid,Double glasswidth,Double glassheight,Double glasswidthmm,Double glassheightmm,int state,int glasstype,int number);
| //获取进片数据
| @Select("select glassid,flowcard,glasswidth as width,glassheight as height,glasswidthmm,glassheightmm,glasstype from queue where glasstype=1")
| GlassInfo SelectGlass();
|
|
| }
|
|
