From da13bea76b64183790ab17775f04d43d8c7f6607 Mon Sep 17 00:00:00 2001
From: zhou zhou <3272660260@qq.com>
Date: 星期五, 26 十二月 2025 14:36:44 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java | 12 ++++++++++++
1 files changed, 12 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 358f782..fdb5f07 100644
--- a/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
@@ -2,12 +2,24 @@
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.MatBarcode;
+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
public interface MatBarcodeMapper extends BaseMapper<MatBarcode> {
MatBarcode selectByMatnr(@Param("matnr")String matnr);
+
+ @Delete("delete from cust_matnr_barcode where matnr=#{matnr}")
+ 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