| | |
|---|
| | | List<StorageCage> selectinout(@Param("task_type") Integer task_type); |
|---|
| | | |
|---|
| | | // 查询是否存在此订单 |
|---|
| | | @Select("select count(*) from storage_cage where order_id=#{orderid} and state=0") |
|---|
| | | @Select("select count(*) from storage_cage where order_id=#{orderid} and state=1") |
|---|
| | | short SelectOrder(@Param("orderid") String orderid); |
|---|
| | | |
|---|
| | | // @Insert("insert into order_out(orderid) values('#{orderid}')") |
|---|
| | | @Insert("INSERT INTO `canadames`.`order_out`( `orderid`,`mod_time`) VALUES ( #{orderid},now())") |
|---|
| | | @Insert("INSERT INTO `canadames`.`order_out`( `order_id`,`state`) VALUES ( #{orderid},0)") |
|---|
| | | void InsertOrder(String orderid); |
|---|
| | | |
|---|
| | | // 停止按当前订单出片 |
|---|
| | |
|---|
| | | void UpdateTask(@Param("task_type") Integer task_type, @Param("shelf_rack") Integer shelf_rack); |
|---|
| | | |
|---|
| | | // 手动完成进片任务修改笼子数据 |
|---|
| | | @Update("update storage_cage set state=1 where cell=#{cell} and state=2") |
|---|
| | | void UpdateCageTask1(@Param("cell") Integer cell); |
|---|
| | | @Update("update storage_cage set state=1 where cell=#{cell} and glass_id=#{glassid} and state=2") |
|---|
| | | void UpdateCageTask1(@Param("cell") Integer cell,@Param("glassid") Integer glassid); |
|---|
| | | |
|---|
| | | // 手动完成出片任务修改笼子数据 |
|---|
| | | @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null,coating=null where cell=#{cell} and state=2") |
|---|
| | | void UpdateCageTask2(@Param("cell") Integer cell); |
|---|
| | | @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null,coating=null where cell=#{cell} and glass_id=#{glassid} and state=3") |
|---|
| | | void UpdateCageTask2(@Param("cell") Integer cell,@Param("glassid") Integer glassid); |
|---|
| | | |
|---|
| | | //获取报警信息 |
|---|
| | | @Select("select id,content,timeon as timeons,endTime from alarmmg where endTime is null") |
|---|
