| | |
|---|
| | | // #{date}, #{address}, #{userNo})") |
|---|
| | | // void insert (Spian spian); |
|---|
| | | // 新增任务表 |
|---|
| | | @Insert("INSERT INTO `canadames`.`storage_task`(`task_type`, `task_state`, `shelf_rack`, `load_rack`,start_time,glass_id,count) VALUES (#{tasktype},#{taskstate},#{shelfrack},#{loadrack},now(),#{glassid},#{count});") |
|---|
| | | void Inserttask(int tasktype, int taskstate, int shelfrack, int loadrack, String glassid, int count); |
|---|
| | | @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 storage_task set task_state=#{state} where task_type=#{type} and task_state=0;") |
|---|
