/// <summary> /// Parent Constructor /// </summary> /// <param name="as1">accounting schema</param> public MAcctSchemaElement(MAcctSchema as1) : this(as1.GetCtx(), 0, as1.Get_TrxName()) { SetClientOrg(as1); SetC_AcctSchema_ID(as1.GetC_AcctSchema_ID()); // setC_Element_ID (0); // setElementType (null); // setName (null); // setSeqNo (0); }
/// <summary> /// Factory: Return ArrayList of Account Schema Elements /// </summary> /// <param name="as1">Accounting Schema</param> /// <returns>ArrayList with Elements</returns> public static MAcctSchemaElement[] GetAcctSchemaElements(MAcctSchema as1) { int key = as1.GetC_AcctSchema_ID(); MAcctSchemaElement[] retValue = (MAcctSchemaElement[])s_cache[key]; if (retValue != null) { return(retValue); } _log.Fine("C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID()); List <MAcctSchemaElement> list = new List <MAcctSchemaElement>(); // String sql = "SELECT * FROM C_AcctSchema_Element " + "WHERE C_AcctSchema_ID=" + as1.GetC_AcctSchema_ID() + " AND IsActive='Y' ORDER BY SeqNo"; try { DataSet ds = DataBase.DB.ExecuteDataset(sql, null, as1.Get_TrxName()); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; MAcctSchemaElement ase = new MAcctSchemaElement(as1.GetCtx(), dr, as1.Get_TrxName()); _log.Fine(" - " + ase); if (ase.IsMandatory() && ase.GetDefaultValue() == 0) { _log.Log(Level.SEVERE, "No default value for " + ase.GetName()); } list.Add(ase); } } catch (Exception e) { _log.Log(Level.SEVERE, sql, e); } retValue = new MAcctSchemaElement[list.Count]; retValue = list.ToArray(); s_cache.Add(key, retValue); return(retValue); }
/// <summary> /// Parent Constructor /// </summary> /// <param name="as1">as account schema</param> public MAccount(MAcctSchema as1) : this(as1.GetCtx(), 0, as1.Get_TrxName()) { SetClientOrg(as1); SetC_AcctSchema_ID(as1.GetC_AcctSchema_ID()); }