Example #1
0
        private List <PXSqlGroup> GetListOfGroupFromPxs()
        {
            if (this.pxsQueryVariable.Values.Items.Length == 0)
            {
                throw new ApplicationException("GetListOfGroupFromPxs(): No entries found");
            }
            List <PXSqlGroup> myOut = new List <PXSqlGroup>();

            foreach (PCAxis.Sql.Pxs.ValueTypeWithGroup val in this.pxsQueryVariable.Values.Items)
            {
                if (val.code.Contains("*") || val.code.Contains("?"))
                {
                    throw new ApplicationException("GetListOfGroupFromPxs(): Groups cannot contain wildcards");
                }
                PXSqlGroup group = new PXSqlGroup(val.code);

                if (val.Group == null || val.Group.GroupValue == null || val.Group.GroupValue.Length < 1)
                {
                    throw new ApplicationException("GetListOfGroupFromPxs(): Expected group children");
                }
                foreach (GroupValueType child in val.Group.GroupValue)
                {
                    group.AddChildCode(child.code);
                }
                myOut.Add(group);
            }
            return(myOut);
        }
Example #2
0
        /// <summary>
        /// Recursive method drilling down to the leafs
        /// </summary>
        /// <param name="toGroup">Add the leaf IDs to this</param>
        /// <param name="parentCode">Check if this has children</param>
        private void addLeafChildIds(PXSqlGroup toGroup, String parentCode)
        {
            Dictionary <string, ValueGroupRow> templist = meta.MetaQuery.GetValueGroupRowskeyValueCode(mGroupingId, parentCode, true);

            if (templist.Count < 1)
            {
                //Has no children
                toGroup.AddChildCode(parentCode);
            }
            else
            {
                foreach (KeyValuePair <string, ValueGroupRow> childOfparent in templist)
                {
                    addLeafChildIds(toGroup, childOfparent.Key);
                }
            }
        }