From fd1bfa1163d438ec6cabfdd6e01e632d31189c80 Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 12 五月 2023 12:34:10 +0800
Subject: [PATCH] 库位规则、混载库位
---
src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 10 ++++++++++
1 files changed, 10 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 0c3a911..3e7d1ba 100644
--- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
@@ -17,16 +17,26 @@
OrderDetl selectItemByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch);
+ OrderDetl selectItemNoneOfBatch(@Param("orderNo")String orderNo, @Param("matnr")String matnr);
+
+ OrderDetl selectItemOfBatch(@Param("matnr")String matnr, @Param("batch")String batch);
+
List<OrderDetl> selectWorkingDetls(Long orderId);
List<OrderDetl> getPakoutPage(Map<String, Object> map);
Integer getPakoutPageCount(Map<String, Object> map);
+ int increaseAnfme(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty);
+
int increase(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty);
int decrease(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty);
int modifyStatus(@Param("orderId") Long orderId, @Param("status")Integer status);
+ List<OrderDetl> selectRemainder(@Param("orderId") Long orderId);
+
+ List<OrderDetl> selectByMatnr(@Param("matnr") String matnr);
+
}
--
Gitblit v1.9.1