From 067e0bd4ae50cfc8810844ff39e9302493309da1 Mon Sep 17 00:00:00 2001
From: whycq <10027870+whycq@user.noreply.gitee.com>
Date: 星期四, 08 十二月 2022 10:09:48 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
index f2461a1..5ec8601 100644
--- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
@@ -13,7 +13,7 @@
@Repository
public interface LocMastMapper extends BaseMapper<LocMast> {
- @Select("select distinct row1 from asr_loc_mast where crn_no = #{crnNo}")
+ @Select("select distinct row1 from asr_loc_mast where crn_no = #{crnNo} and row1 > 30")
List<Integer> queryDistinctRow(@Param("crnNo")Integer crnNo);
LocMast queryFreeLocMast(@Param("row") Integer row, @Param("locType1") Short locType1);
--
Gitblit v1.9.1