From 2790d2558ef656ccddb4dbc94409decc8d227a1e Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期四, 05 九月 2024 10:10:02 +0800 Subject: [PATCH] #许可证 --- src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 27 ++++++++++++++++++++++++++- 1 files changed, 26 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..51c99ad 100644 --- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java @@ -1,12 +1,37 @@ 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); } -- Gitblit v1.9.1