.getDouble(pRecordSet.getRecordSet(), pColumnAlias)); } else if (pField.getType() == Float.class) { pField.set(pEntity, getSrvRecordRetriever() .getFloat(pRecordSet.getRecordSet(), pColumnAlias)); } else if (pField.getType() == BigDecimal.class) { pField.set(pEntity, getSrvRecordRetriever() .getBigDecimal(pRecordSet.getRecordSet(), pColumnAlias)); } else if (pField.getType() == Date.class) { pField.set(pEntity, getSrvRecordRetriever() .getDate(pRecordSet.getRecordSet(), pColumnAlias)); } else if (Enum.class.isAssignableFrom(pField.getType())) { Integer intVal = getSrvRecordRetriever() .getInteger(pRecordSet.getRecordSet(), pColumnAlias); Enum val = null; if (intVal != null) { } else if (pField.getType() == Boolean.class) { pField.set(pEntity, getSrvRecordRetriever() .getBoolean(pRecordSet.getRecordSet(), pColumnAlias)); } else { return false;
if (Integer.class == pFieldType) { pField.set(pEntity, getSrvRecordRetriever() .getInteger(pRecordSet.getRecordSet(), pColumnAlias)); return true; } else if (Long.class == pFieldType) { pField.set(pEntity, getSrvRecordRetriever() .getLong(pRecordSet.getRecordSet(), pColumnAlias)); return true; } else if (String.class == pFieldType) { String strVal = getSrvRecordRetriever() .getString(pRecordSet.getRecordSet(), pColumnAlias); getLogger().debug(ASrvOrm.class, "SrvOrm: fill field/value: " + pColumnAlias + "/" + strVal);
if (fieldId.getType() == Long.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), idName)); } else if (fieldId.getType() == Integer.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), idName)); } else { String msg = "There is no rule to fill ID "
if (itsDateLong == null) { itsDateLong = getSrvDatabase().getSrvRecordRetriever() .getDate(recordSet.getRecordSet(), "ITSDATE").getTime(); getSrvBalance().handleNewAccountEntry(null, null, new Date(itsDateLong)); //This is for SrvBalanceStd only!!! .getString(recordSet.getRecordSet(), "ACCDEBIT"); Account accDebit = new Account(); accDebit.setItsId(accDebitId); accEntry.setAccDebit(accDebit); accEntry.setSubaccDebitType(getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCDEBITTYPE")); accEntry.setSubaccDebitId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SUBACCDEBITID")); accEntry.setSubaccDebit(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACCDEBIT")); accEntry.setDebit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "DEBIT").setScale( getSrvAccSettings().lazyGetAccSettings().getCostPrecision(), getSrvAccSettings().lazyGetAccSettings().getRoundingMode())); String accCreditId = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCCREDIT"); Account accCredit = new Account(); accCredit.setItsId(accCreditId); accEntry.setAccCredit(accCredit); accEntry.setSubaccCreditType(getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCCREDITTYPE")); accEntry.setSubaccCreditId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SUBACCCREDITID"));
do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNAME"); String accId = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCID"); Long subaccId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SUBACCID"); Integer subaccType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCTYPE"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); TrialBalanceLine tbl = new TrialBalanceLine(); tbl.setAccId(accId);
WarehouseRestLine wrl = new WarehouseRestLine(); wrl.setWarehouse(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "WAREHOUSE")); wrl.setInvItemId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "INVITEMID")); wrl.setInvItem(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "INVITEM")); wrl.setUnitOfMeasure(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "UNITOFMEASURE")); wrl.setTheRest(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "THEREST")); result.add(wrl); } while (recordSet.moveToNext());
do { Long sourceId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SOURCEID"); Integer sourceType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SOURCETYPE"); Long sourceOwnerId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SOURCEOWNERID"); Integer sourceOwnerType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SOURCEOWNERTYPE"); BigDecimal theRest = getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "THEREST"); T source = createDrawItemEntry(); source.setSourceId(sourceId);
do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCOUNTNAME"); Integer accType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "ITSTYPE"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); if (debit != 0 || credit != 0) { BalanceLine bl = new BalanceLine();
do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNAME"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); if (debit != 0 || credit != 0) { TrialBalanceLine tbl = new TrialBalanceLine();
LedgerPreviousLine lpl = new LedgerPreviousLine(); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); lpl.setDebit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "DEBIT") .setScale(getSrvAccSettings().lazyGetAccSettings() .getCostPrecision(), getSrvAccSettings() .lazyGetAccSettings().getRoundingMode())); lpl.setCredit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "CREDIT") .setScale(getSrvAccSettings().lazyGetAccSettings() .getCostPrecision(), getSrvAccSettings()
/** * <p>Evaluate single Double result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Double result e.g 1.1231 or NULL * @throws Exception - an exception */ @Override public final Double evalDoubleResult( final String pQuery, final String pColumnName) throws Exception { Double result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getDouble(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
/** * <p>Evaluate single Long result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Long result e.g 11231 or NULL * @throws Exception - an exception */ @Override public final Long evalLongResult( final String pQuery, final String pColumnName) throws Exception { Long result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getLong(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
/** * <p>Evaluate single Integer result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Integer result e.g 11231 or NULL * @throws Exception - an exception */ @Override public final Integer evalIntegerResult( final String pQuery, final String pColumnName) throws Exception { Integer result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getInteger(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
/** * <p>Evaluate single Float result.</p> * @param pQuery Query * @param pColumnName Column Name * @return Float result e.g 1.1231 or NULL * @throws Exception - an exception */ @Override public final Float evalFloatResult( final String pQuery, final String pColumnName) throws Exception { Float result = null; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { result = getSrvRecordRetriever().getFloat(recordSet.getRecordSet(), pColumnName); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
LedgerDetailLine ldl = new LedgerDetailLine(); ldl.setItsDate(getSrvDatabase().getSrvRecordRetriever() .getDate(recordSet.getRecordSet(), "ITSDATE")); ldl.setSourceId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SOURCEID")); ldl.setSourceType(getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SOURCETYPE")); ldl.setDescription(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "DESCRIPTION")); ldl.setSubaccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC")); ldl.setCorrAccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORACC")); ldl.setCorrSubaccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORSUBACC")); ldl.setCorrAccNumber(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORACCNUMBER")); Boolean isDebit = getSrvDatabase().getSrvRecordRetriever() .getBoolean(recordSet.getRecordSet(), "ISDEBIT"); if (isDebit) { ldl.setDebit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "ITSTOTAL") .setScale(getSrvAccSettings().lazyGetAccSettings() .getCostPrecision(), getSrvAccSettings() } else { ldl.setCredit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "ITSTOTAL") .setScale(getSrvAccSettings().lazyGetAccSettings()
do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNAME"); String accId = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCID"); Long subaccId = getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SUBACCID"); Integer subaccType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SUBACCTYPE"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); if (debit != 0 || credit != 0) { TrialBalanceLine tbl = new TrialBalanceLine();
WarehouseSiteRestLine wrl = new WarehouseSiteRestLine(); wrl.setWarehouse(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "WAREHOUSE")); wrl.setWarehouseSite(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "WAREHOUSESITE")); wrl.setInvItemId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "INVITEMID")); wrl.setInvItem(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "INVITEM")); wrl.setUnitOfMeasure(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "UNITOFMEASURE")); wrl.setTheRest(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "THEREST")); result.add(wrl); } while (recordSet.moveToNext());
if (fieldId.getType() == Long.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), insertedIdName)); } else if (fieldId.getType() == Integer.class) { fieldId.set(pEntity, getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), insertedIdName)); } else { String msg = "There is no rule to fill ID "