From 8cfe3e91a887ad9025633a15b229a1e62d962ee8 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期五, 28 五月 2021 15:40:23 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index 8afdb63..551dae4 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -33,4 +33,10 @@
Integer getStockStatisCount(Map<String, Object> map);
List<LocDetl> getStockStatisExcel();
+
+ @Select("select sum(anfme) as sum from asr_loc_detl where matnr = #{matnr}")
+ Double selectSumAnfmeByMatnr(@Param("matnr") String matnr);
+
+ List<LocDetl> selectPakoutByRule(String matnr);
+
}
--
Gitblit v1.9.1