public DatabaseAdapter(Page page)
{
//
//TODO: 在此处添加构造函数逻辑
//
DLL.User loginUser = page.Session["dsUser"] as DLL.User;
sobType = loginUser != null ? loginUser.SetOfBook : SetOfBookType.Offical;
SetDatabaseHelper(sobType);
}
public SqlServerHelper(SetOfBookType sobType)
{
setOfBook = sobType;
this._commandTimeout = 30;
//this._sqlConnStr = ConfigurationSettings.AppSettings["SqlConnStr"].ToString();
this._sqlConnStr = ConfigurationSettings.AppSettings[setOfBook.ToString()].ToString();
if (ConfigurationSettings.AppSettings["CommandTimeout"] != null)
{
this._commandTimeout = int.Parse(ConfigurationSettings.AppSettings["CommandTimeout"].ToString());
}
}
public MySqlHelper(SetOfBookType sobType)
{
setOfBook = sobType;
//this._sqlConnStr = ConfigurationSettings.AppSettings["SqlConnStr"].ToString();
//if (ConfigurationSettings.AppSettings["CommandTimeout"] != null)
//{
// this._commandTimeout = int.Parse(ConfigurationSettings.AppSettings["CommandTimeout"].ToString());
//}
//this._sqlConnStr = ConfigurationManager.AppSettings["LocalMySqlServer"].ToString(); ;
//this._commandTimeout = int.Parse(ConfigurationSettings.AppSettings["CommandTimeout"].ToString());
//this._sqlConnStr = ConfigurationManager.ConnectionStrings["LocalMySqlServer"].ToString();
this._sqlConnStr = ConfigurationManager.ConnectionStrings[setOfBook.ToString()].ToString();
}
private void SetDatabaseHelper(SetOfBookType sobType)
{
switch (DbType)
{
case DatabaseTypeEnum.MySql:
{
DbHelper = new MySqlHelper(sobType);
}
break;
case DatabaseTypeEnum.SqlServer:
{
DbHelper = new SqlServerHelper(sobType);
}
break;
default:
{
throw new Exception("没有定义有效的数据库类型!");
}
break;
}
}
public DatabaseAdapter(SetOfBookType sobType)
{
SetDatabaseHelper(sobType);
}
private static string GetSobKey(SetOfBookType sobType,string key)
{
return string.Format("{0}-{1}", (int)sobType, key);
}
public static void SetItemToSession(Page page, SetOfBookType sobType, string strKey,object objValue)
{
string sobKey = GetSobKey(sobType, strKey);
page.Session[sobKey] = objValue;
}
