/// <summary>
/// 得到缺省的设置
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public static UserRecentData GetDefaultSettings(string userID)
{
userID.CheckStringIsNullOrEmpty("userID");
UserRecentData settings = new UserRecentData();
settings.UserID = userID;
settings.InitFromConfiguration();
return(settings);
}
/// <summary>
/// 从数据库中加载
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
private static UserRecentData LoadFromDB(string userID)
{
string sql = string.Format("SELECT CATEGORY,DATA FROM USER_RECENT_DATA WHERE USER_ID = {0}",
TSqlBuilder.Instance.CheckQuotationMark(userID, true));
UserRecentData result = new UserRecentData()
{
UserID = userID
};
result.InitFromConfiguration();
using (DbContext dbi = DbContext.GetContext(ConnectionDefine.UserRelativeInfoConnectionName))
{
Database db = DatabaseFactory.Create(dbi);
using (var dr = db.ExecuteReader(System.Data.CommandType.Text, sql))
{
while (dr.Read())
{
var catDataString = dr.GetString(1);
if (catDataString != null)
{
XElementFormatter formatter = new XElementFormatter();
formatter.OutputShortType = false;
XElement root = XElement.Parse(catDataString);
var loadedCatData = (UserRecentDataCategory)formatter.Deserialize(root);
result.Categories[(string)dr.GetString(0)].ImportValues(loadedCatData);
}
}
}
}
return(result);
}
/// <summary>
/// 从数据库中加载
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
private static UserRecentData LoadFromDB(string userID)
{
string sql = string.Format("SELECT CATEGORY,DATA FROM USER_RECENT_DATA WHERE USER_ID = {0}",
TSqlBuilder.Instance.CheckQuotationMark(userID, true));
UserRecentData result = new UserRecentData() { UserID = userID };
result.InitFromConfiguration();
using (DbContext dbi = DbContext.GetContext(ConnectionDefine.UserRelativeInfoConnectionName))
{
Database db = DatabaseFactory.Create(dbi);
using (var dr = db.ExecuteReader(System.Data.CommandType.Text, sql))
{
while (dr.Read())
{
var catDataString = dr.GetString(1);
if (catDataString != null)
{
XElementFormatter formatter = new XElementFormatter();
formatter.OutputShortType = false;
XElement root = XElement.Parse(catDataString);
var loadedCatData = (UserRecentDataCategory)formatter.Deserialize(root);
result.Categories[(string)dr.GetString(0)].ImportValues(loadedCatData);
}
}
}
}
return result;
}
/// <summary>
/// 得到缺省的设置
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public static UserRecentData GetDefaultSettings(string userID)
{
userID.CheckStringIsNullOrEmpty("userID");
UserRecentData settings = new UserRecentData();
settings.UserID = userID;
settings.InitFromConfiguration();
return settings;
}
