/** * Get Cash Journal for currency, org and date * @param ctx context * @param C_Currency_ID currency * @param AD_Org_ID org * @param dateAcct date * @param trxName transaction * @return cash */ public static MCash Get(Ctx ctx, int AD_Org_ID, DateTime?dateAcct, int C_Currency_ID, Trx trxName) { MCash retValue = null; // Existing Journal String sql = "SELECT * FROM C_Cash c " + "WHERE c.AD_Org_ID=" + AD_Org_ID // #1 + " AND TRUNC(c.StatementDate, 'DD')=@sdate" // #2 + " AND c.Processed='N'" + " AND EXISTS (SELECT * FROM C_CashBook cb " + "WHERE c.C_CashBook_ID=cb.C_CashBook_ID AND cb.AD_Org_ID=c.AD_Org_ID" + " AND cb.C_Currency_ID=" + C_Currency_ID + ")"; // #3 DataTable dt = null; SqlParameter[] param = null; IDataReader idr = null; try { param = new SqlParameter[1]; param[0] = new SqlParameter("@sdate", TimeUtil.GetDay(dateAcct)); idr = DB.ExecuteReader(sql, param, trxName); dt = new DataTable(); dt.Load(idr); idr.Close(); foreach (DataRow dr in dt.Rows) { retValue = new MCash(ctx, dr, trxName); } } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); } finally { dt = null; } if (retValue != null) { return(retValue); } // Get CashBook MCashBook cb = MCashBook.Get(ctx, AD_Org_ID, C_Currency_ID); if (cb == null) { _log.Warning("No CashBook for AD_Org_ID=" + AD_Org_ID + ", C_Currency_ID=" + C_Currency_ID); return(null); } // Create New Journal retValue = new MCash(cb, dateAcct); retValue.Save(trxName); return(retValue); }
/** * Get Cash Book * @return cash book */ public MCashBook GetCashBook() { if (_book == null) { _book = MCashBook.Get(GetCtx(), GetC_CashBook_ID()); } return(_book); }
/** * Get CashBook * @return cash book */ public MCashBook GetCashBook() { if (_cashBook == null) { _cashBook = MCashBook.Get(GetCtx(), GetParent().GetC_CashBook_ID()); } return(_cashBook); }