/**
* Selects records from the F55XXXXX table.
* <p>Following SQL statement can be produced by this generated code
* <blockquote><pre><code>
* SELECT F55XXXXX.UKID, F55XXXXX.DOC, F55XXXXX.DCT, F55XXXXX.IDROW, F55XXXXX.MCU, F55XXXXX.ITM, F55XXXXX.LITM, F55XXXXX.LOCN, F55XXXXX.LOTN, F55XXXXX.MMEA, F55XXXXX.QTY, F55XXXXX.UM, F55XXXXX.DTAI
*
* FROM F55XXXXX
*
* WHERE F55XXXXX.UKID=? AND F55XXXXX.DOC=? AND F55XXXXX.DCT=?
*
*/
private static ArrayList selectFromF55XXXXX(IContext context,
IConnection connection,
keyF55XXXXX internalVO) {
//create return object
E1MessageList returnMessages = new E1MessageList();
ArrayList queryResults = new ArrayList();
//specify columns to select
BSSVDBField[] selectFields =
{ new BSSVDBField("F55XXXXX.UKID"), // Numeric - UniqueKeyIDInternal
new BSSVDBField("F55XXXXX.DOC"), // Numeric - DocVoucherInvoiceE
new BSSVDBField("F55XXXXX.DCT"), // String - DocumentType
new BSSVDBField("F55XXXXX.IDROW"), // Numeric - IDRow
new BSSVDBField("F55XXXXX.MCU"), // String - CostCenter
new BSSVDBField("F55XXXXX.ITM"), // Numeric - IdentifierShortItem
new BSSVDBField("F55XXXXX.LITM"), // String - Identifier2ndItem
new BSSVDBField("F55XXXXX.LOCN"), // String - Location
new BSSVDBField("F55XXXXX.LOTN"), // String - Lot
new BSSVDBField("F55XXXXX.MMEA"),
// String - DATELOTEXPIRATIONALPHA
new BSSVDBField("F55XXXXX.QTY"), // Numeric - Quantity
new BSSVDBField("F55XXXXX.UM"), // String - UnitOfMeasure
new BSSVDBField("F55XXXXX.DTAI") // String - DataItem
} ;
//specify sort order
BSSVDBSortField[] sortOrder = null;
//specify condition records must meet to be selected
BSSVDBWhereField[] whereFields =
{ new BSSVDBWhereField(null, new BSSVDBField("F55XXXXX.UKID"),
IDBService.EQUALS,
internalVO.getF55XXXXX_UKID()),
new BSSVDBWhereField(IDBService.AND, new BSSVDBField("F55XXXXX.DOC"),
IDBService.EQUALS,
internalVO.getF55XXXXX_DOC()),
new BSSVDBWhereField(IDBService.AND, new BSSVDBField("F55XXXXX.DCT"),
IDBService.EQUALS,
internalVO.getF55XXXXX_DCT()) };
BSSVDBWhereClauseBuilder whereClause =
new BSSVDBWhereClauseBuilder(context, whereFields);
BSSVDBResultSet resultSet = null;
boolean selectDistinct = false;
try {
//get dbService from context
IDBService dbService = context.getDBService();
//execute db select operation
resultSet =
dbService.select(context, connection, "F55XXXXX", IDBService.DB_TABLE,
selectDistinct, IDBService.DB_FETCH_ALL,
selectFields, sortOrder, whereClause);
} catch (DBServiceException e) {
//TODO take some action in response to the database exception
returnMessages.addMessage(new E1Message(context, "005FIS",
e.getMessage()));
}
//process the results of the select
if (resultSet != null) {
BSSVDBFieldMap[] fieldMap = resultSet.getFieldMap();
if (fieldMap != null && fieldMap.length > 0) {
for (int i = 0; i < fieldMap.length; i++) {
BSSVDBFieldMap map = fieldMap;
recordF55XXXXX result = new recordF55XXXXX();
result.setF55XXXXX_UKID((MathNumeric)map.getValue("F55XXXXX.UKID"));
result.setF55XXXXX_DOC((MathNumeric)map.getValue("F55XXXXX.DOC"));
result.setF55XXXXX_DCT((String)map.getValue("F55XXXXX.DCT"));
result.setF55XXXXX_IDROW((MathNumeric)map.getValue("F55XXXXX.IDROW"));
result.setF55XXXXX_MCU((String)map.getValue("F55XXXXX.MCU"));
result.setF55XXXXX_ITM((MathNumeric)map.getValue("F55XXXXX.ITM"));
result.setF55XXXXX_LITM((String)map.getValue("F55XXXXX.LITM"));
result.setF55XXXXX_LOCN((String)map.getValue("F55XXXXX.LOCN"));
result.setF55XXXXX_LOTN((String)map.getValue("F55XXXXX.LOTN"));
result.setF55XXXXX_MMEA((String)map.getValue("F55XXXXX.MMEA"));
result.setF55XXXXX_QTY((MathNumeric)map.getValue("F55XXXXX.QTY"));
result.setF55XXXXX_UM((String)map.getValue("F55XXXXX.UM"));
result.setF55XXXXX_DTAI((String)map.getValue("F55XXXXX.DTAI"));
queryResults.add(result);
}
}
}
}
return queryResults;
}