private void Form_Database_Load(object sender, EventArgs e)
{
Form.CheckForIllegalCrossThreadCalls = false;
var serverList = new Common.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;
Common.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.IsNullOrEmpty() ? "" : string.Format("-{0}", server.Uid));
RootNode.ImageIndex = 0;
RootNode.SelectedImageIndex = 0;
RootNode.Tag = new Model.TreeNodeTag()
{
Type = TreeNodeType.Server, Tag = ser
};
tvDatabase.Nodes.Add(RootNode);
}
}
private void Form_AddDatabase_MySql_Load(object sender, EventArgs e)
{
Common.Config_Servers CS = new Common.Config_Servers();
csList = CS.GetAll().Where(p => p.Type == this.dbType.ToString());
foreach (var li in csList)
{
this.comboBox_mysql_server.Items.Add(li.ServerName);
}
Model.ConfigServers cs = CS.GetDefault(this.dbType);
if (cs != null)
{
this.comboBox_mysql_server.Text = cs.ServerName;
this.textBox_mysql_pwd.Text = cs.Pwd;
this.textBox_mysql_uid.Text = cs.Uid;
this.checkBox1.Checked = !cs.Pwd.IsNullOrEmpty();
}
}