Example usage for org.hibernate.criterion Restrictions le

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions le.

Prototype

public static SimpleExpression le(String propertyName, Object value) 

Source Link

Document

Apply a "less than or equal" constraint to the named property

Usage

From source file:com.selfsoft.business.service.impl.TbBookServiceImpl.java

public List<TbBook> findByTbBook(TbBook tbBook) {
    // TODO Auto-generated method stub
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbBook.class);

    if (null != tbBook) {
        if (null != tbBook.getId()) {
            detachedCriteria.add(Restrictions.eq("id", tbBook.getId()));
        }/*from   ww  w.j av a  2s .c  o m*/
        if (null != tbBook.getBookCode()) {
            detachedCriteria.add(Restrictions.like("bookCode", "%" + tbBook.getBookCode() + "%"));
        }
        if (null != tbBook.getRegisterDateStart()) {
            detachedCriteria.add(Restrictions.ge("registerDate", tbBook.getRegisterDateStart()));
        }
        if (null != tbBook.getRegisterDateEnd()) {
            detachedCriteria.add(Restrictions.le("registerDate", tbBook.getRegisterDateEnd()));
        }
        if (null != tbBook.getLicenseCode() && !"".equals(tbBook.getLicenseCode())) {
            detachedCriteria.add(Restrictions.like("licenseCode", "%" + tbBook.getLicenseCode() + "%"));
        }
        if (null != tbBook.getIsCome()) {
            detachedCriteria.add(Restrictions.eq("isCome", tbBook.getIsCome()));
        }
        if (null != tbBook.getPlanFixTimeStart()) {
            detachedCriteria.add(Restrictions.ge("planFixTime", tbBook.getPlanFixTimeStart()));
        }
        if (null != tbBook.getPlanFixTimeEnd()) {
            detachedCriteria.add(Restrictions.le("planFixTime", tbBook.getPlanFixTimeEnd()));
        }
        if (null != tbBook.getTmUser()) {

            if (null != tbBook.getTmUser().getId()) {

                detachedCriteria.createAlias("tmUser", "tmUser");

                detachedCriteria.add(Restrictions.eq("tmUser.id", tbBook.getTmUser().getId()));

            }
        }
    }

    return tbBookDao.findByCriteria(detachedCriteria, tbBook);
}

---

From source file:com.selfsoft.business.service.impl.TbBusinessBalanceServiceImpl.java

