From c2d424ca7cdb050f4052a70bbd462d6bafa91650 Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期二, 18 十一月 2025 13:22:26 +0800
Subject: [PATCH] 1.日出库明细统计增加模具名称字段查询条件2.半托查询增加可放长度查询条件
---
src/main/java/com/zy/asrs/mapper/InOutMapper.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/InOutMapper.java b/src/main/java/com/zy/asrs/mapper/InOutMapper.java
index 011c94b..bf23440 100644
--- a/src/main/java/com/zy/asrs/mapper/InOutMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/InOutMapper.java
@@ -10,6 +10,6 @@
@Mapper
@Repository
public interface InOutMapper extends BaseMapper<InOut> {
- @Select("select * from man_mat_inout where matnr = #{matnr}")
+ @Select("select top 1 * from man_mat_inout where matnr = #{matnr}")
InOut selectByMatnr(String matnr);
}
--
Gitblit v1.9.1