StringBuffer hql = new StringBuffer("from CellPrepareAccessApply cpaa "
                + " LEFT JOIN "
                + " CellPrepareProject cpp ON cpaa.cellPrepareProject=cpp.id "
                + " LEFT JOIN "
                + " CellPrepareAccessSample cpas on cpaa.id=cpas.applyId "
                + " LEFT JOIN "
                + " CellPrepareSample cps on cpas.simpleId = cps.id where 1=1 ");
        Map<String, Object> params = new HashMap<>();
         if(StringUtils.hasText(accessVo.getProject())){
             hql.append(" and cpp.id=:id");
             params.put("id", accessVo.getProject());
         }
         if(StringUtils.hasText(accessVo.getName())){
             hql.append(" and cpaa.name = :name");
             params.put("name", accessVo.getName());
         }
         if(accessVo.getApplyStartDate()!=null){
             hql.append(" and cpaa.apply_date>=:startDate");
             params.put("startDate", accessVo.getApplyStartDate());
         }
         if(accessVo.getApplyEndDate()!=null){
             hql.append(" and cpaa.apply_date<=:endDate");
             params.put("endDate", accessVo.getApplyEndDate());
         }
        
        return query_hql(hql.toString(), params, pageNo, pageSize);