From 815a94a56d6c0fe940349de1bcf1a61850d0eddc Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期四, 26 十二月 2024 13:49:27 +0800 Subject: [PATCH] #空板出库口替换 --- src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java | 12 ++++++++++++ 1 files changed, 12 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java b/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java index b89da24..a336d03 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java @@ -6,6 +6,7 @@ import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; +import java.util.Date; import java.util.List; @Mapper @@ -20,4 +21,15 @@ List<WrkDetl> selectAndLogByOrderNo(String orderNo); + int updateInspect( @Param("wrkNo")Integer wrkNo, @Param("matnr")String matnr, @Param("batch")String batch); + + List<WrkDetl> selectPakoutQuery(@Param("staNo")Integer staNo, @Param("matnr")String matnr); + + List<WrkDetl> selectAndLogByOrderNoGroupByMatnrOfSum(String orderNo); + + int updateIoTimeWms(@Param("workNo") Integer workNo, @Param("ioTime") Date ioTime); + + int updateIoTime(@Param("workNo") Integer workNo, @Param("ioTime") Date ioTime); + + List<WrkDetl> findByWorkNo(Integer workNo); } -- Gitblit v1.9.1