From 0b892279761b47b56a1113848cd4f479cf8d00f2 Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期二, 23 十二月 2025 17:02:55 +0800
Subject: [PATCH] #1
---
src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java b/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
index 2bb0d6b..fdb5f07 100644
--- a/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
@@ -5,7 +5,10 @@
import org.apache.ibatis.annotations.Delete;
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;
@Mapper
@Repository
@@ -16,4 +19,7 @@
void deleteByMatnr(String matnr);
String page(Integer pageNo, Integer pageSize, String barcode, Integer spec);
+
+ @Select("select top 100 * from cust_matnr_barcode where model = '' or model is null ")
+ List<MatBarcode> select100();
}
--
Gitblit v1.9.1