From 9052fef232f56eb878d7cf8360a09a11e6a0fe2f Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期五, 06 六月 2025 10:48:54 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java | 33 ++++++++++++++++++++++++++++++++- 1 files changed, 32 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java b/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java index 042de94..1cccd65 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java @@ -1,12 +1,43 @@ package com.zy.asrs.mapper; -import com.zy.asrs.entity.WrkDetlLog; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.WrkDetlLog; +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 public interface WrkDetlLogMapper extends BaseMapper<WrkDetlLog> { + @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("anfme") Double anfme, @Param("model") String model, + @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("anfme") Double anfme, @Param("model") String model, + @Param("modiTimeStart") Date modiTimeStart, + @Param("modiTimeEnd") Date modiTimeEnd); + + } -- Gitblit v1.9.1