public List<TbBusinessBalance> findByTbBusinessBalance(TbBusinessBalance tbBusinessBalance) {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbBusinessBalance.class);

    if (null != tbBusinessBalance) {

        if (null != tbBusinessBalance.getBalanceCode() && !"".equals(tbBusinessBalance.getBalanceCode())) {
            detachedCriteria/*from  w ww .  ja v a  2 s  . co  m*/
                    .add(Restrictions.like("balanceCode", "%" + tbBusinessBalance.getBalanceCode() + "%"));
        }
        if (null != tbBusinessBalance.getTbFixEntrust()) {

            if (null != tbBusinessBalance.getTbFixEntrust().getEntrustCode()
                    && !"".equals(tbBusinessBalance.getTbFixEntrust().getEntrustCode())) {
                detachedCriteria.createAlias("tbFixEntrust", "tbFixEntrust");

                detachedCriteria.add(Restrictions.like("tbFixEntrust.entrustCode",
                        "%" + tbBusinessBalance.getTbFixEntrust().getEntrustCode() + "%"));
            }
        }

        if (null != tbBusinessBalance.getLicenseCode() && !"".equals(tbBusinessBalance.getLicenseCode())) {

            if ((null == tbBusinessBalance.getTbFixEntrust().getEntrustCode()
                    || "".equals(tbBusinessBalance.getTbFixEntrust().getEntrustCode())))
                detachedCriteria.createAlias("tbFixEntrust", "tbFixEntrust");

            detachedCriteria.createAlias("tbFixEntrust.tbCarInfo", "tbCarInfo");

            detachedCriteria.add(
                    Restrictions.like("tbCarInfo.licenseCode", "%" + tbBusinessBalance.getLicenseCode() + "%"));

        }

        if (null != tbBusinessBalance.getTmUser()) {

            if (null != tbBusinessBalance.getTmUser().getId()) {

                detachedCriteria.createAlias("tmUser", "tmUser");

                detachedCriteria.add(Restrictions.eq("tmUser.id", +tbBusinessBalance.getTmUser().getId()));

            }

        }

        if (null != tbBusinessBalance.getUserId()) {

            if ((null == tbBusinessBalance.getTbFixEntrust().getEntrustCode()
                    || "".equals(tbBusinessBalance.getTbFixEntrust().getEntrustCode()))
                    && (null == tbBusinessBalance.getLicenseCode()
                            || "".equals(tbBusinessBalance.getLicenseCode())))
                detachedCriteria.createAlias("tbFixEntrust", "tbFixEntrust");

            if (null == tbBusinessBalance.getTmUser() || null == tbBusinessBalance.getTmUser().getId())

                detachedCriteria.createAlias("tbFixEntrust.tmUser", "tmUser");

            detachedCriteria.add(Restrictions.eq("tmUser.id", +tbBusinessBalance.getUserId()));

        }

        if (null != tbBusinessBalance.getBananceDateStart()) {
            detachedCriteria.add(Restrictions.ge("bananceDate", tbBusinessBalance.getBananceDateStart()));
        }
        if (null != tbBusinessBalance.getBananceDateEnd()) {
            detachedCriteria.add(Restrictions.le("bananceDate",
                    CommonMethod.addDate(tbBusinessBalance.getBananceDateEnd(), 1)));
        }
        if (null != tbBusinessBalance.getBalanceStatus()) {
            detachedCriteria.add(Restrictions.eq("balanceStatus", tbBusinessBalance.getBalanceStatus()));
        }
        if (null != tbBusinessBalance.getTmModelTypeId()) {

            if (null == tbBusinessBalance.getTbFixEntrust()
                    && (null == tbBusinessBalance.getLicenseCode()
                            || "".equals(tbBusinessBalance.getLicenseCode()))
                    && null == tbBusinessBalance.getUserId())

                detachedCriteria.createAlias("tbFixEntrust", "tbFixEntrust");

            detachedCriteria.createAlias("tbFixEntrust.tbCarInfo", "tbCarInfo");

            detachedCriteria.createAlias("tbCarInfo.tmCarModelType", "tmCarModelType");

            detachedCriteria.add(Restrictions.eq("tmCarModelType.id", tbBusinessBalance.getTmModelTypeId()));
        }

    }

    return tbBusinessBalanceDao.findByCriteria(detachedCriteria, tbBusinessBalance);

}

---

From source file:com.selfsoft.business.service.impl.TbBusinessSpecialBalanceServiceImpl.java

