From 56a6e23e02f33d851a4882a20a0739081f308a23 Mon Sep 17 00:00:00 2001 From: LSH Date: 星期五, 02 十二月 2022 08:10:15 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 30 +++++++++++++++++++++++++++++- 1 files changed, 29 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java index 37933ff..b67806c 100644 --- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java @@ -1,12 +1,40 @@ package com.zy.asrs.mapper; -import com.zy.asrs.entity.OrderDetl; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.OrderDetl; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; + +import java.util.List; +import java.util.Map; @Mapper @Repository public interface OrderDetlMapper extends BaseMapper<OrderDetl> { + 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> selectWorkingDetls(Long orderId); + + List<OrderDetl> getPakoutPage(Map<String, Object> map); + + Integer getPakoutPageCount(Map<String, Object> map); + + 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); + + int addToLogTable(OrderDetl orderDetl); + + int increaseQtyByOrderNo(@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("workQty")Double workQty); + + int increaseWorkQtytest(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("anfme")Double anfme); + } -- Gitblit v1.9.1