Package org.hibernate

Examples of org.hibernate.Criteria


        new HibernateCallback() {

          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(TakstolPackageV.class)
                .add(Restrictions.eq("customerNr", customerNr));
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
           
            criteria.addOrder(Order.asc("orderNr")).addOrder(
                    Order.asc("defaultArticle")).addOrder(
                    Order.desc("numberOfItems"));
            return criteria.list();
          }

        });
  }
View Full Code Here


        new HibernateCallback() {

          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(
            TakstolPackageV.class).add(
                Restrictions.eq("orderNr", orderNr));
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            criteria.addOrder(
                Order.asc("orderNr")).addOrder(
                Order.asc("defaultArticle")).addOrder(
                Order.desc("numberOfItems"));
            return criteria.list();
          }

        });
  }
View Full Code Here

    return (List<Produceable>) getHibernateTemplate().execute(
        new HibernateCallback() {

          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(FrontProductionV.class)
                .add(Restrictions.eq("customerNr", customerNr));
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
                return criteria.list();
          }

        });
  }
View Full Code Here

    return (List<Produceable>) getHibernateTemplate().execute(
        new HibernateCallback() {

          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(FrontProductionV.class)
                .add(Restrictions.eq("orderNr", orderNr));
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here

    @SuppressWarnings("unchecked")
  public List<DeviationV> findByParams(final ExcelReportSettingDeviation params) {
        return (List<DeviationV>) getHibernateTemplate().execute(new HibernateCallback() {

            public Object doInHibernate(Session session) {
                Criteria criteria = session.createCriteria(DeviationV.class).add(
                        Restrictions.eq("registrationYear", params.getYear()));

                if (params.getWeekFrom() != null && params.getWeekTo() == null) {
                    criteria.add(Restrictions.ge("registrationWeek", params.getWeekFrom()));
                } else if (params.getWeekFrom() == null && params.getWeekTo() != null) {
                    criteria.add(Restrictions.le("registrationWeek", params.getWeekTo()));
                } else {
                    criteria.add(Restrictions.between("registrationWeek", params.getWeekFrom(), params
                            .getWeekTo()));
                }

                if (params.getDeviationFunction() != null) {
                    criteria.add(Restrictions.eq("deviationFunction", params.getDeviationFunction()
                            .getJobFunctionName()));
                }

                if (params.getFunctionCategory() != null) {
                    criteria.add(Restrictions.eq("functionCategoryName", params.getFunctionCategory()
                            .getFunctionCategoryName()));
                }
                if (params.getDeviationStatus() != null) {
                    criteria.add(Restrictions.eq("deviationStatusName", params.getDeviationStatus()
                            .getDeviationStatusName()));
                }

                return criteria.list();
            }

        });

    }
View Full Code Here

        return (List<Transport>) getHibernateTemplate().execute(
                new HibernateCallback() {

                    public Object doInHibernate(final Session session) {

                        Criteria crit = session.createCriteria(Transport.class)
                                .add(Restrictions.eq("transportYear", year))
                                .add(
                                        Restrictions.between("transportWeek",
                                                fromWeek, toWeek));

                        if (orderBy != null) {
                            for (int i = 0; i < orderBy.length; i++) {
                                crit.addOrder(org.hibernate.criterion.Order
                                        .asc(orderBy[i]));
                            }
                        }
                        return crit.list();

                    }

                });
    }
View Full Code Here

        new HibernateCallback() {

          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria=    session.createCriteria(
                PacklistV.class).add(
                Restrictions.eq("customerNr", customerNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here

    return (List<PacklistV>) getHibernateTemplate().execute(
        new HibernateCallback() {

          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)throws HibernateException {
            Criteria criteria= session.createCriteria(
               
                PacklistV.class).add(
                Restrictions.eq("orderNr", orderNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here

        new HibernateCallback() {

          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(PaidV.class).add(
                Restrictions.eq("customerNr", customerNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here

        new HibernateCallback() {

          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(PaidV.class).add(
                Restrictions.eq("orderNr", orderNr));
           
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }

        });
  }
View Full Code Here

TOP

Related Classes of org.hibernate.Criteria

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.