public List<TbBusinessSpecialBalance> findByTbBusinessSpecialBalance(
        TbBusinessSpecialBalance tbBusinessSpecialBalance) {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbBusinessSpecialBalance.class);

    if (null != tbBusinessSpecialBalance) {

        if (null != tbBusinessSpecialBalance.getEditCode()
                && !"".equals(tbBusinessSpecialBalance.getEditCode())) {

            detachedCriteria/* w w w.  j  a va 2s. com*/
                    .add(Restrictions.like("editCode", "%" + tbBusinessSpecialBalance.getEditCode() + "%"));
        }
        /*
         * if(null!=tbBusinessSpecialBalance.getBananceDateStart()){
         * detachedCriteria.add(Restrictions.ge("bananceDate",
         * tbBusinessSpecialBalance.getBananceDateStart())); }
         * if(null!=tbBusinessSpecialBalance.getBananceDateEnd()){
         * detachedCriteria.add(Restrictions.le("bananceDate",
         * tbBusinessSpecialBalance.getBananceDateEnd())); }
         */
        if (null != tbBusinessSpecialBalance.getSpecialType()) {
            detachedCriteria.add(Restrictions.eq("specialType", tbBusinessSpecialBalance.getSpecialType()));
        }
        if (null != tbBusinessSpecialBalance.getBalanceCodeDB()
                && !"".equals(tbBusinessSpecialBalance.getBalanceCodeDB())) {
            detachedCriteria.add(
                    Restrictions.like("balanceCode", "%" + tbBusinessSpecialBalance.getBalanceCodeDB() + "%"));
        }
        if (null != tbBusinessSpecialBalance.getBalanceCode()
                && !"".equals(tbBusinessSpecialBalance.getBalanceCode())) {

            List<TbBusinessBalance> tbBusinessBalanceList = tbBusinessBalanceService
                    .findTbBusinessBalanceByBalanceCode(tbBusinessSpecialBalance.getBalanceCode());

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

                detachedCriteria
                        .add(Restrictions.eq("tbBusinessBalance.id", tbBusinessBalanceList.get(0).getId()));

            }

        }
        if (null != tbBusinessSpecialBalance.getEntrustCodeDB()
                && !"".equals(tbBusinessSpecialBalance.getEntrustCodeDB())) {
            detachedCriteria.add(
                    Restrictions.like("entrustCode", "%" + tbBusinessSpecialBalance.getEntrustCodeDB() + "%"));
        }
        // if(null!=tbBusinessSpecialBalance.getTbBusinessBalance()){

        /*
         * detachedCriteria.createAlias("tbBusinessBalance","tbBusinessBalance"
         * );
         * 
         * if(null!=tbBusinessSpecialBalance.getTbBusinessBalance().
         * getBalanceCode
         * ()&&!"".equals(tbBusinessSpecialBalance.getTbBusinessBalance
         * ().getBalanceCode())){ detachedCriteria.add(Restrictions.like(
         * "tbBusinessBalance.balanceCode",
         * "%"+tbBusinessSpecialBalance.getTbBusinessBalance
         * ().getBalanceCode()+"%")); }
         */

        if (null != tbBusinessSpecialBalance.getEntrustCode()
                && !"".equals(tbBusinessSpecialBalance.getEntrustCode())) {
            // detachedCriteria.createAlias("tbBusinessBalance.tbFixEntrust","tbFixEntrust");
            TbFixEntrust tbFixEntrust = tbFixEntrustService
                    .findByEntrustCode(tbBusinessSpecialBalance.getEntrustCode());

            if (null != tbFixEntrust) {

                TbBusinessBalance tbBusinessBalance = tbBusinessBalanceService
                        .findByEntrustId(tbFixEntrust.getId());

                if (null != tbBusinessBalance) {

                    detachedCriteria.add(
                            Restrictions.or(Restrictions.eq("tbBusinessBalance.id", tbBusinessBalance.getId()),
                                    Restrictions.like("entrustId", tbFixEntrust.getId())));

                }

                else {

                    detachedCriteria.add(Restrictions.like("entrustId", tbFixEntrust.getId()));

                }
            }

        }
        if (null != tbBusinessSpecialBalance.getBananceDateStart()) {
            detachedCriteria
                    .add(Restrictions.ge("bananceDate", tbBusinessSpecialBalance.getBananceDateStart()));
        }
        if (null != tbBusinessSpecialBalance.getBananceDateEnd()) {
            detachedCriteria.add(Restrictions.le("bananceDate",
                    CommonMethod.addDate(tbBusinessSpecialBalance.getBananceDateEnd(), 1)));
        }

        // }

    }

    return tbBusinessSpecialBalanceDao.findByCriteria(detachedCriteria, tbBusinessSpecialBalance);
}

---

From source file:com.selfsoft.business.service.impl.TbFixEntrustCostServiceImpl.java

