| | |
|---|
| | | import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
|
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
|---|
| | | import com.mes.entity.DownGlassInfo;
|
|---|
| | | import org.apache.ibatis.annotations.Mapper;
|
|---|
| | | import org.apache.ibatis.annotations.*;
|
|---|
| | | import org.springframework.stereotype.Repository;
|
|---|
| | |
|
|---|
| | | import java.util.List;
|
|---|
| | |
|
|---|
| | | @Mapper
|
|---|
| | | @Repository
|
|---|
| | | @InterceptorIgnore(tenantLine = "true")
|
|---|
| | | @DS("hangzhoumes") // 指定使用 hangzhoumes 数据源
|
|---|
| | | public interface DownGlassInfoMapper extends BaseMapper<DownGlassInfo> {
|
|---|
| | |
|
|---|
| | | // 查询下片任务表中状态为1的下片信息
|
|---|
| | | @Select("SELECT flow_card_id,filmsid,width,height,thickness FROM down_glass_task WHERE state = 1;")
|
|---|
| | | List<DownGlassInfo> selectunloadingtaskstate();
|
|---|
| | |
|
|---|
| | | @Update("UPDATE down_glass_task SET state = 0 WHERE flow_card_id = #{flowCardId}")
|
|---|
| | | void updateTaskStateToZero(@Param("flowCardId") String flowCardId);
|
|---|
| | |
|
|---|
| | | @Select("SELECT MAX(sequence) FROM down_glass_info WHERE flow_card_id = #{flowCardId} LIMIT 1")
|
|---|
| | | Integer getMaxSequenceByFlowCardId(@Param("flowCardId") String flowCardId);
|
|---|
| | |
|
|---|
| | | @Delete("delete from down_glass_task where flow_card_id = #{flowCardId}")
|
|---|
| | | void deletetask(@Param("flowCardId") String flowCardId);
|
|---|
| | | }
|
|---|
