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