public object Clone()
{
Vars stat = new Vars();
stat.MaxOnlineCount = MaxOnlineCount;
stat.MaxOnlineDate = MaxOnlineDate;
stat.MaxPostDate = MaxPostDate;
stat.MaxPosts = MaxPosts;
stat.NewUserID = NewUserID;
stat.NewUsername = NewUsername;
stat.TotalUsers = TotalUsers;
stat.YestodayPosts = YestodayPosts;
stat.LastResetDate = LastResetDate;
stat.YestodayTopics = YestodayTopics;
return stat;
}
public override Vars GetVars()
{
Vars stat = null;
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_GetVars";
query.CommandType = CommandType.StoredProcedure;
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
stat = new Vars(reader);
}
}
}
if (stat == null)
{
stat = UpdateNewUserStat();
}
return stat;
}
public static void UpdateVars(Vars vars)
{
try
{
VarDao.Instance.UpdateVars(vars);
VarsManager.stat = vars;
}
catch(Exception ex)
{
LogHelper.CreateErrorLog(ex);
}
}
/// <summary>
/// 重新统计用户数 只用于后台 的重新统计
/// </summary>
public static void UpdateUserCount()
{
Vars newStat = VarDao.Instance.UpdateNewUserStat();
stat = newStat;
}
public static void ResetVars()
{
stat = null;
}
public override void UpdateVars(Vars vars)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_UpdateVars";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter<int>("@MaxPosts", vars.MaxPosts, SqlDbType.Int);
query.CreateParameter<int>("@NewUserID", vars.NewUserID, SqlDbType.Int);
query.CreateParameter<int>("@TotalUsers", vars.TotalUsers, SqlDbType.Int);
query.CreateParameter<int>("@YestodayPosts", vars.YestodayPosts, SqlDbType.Int);
query.CreateParameter<int>("@YestodayTopics", vars.YestodayTopics, SqlDbType.Int);
query.CreateParameter<int>("@MaxOnlineCount", vars.MaxOnlineCount, SqlDbType.Int);
query.CreateParameter<DateTime>("@MaxPostDate", vars.MaxPostDate, SqlDbType.DateTime);
query.CreateParameter<DateTime>("@MaxOnlineDate", vars.MaxOnlineDate, SqlDbType.DateTime);
query.CreateParameter<DateTime>("@LastResetDate", vars.LastResetDate, SqlDbType.DateTime);
query.CreateParameter<string>("@NewUsername", vars.NewUsername, SqlDbType.NVarChar, 50);
query.ExecuteNonQuery();
}
}
public override Vars UpdateNewUserStat()
{
Vars stat = null;
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_UpdateNewUserVars";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter<bool>("@GetVars", true, SqlDbType.Bit);
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
stat = new Vars(reader);
}
}
}
if (stat == null)
{
stat = new Vars();
stat.NewUserID = 1;
stat.NewUsername = "******";
}
return stat;
}