public interface RowSetInterface
extends com.deltek.enterprise.system.serverapi.remoteapi.rowset.BasicRowSetInterface
ResultSetInterface
,
AppInterface
Modifier and Type | Field and Description |
---|---|
static byte |
ROW_ChildModified
Set by the system in parent row set.Indicates that child has been modified in always validate mode.
|
static byte |
ROW_Loaded
Indicates row is loaded in memory on the server.
|
static byte |
ROW_Selected
Indicates row is selected.
|
static byte |
ROW_Unvalidated
Indicates row is not validated through the client.
|
Modifier and Type | Method and Description |
---|---|
int |
addNewRow()
Add a new empty row to the row set.
|
boolean |
checkRowStatus(byte flag)
checks whether given flag is set
|
void |
clearAllRowsStatus()
Clears all flags in all rows in the result set
|
void |
clearRowStatus()
Clears all flags in context row in the result set
|
void |
enableDigitalSign(boolean flag)
Enables or disables digital signature for context row in the RS.
|
char |
getchar(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as a char.
|
double |
getColumnDelta(java.lang.String sObjectId)
Returns back delta of all changes made to the specified column.
|
double |
getColumnDelta(java.lang.String sObjectId,
double columnTotal)
Returns back the difference between the delta of all changes made to the specified column and the
columnTotal number or 0 if they are equal according to the framework number compare algorithm
( you cannot use java == method because java computations are not precise ).
|
java.util.Calendar |
getDate(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as a Calendar.
|
double |
getdouble(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as a double.
|
java.lang.Double |
getDouble(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as a Double.
|
int |
getint(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as an int.
|
java.lang.Integer |
getInteger(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as an Integer.
|
ListControlInterface |
getListInterface(java.lang.String objectId)
Used only on the client side .Returns ListControlInterface
which allows delelopers to invoke listbox specific functions on the client side
|
long |
getlong(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as long.
|
java.lang.Long |
getLong(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as Long.
|
java.lang.String |
getOrigObjectId(java.lang.String sObjectId)
Returns back the system assigned object id of the system-created column that
stores the previous value of the sObjectId column.
|
java.lang.String |
getPrevObjectId(java.lang.String sObjectId)
Returns back the system assigned object id of the system-created column that
stores the previous value (the one that was already validated) of the
sObjectId column.
|
java.util.ArrayList<java.lang.String> |
getRowData()
Returns context row from the row set as ArrayList.
|
byte |
getRowStatus()
Returns the status of the row (whether it is new, edited, marked deleted or
a combination of them).
|
double |
getRowVersion(java.lang.String sTableAliasName)
Allows developer to get value of the system ROWVERSION column,should be used
only on exceptional basic because ROWVERSION manipulation can break system
logic of saving data
|
java.lang.String |
getStringValue(java.lang.String sColumnName)
Returns value of the field (specified with ObjectId) as a String.
|
java.lang.Object |
getValue(java.lang.String sObjectId)
Returns value of the field (specified with ObjectId) as an Object.
|
boolean |
isChanged()
Checks if the row set contains rows with either of the following flags:
ROW_Edited|ROW_New|ROW_MarkDeleted|ROW_ChildModified.
|
boolean |
isRowDeleted()
Checks if the row has been marked deleted.
|
boolean |
isRowModified()
Checks if the row has been modified.
|
boolean |
isRowNew()
Checks if the row is a new row
Example:
|
boolean |
isRowUnvalidated() |
void |
removeNewRowsMarkedForDeletion()
Call this method from server side action to permanently delete rows that have both flags :
ROW_New ROW_MarkDeleted .
|
void |
setchar(char value,
java.lang.String sObjectId)
Set the value of the specified column to a character.
|
void |
setDate(java.util.Calendar value,
java.lang.String sObjectId)
Set the value of the specified column to a date.
|
void |
setdouble(double value,
java.lang.String sObjectId)
Set the value of the specified column to a number.
|
void |
setDouble(java.lang.Double value,
java.lang.String sObjectId)
Set the value of the specified column to a number.
|
void |
setint(int value,
java.lang.String sObjectId)
Set the value of the specified column to a number or a string.
|
void |
setInteger(java.lang.Integer value,
java.lang.String sObjectId)
Set the value of the specified column to a number or a string.
|
void |
setlong(long value,
java.lang.String sObjectId)
Set the value of the specified column to a number or a string.
|
void |
setLong(java.lang.Long value,
java.lang.String sObjectId)
Set the value of the specified column to a number or a string.
|
void |
setRowStatus(byte status,
boolean bSet)
Turns row flags on or off for the row in context.
|
void |
setRowStatusOnPopulate(byte status,
boolean bSet)
Turns row flags on or off for the row in context.
|
void |
setRowVersion(double rowversion,
java.lang.String sTableAliasName)
Allows developer to set value of the system ROWVERSION column,should be used
only on exceptional basic because ROWVERSION manipulation can break system
logic of saving data
|
void |
setStringValue(java.lang.String value,
java.lang.String sObjectId)
Set the value of the specified column to a number or a string.
|
void |
setUnvalidatedData(boolean bOnOff)
Allows developer to change system behavior to treat programmatically set values as unvalidated.
|
void |
setValue(java.lang.Object value,
java.lang.String sObjectId)
Set the value of the specified column to a number, string or date.
|
void |
setValueIfNull(java.lang.Object value,
java.lang.String sObjectId)
The same as setValue() but only sets the value if the column specified by objectId is currently empty.
|
static final byte ROW_ChildModified
static final byte ROW_Unvalidated
static final byte ROW_Loaded
static final byte ROW_Selected
int addNewRow()
char getchar(java.lang.String sObjectId)
public short validatePOStatus(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); if (roi.getchar("PO_HDR__S_PO_STATUS_TYPE") != 'O') ....... }
sObjectId
- The Object ID of the field being evaluated.java.util.Calendar getDate(java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) throws Exception { RowSetInterface roi = rsi.getRowSet(); Calendar ordDt = roi.getDate("PO_HDR__ORD_DT"); if (ordDt==null) ...... }
sObjectId
- The Object ID of the field being evaluated.double getdouble(java.lang.String sObjectId)
public short validateAmount(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); if (roi.getdouble("PO_HDR__PO_TOT_AMT") < O.0) ....... }
sObjectId
- The Object ID of the field being evaluated.java.lang.Double getDouble(java.lang.String sObjectId)
public short validateAmount(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); Double poTotAmt = roi.getDouble("PO_HDR__PO_TOT_AMT"); if (poTotAmt.doubleValue() < 0.0) ......... }
sObjectId
- The Object ID of the field being evaluated.int getint(java.lang.String sObjectId)
public short getPoReaseNo(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); int poReleaseNo = roi.getint("PO_HDR__PO_RLSE_NO"); ..... }
sObjectId
- The Object ID of the field being evaluated.long getlong(java.lang.String sObjectId)
public long getSeqNo(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); long seqNo = roi.getlong("SEQ_NO"); ..... }
sObjectId
- The Object ID of the field being evaluated.java.lang.Integer getInteger(java.lang.String sObjectId)
public short getPoReaseNo(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); Integer poReleaseNo = roi.getInteger("PO_HDR__PO_RLSE_NO"); int releaseNo = poReleaseNo.intValue(); ..... }
sObjectId
- The Object ID of the field being evaluated.java.lang.Long getLong(java.lang.String sObjectId)
public Long getSeqNo(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); Long seqNo = roi.getLong("SEQ_NO"); ..... }
sObjectId
- The Object ID of the field being evaluated.java.util.ArrayList<java.lang.String> getRowData()
byte getRowStatus()
boolean checkRowStatus(byte flag)
flag
- java.lang.String getStringValue(java.lang.String sColumnName)
public short validatePOStatus(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); String status = roi.getStringValue("PO_HDR__S_PO_STATUS_TYPE"); if (!status.trim().equals("O")) ....... }
sColumnName
- The Object ID of the field being evaluated.java.lang.Object getValue(java.lang.String sObjectId)
sObjectId
- The Object ID of the field being evaluated.boolean isChanged()
public short validateRSRow(ResultSetInterface rsi) throws Exception { RowSetInterface roi = rsi.getRowSet(); if (roi.isChanged()) .......... }
boolean isRowDeleted()
public short validateRSRow(ResultSetInterface rsi) throws Exception { RowSetInterface roi = rsi.getRowSet(); if (roi.isRowDeleted()) .......... }
getRowStatus()
,
isRowModified()
,
isRowNew()
boolean isRowModified()
public short validateRSRow(ResultSetInterface rsi) throws Exception { RowSetInterface roi = rsi.getRowSet(); if (roi.isRowModified()) .......... }
getRowStatus()
,
isRowDeleted()
,
isRowNew()
boolean isRowNew()
public short validateRSRow(ResultSetInterface rsi) throws Exception { RowSetInterface roi = rsi.getRowSet(); if (roi.isRowNew()) .......... }
getRowStatus()
,
isRowDeleted()
,
isRowModified()
boolean isRowUnvalidated()
getRowStatus()
,
isRowDeleted()
,
isRowModified()
void setValue(java.lang.Object value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) throws Exception { RowSetInterface roi = rsi.getRowSet(); Calendar ordDt = roi.getDate("PO_HDR__ORD_DT"); if (ordDt==null) { Calendar rightNow = Calendar.getInstance(); roi.setValue(rightNow,"PO_HDR__ORD_DT"); } }
value
- value to be set to. Object must be of type String, Integer, Double or Calendar. Object
can be a null object.sObjectId
- The Object ID of the field being set.void setValueIfNull(java.lang.Object value, java.lang.String sObjectId)
value
- value to be set tosObjectId
- The Object ID of the field being set.void setStringValue(java.lang.String value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); String status = roi.getStringValue("PO_HDR__S_PO_STATUS_TYPE"); if (status.trim().equals("")) roi.setStringValue("O", "PO_HDR__S_PO_STATUS_TYPE"); }
value
- value to be set to. Object must contain value that can be converted
to a String object type. eg. Date object cannot be converted.sObjectId
- The Object ID of the field being set.void setint(int value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) { RowSetInterface roi = rsi.getRowSet(); if (roi.isRowNew()) int key = getNewSubKeyFromSomeWhere(...); roi.setint(key,"PO_LN_ACCT__SUB_KEY"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setlong(long value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) { RowSetInterface roi = rsi.getRowSet(); if (roi.isRowNew()) long key = sqlmanager.SqlGenerateSequenceNo(...); roi.setlong(key,"SEQ_NO"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setdouble(double value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) { RowSetInterface roi = rsi.getRowSet(); double rate = roi.getdouble("PO_LN_ACCT__CST_AMT_PCT_RT"); if (rate < 0.0) roi.setdouble(0.0,"PO_LN_ACCT__CST_AMT_PCT_RT"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setInteger(java.lang.Integer value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) { RowSetInterface roi = rsi.getRowSet(); if (roi.isRowNew()) Integer key = getSubKeyFromSomeWhere(...); roi.setInteger(key,"PO_LN_ACCT__SUB_KEY"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setLong(java.lang.Long value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) { RowSetInterface roi = rsi.getRowSet(); if (roi.isRowNew()) Long key = new Long(sqlmanager.SqlGenerateSequenceNo(...));* roi.setLong(key,"SEQ_NO"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setDouble(java.lang.Double value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) { RowSetInterface roi = rsi.getRowSet(); double rate = roi.getdouble("PO_LN_ACCT__CST_AMT_PCT_RT"); if (rate < 0.0) } roi.setDouble(new Double(0.0),"PO_LN_ACCT__CST_AMT_PCT_RT"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setchar(char value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) throws DEException { RowSetInterface roi = rsi.getRowSet(); String status = roi.getStringValue("PO_HDR__S_PO_STATUS_TYPE"); if (status.trim().equals("")) roi.setchar('O', "PO_HDR__S_PO_STATUS_TYPE"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setDate(java.util.Calendar value, java.lang.String sObjectId)
public short validateRSRow(ResultSetInterface rsi) throws Exception { RowSetInterface roi = rsi.getRowSet(); Calendar ordDt = roi.getDate("PO_HDR__ORD_DT"); if (ordDt==null) Calendar rightNow = Calendar.getInstance(); roi.setDate(rightNow,"PO_HDR__ORD_DT"); }
value
- value to be set to.sObjectId
- The Object ID of the field being set.void setRowStatus(byte status, boolean bSet)
status
- Row flags (ROW_Edited, ROW_New, ROW_MarkDeleted)bSet
- true to turn the flag(s) on. false to turn the flag(s) off.java.lang.String getPrevObjectId(java.lang.String sObjectId)
sObjectId
- The Object ID of the field for which the previous value is being looked up.java.lang.String getOrigObjectId(java.lang.String sObjectId)
RowSetInterface roi = rsi.getRowSet(); String origObjId = roi.getOrigObjectId("EMPL_ID"); if (origObjId !=null) { String origEmplId = roi.getStringValue(origObjId); String newEmplId = roi.getStringValue("EMPL_ID"); if (!origEmplId.trim().equals(newEmplId)) rsi.addObjectMessage("EMPL_ID","Empl ID cannot be changed from " + origEmplId,"CP_1001",rsi.ERROR); }
sObjectId
- The Object ID of the field for which the original value is being looked up.double getColumnDelta(java.lang.String sObjectId)
double getColumnDelta(java.lang.String sObjectId, double columnTotal)
columnTotal
- The number , usually defined in the parent resultsetListControlInterface getListInterface(java.lang.String objectId)
objectId
- The Object ID of the field which displayd as a listbox on the client.void clearAllRowsStatus()
void clearRowStatus()
double getRowVersion(java.lang.String sTableAliasName)
sTableAliasName
- table alias name if you use alias , table name otherwisevoid setRowVersion(double rowversion, java.lang.String sTableAliasName)
rowversion
- sTableAliasName
- table alias name if you use alias , table name otherwisevoid setUnvalidatedData(boolean bOnOff)
bOnOff
- - true to turn On the mode for setting unvalidated data into rowset. False to turn it Off. This mode is turned off by default.void setRowStatusOnPopulate(byte status, boolean bSet)
status
- Row flags (ROW_Edited, ROW_New, ROW_MarkDeleted)bSet
- true to turn the flag(s) on. false to turn the flag(s) off.void removeNewRowsMarkedForDeletion()
void enableDigitalSign(boolean flag)
flag
- true to enable, false to disable.