/*-----------------------------------------------------------------
* For the database connection.
* ---------------------------------------------------------------*/
/// <summary>
/// return a ConnectionString object for connecting to a database.
/// </summary>
/// <returns></returns>
public static string GetConnString()
{
//创建数据库连接对象
// return "Data Source=.\\SQLEXPRESS;Initial Catalog=Geo2010;Integrated Security=True";
// return "Data Source=.;Initial Catalog=Geo2010;Integrated Security=True";
// return connStr;
// return ConstructCnStr(@".", "Geo2010", "GeoUser2007", "gdser_123456");
Geo.Utils.DbLoginInfo loginInfo = Setting.LoginInfo;
return(GetConnString(loginInfo));
}
/// <summary>
/// 从配置文件读取数据库连接设置.从自定义的 databaseSettings 中，非系统字符串中。
/// </summary>
/// <returns></returns>
public static Geo.Utils.DbLoginInfo GetLoginInfoFromConfigFile()
{
Geo.Utils.DbLoginInfo loginInfo = new Geo.Utils.DbLoginInfo();
NameValueCollection nc = (NameValueCollection)ConfigurationManager.GetSection("databaseSettings");
loginInfo.ServerAddress = nc["db.datasource"].Trim();
loginInfo.DababaseName = nc["db.database"].Trim();
loginInfo.LoginUser = nc["db.user"].Trim();
loginInfo.LoginPass = Geo.Utils.EncryptUtil.Decrypt(nc["db.password"].Trim());//nc["db.password"].Trim();//
return(loginInfo);
}
/// <summary>
/// 将登陆信息保存到数据库。
/// </summary>
/// <param name="loginInfo"></param>
public static void SaveLoginInfoToConfigFile(Geo.Utils.DbLoginInfo loginInfo)
{
Setting.LoginInfo = loginInfo;
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//Save to
string AppName = config.AppSettings.Settings["AppName"].Value;
Geo.Utils.AppConfigSetter setter = new Geo.Utils.AppConfigSetter();
setter.AppName = AppName;
setter.Open();
setter.SingleNodeName = "//databaseSettings";
setter.SetValue("db.datasource", loginInfo.ServerAddress);
setter.SetValue("db.database", loginInfo.DababaseName);
setter.SetValue("db.user", loginInfo.LoginUser);
string pass = Geo.Utils.EncryptUtil.Encrypt(loginInfo.LoginPass.Trim());//LoginInfo.LoginPass.Trim();//
setter.SetValue("db.password", pass);
setter.Save();
// var dbConsection = config.GetSection("databaseSettings");
//config.SectionGroups["config"].Sections[""].
// dbConsection["bd"]
// var conn = config.GetSectionGroup("databaseSettings");
// dbConsection.
//记录登录用户名，下次自动填充。
//Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//Save to
//config.AppSettings.Settings["LastUserName"].Value = username;
// config.Save(ConfigurationSaveMode.Modified);
//log.Debug("写登录信息到磁盘。");
//ConfigurationManager.RefreshSection("appSettings");
ConfigurationManager.RefreshSection("databaseSettings");
}
public static string GetConnString(Geo.Utils.DbLoginInfo loginInfo)
{
return(GetConnString(loginInfo.ServerAddress, loginInfo.DababaseName, loginInfo.LoginUser, loginInfo.LoginPass));
}
