| | |
|---|
| | | import com.zy.asrs.entity.LocMast; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | @Repository |
|---|
| | | public interface LocMastMapper extends BaseMapper<LocMast> { |
|---|
| | | |
|---|
| | | LocMast queryFreeLocMast(@Param("row") Integer row); |
|---|
| | | LocMast queryFreeLocMast(@Param("row") Integer row, @Param("locType1") Short locType1); |
|---|
| | | |
|---|
| | | @Select("select loc_no from asr_loc_mast where 1=1 and loc_sts = 'O' and crn_no = #{crnNo}") |
|---|
| | | List<String> queryGroupEmptyStock(Integer crnNo); |
|---|
| | | |
|---|
| | | @Select("select count(*) as count from asr_loc_mast where 1=1 and loc_sts = 'O' and loc_type1 = #{locType1} and crn_no = #{crnNo}") |
|---|
| | | Integer selectEmptyLocCount(@Param("locType1") Short locType1, @Param("crnNo") Integer crnNo); |
|---|
| | | |
|---|
| | | List<LocMast> queryShallowLocFMast(@Param("crnNo") Integer crnNo); |
|---|
| | | } |
|---|
