| package com.zy.asrs.mapper; | 
|   | 
| import com.baomidou.mybatisplus.mapper.BaseMapper; | 
| import com.zy.asrs.entity.LocMast; | 
| import org.apache.ibatis.annotations.Mapper; | 
| import org.apache.ibatis.annotations.Param; | 
| import org.springframework.stereotype.Repository; | 
|   | 
| import java.util.List; | 
|   | 
| @Mapper | 
| @Repository | 
| public interface LocMastMapper extends BaseMapper<LocMast> { | 
|   | 
|     LocMast queryByLoc(String locNo); | 
|   | 
|     LocMast queryByQrCode(String qrCodeValue); | 
|   | 
|     List<LocMast> selectLocByLev(Integer lev); | 
|   | 
|     List<LocMast> selectEmptyLocNos(@Param("locNos") List<String> locNos); | 
|   | 
|     List<LocMast> selectNotEmptyLocNos(@Param("locNos") List<String> locNos); | 
| } |