From 59f80df1e377e8775969ca4acadfa2eadd6e37ae Mon Sep 17 00:00:00 2001
From: zhangchao <zc857179121@qq.com>
Date: 星期一, 04 十一月 2024 19:01:38 +0800
Subject: [PATCH] excel导出优化
---
src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
index 4aa30a4..f605a1b 100644
--- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
@@ -23,6 +23,8 @@
*/
OrderDetl selectItemByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch, @Param("csocode")String csocode, @Param("isocode")String isocode);
+ OrderDetl selectItemByOrderNo2(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("threeCode") String threeCode);
+
OrderDetl selectItemNoneOfBatch(@Param("orderNo")String orderNo, @Param("matnr")String matnr);
OrderDetl selectItemOfBatch(@Param("matnr")String matnr, @Param("batch")String batch);
@@ -45,4 +47,10 @@
List<OrderDetl> selectByMatnr(@Param("matnr") String matnr);
+ List<OrderDetl> getPakoutDetlPage(Map<String, Object> map);
+
+ List<OrderDetl> getOrderDetlByDoctype(Map<String, Object> map);
+
+ Integer getOrderDetlByDoctypeCount(Map<String, Object> map);
+
}
--
Gitblit v1.9.1