本文整理汇总了Java中org.apache.ojb.broker.query.QueryByCriteria.addOrderByAscending方法的典型用法代码示例。如果您正苦于以下问题:Java QueryByCriteria.addOrderByAscending方法的具体用法?Java QueryByCriteria.addOrderByAscending怎么用?Java QueryByCriteria.addOrderByAscending使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.QueryByCriteria
的用法示例。
在下文中一共展示了QueryByCriteria.addOrderByAscending方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getDocumentPBGLFringeLines
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getDocumentPBGLFringeLines(java.lang.String,
* java.util.List)
*/
public List getDocumentPBGLFringeLines(String documentNumber, List fringeObjects) {
List documentPBGLfringeLines = new ArrayList();
// we probably should just add a clearcache call at the end of all JDBC public methods that update the DB
getPersistenceBrokerTemplate().clearCache();
Criteria criteria = new Criteria();
criteria.addEqualTo("documentNumber", documentNumber);
criteria.addIn("financialObjectCode", fringeObjects);
QueryByCriteria query = QueryFactory.newQuery(PendingBudgetConstructionGeneralLedger.class, criteria);
query.addOrderByAscending("financialObjectCode");
documentPBGLfringeLines = (List) getPersistenceBrokerTemplate().getCollectionByQuery(query);
return documentPBGLfringeLines;
}
示例2: getEncumbrancesToClose
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* Returns an Iterator of all encumbrances that need to be closed for the fiscal year and specified charts
*
* @param fiscalYear a fiscal year to find encumbrances for
* @param charts charts to find encumbrances for
* @return an Iterator of encumbrances to close
* @see org.kuali.kfs.gl.dataaccess.EncumbranceDao#getEncumbrancesToClose(java.lang.Integer, java.util.List)
*/
@Override
public Iterator getEncumbrancesToClose(Integer fiscalYear, List<String> charts) {
Criteria criteria = new Criteria();
criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear);
criteria.addIn(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, charts);
QueryByCriteria query = new QueryByCriteria(Encumbrance.class, criteria);
query.addOrderByAscending(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
query.addOrderByAscending(KFSPropertyConstants.ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.SUB_OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.BALANCE_TYPE_CODE);
return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
示例3: getAssetPayments
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<AssetPayment> getAssetPayments(List<Asset> assets) {
List<Long> capitalAssetNumbers = new ArrayList<Long>();
for(Asset asset : assets) {
capitalAssetNumbers.add(asset.getCapitalAssetNumber());
}
Criteria criteria = new Criteria();
criteria.addIn(CamsPropertyConstants.AssetPayment.CAPITAL_ASSET_NUMBER, capitalAssetNumbers);
QueryByCriteria q = QueryFactory.newQuery(AssetPayment.class, criteria);
q.addOrderByAscending(CamsPropertyConstants.AssetPayment.CAPITAL_ASSET_NUMBER);
q.addOrderByAscending(CamsPropertyConstants.AssetPayment.PAYMENT_SEQ_NUMBER);
Collection<AssetPayment> assetPayments = getPersistenceBrokerTemplate().getCollectionByQuery(q);
return assetPayments;
}
示例4: findGeneralBalancesToForwardForFiscalYear
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.gl.dataaccess.BalanceDao#findGeneralBalancesToForwardForFiscalYear(java.lang.Integer, java.util.List,
* java.lang.String[])
*/
@Override
public Iterator<Balance> findGeneralBalancesToForwardForFiscalYear(Integer year, Collection<String> generalForwardBalanceObjectTypes, Collection<String> generalBalanceForwardBalanceTypes) {
Criteria c = new Criteria();
c.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year);
c.addIn(KFSPropertyConstants.BALANCE_TYPE_CODE, generalBalanceForwardBalanceTypes);
c.addIn(KFSPropertyConstants.OBJECT_TYPE_CODE, generalForwardBalanceObjectTypes);
QueryByCriteria query = QueryFactory.newQuery(Balance.class, c);
query.addOrderByAscending(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
query.addOrderByAscending(KFSPropertyConstants.ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.SUB_OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.BALANCE_TYPE_CODE);
query.addOrderByAscending(KFSPropertyConstants.OBJECT_TYPE_CODE);
Iterator<Balance> balances = getPersistenceBrokerTemplate().getIteratorByQuery(query);
return balances;
}
示例5: findAccountBalances
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* Find all matching account balances. The Sufficient funds code is used to determine the sort of the results.
*
* @param universityFiscalYear the university fiscal year of balances to return
* @param chartOfAccountsCode the chart of accounts code of balances to return
* @param accountNumber the account number of balances to return
* @param sfCode the sufficient funds code, used to sort on
* @return an Iterator of balances
*/
@Override
public Iterator<Balance> findAccountBalances(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String sfCode) {
LOG.debug("findAccountBalances() started");
Criteria crit = new Criteria();
crit.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, universityFiscalYear);
crit.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartOfAccountsCode);
crit.addEqualTo(KFSPropertyConstants.ACCOUNT_NUMBER, accountNumber);
QueryByCriteria qbc = QueryFactory.newQuery(Balance.class, crit);
if (KFSConstants.SF_TYPE_OBJECT.equals(sfCode)) {
qbc.addOrderByAscending(KFSPropertyConstants.OBJECT_CODE);
}
else if (KFSConstants.SF_TYPE_LEVEL.equals(sfCode)) {
qbc.addOrderByAscending(GeneralLedgerConstants.BalanceInquiryDrillDowns.OBJECT_LEVEL_CODE);
}
else if (KFSConstants.SF_TYPE_CONSOLIDATION.equals(sfCode)) {
qbc.addOrderByAscending(GeneralLedgerConstants.BalanceInquiryDrillDowns.CONSOLIDATION_OBJECT_CODE);
}
return getPersistenceBrokerTemplate().getIteratorByQuery(qbc);
}
示例6: testDistinct
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* Distinct Query
*/
public void testDistinct()
{
Criteria crit = new Criteria();
crit.addLike("allArticlesInGroup.articleName", "C%");
QueryByCriteria q = QueryFactory.newQuery(ProductGroup.class, crit, true);
q.addOrderByAscending("groupId");
Collection results = broker.getCollectionByQuery(q);
assertNotNull(results);
assertEquals(5, results.size());
// compare with count
int count = broker.getCount(q);
assertEquals(results.size(), count);
}
示例7: testQueryOrderByNonSelectColumn
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* ReportQuery returning rows with some "Liquor" data ordered by productGroup.groupId
*/
public void testQueryOrderByNonSelectColumn()
{
Criteria crit = new Criteria();
Collection results = new Vector();
crit.addEqualTo("productGroup.groupName", "Liquors");
QueryByCriteria q = QueryFactory.newQuery(Article.class, crit);
q.addOrderByAscending("productGroup.groupId");
Iterator iter = broker.getIteratorByQuery(q);
assertNotNull(iter);
while(iter.hasNext())
{
results.add(iter.next());
}
assertTrue(results.size() > 0);
}
示例8: getAccountOrgHierForAccount
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getAccountOrgHierForAccount(java.lang.String,
* java.lang.String, java.lang.Integer)
*/
public List<BudgetConstructionAccountOrganizationHierarchy> getAccountOrgHierForAccount(String chartOfAccountsCode, String accountNumber, Integer universityFiscalYear) {
List<BudgetConstructionAccountOrganizationHierarchy> accountOrgHier = new ArrayList();
Criteria criteria = new Criteria();
criteria.addEqualTo("universityFiscalYear", universityFiscalYear);
criteria.addEqualTo("chartOfAccountsCode", chartOfAccountsCode);
criteria.addEqualTo("accountNumber", accountNumber);
QueryByCriteria query = QueryFactory.newQuery(BudgetConstructionAccountOrganizationHierarchy.class, criteria);
query.addOrderByAscending("organizationLevelCode");
accountOrgHier = (List) getPersistenceBrokerTemplate().getCollectionByQuery(query);
return accountOrgHier;
}
示例9: findBalancesForFiscalYear
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.ld.dataaccess.LaborLedgerBalanceDao#findBalancesForFiscalYear(Integer, Map, List, List)
*/
public Iterator<LedgerBalance> findBalancesForFiscalYear(Integer fiscalYear, Map<String, String> fieldValues, List<String> encumbranceBalanceTypes) {
Criteria criteria = buildCriteriaFromMap(fieldValues, new LedgerBalance(), encumbranceBalanceTypes, false);
criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear);
QueryByCriteria query = QueryFactory.newQuery(LedgerBalance.class, criteria);
query.addOrderByAscending(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
query.addOrderByAscending(KFSPropertyConstants.ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_SUB_OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE);
query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_OBJECT_TYPE_CODE);
return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
示例10: findPaymentRequestAccountRevisions
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findPaymentRequestAccountHistory(org.kuali.kfs.module.cab.businessobject.BatchParameters)
*/
@Override
public Collection<PaymentRequestAccountRevision> findPaymentRequestAccountRevisions(BatchParameters batchParameters) {
Criteria criteria = new Criteria();
criteria.addGreaterThan(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_REVISION_TIMESTAMP, batchParameters.getLastRunTime());
if (!batchParameters.getExcludedChartCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PaymentRequestAccountRevision.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
}
if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
}
if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.PaymentRequestAccountRevision.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
}
QueryByCriteria query = new QueryByCriteria(PaymentRequestAccountRevision.class, criteria);
query.addOrderByAscending(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_REVISION_TIMESTAMP);
Collection<PaymentRequestAccountRevision> historyRecs = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return historyRecs;
}
示例11: findAllOrderBy
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.rice.krad.dao.BusinessObjectDao#findAllOrderBy(java.lang.Class, java.lang.String, boolean)
*/
public <T extends BusinessObject> Collection<T> findAllOrderBy(Class<T> clazz, String sortField, boolean sortAscending) {
QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, (Criteria) null);
if (sortAscending) {
queryByCriteria.addOrderByAscending(sortField);
}
else {
queryByCriteria.addOrderByDescending(sortField);
}
return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
}
示例12: findAllActiveOrderBy
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.rice.krad.dao.BusinessObjectDao#findAllActiveOrderBy(java.lang.Class, java.lang.String, boolean)
*/
public <T extends BusinessObject> Collection<T> findAllActiveOrderBy(Class<T> clazz, String sortField, boolean sortAscending) {
QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, buildActiveCriteria());
if (sortAscending) {
queryByCriteria.addOrderByAscending(sortField);
}
else {
queryByCriteria.addOrderByDescending(sortField);
}
return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
}
示例13: findMatchingOrderBy
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* This is the default impl that comes with Kuali - uses OJB.
*
* @see org.kuali.rice.krad.dao.BusinessObjectDao#findMatching(java.lang.Class, java.util.Map)
*/
public <T extends BusinessObject> Collection<T> findMatchingOrderBy(Class<T> clazz, Map<String, ?> fieldValues, String sortField, boolean sortAscending) {
Criteria criteria = buildCriteria(fieldValues);
QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, criteria);
if (sortAscending) {
queryByCriteria.addOrderByAscending(sortField);
}
else {
queryByCriteria.addOrderByDescending(sortField);
}
return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
}
示例14: getAllItemTypes
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public List getAllItemTypes() {
LOG.debug("getAllItemTypes() started");
Criteria criteria = new Criteria();
criteria.addEqualTo("active", Boolean.TRUE);
QueryByCriteria qbc = new QueryByCriteria(ItemType.class, criteria);
qbc.addOrderByAscending("code");
return (List) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
示例15: findMatchingGLEntries
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findMatchingGLEntries(org.kuali.kfs.module.cab.businessobject.BatchParameters)
*/
@Override
public Collection<Entry> findMatchingGLEntries(BatchParameters batchParameters) {
Criteria criteria = new Criteria();
criteria.addGreaterThan(CabPropertyConstants.Entry.TRANSACTION_DATE_TIME_STAMP, batchParameters.getLastRunTime());
if (!batchParameters.getExcludedChartCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
}
if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
}
if (!batchParameters.getIncludedFinancialBalanceTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.Entry.FINANCIAL_BALANCE_TYPE_CODE, batchParameters.getIncludedFinancialBalanceTypeCodes());
}
if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.Entry.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
}
if (!batchParameters.getExcludedFiscalPeriods().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.UNIVERSITY_FISCAL_PERIOD_CODE, batchParameters.getExcludedFiscalPeriods());
}
if (!batchParameters.getExcludedDocTypeCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.FINANCIAL_DOCUMENT_TYPE_CODE, batchParameters.getExcludedDocTypeCodes());
}
QueryByCriteria query = new QueryByCriteria(Entry.class, criteria);
query.addOrderByAscending(CabPropertyConstants.Entry.DOCUMENT_NUMBER);
query.addOrderByAscending(CabPropertyConstants.Entry.TRANSACTION_DATE_TIME_STAMP);
return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}