From e5cf12d2e3441b83cc3aeafd4f7f23d4075ab5fc Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期二, 07 一月 2025 14:56:14 +0800
Subject: [PATCH] #并板出库
---
src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java | 19 ++++++++++++++++---
1 files changed, 16 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
index 03dc5a3..4eac4f1 100644
--- a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java
@@ -42,7 +42,7 @@
List<ManLocDetl> getStockStatisExcel();
- @Select("select sum(a.anfme) as sum from asr_loc_detl a left join asr_loc_mast b on a.loc_no = b.loc_no where b.loc_sts = 'F' and a.matnr = #{matnr}")
+ @Select("select sum(a.anfme) as sum from man_loc_detl where matnr = #{matnr}")
Double selectSumAnfmeByMatnr(@Param("matnr") String matnr);
List<ManLocDetl> selectPakoutByRule(String matnr);
@@ -60,7 +60,7 @@
List<StockVo> queryStockTotal();
- Integer sum();
+ Double sum();
List<ManLocDetl> unreason();
@@ -68,6 +68,19 @@
int updateLocNo0(Long nodeId, String locNo);
- List<ManLocDetl> selectLocNo0(String locNo, String matnr);
+ ManLocDetl selectLocNo0(String locNo, String matnr);
+
+ List<ManLocDetl> selectItem0(String locNo, String matnr);
+
int deleteLocNo0(String locNo, String matnr);
+
+ int updateAnfme0(double anfme, Long nodeId);
+
+ List<ManLocDetl> listByOutPage(Map<String, Object> condition);
+
+ long listByOutPageCount(Map<String, Object> condition);
+
+ List<ManLocDetl> selectAllPage(Map<String, Object> condition);
+
+ long selectAllPageSize(Map<String, Object> condition);
}
--
Gitblit v1.9.1