public IList <Org> GetChildOrgs(string orgId, OrgType type)
{
return((IList <Org>)CacheHelper.Get("GetChildOrgs_" + orgId + "_" + type.ToString(), () =>
{
return Config.Logic.OrgService.GetChildOrgs(orgId, type);
}));
}
private void WriteAttributes(XmlWriter w, bool newGuids = false)
{
if (newGuids)
{
w.WriteAttributeString("Id", Guid.NewGuid().ToString());
}
else
{
w.WriteAttributeString("Id", Id.ToString());
}
w.WriteAttributeString("Order", Order.ToString());
w.WriteAttributeString("Field", ConditionName);
w.WriteAttributeString("Comparison", Comparison);
if (Description.HasValue())
{
w.WriteAttributeString("Description", Description);
}
if (PreviousName.HasValue())
{
w.WriteAttributeString("PreviousName", Description);
}
if (TextValue.HasValue())
{
w.WriteAttributeString("TextValue", TextValue);
}
if (DateValue.HasValue)
{
w.WriteAttributeString("DateValue", DateValue.ToString());
}
if (CodeIdValue.HasValue())
{
w.WriteAttributeString("CodeIdValue", CodeIdValue);
}
if (StartDate.HasValue)
{
w.WriteAttributeString("StartDate", StartDate.ToString());
}
if (EndDate.HasValue)
{
w.WriteAttributeString("EndDate", EndDate.ToString());
}
if (Program > 0)
{
w.WriteAttributeString("Program", Program.ToString());
}
if (Division > 0)
{
w.WriteAttributeString("Division", Division.ToString());
}
if (Organization > 0)
{
w.WriteAttributeString("Organization", Organization.ToString());
}
if (OrgType > 0)
{
w.WriteAttributeString("OrgType", OrgType.ToString());
}
if (Days > 0)
{
w.WriteAttributeString("Days", Days.ToString());
}
if (Quarters.HasValue())
{
w.WriteAttributeString("Quarters", Quarters);
}
if (Tags.HasValue())
{
w.WriteAttributeString("Tags", Tags);
}
if (Schedule != 0)
{
w.WriteAttributeString("Schedule", Schedule.ToString());
}
if (Campus > 0)
{
w.WriteAttributeString("Campus", Campus.ToString());
}
if (ConditionName != "FamilyHasChildrenAged")
{
Age = null;
}
if (Age.HasValue)
{
w.WriteAttributeString("Age", Age.ToString());
}
if (SavedQuery.HasValue())
{
w.WriteAttributeString("SavedQueryIdDesc", SavedQuery);
}
if (OnlineReg.HasValue)
{
w.WriteAttributeString("OnlineReg", OnlineReg.ToString());
}
if (OrgStatus.HasValue)
{
w.WriteAttributeString("OrgStatus", OrgStatus.ToString());
}
if (OrgType2.HasValue)
{
w.WriteAttributeString("OrgType2", OrgType2.ToString());
}
if (OrgName.HasValue())
{
w.WriteAttributeString("OrgName", OrgName);
}
}
public static IList <Org> GetChildOrgs(string orgId, OrgType type)
{
var sqlHelper = SQLHelper.CreateSqlHelper(ConnEnum.Base);
var sql = string.Format("select * from S_A_Org where ParentID = '{0}' and Type='{1}' and IsDeleted = '0'", orgId, type.ToString());
var dt = sqlHelper.ExecuteDataTable(sql);
var orgs = new List <Org>();
foreach (DataRow row in dt.Rows)
{
var org = new Org();
org.ID = row["ID"].ToString();
org.Code = row["Code"].ToString();
org.Name = row["Name"].ToString();
org.ParentID = row["ParentID"].ToString();
org.FullID = row["FullID"].ToString();
org.SortIndex = row["SortIndex"] is DBNull?0:float.Parse(row["SortIndex"].ToString());
orgs.Add(org);
}
return(orgs);
}