From 7cdb188ddd1655cae52c5146db8069d0288a5a97 Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期四, 31 七月 2025 12:40:31 +0800 Subject: [PATCH] #erp读取实际数量 --- src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 18 ++++++++++++++++-- 1 files changed, 16 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java index 3dac639..4b77393 100644 --- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java @@ -1,6 +1,7 @@ package com.zy.asrs.mapper; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.AcQuantity; import com.zy.asrs.entity.OrderDetl; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -13,11 +14,12 @@ @Repository public interface OrderDetlMapper extends BaseMapper<OrderDetl> { - OrderDetl selectItem(@Param("orderId") Long orderId, @Param("matnr") String matnr, @Param("batch") String batch); + List<OrderDetl> selectItem(@Param("orderId") Long orderId, @Param("matnr") String matnr, @Param("batch") String batch); - OrderDetl selectItemByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch); + List<OrderDetl> selectItemByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch); List<OrderDetl> selectWorkingDetls(Long orderId); + List<AcQuantity> loadQuantity(String orderNo); List<OrderDetl> getPakoutPage(Map<String, Object> map); @@ -27,7 +29,19 @@ int decrease(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty); + int decrease2(@Param("id")Long id, @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("qty")Double qty); + + int increaseQtyById(@Param("id")Long id, @Param("qty")Double qty); + + int increaseWorkQty(@Param("id")Long id, @Param("workQty")Double workQty); + + + List<OrderDetl> listByOrderNo(@Param("orderNo") String orderNo); + } -- Gitblit v1.9.1