.getDouble(pRecordSet.getRecordSet(), pColumnAlias)); } else if (pField.getType() == Float.class) { pField.set(pEntity, getSrvRecordRetriever()
/** * <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 Double results.</p> * @param pQuery Query * @param pColumnNames Column Names * @return Double[] result e.g. [2.14, NULL, 111.456] * @throws Exception - an exception */ @Override public final Double[] evalDoubleResults( final String pQuery, final String[] pColumnNames) throws Exception { Double[] result = new Double[pColumnNames.length]; IRecordSet<RS> recordSet = null; try { recordSet = retrieveRecords(pQuery); if (recordSet.moveToFirst()) { for (int i = 0; i < pColumnNames.length; i++) { result[i] = getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), pColumnNames[i]); } } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
.getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); SalesInvoiceTaxLine sit; if (sitl.size() > countUpdatedSitl) {
.getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); PurchaseReturnTaxLine cit; if (citl.size() > countUpdatedSitl) {
.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();
.getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); SalesReturnTaxLine sit; if (sitl.size() > countUpdatedSitl) {
.getLong(recordSet.getRecordSet(), "TAXID"); Double totalTax = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "TOTALTAX"); PurchaseInvoiceTaxLine sit; if (sitl.size() > countUpdatedSitl) {
.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();
.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();
.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);