/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
public void Add(ConfigServers model)
{
if (!list.Exists(x => x.Name == model.Name))
{
list.Add(model);
Save();
}
}
/// <summary>
/// 新增服务器
/// </summary>
/// <param name="ser"></param>
public static void AddServers(Servers ser)
{
ServerList.Add(ser);
var model = new ConfigServers
{
Id = ser.Id,
Name = string.Format("{0}({1})", ser.Name, ser.Type.ToString()),
Type = ser.Type.ToString(),
Server = ser.Server,
Uid = ser.Uid,
Pwd = ser.Pwd
};
ServersConfigClass.Instance.Add(model);
}
/// <summary>
/// 记录服务器设置
/// </summary>
private void AddServer()
{
string file = this.textBox_file.Text.Replace("/", "\\");
string userpass = this.textBox_pwd.Text;
Model.ConfigServers cs = new ConfigServers();
cs.Name = string.Format("{0}({1})", file, dbType.ToString());
cs.Port = "";
cs.Database = file;
cs.file = file;
cs.Pwd = this.checkBox1.Checked ? userpass : "";
cs.ServerName = file;
cs.Type = dbType.ToString();
cs.Uid = "";
Form_AddDatabase.AddServerToXml(cs);
}
/// <summary>
/// 记录服务器设置
/// </summary>
private void AddServer()
{
string server = this.sqlserver_server.Text;
string userid = this.sqlserver_uid.Text;
string userpass = this.sqlserver_pwd.Text;
Model.ConfigServers cs = new ConfigServers();
cs.Name = string.Format("{0}({1})", server, dbType.ToString());
cs.Port = "";
cs.Database = "";
cs.file = "";
cs.Pwd = this.checkBox1.Checked ? userpass : "";
cs.ServerName = server;
cs.Type = dbType.ToString();
cs.Uid = userid;
Form_AddDatabase.AddServerToXml(cs);
}
public static List <ConfigServers> GetAll()
{
var list = new List <ConfigServers>();
var model = new ConfigServers
{
Database = "",
Name = "172.18.30.6(MySql)",
Port = "3306",
Uid = "root",
Pwd = "root",
ServerName = "172.18.30.6",
Type = "MySql",
File = ""
};
list.Add(model);
return(list);
}
private void AddServer()
{
string serverName = this.cBtn_SqlServer_ServerName.Text;
string userId = this.tBox_SqlServer_UserName.Text;
string pwd = this.tBox_SqlServer_Pwd.Text;
ConfigServers server = new ConfigServers()
{
Name = string.Format("{0}({1})", serverName, dbType.ToString()),
Port = "",
Database = "",
file = "",
Pwd = this.cBox_SqlServer_Remenber.Checked?pwd:"",
ServerName = serverName,
Type = dbType.ToString(),
Uid = userId
};
Form_AddDatabase.AddServerToXml(server);
}
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();
}
}
public object Clone()
{
DbmClusterConfiguration dbmClusterConfig = new DbmClusterConfiguration();
dbmClusterConfig.Name = this.Name;
dbmClusterConfig.ConfigServers = (this.ConfigServers != null ? (DbmConfigServers)ConfigServers.Clone() : null);
dbmClusterConfig.Shards = (this.Shards != null ? (DbmShards)Shards.Clone() : null);
dbmClusterConfig.UID = this.UID;
return(dbmClusterConfig);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="model"></param>
public void Delete(ConfigServers model)
{
list.Remove(model);
Save();
}
/// <summary>
/// 保存服务器至配置文件
/// </summary>
/// <param name="configServer"></param>
public static void AddServerToXml(ConfigServers configServer)
{
new Config_Servers().Add(configServer);
}
public static void Add(ConfigServers model)
{
}
