/// <summary>
/// 取得具体的连接字符串名称
/// </summary>
/// <param name="keyName">配置文件中的Key Name</param>
/// <param name="isencript">是否加密</param>
/// <returns></returns>
public static string GetAppConfig(string keyName, bool isencript)
{
string sResult = "";
try
{
if (ConfigurationManager.AppSettings[keyName] != "")
{
if (isencript)
{
sResult = SysEncrypt.DecryptStr(ConfigurationManager.AppSettings[keyName]);
if (sResult == "KeyError")
{
sResult = "";
}
}
else
{
sResult = ConfigurationManager.AppSettings[keyName];
}
}
return(sResult);
}
catch
{
Public.SystemInfo("获取连接字符串失败！", true);
return(sResult);
}
}
/// <summary>
/// 保存信息至配置文件
/// </summary>
/// <param name="keyname">节点名称</param>
/// <param name="keyvalue">节点值</param>
/// <param name="isencript">是否加密</param>
public static void SaveAppConfig(string keyname, string keyvalue, bool isencript)
{
try
{
System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
if (isencript)
{
if (config.AppSettings.Settings[keyname] == null)
{
config.AppSettings.Settings.Add(keyname, SysEncrypt.EncryptStr(keyvalue));
}
else
{
config.AppSettings.Settings[keyname].Value = SysEncrypt.EncryptStr(keyvalue);
}
}
else
{
if (config.AppSettings.Settings[keyname] == null)
{
config.AppSettings.Settings.Add(keyname, keyvalue);
}
else
{
config.AppSettings.Settings[keyname].Value = keyvalue;
}
}
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("appSettings");//重新加载新的配置文件
}
catch
{
//Public.SystemInfo("写配置文件失败！", true);
}
}
/// <summary>
/// 保存数据库连接设置
/// </summary>
/// <param name="server">服务器名称</param>
/// <param name="database">数据库名称</param>
/// <param name="username">用户名</param>
/// <param name="password">密码</param>
public static void SaveSqlConnString(string server, string database, string username, string password)
{
try
{
System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//数据库服务器
if (config.AppSettings.Settings["ServerName"] == null)
{
config.AppSettings.Settings.Add("ServerName", SysEncrypt.EncryptStr(server));
}
else
{
config.AppSettings.Settings["ServerName"].Value = SysEncrypt.EncryptStr(server);
}
//数据库名称
if (config.AppSettings.Settings["DataBase"] == null)
{
config.AppSettings.Settings.Add("DataBase", SysEncrypt.EncryptStr(database));
}
else
{
config.AppSettings.Settings["DataBase"].Value = SysEncrypt.EncryptStr(database);
}
//用户名
if (config.AppSettings.Settings["UserName"] == null)
{
config.AppSettings.Settings.Add("UserName", SysEncrypt.EncryptStr(username));
}
else
{
config.AppSettings.Settings["UserName"].Value = SysEncrypt.EncryptStr(username);
}
//密码
if (config.AppSettings.Settings["Password"] == null)
{
config.AppSettings.Settings.Add("Password", SysEncrypt.EncryptStr(password));
}
else
{
config.AppSettings.Settings["Password"].Value = SysEncrypt.EncryptStr(password);
}
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("appSettings");//重新加载新的配置文件
//重新设置系统数据库连接
SysSqlConnection = new SqlConnection(GetSqlConnString());
}
catch
{
Public.SystemInfo("写配置文件失败！", true);
}
}
