当前位置: 首页>>代码示例>>Java>>正文

Java Criteria.addNotLike方法代码示例

本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addNotLike方法的典型用法代码示例。如果您正苦于以下问题：Java Criteria.addNotLike方法的具体用法？Java Criteria.addNotLike怎么用？Java Criteria.addNotLike使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria的用法示例。


在下文中一共展示了Criteria.addNotLike方法的10个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: addNotCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
private void addNotCriteria(String propertyName, String propertyValue, Class propertyType, boolean caseInsensitive, Criteria criteria) {

        String[] splitPropVal = StringUtils.split(propertyValue, SearchOperator.NOT.op());
        try {
            int strLength = splitPropVal.length;
            // if Not'ed empty criteria
            if (strLength == 0)
                throw new IllegalArgumentException("Improper syntax of NOT operator in " + propertyName);
            // if more than one NOT operator assume an implicit and (i.e. !a!b = !a&!b)
            if (strLength > 1) {
                String expandedNot = SearchOperator.NOT + StringUtils.join(splitPropVal, SearchOperator.AND.op() + SearchOperator.NOT.op());
                // we know that since this method was called, treatWildcardsAndOperatorsAsLiteral must be false
                addCriteria(propertyName, expandedNot, propertyType, caseInsensitive, false, criteria);
            }
            else {
                // only one so add a not like
                criteria.addNotLike(propertyName, splitPropVal[0]);
            }
        } catch (IllegalArgumentException ex) {
            GlobalVariables.getMessageMap().putError("lookupCriteria[" + propertyName + "]", RiceKeyConstants.ERROR_NOT_SYNTAX, propertyName);
        }
    }
开发者ID:kuali，项目名称:kc-rice，代码行数:23，代码来源:LookupDaoOjb.java

示例2: calculatePendBudget

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * calculates the current year pending budget total
 * 
 * @param isYearEndDocument should year end documents be included?
 * @param budgetCheckingBalanceTypeCd the budget balance type code
 * @param universityFiscalYear the university fiscal year of sufficient funds balances to summarize
 * @param chartOfAccountsCode the chart of accounts code of sufficient funds balances to summarize
 * @param accountNumber the account number of sufficient fund balances to summarize
 * @param acctSufficientFundsFinObjCd the object code for sufficient funds
 * @param expenditureCodes object codes that represent expenditures
 * @return calculates the current year pending budget total
 * @see org.kuali.ole.gl.batch.dataaccess.SufficientFundsDao#calculatePendBudget(boolean, java.lang.String, java.lang.Integer,
 *      java.lang.String, java.lang.String, java.lang.String, List)
 */
