From ff7314fff052c3e34880d4bfd9bbdd3adcb31fbb Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期四, 12 十月 2023 18:59:44 +0800 Subject: [PATCH] #解决入库通知档不删除问题 --- src/main/java/com/zy/asrs/mapper/StaDescMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/StaDescMapper.java b/src/main/java/com/zy/asrs/mapper/StaDescMapper.java index 4eb6237..2ef51ad 100644 --- a/src/main/java/com/zy/asrs/mapper/StaDescMapper.java +++ b/src/main/java/com/zy/asrs/mapper/StaDescMapper.java @@ -4,6 +4,7 @@ import com.zy.asrs.entity.StaDesc; 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; @@ -18,4 +19,7 @@ StaDesc queryCrnStn(Integer crnNo); + @Select("SELECT dev_no FROM [dbo].[asr_bas_devp] WHERE out_enable = 'Y' AND loading = 'N' AND autoing = 'Y'") + List<Integer> queryOutStation(); + } -- Gitblit v1.9.1