From 0af6638fa1228d7af4ef65971ad573fe98dbffd4 Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期四, 11 九月 2025 10:21:22 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 38 +++++++++++++++++++++++++++++++++----- 1 files changed, 33 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java index 4b95a4f..d3f865d 100644 --- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java @@ -13,9 +13,17 @@ @Repository public interface OrderDetlMapper extends BaseMapper<OrderDetl> { - OrderDetl selectItem(@Param("orderId") Long orderId, @Param("matnr") String matnr, @Param("batch") String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3); + OrderDetl selectItem(@Param("orderId") Long orderId, @Param("matnr") String matnr, @Param("batch") String batch, @Param("brand")String brand, + @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3 + , @Param("boxType1")String boxType1, + @Param("boxType2")String boxType2, + @Param("boxType3")String boxType3); - OrderDetl selectItemByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3); + OrderDetl selectItemByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch, @Param("brand")String brand, + @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3 + , @Param("boxType1")String boxType1, + @Param("boxType2")String boxType2, + @Param("boxType3")String boxType3); List<OrderDetl> selectWorkingDetls(Long orderId); @@ -23,16 +31,36 @@ Integer getPakoutPageCount(Map<String, Object> map); - int increase(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3, @Param("qty")Double qty); + int increase(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, + @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3 + , @Param("boxType1")String boxType1, + @Param("boxType2")String boxType2, + @Param("boxType3")String boxType3, @Param("qty")Double qty); - int decrease(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3, @Param("qty")Double qty); + int decrease(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, + @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3 + , @Param("boxType1")String boxType1, + @Param("boxType2")String boxType2, + @Param("boxType3")String boxType3, @Param("qty")Double qty); int modifyStatus(@Param("orderId") Long orderId, @Param("status")Integer status); int addToLogTable(OrderDetl orderDetl); - int increaseQtyByOrderNo(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3, @Param("qty")Double qty); + int increaseQtyByOrderNo(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, + @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3 + , @Param("boxType1")String boxType1, + @Param("boxType2")String boxType2, + @Param("boxType3")String boxType3, @Param("qty")Double qty); + + int increaseWorkQty(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, + @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3 + , @Param("boxType1")String boxType1, + @Param("boxType2")String boxType2, + @Param("boxType3")String boxType3, @Param("workQty")Double workQty); + int increaseWorkQtyByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch, @Param("qty") Double qty); int increaseWorkQty(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3, @Param("workQty")Double workQty); + List<OrderDetl> selectByOrderNo(@Param("orderNo") String orderNo); } -- Gitblit v1.9.1