public KualiDecimal calculatePendBudget(boolean isYearEndDocument, String budgetCheckingBalanceTypeCd, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String acctSufficientFundsFinObjCd, List expenditureCodes) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo(OLEConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, budgetCheckingBalanceTypeCd);
    criteria.addEqualTo(OLEConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
    criteria.addEqualTo(OLEConstants.ACCOUNT_NUMBER_PROPERTY_NAME, accountNumber);
    criteria.addIn(OLEConstants.FINANCIAL_OBJECT_TYPE_CODE, expenditureCodes);
    criteria.addEqualTo(OLEConstants.ACCOUNT_SUFFICIENT_FUNDS_FINANCIAL_OBJECT_CODE_PROPERTY_NAME, acctSufficientFundsFinObjCd);
    criteria.addNotEqualTo(OLEConstants.DOCUMENT_HEADER_PROPERTY_NAME + "." + OLEConstants.DOCUMENT_HEADER_DOCUMENT_STATUS_CODE_PROPERTY_NAME, OLEConstants.DocumentStatusCodes.CANCELLED);

    if (isYearEndDocument) {
        criteria.addLike(OLEConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }
    else {
        criteria.addNotLike(OLEConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }

    ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(GeneralLedgerPendingEntry.class, criteria);
    reportQuery.setAttributes(new String[] { "sum(" + OLEConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")" });

    return executeReportQuery(reportQuery);

}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:37，代码来源:SufficientFundsDaoOjb.java

示例3: calculatePendBudget

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * calculates the current year pending budget total
 * 
 * @param isYearEndDocument should year end documents be included?
 * @param budgetCheckingBalanceTypeCd the budget balance type code
 * @param universityFiscalYear the university fiscal year of sufficient funds balances to summarize
 * @param chartOfAccountsCode the chart of accounts code of sufficient funds balances to summarize
 * @param accountNumber the account number of sufficient fund balances to summarize
 * @param acctSufficientFundsFinObjCd the object code for sufficient funds
 * @param expenditureCodes object codes that represent expenditures
 * @return calculates the current year pending budget total
 * @see org.kuali.kfs.gl.batch.dataaccess.SufficientFundsDao#calculatePendBudget(boolean, java.lang.String, java.lang.Integer,
 *      java.lang.String, java.lang.String, java.lang.String, List)
 */
public KualiDecimal calculatePendBudget(boolean isYearEndDocument, String budgetCheckingBalanceTypeCd, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String acctSufficientFundsFinObjCd, List expenditureCodes) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo(KFSConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, budgetCheckingBalanceTypeCd);
    criteria.addEqualTo(KFSConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
    criteria.addEqualTo(KFSConstants.ACCOUNT_NUMBER_PROPERTY_NAME, accountNumber);
    criteria.addIn(KFSConstants.FINANCIAL_OBJECT_TYPE_CODE, expenditureCodes);
    criteria.addEqualTo(KFSConstants.ACCOUNT_SUFFICIENT_FUNDS_FINANCIAL_OBJECT_CODE_PROPERTY_NAME, acctSufficientFundsFinObjCd);
    criteria.addNotEqualTo(KFSConstants.DOCUMENT_HEADER_PROPERTY_NAME + "." + KFSConstants.DOCUMENT_HEADER_DOCUMENT_STATUS_CODE_PROPERTY_NAME, KFSConstants.DocumentStatusCodes.CANCELLED);

    if (isYearEndDocument) {
        criteria.addLike(KFSConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }
    else {
        criteria.addNotLike(KFSConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }

    ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(GeneralLedgerPendingEntry.class, criteria);
    reportQuery.setAttributes(new String[] { "sum(" + KFSConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")" });

    return executeReportQuery(reportQuery);

}
开发者ID:kuali，项目名称:kfs，代码行数:37，代码来源:SufficientFundsDaoOjb.java

示例4: addSingleValuePredicate

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/** adds a single valued predicate to a Criteria. */
private void addSingleValuePredicate(SingleValuedPredicate p, Criteria parent) {
    final Object value = getVal(p.getValue());
    final String pp = p.getPropertyPath();
    if (p instanceof EqualPredicate) {
        parent.addEqualTo(pp, value);
    } else if (p instanceof EqualIgnoreCasePredicate) {
        parent.addEqualTo(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof GreaterThanOrEqualPredicate) {
        parent.addGreaterOrEqualThan(pp, value);
    } else if (p instanceof GreaterThanPredicate) {
        parent.addGreaterThan(pp, value);
    } else if (p instanceof LessThanOrEqualPredicate) {
        parent.addLessOrEqualThan(pp, value);
    } else if (p instanceof LessThanPredicate) {
        parent.addLessThan(pp, value);
    } else if (p instanceof LikePredicate) {
        //no need to convert * or ? since ojb handles the conversion/escaping
        parent.addLike(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof NotEqualPredicate) {
        parent.addNotEqualTo(pp, value);
    } else if (p instanceof NotEqualIgnoreCasePredicate) {
        parent.addNotEqualTo(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof NotLikePredicate) {
        parent.addNotLike(pp, value);
    } else {
        throw new UnsupportedPredicateException(p);
    }
}
开发者ID:kuali，项目名称:kc-rice，代码行数:30，代码来源:CriteriaLookupDaoOjb.java

示例5: calculatePendActual1

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Calculate this part of the actual total
 * 
 * @param isYearEndDocument should year end documents be included?
 * @param actualFinancialBalanceTypeCd the actual balance type code
 * @param universityFiscalYear the university fiscal year of sufficient funds balances to summarize
 * @param chartOfAccountsCode the chart of accounts code of sufficient funds balances to summarize
 * @param accountNumber the account number of sufficient fund balances to summarize
 * @param acctSufficientFundsFinObjCd the object code for sufficient funds
 * @return this part of the actual total
 */
protected KualiDecimal calculatePendActual1(boolean isYearEndDocument, String actualFinancialBalanceTypeCd, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String acctSufficientFundsFinObjCd, boolean isEqualDebitCode, List expenditureCodes) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo(OLEConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, actualFinancialBalanceTypeCd);
    criteria.addEqualTo(OLEConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
    criteria.addEqualTo(OLEConstants.ACCOUNT_NUMBER_PROPERTY_NAME, accountNumber);
    criteria.addEqualTo(OLEConstants.ACCOUNT_SUFFICIENT_FUNDS_FINANCIAL_OBJECT_CODE_PROPERTY_NAME, acctSufficientFundsFinObjCd);
    criteria.addIn(OLEConstants.FINANCIAL_OBJECT_TYPE_CODE, expenditureCodes);

    if (isEqualDebitCode) {
        criteria.addEqualTo(OLEConstants.TRANSACTION_DEBIT_CREDIT_CODE, OLEConstants.GL_DEBIT_CODE);
    }
    else {
        criteria.addNotEqualTo(OLEConstants.TRANSACTION_DEBIT_CREDIT_CODE, OLEConstants.GL_DEBIT_CODE);
    }

    criteria.addNotEqualTo(OLEConstants.DOCUMENT_HEADER_PROPERTY_NAME + "." + OLEConstants.DOCUMENT_HEADER_DOCUMENT_STATUS_CODE_PROPERTY_NAME, OLEConstants.DocumentStatusCodes.CANCELLED);

    if (isYearEndDocument) {
        criteria.addLike(OLEConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }
    else {
        criteria.addNotLike(OLEConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }

    ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(GeneralLedgerPendingEntry.class, criteria);
    reportQuery.setAttributes(new String[] { "sum(" + OLEConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")" });
    return executeReportQuery(reportQuery);
}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:40，代码来源:SufficientFundsDaoOjb.java

示例6: likeExpr

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public final void likeExpr(
	Criteria criteria
) throws RecognitionException, TokenStreamException {
	
	Token  id = null;
	
	try {      // for error handling
		
		boolean negative = false;
		Object value = null;
		
		id = LT(1);
		match(Identifier);
		{
		if ((LA(1)==LITERAL_not)) {
			match(LITERAL_not);
			negative = true;
		}
		else if ((LA(1)==LITERAL_like)) {
		}
		else {
			throw new NoViableAltException(LT(1), getFilename());
		}
		
		}
		match(LITERAL_like);
		value=literal();
		
		if (negative) {
		criteria.addNotLike(id.getText(), value);
		} else {
		criteria.addLike(id.getText(), value);
		}
		
	}
	catch (RecognitionException ex) {
		reportError(ex);
		recover(ex,_tokenSet_7);
	}
}
开发者ID:KualiCo，项目名称:ojb，代码行数:41，代码来源:OQLParser.java

示例7: calculatePendActual1

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Calculate this part of the actual total
 * 
 * @param isYearEndDocument should year end documents be included?
 * @param actualFinancialBalanceTypeCd the actual balance type code
 * @param universityFiscalYear the university fiscal year of sufficient funds balances to summarize
 * @param chartOfAccountsCode the chart of accounts code of sufficient funds balances to summarize
 * @param accountNumber the account number of sufficient fund balances to summarize
 * @param acctSufficientFundsFinObjCd the object code for sufficient funds
 * @return this part of the actual total
 */
protected KualiDecimal calculatePendActual1(boolean isYearEndDocument, String actualFinancialBalanceTypeCd, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String acctSufficientFundsFinObjCd, boolean isEqualDebitCode, List expenditureCodes) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo(KFSConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, actualFinancialBalanceTypeCd);
    criteria.addEqualTo(KFSConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
    criteria.addEqualTo(KFSConstants.ACCOUNT_NUMBER_PROPERTY_NAME, accountNumber);
    criteria.addEqualTo(KFSConstants.ACCOUNT_SUFFICIENT_FUNDS_FINANCIAL_OBJECT_CODE_PROPERTY_NAME, acctSufficientFundsFinObjCd);
    criteria.addIn(KFSConstants.FINANCIAL_OBJECT_TYPE_CODE, expenditureCodes);

    if (isEqualDebitCode) {
        criteria.addEqualTo(KFSConstants.TRANSACTION_DEBIT_CREDIT_CODE, KFSConstants.GL_DEBIT_CODE);
    }
    else {
        criteria.addNotEqualTo(KFSConstants.TRANSACTION_DEBIT_CREDIT_CODE, KFSConstants.GL_DEBIT_CODE);
    }

    criteria.addNotEqualTo(KFSConstants.DOCUMENT_HEADER_PROPERTY_NAME + "." + KFSConstants.DOCUMENT_HEADER_DOCUMENT_STATUS_CODE_PROPERTY_NAME, KFSConstants.DocumentStatusCodes.CANCELLED);

    if (isYearEndDocument) {
        criteria.addLike(KFSConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }
    else {
        criteria.addNotLike(KFSConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }

    ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(GeneralLedgerPendingEntry.class, criteria);
    reportQuery.setAttributes(new String[] { "sum(" + KFSConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")" });
    return executeReportQuery(reportQuery);
}
开发者ID:kuali，项目名称:kfs，代码行数:40，代码来源:SufficientFundsDaoOjb.java

示例8: getEdoDossierDocumentInfoByDossierId

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public EdoDossierDocumentInfoBo getEdoDossierDocumentInfoByDossierId(String edoDossierId) {
    Criteria crit = new Criteria();
    crit.addEqualTo("edoDossierId", edoDossierId);
    crit.addNotLike("documentTypeName", "%Supplemental%");
    crit.addNotLike("documentStatus", "%F%"); // this cannot be added here - have to look into this more
    return (EdoDossierDocumentInfoBo) this.getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(EdoDossierDocumentInfoBo.class, crit));
}
开发者ID:kuali-mirror，项目名称:kpme，代码行数:9，代码来源:EdoDossierDocumentInfoDaoImpl.java

示例9: calculatePendEncum1

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Calcluate this part of the encumbrance total
 * 
 * @param isYearEndDocument should year end documents be included?
 * @param extrnlEncumFinBalanceTypCd the external encumbrance balance type
 * @param intrnlEncumFinBalanceTypCd the internal encumbrance balance type
 * @param preencumbranceFinBalTypeCd the pre-encumbrance balance type
 * @param universityFiscalYear the university fiscal year of sufficient funds balances to summarize
 * @param chartOfAccountsCode the chart of accounts code of sufficient funds balances to summarize
 * @param accountNumber the account number of sufficient fund balances to summarize
 * @param acctSufficientFundsFinObjCd the object code for sufficient funds
 * @param isEqualDebitCode should debits be included in the calculation or not
 * @return this part of the encumbrance total
 */
protected KualiDecimal calculatePendEncum1(boolean isYearEndDocument, String extrnlEncumFinBalanceTypCd, String intrnlEncumFinBalanceTypCd, String preencumbranceFinBalTypeCd, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String acctSufficientFundsFinObjCd, boolean isEqualDebitCode, List expenditureCodes) {
    Criteria criteria = new Criteria();

    Criteria sub1 = new Criteria();
    sub1.addEqualTo(OLEConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, extrnlEncumFinBalanceTypCd);
    Criteria sub1_1 = new Criteria();
    sub1_1.addEqualTo(OLEConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, intrnlEncumFinBalanceTypCd);
    Criteria sub1_2 = new Criteria();
    sub1_2.addEqualTo(OLEConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, preencumbranceFinBalTypeCd);
    sub1_1.addOrCriteria(sub1_2);
    sub1.addOrCriteria(sub1_1);
    criteria.addOrCriteria(sub1);


    criteria.addEqualTo(OLEConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
    criteria.addEqualTo(OLEConstants.CHART_OF_ACCOUNTS_CODE_PROPERTY_NAME, chartOfAccountsCode);
    criteria.addEqualTo(OLEConstants.ACCOUNT_NUMBER_PROPERTY_NAME, accountNumber);
    criteria.addEqualTo(OLEConstants.ACCOUNT_SUFFICIENT_FUNDS_FINANCIAL_OBJECT_CODE_PROPERTY_NAME, acctSufficientFundsFinObjCd);
    criteria.addIn(OLEConstants.FINANCIAL_OBJECT_TYPE_CODE, expenditureCodes);

    if (isEqualDebitCode) {
        criteria.addEqualTo(OLEConstants.TRANSACTION_DEBIT_CREDIT_CODE, OLEConstants.GL_DEBIT_CODE);
    }
    else {
        criteria.addNotEqualTo(OLEConstants.TRANSACTION_DEBIT_CREDIT_CODE, OLEConstants.GL_DEBIT_CODE);
    }

    criteria.addNotEqualTo(OLEConstants.DOCUMENT_HEADER_PROPERTY_NAME + "." + OLEConstants.DOCUMENT_HEADER_DOCUMENT_STATUS_CODE_PROPERTY_NAME, OLEConstants.DocumentStatusCodes.CANCELLED);

    if (isYearEndDocument) {
        criteria.addLike(OLEConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }
    else {
        criteria.addNotLike(OLEConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }

    ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(GeneralLedgerPendingEntry.class, criteria);
    reportQuery.setAttributes(new String[] { "sum(" + OLEConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")" });

    return executeReportQuery(reportQuery);


}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:58，代码来源:SufficientFundsDaoOjb.java

示例10: calculatePendEncum1

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Calcluate this part of the encumbrance total
 * 
 * @param isYearEndDocument should year end documents be included?
 * @param extrnlEncumFinBalanceTypCd the external encumbrance balance type
 * @param intrnlEncumFinBalanceTypCd the internal encumbrance balance type
 * @param preencumbranceFinBalTypeCd the pre-encumbrance balance type
 * @param universityFiscalYear the university fiscal year of sufficient funds balances to summarize
 * @param chartOfAccountsCode the chart of accounts code of sufficient funds balances to summarize
 * @param accountNumber the account number of sufficient fund balances to summarize
 * @param acctSufficientFundsFinObjCd the object code for sufficient funds
 * @param isEqualDebitCode should debits be included in the calculation or not
 * @return this part of the encumbrance total
 */
protected KualiDecimal calculatePendEncum1(boolean isYearEndDocument, String extrnlEncumFinBalanceTypCd, String intrnlEncumFinBalanceTypCd, String preencumbranceFinBalTypeCd, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String acctSufficientFundsFinObjCd, boolean isEqualDebitCode, List expenditureCodes) {
    Criteria criteria = new Criteria();

    Criteria sub1 = new Criteria();
    sub1.addEqualTo(KFSConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, extrnlEncumFinBalanceTypCd);
    Criteria sub1_1 = new Criteria();
    sub1_1.addEqualTo(KFSConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, intrnlEncumFinBalanceTypCd);
    Criteria sub1_2 = new Criteria();
    sub1_2.addEqualTo(KFSConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, preencumbranceFinBalTypeCd);
    sub1_1.addOrCriteria(sub1_2);
    sub1.addOrCriteria(sub1_1);
    criteria.addOrCriteria(sub1);


    criteria.addEqualTo(KFSConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
    criteria.addEqualTo(KFSConstants.CHART_OF_ACCOUNTS_CODE_PROPERTY_NAME, chartOfAccountsCode);
    criteria.addEqualTo(KFSConstants.ACCOUNT_NUMBER_PROPERTY_NAME, accountNumber);
    criteria.addEqualTo(KFSConstants.ACCOUNT_SUFFICIENT_FUNDS_FINANCIAL_OBJECT_CODE_PROPERTY_NAME, acctSufficientFundsFinObjCd);
    criteria.addIn(KFSConstants.FINANCIAL_OBJECT_TYPE_CODE, expenditureCodes);

    if (isEqualDebitCode) {
        criteria.addEqualTo(KFSConstants.TRANSACTION_DEBIT_CREDIT_CODE, KFSConstants.GL_DEBIT_CODE);
    }
    else {
        criteria.addNotEqualTo(KFSConstants.TRANSACTION_DEBIT_CREDIT_CODE, KFSConstants.GL_DEBIT_CODE);
    }

    criteria.addNotEqualTo(KFSConstants.DOCUMENT_HEADER_PROPERTY_NAME + "." + KFSConstants.DOCUMENT_HEADER_DOCUMENT_STATUS_CODE_PROPERTY_NAME, KFSConstants.DocumentStatusCodes.CANCELLED);

    if (isYearEndDocument) {
        criteria.addLike(KFSConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }
    else {
        criteria.addNotLike(KFSConstants.FINANCIAL_DOCUMENT_TYPE_CODE, YEAR_END_DOC_PREFIX);
    }

    ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(GeneralLedgerPendingEntry.class, criteria);
    reportQuery.setAttributes(new String[] { "sum(" + KFSConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")" });

    return executeReportQuery(reportQuery);


}
开发者ID:kuali，项目名称:kfs，代码行数:58，代码来源:SufficientFundsDaoOjb.java


注：本文中的org.apache.ojb.broker.query.Criteria.addNotLike方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。