| ADDRESS01 | STRING(60) | | Address Line #1 |
| ADDRESS02 | STRING(60) | | Address Line #2 |
| BELONGS_TO | {@link e4s.db.systabledef.CompanyId}
INTEGER | 3 | Company belongs to another company (can be null or empty) |
| CITY | STRING(60) | | City |
| null | null | null | null |
| COMPANY_ID | {@link e4s.db.systabledef.CompanyId}
INTEGER | 1 | Primary key, company - ID |
| COUNTRYCODE | CountryCode | | Countrycode |
| DATMOD | DATE | | Date modified |
| DATNEW | DATE | | Date created |
| EMAIL | STRING(60) | | Corporate E-Mail |
| GIS_LATITUDE | FLOAT | | GIS Latitude |
| GIS_LONGITUDE | FLOAT | | GIS Longitude |
| GROUP_ID | {@link e4s.db.systabledef.CompanyGroup}
STRING(16) | | Belongs to Group |
| LOGIN_NAME | STRING(16) | 2 | Name for login |
| NAME | STRING(60) | | Company Name |
| PHONE01 | STRING(60) | | Phone #1 |
| PHONE02 | STRING(60) | | Phone #2 |
| REM | STRING(255) | | Remark |
| UID | STRING(10) | | VAT Number |
| VALID_UNTIL | DATE | | Valid until |
| WWW | STRING(60) | | WWW Address |
| ZIPCODE | STRING(10) | | ZIP Code |
*
* Index 1: COMPANY_ID unique
* Index 2: LOGIN_NAME unique
* Index 3: BELONGS
*
* @see e4s.db.systabledef.T_D2S_COMPANY_Sel
* @see e4s.db.systabledef.T_D2S_COMPANY_Obj
* @see tabledef.V_D2S_USERS_Sel
*/
public class T_D2S_COMPANY_Mod extends dbModifyFreefields implements dbModifyFreefields_Intf
{
// ------------------------------------------------------------------
// -- this file was generated by e4s.db.dict.dbTable from the
// -- element4solution library. Do not place modifications here!
// -- http://www.element4solution.com
// -- (C)door2solution software gmbh
// ------------------------------------------------------------------
// ADDRESS01 STRING Address Line #1
// ADDRESS02 STRING Address Line #2
// BELONGS_TO CompanyId 3 Company belongs to another company (can be null or empty)
// CITY STRING City
//
// COMPANY_ID CompanyId 1 Primary key, company - ID
// COUNTRYCODE CountryCode Countrycode
// DATMOD DATE Date modified
// DATNEW DATE Date created
// EMAIL STRING Corporate E-Mail
// GIS_LATITUDE FLOAT GIS Latitude
// GIS_LONGITUDE FLOAT GIS Longitude
// GROUP_ID CompanyGroup Belongs to Group
// LOGIN_NAME STRING 2 Name for login
// NAME STRING Company Name
// PHONE01 STRING Phone #1
// PHONE02 STRING Phone #2
// REM STRING Remark
// UID STRING VAT Number
// VALID_UNTIL DATE Valid until
// WWW STRING WWW Address
// ZIPCODE STRING ZIP Code
/*
* Construct an object for updatating, inserting or deleting data from T_D2S_COMPANY
* using a database connection.
*
* @param dbcon a database connection
* @param applobj an application object, containing client and other information
*/
public T_D2S_COMPANY_Mod(dbConnection_Intf dbcon, applObject_Intf applobj)
{
super(dbcon,T_D2S_COMPANY_Sel.TABLENAME,applobj);
m_AutoincrMode = AUTOINCREMENT_MODE_ON_CLIENT;
}
/*
* Construct an object for updatating, inserting or deleting data from T_D2S_COMPANY
* using a default database connection.
*
* @param applobj an application object, containing client and other information
*/
public T_D2S_COMPANY_Mod(applObject_Intf applobj)
throws dbException
{
super(T_D2S_COMPANY_Sel.TABLENAME,applobj);
m_AutoincrMode = AUTOINCREMENT_MODE_ON_CLIENT;
}
/**
* Insert a new record into the database.
*
* @return the ID of the new created record
*/
public long executeInsert()
throws dbException
{
return executeInsert(T_D2S_COMPANY_Sel.COL_COMPANY_ID);
}
/**
* Insert a new record into the database.
*
* @applobj a valid application object.
* @newRecord the data for the new record.
*
* @return the ID of the new created record
*/
public static long executeInsert(applObject_Intf applobj, T_D2S_COMPANY_Obj newRecord)
throws dbException
{
T_D2S_COMPANY_Mod recordset = new T_D2S_COMPANY_Mod(applobj);
recordset.set_ADDRESS01(newRecord.get_ADDRESS01());
recordset.set_ADDRESS02(newRecord.get_ADDRESS02());
recordset.set_BELONGS_TO(newRecord.get_BELONGS_TO());
recordset.set_CITY(newRecord.get_CITY());
recordset.set_COUNTRYCODE(newRecord.get_COUNTRYCODE());
recordset.set_DATMOD(newRecord.get_DATMOD());
recordset.set_DATNEW(newRecord.get_DATNEW());
recordset.set_EMAIL(newRecord.get_EMAIL());
recordset.set_GIS_LATITUDE(newRecord.get_GIS_LATITUDE());
recordset.set_GIS_LONGITUDE(newRecord.get_GIS_LONGITUDE());
recordset.set_GROUP_ID(newRecord.get_GROUP_ID());
recordset.set_LOGIN_NAME(newRecord.get_LOGIN_NAME());
recordset.set_NAME(newRecord.get_NAME());
recordset.set_PHONE01(newRecord.get_PHONE01());
recordset.set_PHONE02(newRecord.get_PHONE02());
recordset.set_REM(newRecord.get_REM());
recordset.set_UID(newRecord.get_UID());
recordset.set_VALID_UNTIL(newRecord.get_VALID_UNTIL());
recordset.set_WWW(newRecord.get_WWW());
recordset.set_ZIPCODE(newRecord.get_ZIPCODE());
FreeValueContent freevalues[] = newRecord.getFreeValues();
recordset.setFreeval(freevalues);
return recordset.executeInsert();
}
/**
* Insert a new record into the database.
*
* @con a valid database connection.
* @applobj a valid application object.
* @newRecord the data for the new record.
*
* @return the ID of the new created record
*/
public static long executeInsert(dbConnection_Intf con,applObject_Intf applobj, T_D2S_COMPANY_Obj newRecord)
throws dbException
{
T_D2S_COMPANY_Mod recordset = new T_D2S_COMPANY_Mod(con,applobj);
recordset.set_ADDRESS01(newRecord.get_ADDRESS01());
recordset.set_ADDRESS02(newRecord.get_ADDRESS02());
recordset.set_BELONGS_TO(newRecord.get_BELONGS_TO());
recordset.set_CITY(newRecord.get_CITY());
recordset.set_COUNTRYCODE(newRecord.get_COUNTRYCODE());
recordset.set_DATMOD(newRecord.get_DATMOD());
recordset.set_DATNEW(newRecord.get_DATNEW());
recordset.set_EMAIL(newRecord.get_EMAIL());
recordset.set_GIS_LATITUDE(newRecord.get_GIS_LATITUDE());
recordset.set_GIS_LONGITUDE(newRecord.get_GIS_LONGITUDE());
recordset.set_GROUP_ID(newRecord.get_GROUP_ID());
recordset.set_LOGIN_NAME(newRecord.get_LOGIN_NAME());
recordset.set_NAME(newRecord.get_NAME());
recordset.set_PHONE01(newRecord.get_PHONE01());
recordset.set_PHONE02(newRecord.get_PHONE02());
recordset.set_REM(newRecord.get_REM());
recordset.set_UID(newRecord.get_UID());
recordset.set_VALID_UNTIL(newRecord.get_VALID_UNTIL());
recordset.set_WWW(newRecord.get_WWW());
recordset.set_ZIPCODE(newRecord.get_ZIPCODE());
FreeValueContent freevalues[] = newRecord.getFreeValues();
recordset.setFreeval(freevalues);
return recordset.executeInsert();
}
/**
* Set value for column ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param ADDRESS01 the value to be set for this column
*/
public void set_ADDRESS01(String ADDRESS01)
{
set(T_D2S_COMPANY_Sel.COL_ADDRESS01,ADDRESS01);
}
/**
* Set value for column ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param ADDRESS02 the value to be set for this column
*/
public void set_ADDRESS02(String ADDRESS02)
{
set(T_D2S_COMPANY_Sel.COL_ADDRESS02,ADDRESS02);
}
/**
* Set value for column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param BELONGS_TO the value to be set for this column
*
* @see e4s.db.systabledef.CompanyId
*/
public void set_BELONGS_TO(CompanyId BELONGS_TO)
{
set(T_D2S_COMPANY_Sel.COL_BELONGS_TO,BELONGS_TO);
}
/**
* Set value for column CITY.
* STRING(60)
* City
*
* @param CITY the value to be set for this column
*/
public void set_CITY(String CITY)
{
set(T_D2S_COMPANY_Sel.COL_CITY,CITY);
}
/**
* Set value for column COUNTRYCODE.
* CountryCode
* Countrycode
*
* @param COUNTRYCODE the value to be set for this column
*/
public void set_COUNTRYCODE(CountryCode COUNTRYCODE)
{
set(T_D2S_COMPANY_Sel.COL_COUNTRYCODE,COUNTRYCODE);
}
/**
* Set value for column DATMOD.
* DATE
* Date modified
*
* @param DATMOD the value to be set for this column
*/
public void set_DATMOD(java.util.Date DATMOD)
{
set(T_D2S_COMPANY_Sel.COL_DATMOD,DATMOD);
}
/**
* Set actual date/time for column DATMOD.
* DATE
* Date modified
*/
public void set_DATMOD()
{
set_DATMOD(new java.util.Date());
}
/**
* Set value for column DATMOD.
* DATE
* Date modified
*
* @param DATMOD the value to be set for this column
*/
public void set_DATMOD(Calendar DATMOD)
{
set_DATMOD(DATMOD == null ? null : DATMOD.getTime());
}
/**
* Set value for column DATNEW.
* DATE
* Date created
*
* @param DATNEW the value to be set for this column
*/
public void set_DATNEW(java.util.Date DATNEW)
{
set(T_D2S_COMPANY_Sel.COL_DATNEW,DATNEW);
}
/**
* Set actual date/time for column DATNEW.
* DATE
* Date created
*/
public void set_DATNEW()
{
set_DATNEW(new java.util.Date());
}
/**
* Set value for column DATNEW.
* DATE
* Date created
*
* @param DATNEW the value to be set for this column
*/
public void set_DATNEW(Calendar DATNEW)
{
set_DATNEW(DATNEW == null ? null : DATNEW.getTime());
}
/**
* Set value for column EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param EMAIL the value to be set for this column
*/
public void set_EMAIL(String EMAIL)
{
set(T_D2S_COMPANY_Sel.COL_EMAIL,EMAIL);
}
/**
* Set value for column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*
* @param GIS_LATITUDE the value to be set for this column
*/
public void set_GIS_LATITUDE(float GIS_LATITUDE)
{
set(T_D2S_COMPANY_Sel.COL_GIS_LATITUDE,GIS_LATITUDE);
}
/**
* Set value for column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*
* @param GIS_LONGITUDE the value to be set for this column
*/
public void set_GIS_LONGITUDE(float GIS_LONGITUDE)
{
set(T_D2S_COMPANY_Sel.COL_GIS_LONGITUDE,GIS_LONGITUDE);
}
/**
* Set value for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param GROUP_ID the value to be set for this column
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void set_GROUP_ID(CompanyGroup GROUP_ID)
{
set(T_D2S_COMPANY_Sel.COL_GROUP_ID,GROUP_ID);
}
/**
* Set value for column LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param LOGIN_NAME the value to be set for this column
*/
public void set_LOGIN_NAME(String LOGIN_NAME)
{
set(T_D2S_COMPANY_Sel.COL_LOGIN_NAME,LOGIN_NAME);
}
/**
* Set value for column NAME.
* STRING(60)
* Company Name
*
* @param NAME the value to be set for this column
*/
public void set_NAME(String NAME)
{
set(T_D2S_COMPANY_Sel.COL_NAME,NAME);
}
/**
* Set value for column PHONE01.
* STRING(60)
* Phone #1
*
* @param PHONE01 the value to be set for this column
*/
public void set_PHONE01(String PHONE01)
{
set(T_D2S_COMPANY_Sel.COL_PHONE01,PHONE01);
}
/**
* Set value for column PHONE02.
* STRING(60)
* Phone #2
*
* @param PHONE02 the value to be set for this column
*/
public void set_PHONE02(String PHONE02)
{
set(T_D2S_COMPANY_Sel.COL_PHONE02,PHONE02);
}
/**
* Set value for column REM.
* STRING(255)
* Remark
*
* @param REM the value to be set for this column
*/
public void set_REM(String REM)
{
set(T_D2S_COMPANY_Sel.COL_REM,REM);
}
/**
* Set value for column UID.
* STRING(10)
* VAT Number
*
* @param UID the value to be set for this column
*/
public void set_UID(String UID)
{
set(T_D2S_COMPANY_Sel.COL_UID,UID);
}
/**
* Set value for column VALID_UNTIL.
* DATE
* Valid until
*
* @param VALID_UNTIL the value to be set for this column
*/
public void set_VALID_UNTIL(java.util.Date VALID_UNTIL)
{
set(T_D2S_COMPANY_Sel.COL_VALID_UNTIL,VALID_UNTIL);
}
/**
* Set actual date/time for column VALID_UNTIL.
* DATE
* Valid until
*/
public void set_VALID_UNTIL()
{
set_VALID_UNTIL(new java.util.Date());
}
/**
* Set value for column VALID_UNTIL.
* DATE
* Valid until
*
* @param VALID_UNTIL the value to be set for this column
*/
public void set_VALID_UNTIL(Calendar VALID_UNTIL)
{
set_VALID_UNTIL(VALID_UNTIL == null ? null : VALID_UNTIL.getTime());
}
/**
* Set value for column WWW.
* STRING(60)
* WWW Address
*
* @param WWW the value to be set for this column
*/
public void set_WWW(String WWW)
{
set(T_D2S_COMPANY_Sel.COL_WWW,WWW);
}
/**
* Set value for column ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param ZIPCODE the value to be set for this column
*/
public void set_ZIPCODE(String ZIPCODE)
{
set(T_D2S_COMPANY_Sel.COL_ZIPCODE,ZIPCODE);
}
// generated using dbTable.generateClass_Function_Filter:4819
/**
* Define a filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS01(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ADDRESS01,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_ADDRESS01(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ADDRESS01,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ADDRESS01,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_ADDRESS01,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_ADDRESS01);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_ADDRESS01);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS01_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_ADDRESS01,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01.
* STRING(60)
* Address Line #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS01_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_ADDRESS01,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_ADDRESS01);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
* STRING(60)
* Address Line #1
*/
public void where_ADDRESS01_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_ADDRESS01);
}
/**
* Define a filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS02(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ADDRESS02,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_ADDRESS02(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ADDRESS02,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ADDRESS02,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_ADDRESS02,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_ADDRESS02);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_ADDRESS02);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS02_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_ADDRESS02,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02.
* STRING(60)
* Address Line #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ADDRESS02_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_ADDRESS02,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_ADDRESS02);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
* STRING(60)
* Address Line #2
*/
public void where_ADDRESS02_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_ADDRESS02);
}
/**
* Define a filter (AND-ed WHERE) for column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO(final CompanyId filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_BELONGS_TO,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO(int operator, final CompanyId filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_BELONGS_TO,operator,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_BELONGS_TO,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Company belongs to another company (can be null or empty)
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_BELONGS_TO_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_BELONGS_TO,filter);
}
/**
* Define a filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
*/
public void where_CITY(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_CITY,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_CITY(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_CITY,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_CITY,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_CITY,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_CITY);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_CITY);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
*/
public void where_CITY_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_CITY,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY.
* STRING(60)
* City
*
* @param filter the value to be compared within the SQL statement
*/
public void where_CITY_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_CITY,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_CITY);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
* STRING(60)
* City
*/
public void where_CITY_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_CITY);
}
/**
* Define a filter (AND-ed WHERE) for column COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID(final CompanyId filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_COMPANY_ID,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID(int operator, final CompanyId filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_COMPANY_ID,operator,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_COMPANY_ID,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID.
* CompanyId
* defined as e4s.util.e4sLong Numeric, incremental ID for companies
* Primary key, company - ID
* Autoincremental value
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyId
*/
public void where_COMPANY_ID_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_COMPANY_ID,filter);
}
/**
* Define a filter (AND-ed WHERE) for column COUNTRYCODE.
* CountryCode
* Countrycode
*
* @param filter the value to be compared within the SQL statement
*/
public void where_COUNTRYCODE(final CountryCode filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_COUNTRYCODE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column COUNTRYCODE.
* CountryCode
* Countrycode
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_COUNTRYCODE(int operator, final CountryCode filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_COUNTRYCODE,operator,filter);
}
/**
* Define a filter (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATMOD(final java.util.Date filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_DATMOD,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_DATMOD(int operator, final java.util.Date filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_DATMOD,operator,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_DATMOD);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_DATMOD);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATMOD_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_DATMOD,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD.
* DATE
* Date modified
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATMOD_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_DATMOD,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_DATMOD);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
* DATE
* Date modified
*/
public void where_DATMOD_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_DATMOD);
}
/**
* Define a filter (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATNEW(final java.util.Date filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_DATNEW,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_DATNEW(int operator, final java.util.Date filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_DATNEW,operator,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_DATNEW);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_DATNEW);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATNEW_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_DATNEW,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW.
* DATE
* Date created
*
* @param filter the value to be compared within the SQL statement
*/
public void where_DATNEW_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_DATNEW,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_DATNEW);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
* DATE
* Date created
*/
public void where_DATNEW_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_DATNEW);
}
/**
* Define a filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
*/
public void where_EMAIL(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_EMAIL,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_EMAIL(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_EMAIL,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_EMAIL,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_EMAIL,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_EMAIL);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_EMAIL);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
*/
public void where_EMAIL_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_EMAIL,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL.
* STRING(60)
* Corporate E-Mail
*
* @param filter the value to be compared within the SQL statement
*/
public void where_EMAIL_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_EMAIL,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_EMAIL);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
* STRING(60)
* Corporate E-Mail
*/
public void where_EMAIL_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_EMAIL);
}
/**
* Define a filter (AND-ed WHERE) for column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*
* @param filter the value to be compared within the SQL statement
*/
public void where_GIS_LATITUDE(final float filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_GIS_LATITUDE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column GIS_LATITUDE.
* FLOAT
* GIS Latitude
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_GIS_LATITUDE(int operator, final float filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_GIS_LATITUDE,operator,filter);
}
/**
* Define a filter (AND-ed WHERE) for column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*
* @param filter the value to be compared within the SQL statement
*/
public void where_GIS_LONGITUDE(final float filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_GIS_LONGITUDE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column GIS_LONGITUDE.
* FLOAT
* GIS Longitude
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_GIS_LONGITUDE(int operator, final float filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_GIS_LONGITUDE,operator,filter);
}
/**
* Define a filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID(final CompanyGroup filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_GROUP_ID,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID(int operator, final CompanyGroup filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_GROUP_ID,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_in(final CompanyGroup filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_GROUP_ID,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_not_in(final CompanyGroup filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_GROUP_ID,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_GROUP_ID);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_GROUP_ID);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_GROUP_ID,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @param filter the value to be compared within the SQL statement
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_GROUP_ID,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_GROUP_ID);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
* CompanyGroup
* defined as e4s.util.e4sString(16) Company Group
* Belongs to Group
*
* @see e4s.db.systabledef.CompanyGroup
*/
public void where_GROUP_ID_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_GROUP_ID);
}
/**
* Define a filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
*/
public void where_LOGIN_NAME(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_LOGIN_NAME,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_LOGIN_NAME(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_LOGIN_NAME,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_LOGIN_NAME,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_LOGIN_NAME,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_LOGIN_NAME);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_LOGIN_NAME);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
*/
public void where_LOGIN_NAME_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_LOGIN_NAME,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME.
* STRING(16)
* Name for login
*
* @param filter the value to be compared within the SQL statement
*/
public void where_LOGIN_NAME_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_LOGIN_NAME,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_LOGIN_NAME);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
* STRING(16)
* Name for login
*/
public void where_LOGIN_NAME_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_LOGIN_NAME);
}
/**
* Define a filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
*/
public void where_NAME(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_NAME,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_NAME(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_NAME,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_NAME,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_NAME,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_NAME);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_NAME);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
*/
public void where_NAME_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_NAME,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME.
* STRING(60)
* Company Name
*
* @param filter the value to be compared within the SQL statement
*/
public void where_NAME_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_NAME,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_NAME);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
* STRING(60)
* Company Name
*/
public void where_NAME_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_NAME);
}
/**
* Define a filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE01(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_PHONE01,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_PHONE01(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_PHONE01,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_PHONE01,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_PHONE01,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_PHONE01);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_PHONE01);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE01_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_PHONE01,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01.
* STRING(60)
* Phone #1
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE01_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_PHONE01,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_PHONE01);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
* STRING(60)
* Phone #1
*/
public void where_PHONE01_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_PHONE01);
}
/**
* Define a filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE02(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_PHONE02,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_PHONE02(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_PHONE02,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_PHONE02,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_PHONE02,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_PHONE02);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_PHONE02);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE02_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_PHONE02,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02.
* STRING(60)
* Phone #2
*
* @param filter the value to be compared within the SQL statement
*/
public void where_PHONE02_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_PHONE02,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_PHONE02);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
* STRING(60)
* Phone #2
*/
public void where_PHONE02_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_PHONE02);
}
/**
* Define a filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
*/
public void where_REM(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_REM,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_REM(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_REM,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_REM,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_REM,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_REM);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_REM);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
*/
public void where_REM_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_REM,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM.
* STRING(255)
* Remark
*
* @param filter the value to be compared within the SQL statement
*/
public void where_REM_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_REM,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_REM);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
* STRING(255)
* Remark
*/
public void where_REM_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_REM);
}
/**
* Define a filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
*/
public void where_UID(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_UID,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_UID(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_UID,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_UID,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_UID,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_UID);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_UID);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
*/
public void where_UID_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_UID,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID.
* STRING(10)
* VAT Number
*
* @param filter the value to be compared within the SQL statement
*/
public void where_UID_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_UID,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_UID);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
* STRING(10)
* VAT Number
*/
public void where_UID_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_UID);
}
/**
* Define a filter (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
*/
public void where_VALID_UNTIL(final java.util.Date filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_VALID_UNTIL,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_VALID_UNTIL(int operator, final java.util.Date filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_VALID_UNTIL,operator,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_VALID_UNTIL);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_VALID_UNTIL);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
*/
public void where_VALID_UNTIL_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_VALID_UNTIL,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL.
* DATE
* Valid until
*
* @param filter the value to be compared within the SQL statement
*/
public void where_VALID_UNTIL_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_VALID_UNTIL,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_VALID_UNTIL);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
* DATE
* Valid until
*/
public void where_VALID_UNTIL_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_VALID_UNTIL);
}
/**
* Define a filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
*/
public void where_WWW(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_WWW,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_WWW(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_WWW,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_WWW,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_WWW,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_WWW);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_WWW);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
*/
public void where_WWW_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_WWW,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW.
* STRING(60)
* WWW Address
*
* @param filter the value to be compared within the SQL statement
*/
public void where_WWW_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_WWW,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_WWW);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
* STRING(60)
* WWW Address
*/
public void where_WWW_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_WWW);
}
/**
* Define a filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ZIPCODE(final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ZIPCODE,filter);
}
/**
* Define a filter (AND-ed WHERE with operator) for column ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
* @param operator the comparsion operator {@link e4s.db.dbFilter}
*/
public void where_ZIPCODE(int operator, final String filter)
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ZIPCODE,operator,filter);
}
/**
* Define a IN-filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_in(final String filter[])
throws dbException
{
setFilter(T_D2S_COMPANY_Sel.COL_ZIPCODE,filter);
}
/**
* Define a NOT-IN-filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_not_in(final String filter[])
throws dbException
{
setFilter_NOT(T_D2S_COMPANY_Sel.COL_ZIPCODE,filter);
}
/**
* Define a is-null filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isNull()
throws dbException
{
isNull(T_D2S_COMPANY_Sel.COL_ZIPCODE);
}
/**
* Define a is-NOT-null filter (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isNotNull()
throws dbException
{
isNotNull(T_D2S_COMPANY_Sel.COL_ZIPCODE);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ZIPCODE_IN(final dbSelectDistinct filter)
throws dbException
{
setFilter_IN(T_D2S_COMPANY_Sel.COL_ZIPCODE,filter);
}
/**
* Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE.
* STRING(10)
* ZIP Code
*
* @param filter the value to be compared within the SQL statement
*/
public void where_ZIPCODE_NOTIN(final dbSelectDistinct filter)
throws dbException
{
setFilter_NOT_IN(T_D2S_COMPANY_Sel.COL_ZIPCODE,filter);
}
/**
* Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isEmpty()
throws dbException
{
isEmpty(T_D2S_COMPANY_Sel.COL_ZIPCODE);
}
/**
* Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
* STRING(10)
* ZIP Code
*/
public void where_ZIPCODE_isNotEmpty()
throws dbException
{
isNotEmpty(T_D2S_COMPANY_Sel.COL_ZIPCODE);
}
/*
* List of references for delete trigger.
*
* @return null if no delete references are set or an array of objects of
* class {@link e4s.db.dbReference} with associated tables.
*/
public dbReference[] getReferenceDelete(dbColumnName cName)
{
return null;
}
/*
* List of references for lookup-reference trigger.
*
* @return null if no delete references are set or an array of objects of
* class {@link e4s.db.dbReference} with associated tables.
*/
public dbReference[] getReferenceLookup(dbColumnName cName)
{
return null;
}
public void set(FIELDSET fieldset)
throws dbException
{
try
{
if (fieldset == null)
throw new dbException("Invalid fieldset (null) for T_D2S_COMPANY");
InputField_Intf f_ADDRESS01 = fieldset.getField(T_D2S_COMPANY_Sel.COL_ADDRESS01);
if (f_ADDRESS01 != null)
{
set_ADDRESS01(f_ADDRESS01.getValue_native());
}
InputField_Intf f_ADDRESS02 = fieldset.getField(T_D2S_COMPANY_Sel.COL_ADDRESS02);
if (f_ADDRESS02 != null)
{
set_ADDRESS02(f_ADDRESS02.getValue_native());
}
InputField_Intf f_BELONGS_TO = fieldset.getField(T_D2S_COMPANY_Sel.COL_BELONGS_TO);
if (f_BELONGS_TO != null)
{
if (f_BELONGS_TO instanceof LONGFIELD)
{
long l_BELONGS_TO = ((LONGFIELD)f_BELONGS_TO).getValue();
set_BELONGS_TO(new CompanyId(l_BELONGS_TO));
}
else
{
try
{
String h = f_BELONGS_TO.getValue_native();
if (isok(h))
{
long l_BELONGS_TO = Long.parseLong(h);
set_BELONGS_TO(new CompanyId(l_BELONGS_TO));
}
}
catch(NumberFormatException ne)
{
throw ne;
}
}
}
InputField_Intf f_CITY = fieldset.getField(T_D2S_COMPANY_Sel.COL_CITY);
if (f_CITY != null)
{
set_CITY(f_CITY.getValue_native());
}
InputField_Intf f_COUNTRYCODE = fieldset.getField(T_D2S_COMPANY_Sel.COL_COUNTRYCODE);
if (f_COUNTRYCODE != null)
{
String s_COUNTRYCODE = f_COUNTRYCODE.getValue_native();
set_COUNTRYCODE(new CountryCode(s_COUNTRYCODE));
}
InputField_Intf f_DATMOD = fieldset.getField(T_D2S_COMPANY_Sel.COL_DATMOD);
if (f_DATMOD != null)
{
java.util.Date d_DATMOD;
if (f_DATMOD instanceof DATEFIELD)
d_DATMOD = ((DATEFIELD)f_DATMOD).getValue();
else
throw new Exception("Internal Error: " + f_DATMOD.toString() + ", expected: e4s.html.input.extended.DATEFIELD");
set_DATMOD(d_DATMOD);
}
InputField_Intf f_DATNEW = fieldset.getField(T_D2S_COMPANY_Sel.COL_DATNEW);
if (f_DATNEW != null)
{
java.util.Date d_DATNEW;
if (f_DATNEW instanceof DATEFIELD)
d_DATNEW = ((DATEFIELD)f_DATNEW).getValue();
else
throw new Exception("Internal Error: " + f_DATNEW.toString() + ", expected: e4s.html.input.extended.DATEFIELD");
set_DATNEW(d_DATNEW);
}
InputField_Intf f_EMAIL = fieldset.getField(T_D2S_COMPANY_Sel.COL_EMAIL);
if (f_EMAIL != null)
{
set_EMAIL(f_EMAIL.getValue_native());
}
InputField_Intf f_GIS_LATITUDE = fieldset.getField(T_D2S_COMPANY_Sel.COL_GIS_LATITUDE);
if (f_GIS_LATITUDE != null)
{
if (f_GIS_LATITUDE instanceof FLOATFIELD)
{
float fl_GIS_LATITUDE = ((FLOATFIELD)f_GIS_LATITUDE).getValue();
set_GIS_LATITUDE(fl_GIS_LATITUDE);
}
else
{
try
{
String h = f_GIS_LATITUDE.getValue_native();
if (isok(h))
{
float fl_GIS_LATITUDE = Float.parseFloat(h);
set_GIS_LATITUDE(fl_GIS_LATITUDE);
}
}
catch(NumberFormatException ne)
{
throw ne;
}
}
}
InputField_Intf f_GIS_LONGITUDE = fieldset.getField(T_D2S_COMPANY_Sel.COL_GIS_LONGITUDE);
if (f_GIS_LONGITUDE != null)
{
if (f_GIS_LONGITUDE instanceof FLOATFIELD)
{
float fl_GIS_LONGITUDE = ((FLOATFIELD)f_GIS_LONGITUDE).getValue();
set_GIS_LONGITUDE(fl_GIS_LONGITUDE);
}
else
{
try
{
String h = f_GIS_LONGITUDE.getValue_native();
if (isok(h))
{
float fl_GIS_LONGITUDE = Float.parseFloat(h);
set_GIS_LONGITUDE(fl_GIS_LONGITUDE);
}
}
catch(NumberFormatException ne)
{
throw ne;
}
}
}
InputField_Intf f_GROUP_ID = fieldset.getField(T_D2S_COMPANY_Sel.COL_GROUP_ID);
if (f_GROUP_ID != null)
{
String s_GROUP_ID = f_GROUP_ID.getValue_native();
set_GROUP_ID(new CompanyGroup(s_GROUP_ID));
}
InputField_Intf f_LOGIN_NAME = fieldset.getField(T_D2S_COMPANY_Sel.COL_LOGIN_NAME);
if (f_LOGIN_NAME != null)
{
set_LOGIN_NAME(f_LOGIN_NAME.getValue_native());
}
InputField_Intf f_NAME = fieldset.getField(T_D2S_COMPANY_Sel.COL_NAME);
if (f_NAME != null)
{
set_NAME(f_NAME.getValue_native());
}
InputField_Intf f_PHONE01 = fieldset.getField(T_D2S_COMPANY_Sel.COL_PHONE01);
if (f_PHONE01 != null)
{
set_PHONE01(f_PHONE01.getValue_native());
}
InputField_Intf f_PHONE02 = fieldset.getField(T_D2S_COMPANY_Sel.COL_PHONE02);
if (f_PHONE02 != null)
{
set_PHONE02(f_PHONE02.getValue_native());
}
InputField_Intf f_REM = fieldset.getField(T_D2S_COMPANY_Sel.COL_REM);
if (f_REM != null)
{
set_REM(f_REM.getValue_native());
}
InputField_Intf f_UID = fieldset.getField(T_D2S_COMPANY_Sel.COL_UID);
if (f_UID != null)
{
set_UID(f_UID.getValue_native());
}
InputField_Intf f_VALID_UNTIL = fieldset.getField(T_D2S_COMPANY_Sel.COL_VALID_UNTIL);
if (f_VALID_UNTIL != null)
{
java.util.Date d_VALID_UNTIL;
if (f_VALID_UNTIL instanceof DATEFIELD)
d_VALID_UNTIL = ((DATEFIELD)f_VALID_UNTIL).getValue();
else
throw new Exception("Internal Error: " + f_VALID_UNTIL.toString() + ", expected: e4s.html.input.extended.DATEFIELD");
set_VALID_UNTIL(d_VALID_UNTIL);
}
InputField_Intf f_WWW = fieldset.getField(T_D2S_COMPANY_Sel.COL_WWW);
if (f_WWW != null)
{
set_WWW(f_WWW.getValue_native());
}
InputField_Intf f_ZIPCODE = fieldset.getField(T_D2S_COMPANY_Sel.COL_ZIPCODE);
if (f_ZIPCODE != null)
{
set_ZIPCODE(f_ZIPCODE.getValue_native());
}
}
catch( Exception e )
{
throw new dbException(e);
}
}
// generated using dbTable.generateClass_setParams:2850
/**
* Read the field values out of the {@link e4s.html.CgiParameters} and store them into the database fields.
*
* @param params the parameters
*/
public void set( CgiParameters params )
throws Exception
{
if (params != null)
{
String s_ADDRESS01 = params.get(T_D2S_COMPANY_Sel.COL_ADDRESS01);
if (s_ADDRESS01 != null)
set_ADDRESS01(s_ADDRESS01);
String s_ADDRESS02 = params.get(T_D2S_COMPANY_Sel.COL_ADDRESS02);
if (s_ADDRESS02 != null)
set_ADDRESS02(s_ADDRESS02);
long l_BELONGS_TO = params.getLong(T_D2S_COMPANY_Sel.COL_BELONGS_TO);
if (l_BELONGS_TO != -1)
set_BELONGS_TO(new CompanyId(l_BELONGS_TO));
String s_CITY = params.get(T_D2S_COMPANY_Sel.COL_CITY);
if (s_CITY != null)
set_CITY(s_CITY);
String s_COUNTRYCODE = params.get(T_D2S_COMPANY_Sel.COL_COUNTRYCODE);
if (s_COUNTRYCODE != null)
set_COUNTRYCODE(new CountryCode(s_COUNTRYCODE));
java.util.Date d_DATMOD = params.getDate(T_D2S_COMPANY_Sel.COL_DATMOD);
if (d_DATMOD != null)
set_DATMOD(d_DATMOD);
java.util.Date d_DATNEW = params.getDate(T_D2S_COMPANY_Sel.COL_DATNEW);
if (d_DATNEW != null)
set_DATNEW(d_DATNEW);
String s_EMAIL = params.get(T_D2S_COMPANY_Sel.COL_EMAIL);
if (s_EMAIL != null)
set_EMAIL(s_EMAIL);
float f_GIS_LATITUDE = params.getFloat(T_D2S_COMPANY_Sel.COL_GIS_LATITUDE);
set_GIS_LATITUDE(f_GIS_LATITUDE);
float f_GIS_LONGITUDE = params.getFloat(T_D2S_COMPANY_Sel.COL_GIS_LONGITUDE);
set_GIS_LONGITUDE(f_GIS_LONGITUDE);
String s_GROUP_ID = params.get(T_D2S_COMPANY_Sel.COL_GROUP_ID);
if (s_GROUP_ID != null)
set_GROUP_ID(new CompanyGroup(s_GROUP_ID));
String s_LOGIN_NAME = params.get(T_D2S_COMPANY_Sel.COL_LOGIN_NAME);
if (s_LOGIN_NAME != null)
set_LOGIN_NAME(s_LOGIN_NAME);
String s_NAME = params.get(T_D2S_COMPANY_Sel.COL_NAME);
if (s_NAME != null)
set_NAME(s_NAME);
String s_PHONE01 = params.get(T_D2S_COMPANY_Sel.COL_PHONE01);
if (s_PHONE01 != null)
set_PHONE01(s_PHONE01);
String s_PHONE02 = params.get(T_D2S_COMPANY_Sel.COL_PHONE02);
if (s_PHONE02 != null)
set_PHONE02(s_PHONE02);
String s_REM = params.get(T_D2S_COMPANY_Sel.COL_REM);
if (s_REM != null)
set_REM(s_REM);
String s_UID = params.get(T_D2S_COMPANY_Sel.COL_UID);
if (s_UID != null)
set_UID(s_UID);
java.util.Date d_VALID_UNTIL = params.getDate(T_D2S_COMPANY_Sel.COL_VALID_UNTIL);
if (d_VALID_UNTIL != null)
set_VALID_UNTIL(d_VALID_UNTIL);
String s_WWW = params.get(T_D2S_COMPANY_Sel.COL_WWW);
if (s_WWW != null)
set_WWW(s_WWW);
String s_ZIPCODE = params.get(T_D2S_COMPANY_Sel.COL_ZIPCODE);
if (s_ZIPCODE != null)
set_ZIPCODE(s_ZIPCODE);
}
}
// generated using dbTable.generateClass_RemoveAll:3723
/**
* Remove all data from table T_D2S_COMPANY containing data from the specified client
*
* @param con a valid, open database connection
* @param applobj the current application object (not necessary the client to be removed)
* @param client the client to be removed
*/
public static void removeAllClientData(dbConnection_Intf con, applObject_Intf applobj, Client client)
throws dbException
{
String sql = "delete from " + T_D2S_COMPANY_Sel.TABLENAME + " where CLIENT='" + client + "'";
executeSQL(con,applobj,sql);
}
/**
* Remove all data from table T_D2S_COMPANY
*
* @param con a valid, open database connection
* @param applobj the current application object
*/
public static void removeAllData(dbConnection_Intf con, applObject_Intf applobj)
throws dbException
{
String sql = "delete from " + T_D2S_COMPANY_Sel.TABLENAME;
executeSQL(con,applobj,sql);
}
/**
* Import data from XML file into database table.
*
* @param appobj the current application object containing client informations
* @param path the path for file export
*
* @return the number of records written
*/
public static int fromXml(applObject_Intf appobj, String path)
throws dbException, IOException, ParserConfigurationException, SAXException
{
dbConnectionTransactional con = dbConnectionTransactional.getTransactionalConnection();
int res = fromXml(con, appobj, path);
con.commit();
return res;
}
/**
* Import data from XML file into database table.
*
* @param con the database connection to be used for insert
* @param appobj the current application object containing client informations
* @param path the path for file export
*
* @return the number of records written
*/
public static int fromXml(dbConnectionTransactional con, applObject_Intf appobj, String path)
throws dbException, IOException, ParserConfigurationException, SAXException
{
int res = 0;
String filename = e4sUtil.concatenatePath(path,T_D2S_COMPANY_Sel.TABLENAME.getName() + ".xml");
File f = new File(filename);
if (con == null)
throw new dbException("Invalid database connection");
if (f.exists())
{
xmlImportHandler xml = new xmlImportHandler(con,T_D2S_COMPANY_Sel.TABLENAME,appobj);
XMLReader parser = e4sUtil.makeXMLReader();
parser.setContentHandler(xml);
parser.parse(new InputSource(filename));
res = xml.getNumRecords();
}
else
{
throw new IOException("File " + filename + " not found!");
}
return res;
}
// generated using dbTable.generateClass_Duplicate:3646
/**
* Copy data from the current client to another.
*
* @param copyTo the new client
*/
public void duplicateAllClientData( Client copyTo)
throws dbException
{
duplicateAllClientData( getConnection(),
getApplicationObject(),
getApplicationObject().getClient(),
copyTo );
}
/**
* Copy data from one client to another.
*
* @param con the database connection
* @param appobj the current application object
* @param copyFrom the old client
* @param copyTo the new client
*/
public static void duplicateAllClientData( dbConnection_Intf con, applObject_Intf appobj, Client copyFrom, Client copyTo)
throws dbException
{
if (! isok(copyFrom))
throw new dbException("copyFrom - value is missing");
if (! isok(copyTo))
throw new dbException("copyTo - value is missing");
String sql = "INSERT INTO " + T_D2S_COMPANY_Sel.TABLENAME + " ";
sql += "(" + Client.COLUMN_NAME + ",";
sql += T_D2S_COMPANY_Sel.COL_ADDRESS01 + ",";
sql += T_D2S_COMPANY_Sel.COL_ADDRESS02 + ",";
sql += T_D2S_COMPANY_Sel.COL_BELONGS_TO + ",";
sql += T_D2S_COMPANY_Sel.COL_CITY + ",";
sql += T_D2S_COMPANY_Sel.COL_COMPANY_ID + ",";
sql += T_D2S_COMPANY_Sel.COL_COUNTRYCODE + ",";
sql += T_D2S_COMPANY_Sel.COL_DATMOD + ",";
sql += T_D2S_COMPANY_Sel.COL_DATNEW + ",";
sql += T_D2S_COMPANY_Sel.COL_EMAIL + ",";
sql += T_D2S_COMPANY_Sel.COL_GIS_LATITUDE + ",";
sql += T_D2S_COMPANY_Sel.COL_GIS_LONGITUDE + ",";
sql += T_D2S_COMPANY_Sel.COL_GROUP_ID + ",";
sql += T_D2S_COMPANY_Sel.COL_LOGIN_NAME + ",";
sql += T_D2S_COMPANY_Sel.COL_NAME + ",";
sql += T_D2S_COMPANY_Sel.COL_PHONE01 + ",";
sql += T_D2S_COMPANY_Sel.COL_PHONE02 + ",";
sql += T_D2S_COMPANY_Sel.COL_REM + ",";
sql += T_D2S_COMPANY_Sel.COL_UID + ",";
sql += T_D2S_COMPANY_Sel.COL_VALID_UNTIL + ",";
sql += T_D2S_COMPANY_Sel.COL_WWW + ",";
sql += T_D2S_COMPANY_Sel.COL_ZIPCODE+ ") ";
sql += "SELECT '" + copyTo + "'" + ",";
sql += T_D2S_COMPANY_Sel.COL_ADDRESS01 + ",";
sql += T_D2S_COMPANY_Sel.COL_ADDRESS02 + ",";
sql += T_D2S_COMPANY_Sel.COL_BELONGS_TO + ",";
sql += T_D2S_COMPANY_Sel.COL_CITY + ",";
sql += T_D2S_COMPANY_Sel.COL_COMPANY_ID + ",";
sql += T_D2S_COMPANY_Sel.COL_COUNTRYCODE + ",";
sql += T_D2S_COMPANY_Sel.COL_DATMOD + ",";
sql += T_D2S_COMPANY_Sel.COL_DATNEW + ",";
sql += T_D2S_COMPANY_Sel.COL_EMAIL + ",";
sql += T_D2S_COMPANY_Sel.COL_GIS_LATITUDE + ",";
sql += T_D2S_COMPANY_Sel.COL_GIS_LONGITUDE + ",";
sql += T_D2S_COMPANY_Sel.COL_GROUP_ID + ",";
sql += T_D2S_COMPANY_Sel.COL_LOGIN_NAME + ",";
sql += T_D2S_COMPANY_Sel.COL_NAME + ",";
sql += T_D2S_COMPANY_Sel.COL_PHONE01 + ",";
sql += T_D2S_COMPANY_Sel.COL_PHONE02 + ",";
sql += T_D2S_COMPANY_Sel.COL_REM + ",";
sql += T_D2S_COMPANY_Sel.COL_UID + ",";
sql += T_D2S_COMPANY_Sel.COL_VALID_UNTIL + ",";
sql += T_D2S_COMPANY_Sel.COL_WWW + ",";
sql += T_D2S_COMPANY_Sel.COL_ZIPCODE;
sql += "FROM " + T_D2S_COMPANY_Sel.TABLENAME;
sql += "WHERE " + Client.COLUMN_NAME + " = '" + copyFrom + "'";
dbModify.executeSQL(con,appobj,sql);
}
/**
* Create a {@link e4s.html.input.extended.FIELDSET} object that includes all the input fields for the
* freefield definitions.
*
* @param applobj the application object
*
* @return the new created FIELDSET
*
* @see e4s.db.dbModifyFreefields#getFreevalInputfields(e4s.application.applObject_Intf,e4s.db.dbTableName)
*/
public static FIELDSET getFreevalInputfields( applObject_Intf applobj )
throws dbException
{
return dbModifyFreefields.getFreevalInputfields(applobj,T_D2S_COMPANY_Sel.TABLENAME);
}
/**
* Get the definitions of the free fields.
*
* @param applobj the application object
*
* @return the definitions for table T_D2S_COMPANY.
*
* @see e4s.db.freefield.dbSelectFreefields#getFreevalDefinitions(e4s.application.applObject_Intf,e4s.db.dbTableName)
* @see e4s.db.freefield.dbSelectFreefields#getFreevalDefinitions()
*/
public static T_D2S_FREEFIELD_DEF_Obj[] getFreevalDefinitions(applObject_Intf applobj)
throws dbException
{
return dbModifyFreefields.getFreevalDefinitions(applobj,T_D2S_COMPANY_Sel.TABLENAME);
}
public void executeDelete()
throws dbException
{
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(getApplicationObject());
T_D2S_COMPANY.setWhere(getWhere());
T_D2S_COMPANY.executeQuery();
while (T_D2S_COMPANY.next())
{
T_D2S_FREEFIELD_VAL_Mod del_T_D2S_FREEFIELD_VAL = new T_D2S_FREEFIELD_VAL_Mod(getApplicationObject());
del_T_D2S_FREEFIELD_VAL.where_DB_TABLE(T_D2S_COMPANY_Sel.TABLENAME.getName());
del_T_D2S_FREEFIELD_VAL.where_IDX1(T_D2S_COMPANY.getString(T_D2S_COMPANY_Sel.COL_COMPANY_ID));
del_T_D2S_FREEFIELD_VAL.executeDelete();
}
T_D2S_COMPANY.close();
super.executeDelete();
}
public void executeUpdate()
throws dbException
{
T_D2S_COMPANY_Sel T_D2S_COMPANY = new T_D2S_COMPANY_Sel(getApplicationObject());
T_D2S_COMPANY.setWhere(getWhere());
T_D2S_COMPANY.executeQuery();
while (T_D2S_COMPANY.next())
{
String h_COMPANY_ID = T_D2S_COMPANY.getString(T_D2S_COMPANY_Sel.COL_COMPANY_ID);
updateFreevalues(T_D2S_COMPANY_Sel.TABLENAME,h_COMPANY_ID);
}
T_D2S_COMPANY.close();
super.executeUpdate();
}
public long executeInsert( dbColumnName autoincrName )
throws dbException
{
long res = super.executeInsert(autoincrName);
String h_COMPANY_ID = Long.toString(res);
insertFreevalues(T_D2S_COMPANY_Sel.TABLENAME,h_COMPANY_ID);
return res;
}
}