public List<TbFixEntrustCost> findByTbFixEntrustCost(TbFixEntrustCost tbFixEntrustCost) {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbFixEntrustCost.class);

    if (null != tbFixEntrustCost) {

        if (null != tbFixEntrustCost.getTbFixEntrust()) {

            detachedCriteria.createAlias("tbFixEntrust", "tbFixEntrust");

            if (null != tbFixEntrustCost.getTbFixEntrust().getEntrustCode()
                    && !"".equals(tbFixEntrustCost.getTbFixEntrust().getEntrustCode())) {
                detachedCriteria.add(Restrictions.like("tbFixEntrust.entrustCode",
                        "%" + tbFixEntrustCost.getTbFixEntrust().getEntrustCode() + "%"));
            }/*w ww.jav a  2  s .  c  o  m*/

            if (null != tbFixEntrustCost.getTbFixEntrust().getFixDateStart()) {
                detachedCriteria.add(Restrictions.ge("tbFixEntrust.fixDate",
                        tbFixEntrustCost.getTbFixEntrust().getFixDateStart()));
            }
            if (null != tbFixEntrustCost.getTbFixEntrust().getFixDateEnd()) {
                detachedCriteria.add(Restrictions.le("tbFixEntrust.fixDate",
                        CommonMethod.addDate(tbFixEntrustCost.getTbFixEntrust().getFixDateEnd(), 1)));
            }

            if (null != tbFixEntrustCost.getTbFixEntrust().getTbCarInfo()) {

                detachedCriteria.createAlias("tbFixEntrust.tbCarInfo", "tbCarInfo");

                if (null != tbFixEntrustCost.getTbFixEntrust().getTbCarInfo().getLicenseCode()
                        && !"".equals(tbFixEntrustCost.getTbFixEntrust().getTbCarInfo().getLicenseCode())) {
                    detachedCriteria.add(Restrictions.like("tbCarInfo.licenseCode",
                            "%" + tbFixEntrustCost.getTbFixEntrust().getTbCarInfo().getLicenseCode() + "%"));
                }

            }
        }

    }

    return tbFixEntrustCostDao.findByCriteria(detachedCriteria, tbFixEntrustCost);
}

---

From source file:com.selfsoft.business.service.impl.TbFixEntrustServiceImpl.java

