List of usage examples for java.lang Short toString
public String toString()
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMySql.CFAccMySqlContactURLTable.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 CFAccMySqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlContactURLTable.java
public CFAccCursor openContactURLCursorByProtocolIdx(CFAccAuthorization Authorization, Short URLProtocolId) { String sql = getSqlSelectContactURLBuff() + "WHERE " + ((URLProtocolId == null) ? "curl.URLProtocolId is null " : "curl.URLProtocolId = " + URLProtocolId.toString() + " ") + ((schema.isSystemUser(Authorization)) ? "" : (" AND curl.TenantId = " + Authorization.getSecTenantId())) + "ORDER BY " + "curl.TenantId ASC" + ", " + "curl.ContactURLId ASC"; CFAccCursor cursor = new CFAccPgSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfcrm.v2_1.CFCrmMSSql.CFCrmMSSqlContactURLTable.java
public CFCrmCursor openContactURLCursorByProtocolIdx(CFCrmAuthorization 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"; CFCrmCursor cursor = new CFCrmMSSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfcrm.v2_0.CFCrmDb2LUW.CFCrmDb2LUWAddressTable.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 CFCrmDb2LUWCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfcrm.v2_1.CFCrmMySql.CFCrmMySqlAddressTable.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 CFCrmMySqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMSSql.CFAccMSSqlContactURLTable.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 CFAccMSSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW.CFAccDb2LUWAddressTable.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 CFAccDb2LUWCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMySql.CFAccMySqlAddressTable.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 CFAccMySqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlAddressTable.java
public CFAccCursor openAddressCursorByCountryIdx(CFAccAuthorization Authorization, Short CountryId) { String sql = getSqlSelectAddressBuff() + "WHERE " + ((CountryId == null) ? "adr.CountryId is null " : "adr.CountryId = " + CountryId.toString() + " ") + ((schema.isSystemUser(Authorization)) ? "" : (" AND adr.TenantId = " + Authorization.getSecTenantId())) + "ORDER BY " + "adr.TenantId ASC" + ", " + "adr.AddressId ASC"; CFAccCursor cursor = new CFAccPgSqlCursor(Authorization, schema, sql); return (cursor); }
From source file:net.sourceforge.msscodefactory.cfcrm.v2_1.CFCrmDb2LUW.CFCrmDb2LUWContactTable.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 CFCrmDb2LUWCursor(Authorization, schema, sql); return (cursor); }