mybatis-plus使用记录

如何and和or:

 QuoteSalaryEnum salaryMax = QuoteSalaryEnum.of(memberObjectInfo.getQuoteSalaryMax());
            QuoteSalaryEnum salaryMin = QuoteSalaryEnum.of(memberObjectInfo.getQuoteSalaryMin());
            if (salaryMax != QuoteSalaryEnum.NO_LIMIT || salaryMin != QuoteSalaryEnum.NO_LIMIT) {
                wrapper.and(salaryWrapper -> {
                    if (salaryMax != QuoteSalaryEnum.NO_LIMIT) {
                        salaryWrapper.le("income_amount", salaryMax.getAmount());
                    }
                    if (salaryMin != QuoteSalaryEnum.NO_LIMIT) {
                        salaryWrapper.ge("income_amount", salaryMin.getAmount());
                    }
                    salaryWrapper.or().eq("income_amount", -1).in("income", MemberBaseIncomeEnum.getIncomeList(salaryMin.getAmount(), salaryMax.getAmount()));
                    return salaryWrapper;
                });

 

posted @ 2020-02-10 09:59  l2c  阅读(173)  评论(0)    收藏  举报