public List<TbFixEntrust> findByTbFixEntrust(TbFixEntrust tbFixEntrust) {
    // TODO Auto-generated method stub
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbFixEntrust.class);

    if (null != tbFixEntrust) {

        if (null != tbFixEntrust.getId()) {
            detachedCriteria.add(Restrictions.eq("id", tbFixEntrust.getId()));
        }//from w ww .  j a v  a 2 s  .  c om

        if (null != tbFixEntrust.getEntrustCode() && !"".equals(tbFixEntrust.getEntrustCode())) {
            detachedCriteria.add(Restrictions.like("entrustCode", "%" + tbFixEntrust.getEntrustCode() + "%"));
        }
        if (null != tbFixEntrust.getFixDateStart()) {
            detachedCriteria.add(Restrictions.ge("fixDate", tbFixEntrust.getFixDateStart()));
        }
        if (null != tbFixEntrust.getFixDateEnd()) {
            detachedCriteria
                    .add(Restrictions.le("fixDate", CommonMethod.addDate(tbFixEntrust.getFixDateEnd(), 1)));
        }

        if (null != tbFixEntrust.getMinutes()) {

            Date newDate = new Date();

            tbFixEntrust.setEstimateDateStart(newDate);

            tbFixEntrust.setEstimateDateEnd(CommonMethod.addMinute(new Date(), tbFixEntrust.getMinutes()));

            if (null != tbFixEntrust.getEstimateDateStart()) {
                detachedCriteria.add(Restrictions.ge("estimateDate", tbFixEntrust.getEstimateDateStart()));
            }
            if (null != tbFixEntrust.getEstimateDateEnd()) {
                detachedCriteria.add(Restrictions.le("estimateDate", tbFixEntrust.getEstimateDateEnd()));
            }
        }

        if (null != tbFixEntrust.getTbCustomer()) {

            boolean customerCodeBoolean = (null != tbFixEntrust.getTbCustomer().getCustomerCode()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerCode()));

            boolean customerNameBoolean = (null != tbFixEntrust.getTbCustomer().getCustomerName()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerName()));

            boolean telephoneBoolean = (null != tbFixEntrust.getTbCustomer().getTelephone()
                    && !"".equals(tbFixEntrust.getTbCustomer().getTelephone()));

            if (customerCodeBoolean || customerNameBoolean || telephoneBoolean) {

                detachedCriteria.createAlias("tbCustomer", "tbCustomer");
            }

            if (null != tbFixEntrust.getTbCustomer().getCustomerCode()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerCode())) {
                detachedCriteria.add(Restrictions.like("tbCustomer.customerCode",
                        "%" + tbFixEntrust.getTbCustomer().getCustomerCode() + "%"));
            }

            if (null != tbFixEntrust.getTbCustomer().getCustomerName()
                    && !"".equals(tbFixEntrust.getTbCustomer().getCustomerName())) {
                detachedCriteria.add(Restrictions.like("tbCustomer.customerName",
                        "%" + tbFixEntrust.getTbCustomer().getCustomerName() + "%"));
            }

            if (null != tbFixEntrust.getTbCustomer().getTelephone()
                    && !"".equals(tbFixEntrust.getTbCustomer().getTelephone())) {
                detachedCriteria.add(Restrictions.like("tbCustomer.telephone",
                        "%" + tbFixEntrust.getTbCustomer().getTelephone() + "%"));
            }
        }

        if (null != tbFixEntrust.getTbCarInfo()) {
            detachedCriteria.createAlias("tbCarInfo", "tbCarInfo");

            if (null != tbFixEntrust.getTbCarInfo().getLicenseCode()) {
                detachedCriteria.add(Restrictions.like("tbCarInfo.licenseCode",
                        "%" + tbFixEntrust.getTbCarInfo().getLicenseCode() + "%"));
            }

            if (null != tbFixEntrust.getTbCarInfo().getChassisCode()) {
                detachedCriteria.add(Restrictions.like("tbCarInfo.chassisCode",
                        "%" + tbFixEntrust.getTbCarInfo().getChassisCode() + "%"));
            }

            if (null != tbFixEntrust.getTbCarInfo().getTmCarModelType()) {
                detachedCriteria.createAlias("tbCarInfo.tmCarModelType", "tmCarModelType");

                if (null != tbFixEntrust.getTbCarInfo().getTmCarModelType().getId()) {
                    detachedCriteria.add(Restrictions.eq("tmCarModelType.id",
                            tbFixEntrust.getTbCarInfo().getTmCarModelType().getId()));
                }
            }
        }

        if (null != tbFixEntrust.getIsvalid()) {
            detachedCriteria.add(Restrictions.eq("isvalid", tbFixEntrust.getIsvalid()));
        }

        if (null != tbFixEntrust.getIsFinish()) {
            detachedCriteria.add(Restrictions.eq("isFinish", tbFixEntrust.getIsFinish()));
        }

        if (null != tbFixEntrust.getEntrustStatus()) {
            detachedCriteria.add(Restrictions.eq("entrustStatus", tbFixEntrust.getEntrustStatus()));
        }

        if (null != tbFixEntrust.getWjg() && !"".equals(tbFixEntrust.getWjg())) {

            if ("wjg".equals(tbFixEntrust.getWjg())) {

                detachedCriteria.add(Restrictions.ne("entrustStatus", 2L));

                detachedCriteria.add(Restrictions.ne("entrustStatus", 3L));

            }

            else if ("yjg".equals(tbFixEntrust.getWjg())) {

                detachedCriteria.add(Restrictions.or(Restrictions.eq("entrustStatus", 2L),
                        Restrictions.eq("entrustStatus", 3L)));

            }
        }

        if (null != tbFixEntrust.getJsqk() && !"".equals(tbFixEntrust.getJsqk())) {

            if ("wjs".equals(tbFixEntrust.getJsqk())) {

                detachedCriteria.add(Restrictions.ne("entrustStatus", 3L));

            }

            else if ("yjs".equals(tbFixEntrust.getJsqk())) {

                detachedCriteria.add(Restrictions.eq("entrustStatus", 3L));

            }
        }

        if (null != tbFixEntrust.getTmUser() && null != tbFixEntrust.getTmUser().getId()) {

            detachedCriteria.add(Restrictions.eq("tmUser.id", tbFixEntrust.getTmUser().getId()));

        }

    }
    return tbFixEntrustDao.findByCriteria(detachedCriteria, tbFixEntrust);
}

---

From source file:com.selfsoft.business.service.impl.TbFixEntrustServiceImpl.java

/**
 * ???/*  w  w  w  .j  av a2s .c o  m*/
 */
