分页查询

    //分页查询
    public PageResponseResult findAll(CourseDto dto, PageRequest request) {
        Integer pageNo = request.getPageNo();
        Integer pageSize = request.getPageSize();

        //1.分页 页码参数（Page对象）
        Page<CourseBase> PageParam = new Page<>(
                pageNo, pageSize);//当前页的每页条数

        //2.查询条件
        LambdaQueryWrapper<CourseBase> wrapper = new LambdaQueryWrapper<>();
        //2-1设置查询条件
        String courseName = dto.getCourseName();
        if (!StringUtils.isEmpty(courseName)) {
            wrapper.like(CourseBase::getName, "%" + courseName + "%");
        }
        String auditStatus = dto.getAuditStatus();
        if (!StringUtils.isEmpty(auditStatus)) {
            wrapper.eq(CourseBase::getAuditStatus, auditStatus);
        }
        String teachmode = dto.getTeachmode();
        if (!StringUtils.isEmpty(teachmode)) {
            wrapper.eq(CourseBase::getTeachmode, teachmode);
        }
//        wrapper.eq(CourseBase::getCompanyId, AuthInfoHolder.getCompanyId());
        //3. 分页查询
        Page<CourseBase> page = this.page(PageParam, wrapper);
        //4.构造返回
        return new PageResponseResult(page.getTotal(), page.getRecords());