From 1e6b4d88290ccd79b51bed3acb805750a0ea7d01 Mon Sep 17 00:00:00 2001 From: pjb <pjb123456> Date: 星期二, 12 八月 2025 15:25:23 +0800 Subject: [PATCH] 记录输送线异常日志 --- src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java | 33 +++++++++++++++++++++++++++++++++ 1 files changed, 33 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 042de94..713d413 100644 --- a/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java +++ b/src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java @@ -2,11 +2,44 @@ import com.zy.asrs.entity.WrkDetlLog; 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 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("ioType") Integer ioType, + @Param("wrkSts") Integer wrkSts, + @Param("wrkNo") Integer wrkNo, + @Param("orderNo") String orderNo, + @Param("maktx") String maktx, + @Param("model") String model, + @Param("zpallet") String zpallet, + @Param("volume") String volume, + @Param("modiTimeStart") Date modiTimeStart, + @Param("modiTimeEnd") Date modiTimeEnd, + @Param("pageNumber") Integer curr, + @Param("pageSize") Integer limit); + + Long selectWrkDetlLogsTotal(@Param("ioType") Integer ioType, + @Param("wrkSts") Integer wrkSts, + @Param("wrkNo") Integer wrkNo, + @Param("orderNo") String orderNo, + @Param("maktx") String maktx, + @Param("model") String model, + @Param("zpallet") String zpallet, + @Param("volume") String volume, + @Param("modiTimeStart") Date modiTimeStart, + @Param("modiTimeEnd") Date modiTimeEnd); + + } -- Gitblit v1.9.1