public List<TbFixEntrust> findMaintainCarFixEntrust() {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbFixEntrust.class);

    detachedCriteria.add(Restrictions.ge("remindMaintainDate",
            CommonMethod.addDate(new Date(), 0 - tmAlertDayService.findAll().get(0).getContinueDay())));

    detachedCriteria.add(Restrictions.le("remindMaintainDate",
            CommonMethod.addDate(new Date(), (0 + tmAlertDayService.findAll().get(0).getAlertDay()))));

    return tbFixEntrustDao.findByCriteria(detachedCriteria, null);
}

---

From source file:com.selfsoft.business.service.impl.TbFixEntrustServiceImpl.java

public List<TbFixEntrust> findInsuranceCarFixEntrust() {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbFixEntrust.class);

    detachedCriteria.add(Restrictions.ge("remindInsuranceDate", CommonMethod.addDate(new Date(),
            0 - tmInsuranceAlertDayService.findAll().get(0).getContinueDay())));

    detachedCriteria.add(Restrictions.le("remindInsuranceDate",
            CommonMethod.addDate(new Date(), (0 + tmInsuranceAlertDayService.findAll().get(0).getAlertDay()))));

    return tbFixEntrustDao.findByCriteria(detachedCriteria, null);
}

---

From source file:com.selfsoft.business.service.impl.TbFixShareServiceImpl.java

public List<TbFixShare> findByEntity(TbFixShare tbFixShare) {
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbFixShare.class);
    if (null != tbFixShare) {
        if (null != tbFixShare.getId()) {
            detachedCriteria.add(Restrictions.eq("id", tbFixShare.getId()));
        }//www .  j av  a2  s. c  o m
        if (tbFixShare.getTmUser() != null) {
            detachedCriteria.createAlias("tmUser", "tmUser");
            if (StringUtils.isNotBlank(tbFixShare.getTmUser().getUserRealName())) {
                detachedCriteria.add(Restrictions.like("tmUser.userRealName",
                        "%" + tbFixShare.getTmUser().getUserRealName() + "%"));
            }

            if (tbFixShare.getTmUser().getId() != null) {
                detachedCriteria.add(Restrictions.eq("tmUser.id", tbFixShare.getTmUser().getId()));
            }
        }

        if (tbFixShare.getTbFixEntrustContent() != null) {

            detachedCriteria.createAlias("tbFixEntrustContent", "tbFixEntrustContent");

            if (tbFixShare.getTbFixEntrustContent().getTbWorkingInfo() != null) {

                detachedCriteria.createAlias("tbFixEntrustContent.tbWorkingInfo", "tbWorkingInfo");

                if (StringUtils
                        .isNotBlank(tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationCode())) {
                    detachedCriteria.add(Restrictions.like("tbWorkingInfo.stationCode", "%"
                            + tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationCode() + "%"));
                }

                if (StringUtils
                        .isNotBlank(tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationName())) {
                    detachedCriteria.add(Restrictions.like("tbWorkingInfo.stationName", "%"
                            + tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationName() + "%"));
                }

            }

            if (tbFixShare.getTbFixEntrustContent().getTbFixEntrust() != null) {
                detachedCriteria.createAlias("tbFixEntrustContent.tbFixEntrust", "tbFixEntrust");
                detachedCriteria.add(Restrictions.ne("tbFixEntrust.isvalid", 0L));
                if (StringUtils
                        .isNotBlank(tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getEntrustCode())) {
                    detachedCriteria.add(Restrictions.like("tbFixEntrust.entrustCode", "%"
                            + tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getEntrustCode() + "%"));
                }

                if (null != tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateStart()) {
                    detachedCriteria.add(Restrictions.ge("tbFixEntrust.fixDate",
                            tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateStart()));
                }
                if (null != tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateEnd()) {
                    detachedCriteria.add(Restrictions.le("tbFixEntrust.fixDate", CommonMethod.addDate(
                            tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateEnd(), 1)));
                }

                if (tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getTbCarInfo() != null) {
                    detachedCriteria.createAlias("tbFixEntrustContent.tbFixEntrust.tbCarInfo", "tbCarInfo");

                    if (StringUtils.isNotBlank(tbFixShare.getTbFixEntrustContent().getTbFixEntrust()
                            .getTbCarInfo().getLicenseCode())) {
                        detachedCriteria.add(Restrictions.like("tbCarInfo.licenseCode",
                                "%" + tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getTbCarInfo()
                                        .getLicenseCode() + "%"));
                    }
                }

                /*  */
                if (tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getBalanceDateBegin() != null
                        || tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getBalanceDateEnd() != null) {
                    List entrustIdList = tbBusinessBalanceDao
                            .getTbEntrustByBalanceDate(tbFixShare.getTbFixEntrustContent().getTbFixEntrust());
                    if (entrustIdList != null && entrustIdList.size() == 0) {
                        return null;
                    }
                    detachedCriteria.add(Restrictions.in("tbFixEntrust.id", entrustIdList));
                }
                /*  */
            }
        }
    } else {
        detachedCriteria.createAlias("tbFixEntrustContent", "tbFixEntrustContent");
        detachedCriteria.createAlias("tbFixEntrustContent.tbFixEntrust", "tbFixEntrust");
        detachedCriteria.add(Restrictions.ne("tbFixEntrust.isvalid", 0L));

    }
    detachedCriteria.addOrder(Order.asc("tmUser.id"));
    return tbFixShareDao.findByCriteria(detachedCriteria, tbFixShare);
}

