/// <summary> /// Get BP Group /// </summary> /// <param name="group">group</param> public void SetBPGroup(MBPGroup group) { _group = group; if (_group == null) { return; } SetC_BP_Group_ID(_group.GetC_BP_Group_ID()); if (_group.GetC_Dunning_ID() != 0) { SetC_Dunning_ID(_group.GetC_Dunning_ID()); } if (_group.GetM_PriceList_ID() != 0) { SetM_PriceList_ID(_group.GetM_PriceList_ID()); } if (_group.GetPO_PriceList_ID() != 0) { SetPO_PriceList_ID(_group.GetPO_PriceList_ID()); } if (_group.GetM_DiscountSchema_ID() != 0) { SetM_DiscountSchema_ID(_group.GetM_DiscountSchema_ID()); } if (_group.GetPO_DiscountSchema_ID() != 0) { SetPO_DiscountSchema_ID(_group.GetPO_DiscountSchema_ID()); } }
/** * Get MBPGroup from Business Partner * @param ctx context * @param C_BPartner_ID business partner id * @return MBPGroup */ public static MBPGroup GetOfBPartner(Ctx ctx, int C_BPartner_ID) { MBPGroup retValue = null; DataTable dt = null; String sql = "SELECT * FROM C_BP_Group g " + "WHERE EXISTS (SELECT * FROM C_BPartner p " + "WHERE p.C_BPartner_ID=" + C_BPartner_ID + " AND p.C_BP_Group_ID=g.C_BP_Group_ID)"; IDataReader idr = null; try { idr = DataBase.DB.ExecuteReader(sql, null, null); dt = new DataTable(); dt.Load(idr); idr.Close(); foreach (DataRow dr in dt.Rows) { retValue = new MBPGroup(ctx, dr, null); int key = retValue.GetC_BP_Group_ID(); if (retValue.Get_ID() != 0) { _cache.Add(key, retValue); } } } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); } finally { dt = null; } return(retValue); }