From f653130e5df936041f7a5ae005e10c91415b64b1 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期四, 10 七月 2025 15:54:33 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 11 +++++++---- 1 files changed, 7 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java index 57c635b..388b99a 100644 --- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java @@ -4,7 +4,6 @@ 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; @@ -13,9 +12,13 @@ @Repository public interface LocMastMapper extends BaseMapper<LocMast> { - LocMast queryFreeLocMast(@Param("row") Integer row); + LocMast queryByLoc(String locNo); - @Select("select loc_no from asr_loc_mast where 1=1 and loc_sts = 'O' and crn_no = #{crnNo}") - List<String> queryGroupEmptyStock(Integer crnNo); + 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); } -- Gitblit v1.9.1