| | |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | @Repository |
|---|
| | | public interface LocMastMapper extends BaseMapper<LocMast> { |
|---|
| | | |
|---|
| | | @Select("select top 1 * from asr_loc_mast where row1=#{row} and loc_type='O' order by loc_type desc ,lev1 asc,bay1 asc") |
|---|
| | | LocMast queryFreeLocMast(@Param("row") Integer row); |
|---|
| | | |
|---|
| | | @Select("select loc_no from asr_loc_mast where 1=1 and loc_sts = 'O' and crn_no = #{crnNo}") |
|---|
| | | List<String> queryGroupEmptyStock(Integer crnNo); |
|---|
| | | |
|---|
| | | } |
|---|
