public class OportunityLoader extends java.lang.Object implements ImportLoader
Modifier and Type | Field and Description |
---|---|
static int |
bo_private |
static int |
dt_created |
static int |
dt_last_call |
static int |
dt_modified |
static int |
dt_next_action |
static int |
gu_campaign |
static int |
gu_company |
static int |
gu_contact |
static int |
gu_oportunity |
static int |
gu_workarea |
static int |
gu_writer |
static int |
id_objetive |
static int |
id_ref |
static int |
id_status |
static int |
im_cost |
static int |
im_revenue |
static int |
lv_interest |
static int |
MODE_APPEND |
static int |
MODE_APPENDUPDATE |
static int |
MODE_UPDATE |
static int |
sn_passport |
static int |
tl_oportunity |
static int |
tp_oportunity |
static int |
tp_origin |
static int |
tx_cause |
static int |
tx_company |
static int |
tx_contact |
static int |
tx_email |
static int |
tx_note |
static int |
WRITE_LOOKUPS |
LOOUKP_TR_COLUMNS, LOOUKP_TR_COUNT
Constructor and Description |
---|
OportunityLoader() |
Modifier and Type | Method and Description |
---|---|
void |
close()
Close ImportLoader
Must be always called before ImportLoader is destroyed
|
int |
columnCount()
Get columns count
|
java.lang.String[] |
columnNames()
Get array of column names
|
java.lang.Object |
get(int iColumnIndex)
Get current value for a column given its index
|
java.lang.Object |
get(java.lang.String sColumnName)
Get current value for a column given its name
|
int |
getColumnIndex(java.lang.String sColumnName)
Get column index from its name
|
void |
prepare(java.sql.Connection oConn,
ColumnList oCols)
Prepare ImportLoader for repeated execution
|
void |
put(int iColumnIndex,
java.lang.Object oValue)
Put current value for a column
|
void |
put(java.lang.String sColumnName,
java.lang.Object oValue)
Put current value for a column
|
void |
setAllColumnsToNull()
Set all current values to null
|
void |
store(java.sql.Connection oConn,
java.lang.String sWorkArea,
int iFlags)
Store a single row or a set of related rows
|
public static final int MODE_APPEND
public static final int MODE_UPDATE
public static final int MODE_APPENDUPDATE
public static final int WRITE_LOOKUPS
public static int bo_private
public static int dt_created
public static int dt_last_call
public static int dt_modified
public static int dt_next_action
public static int gu_campaign
public static int gu_company
public static int gu_contact
public static int gu_oportunity
public static int gu_workarea
public static int gu_writer
public static int id_objetive
public static int id_ref
public static int id_status
public static int im_cost
public static int im_revenue
public static int lv_interest
public static int sn_passport
public static int tl_oportunity
public static int tp_oportunity
public static int tp_origin
public static int tx_cause
public static int tx_company
public static int tx_contact
public static int tx_email
public static int tx_note
public int columnCount()
ImportLoader
columnCount
in interface ImportLoader
public java.lang.String[] columnNames() throws java.lang.IllegalStateException
ImportLoader
columnNames
in interface ImportLoader
java.lang.IllegalStateException
public java.lang.Object get(int iColumnIndex) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
get
in interface ImportLoader
iColumnIndex
- int [0..columnCount()-1]java.lang.ArrayIndexOutOfBoundsException
public java.lang.Object get(java.lang.String sColumnName) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
get
in interface ImportLoader
sColumnName
- Case insensitive Stringjava.lang.ArrayIndexOutOfBoundsException
- if no column with such name was foundpublic int getColumnIndex(java.lang.String sColumnName)
ImportLoader
getColumnIndex
in interface ImportLoader
sColumnName
- Stringpublic void put(int iColumnIndex, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
put
in interface ImportLoader
iColumnIndex
- int [0..columnCount()-1]oValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
public void put(java.lang.String sColumnName, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
put
in interface ImportLoader
sColumnName
- String Column nameoValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
public void setAllColumnsToNull()
ImportLoader
setAllColumnsToNull
in interface ImportLoader
public void prepare(java.sql.Connection oConn, ColumnList oCols) throws java.sql.SQLException
ImportLoader
prepare
in interface ImportLoader
oConn
- ConnectionoCols
- ColumnList List of columns that will be inserted or updated at the databasejava.sql.SQLException
public void close() throws java.sql.SQLException
ImportLoader
Close ImportLoader
Must be always called before ImportLoader is destroyedclose
in interface ImportLoader
java.sql.SQLException
public void store(java.sql.Connection oConn, java.lang.String sWorkArea, int iFlags) throws java.sql.SQLException, java.lang.IllegalArgumentException, java.lang.NullPointerException
ImportLoader
store
in interface ImportLoader
oConn
- ConnectionsWorkArea
- StringiFlags
- intjava.sql.SQLException
java.lang.IllegalArgumentException
java.lang.NullPointerException