From 439452f59b03556aecc5dd6dbaa8f064b70cd026 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期一, 31 五月 2021 11:13:49 +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