示例#1
0
        private void Form_DataBase_Load(object sender, EventArgs e)
        {
            //不捕获对错误线程的调用
            Form.CheckForIllegalCrossThreadCalls = false;

            var serverList = new Config_Servers().GetAll();

            foreach (var server in serverList)
            {
                Servers ser = new Servers();
                ser.DatabaseName = server.Database;
                ser.ID           = server.Name;
                ser.Name         = server.ServerName;
                ser.Password     = server.Pwd;
                ser.Port         = server.Port.IsInt() ? server.Port.ToInt() : -1;
                ser.Server       = server.ServerName;

                ser.Type   = Enum.TryParse(server.Type, out DatabaseType dbType) ? dbType : DatabaseType.Empty;
                ser.UserID = server.Uid;

                Config.AddServerList(ser);

                TreeNode rootNode = new TreeNode();
                rootNode.Name               = server.Name;
                rootNode.Text               = string.Format("{0}({1}{2})", server.ServerName, server.Type.ToString(), server.Uid.IsNullOrEmpty() ? "" : string.Format("-{0}", server.Uid));
                rootNode.ImageIndex         = 0;
                rootNode.SelectedImageIndex = 0;
                rootNode.Tag = new TreeNodeTag()
                {
                    Type = TreeNodeType.Server, Tag = ser
                };

                ServerTreeView.Nodes.Add(rootNode);
            }
        }
        private void Form_AddDatabase_SqlServer_Load(object sender, EventArgs e)
        {
            Config_Servers configServer = new Config_Servers();

            serverList = configServer.GetAll().Where(s => s.Type == this.dbType.ToString());

            foreach (var server in serverList)
            {
                this.cBtn_SqlServer_ServerName.Items.Add(server.ServerName);
            }

            ConfigServers defaultServer = configServer.GetDefault(this.dbType);

            if (defaultServer != null)
            {
                this.cBtn_SqlServer_ServerName.Text  = defaultServer.ServerName;
                this.tBox_SqlServer_Pwd.Text         = defaultServer.Pwd;
                this.tBox_SqlServer_UserName.Text    = defaultServer.Uid;
                this.cBox_SqlServer_Remenber.Checked = !defaultServer.Pwd.IsNullOrEmpty();
            }
        }
        private void Form_Database_Load(object sender, EventArgs e)
        {
            Form.CheckForIllegalCrossThreadCalls = false;
            var serverList = new Config_Servers().GetAll();

            foreach (var server in serverList)
            {
                Model.Servers ser = new Servers();
                ser.DatabaseName = server.Database;
                ser.ID           = server.Name;
                ser.Name         = server.ServerName;
                ser.Password     = server.Pwd;
                ser.Port         = server.Port.IsInt() ? server.Port.ToInt() : -1;
                ser.Server       = server.ServerName;
                Model.DatabaseType dbtype;
                ser.Type   = Enum.TryParse(server.Type, out dbtype) ? dbtype : DatabaseType.Empty;
                ser.UserID = server.Uid;

                Config.AddServerList(ser);

                TreeNode RootNode = new TreeNode();
                RootNode.Name               = server.ServerName;
                RootNode.Text               = string.Format("{0}({1}{2})", server.ServerName, server.Type.ToString(), server.Uid == null ? "" : string.Format("-{0}", server.Uid));
                RootNode.ImageIndex         = 0;
                RootNode.SelectedImageIndex = 0;
                RootNode.Tag = new Model.TreeNodeTag()
                {
                    Type = TreeNodeType.Server, Tag = ser
                };
                treeView1.Nodes.Add(RootNode);
                InitializeSqlConnectionStringBuilder();
            }
            treeView1_DoubleClick(null, null);
            treeView1_DoubleClick(null, null);
            treeView1_DoubleClick(null, null);
            treeView1_DoubleClick(null, null);
        }