예제 #1
0
        private void PopulateGroups()
        {
            IManagementGroupSession managementGroupSession = null;

            if (base.ParentForm != null && base.ParentForm.Site != null)
            {
                managementGroupSession = (base.ParentForm.Site.GetService(typeof(IManagementGroupSession)) as IManagementGroupSession);
            }

            if (managementGroupSession == null || managementGroupSession.ManagementGroup == null)
            {
                return;
            }

            using (ManageQueryOleDBSDKHelper helper = new ManageQueryOleDBSDKHelper(managementGroupSession.ManagementGroup))
            {
                monitoringClass = helper.GetManagementPackClass("QueryOleDbMonitorLibrary", "OleDBQueryMonitoringGroup");
                if (GroupsImage == null)
                {
                    GroupsImage = ComponentMethodLibrary.GetImageFromSharedCache(monitoringClass, base.ParentForm);
                }
                List <EnterpriseManagementObject>          list      = new List <EnterpriseManagementObject>();
                IObjectReader <EnterpriseManagementObject> allGroups = helper.GetEnterpriseManagementObjects(monitoringClass);
                if (allGroups != null)
                {
                    foreach (EnterpriseManagementObject current in allGroups)
                    {
                        list.Add(current);
                    }
                }
                groups = list;
            }
        }
        private void PopulateDBEngines()
        {
            IManagementGroupSession managementGroupSession = null;

            if (base.ParentForm != null && base.ParentForm.Site != null)
            {
                managementGroupSession = (base.ParentForm.Site.GetService(typeof(IManagementGroupSession)) as IManagementGroupSession);
            }

            if (managementGroupSession == null || managementGroupSession.ManagementGroup == null)
            {
                return;
            }

            using (ManageQueryOleDBSDKHelper helper = new ManageQueryOleDBSDKHelper(managementGroupSession.ManagementGroup))
            {
                monitoringClass     = helper.GetManagementPackClass("Microsoft.SQLServer.Library", "Microsoft.SQLServer.DBEngine");
                monitoringClass2014 = helper.GetManagementPackClass("Microsoft.SQLServer.2014.Discovery", "Microsoft.SQLServer.2014.DBEngine");
                monitoringClass2016 = helper.GetManagementPackClass("Microsoft.SQLServer.2016.Discovery", "Microsoft.SQLServer.2016.DBEngine");

                if (DBEngineImage == null)
                {
                    DBEngineImage = ComponentMethodLibrary.GetImageFromSharedCache(monitoringClass, base.ParentForm);
                }
                List <EnterpriseManagementObject> list = new List <EnterpriseManagementObject>();

                if (monitoringClass != null)
                {
                    IObjectReader <EnterpriseManagementObject> allDBEngines = helper.GetEnterpriseManagementObjects(monitoringClass);
                    if (allDBEngines != null)
                    {
                        foreach (EnterpriseManagementObject current in allDBEngines)
                        {
                            list.Add(current);
                        }
                    }
                }
                if (monitoringClass2014 != null)
                {
                    IObjectReader <EnterpriseManagementObject> allDBEngines = helper.GetEnterpriseManagementObjects(monitoringClass2014);
                    if (allDBEngines != null)
                    {
                        foreach (EnterpriseManagementObject current in allDBEngines)
                        {
                            list.Add(current);
                        }
                    }
                }

                if (monitoringClass2016 != null)
                {
                    IObjectReader <EnterpriseManagementObject> allDBEngines = helper.GetEnterpriseManagementObjects(monitoringClass2016);
                    if (allDBEngines != null)
                    {
                        foreach (EnterpriseManagementObject current in allDBEngines)
                        {
                            list.Add(current);
                        }
                    }
                }

                DBEngines = list;
            }
        }