自动化立体仓库 - WMS系统
pang.jiabao
2025-07-14 621ee9ed14726ae98bbb6fea9342b8c47a0435f4
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,25 @@
    @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("maktx") String maktx,
                                       @Param("model") String model,
                                       @Param("zpallet") String zpallet,
                                       @Param("volume") Double volume,
                                       @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("maktx") String maktx,
                                @Param("model") String model,
                                @Param("zpallet") String zpallet,
                                @Param("volume") Double volume,
                                @Param("modiTimeStart") Date modiTimeStart,
                                @Param("modiTimeEnd") Date modiTimeEnd);
}