public static void GetTreeNodeHierarchy(Guid applicationId, ref List <Hierarchy> retList, Guid treeNodeId)
        {
            string spName = GetFullyQualifiedName("GetTreeNodeHierarchy");

            try
            {
                IDataReader reader = ProviderUtil.execute_reader(spName, applicationId, treeNodeId);
                ProviderUtil.parse_hierarchy(ref reader, ref retList);
            }
            catch (Exception ex)
            {
                LogController.save_error_log(applicationId, null, spName, ex, ModuleIdentifier.DCT);
            }
        }