---

From source file:com.selfsoft.business.service.impl.TbReturnVisitServiceImpl.java

public List<TbReturnVisit> findByTbReturnVisit(TbReturnVisit tbReturnVisit) {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbReturnVisit.class);

    if (null != tbReturnVisit) {

        if (null != tbReturnVisit.getTbCarInfo()) {

            detachedCriteria.createAlias("tbCarInfo", "tbCarInfo");

            if (null != tbReturnVisit.getTbCarInfo().getLicenseCode()
                    && !"".equals(tbReturnVisit.getTbCarInfo().getLicenseCode())) {

                detachedCriteria.add(Restrictions.like("tbCarInfo.licenseCode",
                        "%" + tbReturnVisit.getTbCarInfo().getLicenseCode() + "%"));

            }//from  w w  w .j a v  a2  s  .c o m
        }

        if (null != tbReturnVisit.getVisitDateFrom()) {

            detachedCriteria.add(Restrictions.ge("visitDate", tbReturnVisit.getVisitDateFrom()));

        }

        if (null != tbReturnVisit.getVisitDateTo()) {

            detachedCriteria
                    .add(Restrictions.le("visitDate", CommonMethod.addDate(tbReturnVisit.getVisitDateTo(), 1)));

        }

        if (null != tbReturnVisit.getReturnType() && !"".equals(tbReturnVisit.getReturnType())) {

            detachedCriteria.add(Restrictions.eq("returnType", tbReturnVisit.getReturnType()));
        }
    }

    return tbReturnVisitDao.findByCriteria(detachedCriteria, tbReturnVisit);
}

---

From source file:com.square.adherent.noyau.dao.implementations.contrat.GarantieDaoImpl.java

License:Open Source License

/**
 * {@inheritDoc}//from www. jav a2s .com
 */
@SuppressWarnings("unchecked")
@Override
public List<Garantie> getListeGarantiesBeneficiaire(Long idAssure, Long idBeneficiaire) {
    final Criteria crit = createCriteria(Garantie.class);
    crit.createAlias("famille", "famille");
    crit.createAlias("statut", "statut");
    crit.add(Restrictions.eq("uidAssure", idAssure));
    crit.add(Restrictions.eq("uidBeneficiaire", idBeneficiaire));
    crit.add(Restrictions.le("dateAdhesion", Calendar.getInstance()));
    crit.add(Restrictions.or(Restrictions.eq("statut.id", adherentMappingService.getIdStatutGarantieEnCours()),
            Restrictions.eq("statut.id", adherentMappingService.getIdStatutGarantieResiliee())));
    crit.add(Restrictions.eq("isVisible", true));
    crit.addOrder(Order.asc("famille.ordre"));
    crit.addOrder(Order.asc("statut.ordre"));
    return crit.list();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »