} // getOrgs
private static void GetOrgsAddSummary(List <KeyNamePair> list, int Summary_Org_ID, String Summary_Name, MRole role, Ctx ctx)
{
if (role == null)
{
return;
}
// Do we look for trees?
if (role.GetAD_Tree_Org_ID() == 0)
{
return;
}
// Summary Org - Get Dependents
MTree tree = MTree.Get(ctx, role.GetAD_Tree_Org_ID(), null);
String sql = "SELECT AD_Client_ID, AD_Org_ID, Name, IsSummary FROM AD_Org "
+ "WHERE IsActive='Y' AND AD_Org_ID IN (SELECT Node_ID FROM "
+ tree.GetNodeTableName()
+ " WHERE AD_Tree_ID='" + tree.GetAD_Tree_ID() + "' AND Parent_ID='" + Summary_Org_ID + "' AND IsActive='Y') "
+ "ORDER BY Name";
IDataReader dr = DB.ExecuteReader(sql);
try
{
while (dr.Read())
{
// int AD_Client_ID = rs.getInt(1);
int AD_Org_ID = Util.GetValueOfInt(dr[1].ToString());
String Name = dr[2].ToString();
bool summary = "Y".Equals(dr[3].ToString());
//
if (summary)
{
GetOrgsAddSummary(list, AD_Org_ID, Name, role, ctx);
}
else
{
KeyNamePair p = new KeyNamePair(AD_Org_ID, Name);
if (!list.Contains(p))
{
list.Add(p);
}
}
}
dr.Close();
}
catch
{
if (dr != null)
{
dr.Close();
}
}
finally
{
if (dr != null)
{
dr.Close();
}
}
} // ge
