package com.chinaztt.mes.basic.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.chinaztt.mes.basic.entity.WorkstationLocation;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* 工作站库位关联表
|
*
|
* @author cxf
|
* @date 2020-11-11 14:01:02
|
*/
|
@Mapper
|
public interface WorkstationLocationMapper extends BaseMapper<WorkstationLocation> {
|
/**
|
* 根据系统唯一编号查出对应工作站的库位
|
*
|
* @param systemNo
|
* @param locationType
|
* @return
|
*/
|
Long selectBySystemNo(@Param("systemNo") String systemNo, @Param("locationType") Long locationType);
|
|
/**
|
* 根据系统唯一编号查出工单中合格库位
|
*
|
* @param systemNo
|
* @return
|
*/
|
Long selectQualifiedLocationIdBySystemNo(@Param("systemNo") String systemNo);
|
|
/**
|
* 根据系统唯一编号查出工单中合格库位
|
*
|
* @param workstationId 工作站id
|
* @param locationType 类型
|
* @return
|
*/
|
List<Long> selectLocationIds(@Param("workstationId") Long workstationId, @Param("locationType") Long locationType);
|
|
/**
|
* 根据系统编号获取绑定的成品待检库
|
* @param systemNo
|
* @return
|
*/
|
Long selectFinishToQualifiedLocationIdBySystemNo(String systemNo);
|
}
|
