public Pagination getLookPage(BeanPatrolScheduling beanPatrolScheduling, int pageNo, int pageSize) {

        SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd");

          Pagination pagination = new Pagination();

          StringBuffer sql = new  StringBuffer();

          sql.append("      select   "); 

          sql.append("      ps.id,ju.username,ps.patrol_times,ps.patrol_month, ps.result,ps.parkid");

          sql.append("      from patrol_scheduling ps, ");

          sql.append("      company_emp ce, ");

          sql.append("      jc_user ju ");

          sql.append("      where ps.emp_id=ce.id ");

          sql.append("      and  ce.id=ju.user_id ");

          sql.append("      and ps.data_status=0");

          if(beanPatrolScheduling.getUserName()!= null && beanPatrolScheduling.getUserName()!= ""){

              sql.append("   and  ju.username like '%"+beanPatrolScheduling.getUserName()+"%'" ); 

          }

          String sqls =  sql.toString();

          Query query =   sessionFactory.getCurrentSession().createSQLQuery(sqls.toString());

          List list = query.list();

          List<BeanPatrolScheduling> result=new ArrayList<BeanPatrolScheduling>();

            if(list!=null&&list.size()>0){

                 for (Object object : list) {

                        int i = 0;

                        BeanPatrolScheduling modell=new BeanPatrolScheduling();

                        Object[] temp = (Object[]) object;

                        modell.setId(Integer.parseInt( temp[i++] +""));

                        modell.setUserName(String.valueOf( temp[i++]));

                        modell.setPatrol_times(Integer.parseInt( temp[i++] +""));

                        try {

                            modell.setPatrol_month(dateformat.parse( temp[i++] +""));

                        } catch (ParseException e) {

                            // TODO Auto-generated catch block

                            e.printStackTrace();

                        }

                        modell.setResult(Integer.parseInt( temp[i++] +""));

                        modell.setParkid(String.valueOf(temp[i++]));

                        result.add(modell);

                 }

             }

            pagination.setList(result);

            pagination.setPageNo(pageNo);

            pagination.setPageSize(pageSize);

        return pagination;

    }