List of usage examples for java.lang Short toString
public String toString()
From source file:net.sourceforge.msscodefactory.cfcrm.v2_1.CFCrmMSSql.CFCrmMSSqlAddressTable.java
public CFCrmCursor openAddressCursorByCountryIdx(CFCrmAuthorization 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"; CFCrmCursor cursor = new CFCrmMSSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfcrm.v2_1.CFCrmMySql.CFCrmMySqlContactTable.java
public CFCrmCursor openContactCursorByTimezoneIdx(CFCrmAuthorization 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"; CFCrmCursor cursor = new CFCrmMySqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW.CFAccDb2LUWContactTable.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 CFAccDb2LUWCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMSSql.CFAccMSSqlAddressTable.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 CFAccMSSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMySql.CFAccMySqlContactTable.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 CFAccMySqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlContactTable.java
public CFAccCursor openContactCursorByTimezoneIdx(CFAccAuthorization Authorization, Short ISOTimezoneId) { String sql = getSqlSelectContactBuff() + "WHERE " + ((ISOTimezoneId == null) ? "ctc.ISOTimezoneId is null " : "ctc.ISOTimezoneId = " + ISOTimezoneId.toString() + " ") + ((schema.isSystemUser(Authorization)) ? "" : (" AND ctc.TenantId = " + Authorization.getSecTenantId())) + "ORDER BY " + "ctc.TenantId ASC" + ", " + "ctc.ContactId ASC"; CFAccCursor cursor = new CFAccPgSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfcrm.v2_1.CFCrmMSSql.CFCrmMSSqlContactTable.java
public CFCrmCursor openContactCursorByTimezoneIdx(CFCrmAuthorization 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"; CFCrmCursor cursor = new CFCrmMSSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccOracle.CFAccOracleContactURLTable.java
public CFAccCursor openContactURLCursorByProtocolIdx(CFAccAuthorization Authorization, Short URLProtocolId) { String sql = getSqlSelectContactURLBuff() + "WHERE " + ((URLProtocolId == null) ? "curl.URLProtocolId is null " : "curl.URLProtocolId = " + URLProtocolId.toString() + " ") + "ORDER BY " + "curl.TenantId ASC" + ", " + "curl.ContactURLId ASC"; CFAccCursor cursor = new CFAccOracleCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMSSql.CFAccMSSqlContactTable.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 CFAccMSSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfcrm.v2_0.CFCrmOracle.CFCrmOracleAddressTable.java
public CFCrmCursor openAddressCursorByCountryIdx(CFCrmAuthorization 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"; CFCrmCursor cursor = new CFCrmOracleCursor(Authorization, schema, sql); return (cursor); }