1

zc

2024-09-21 f97266870e6ad8f964f10937e5588b5b5fa222eb

 src/main/java/com/zy/asrs/mapper/WrkDetlLogMapper.java

@@ -1,10 +1,14 @@
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
@@ -13,4 +17,27 @@
    @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);


}