List of usage examples for java.lang Short toString
public String toString()
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccOracle.CFAccOracleAddressTable.java
public CFAccCursor openAddressCursorByCountryIdx(CFAccAuthorization Authorization, Short CountryId) { String sql = getSqlSelectAddressBuff() + "WHERE " + ((CountryId == null) ? "adr.CountryId is null " : "adr.CountryId = " + CountryId.toString() + " ") + "ORDER BY " + "adr.TenantId ASC" + ", " + "adr.AddressId ASC"; CFAccCursor cursor = new CFAccOracleCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccOracle.CFAccOracleContactTable.java
public CFAccCursor openContactCursorByTimezoneIdx(CFAccAuthorization Authorization, Short ISOTimezoneId) { String sql = getSqlSelectContactBuff() + "WHERE " + ((ISOTimezoneId == null) ? "ctc.ISOTimezoneId is null " : "ctc.ISOTimezoneId = " + ISOTimezoneId.toString() + " ") + "ORDER BY " + "ctc.TenantId ASC" + ", " + "ctc.ContactId ASC"; CFAccCursor cursor = new CFAccOracleCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMySql.CFAccMySqlAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByDrCcyIdx(CFAccAuthorization Authorization, Short DebitCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + "WHERE " + ((DebitCurrencyId == null) ? "acny.debit_ccyid is null " : "acny.debit_ccyid = " + DebitCurrencyId.toString() + " ") + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccMySqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMySql.CFAccMySqlAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByCrCcyIdx(CFAccAuthorization Authorization, Short CreditCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + "WHERE " + ((CreditCurrencyId == null) ? "acny.credit_ccyid is null " : "acny.credit_ccyid = " + CreditCurrencyId.toString() + " ") + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccMySqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW.CFAccDb2LUWAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByDrCcyIdx(CFAccAuthorization Authorization, Short DebitCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + "WHERE " + ((DebitCurrencyId == null) ? "acny.debit_ccyid is null " : "acny.debit_ccyid = " + DebitCurrencyId.toString() + " ") + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW.CFAccDb2LUWAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByCrCcyIdx(CFAccAuthorization Authorization, Short CreditCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + "WHERE " + ((CreditCurrencyId == null) ? "acny.credit_ccyid is null " : "acny.credit_ccyid = " + CreditCurrencyId.toString() + " ") + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccDb2LUWCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByDrCcyIdx(CFAccAuthorization Authorization, Short DebitCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + "WHERE " + ((DebitCurrencyId == null) ? "acny.debit_ccyid is null " : "acny.debit_ccyid = " + DebitCurrencyId.toString() + " ") + ((schema.isSystemUser(Authorization)) ? "" : (" AND acny.TenantId = " + Authorization.getSecTenantId())) + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccPgSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByCrCcyIdx(CFAccAuthorization Authorization, Short CreditCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + "WHERE " + ((CreditCurrencyId == null) ? "acny.credit_ccyid is null " : "acny.credit_ccyid = " + CreditCurrencyId.toString() + " ") + ((schema.isSystemUser(Authorization)) ? "" : (" AND acny.TenantId = " + Authorization.getSecTenantId())) + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccPgSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMSSql.CFAccMSSqlAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByDrCcyIdx(CFAccAuthorization Authorization, Short DebitCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + " WHERE " + ((DebitCurrencyId == null) ? "acny.debit_ccyid is null " : "acny.debit_ccyid = " + DebitCurrencyId.toString() + " ") + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccMSSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMSSql.CFAccMSSqlAccountEntryTable.java
public CFAccCursor openAccountEntryCursorByCrCcyIdx(CFAccAuthorization Authorization, Short CreditCurrencyId) { String sql = getSqlSelectAccountEntryBuff() + " WHERE " + ((CreditCurrencyId == null) ? "acny.credit_ccyid is null " : "acny.credit_ccyid = " + CreditCurrencyId.toString() + " ") + "ORDER BY " + "acny.TenantId ASC" + ", " + "acny.AccountId ASC" + ", " + "acny.EntryId ASC"; CFAccCursor cursor = new CFAccMSSqlCursor(Authorization, schema, sql); return (cursor); }