From 4ea00a26f7773e0ad27aeee512f34ff45fe0f18b Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期二, 16 六月 2020 15:21:29 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 4 +--- 1 files changed, 1 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java index 1dde7eb..6f84c0d 100644 --- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java @@ -4,14 +4,12 @@ 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; @Mapper @Repository public interface LocMastMapper extends BaseMapper<LocMast> { - @Select("select top 1 * from asr_loc_mast where row1=#{row} and loc_sts='O' and loc_type=#{locType} order by loc_type desc ,lev1 asc,bay1 asc") - LocMast queryFreeLocMast(@Param("row") Integer row, @Param("locType") Integer locType); + LocMast queryFreeLocMast(@Param("row") Integer row); } -- Gitblit v1.9.1