From d174064c9c48a409d8ee6cdc1d65a5ffe1b2ed0f Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期二, 05 八月 2025 10:32:04 +0800 Subject: [PATCH] #许可证2.0 --- src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java | 31 +++++++++++++++++++++++++++++++ 1 files changed, 31 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java b/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java index 54b9216..d7ae8d2 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java @@ -4,7 +4,11 @@ import com.baomidou.mybatisplus.mapper.BaseMapper; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; + +import java.util.Date; +import java.util.List; @Mapper @Repository @@ -13,4 +17,31 @@ @Insert("insert into asr_wrk_detl_log select * from asr_wrk_detl where wrk_no=#{workNo}") int save(Integer workNo); + List<WrkDetlLog> selectWrkDetlLogs(@Param("wrkNo") Integer wrkNo, + @Param("orderNo") String orderNo, + @Param("matnr") String matnr, + @Param("specs") String specs, + @Param("zpallet") String zpallet, + @Param("batch") String batch, + @Param("sku") String sku, + @Param("memo") String memo, + @Param("anfme") Double anfme, + @Param("modiTimeStart") Date modiTimeStart, + @Param("modiTimeEnd") Date modiTimeEnd, + @Param("pageNumber") Integer curr, + @Param("pageSize") Integer limit); + + Long selectWrkDetlLogsTotal(@Param("wrkNo") Integer wrkNo, + @Param("orderNo") String orderNo, + @Param("matnr") String matnr, + @Param("specs") String specs, + @Param("zpallet") String zpallet, + @Param("batch") String batch, + @Param("sku") String sku, + @Param("memo") String memo, + @Param("anfme") Double anfme, + @Param("modiTimeStart") Date modiTimeStart, + @Param("modiTimeEnd") Date modiTimeEnd); + + } -- Gitblit v1.9.1