public static void InsertAS(object source, ElapsedEventArgs e)
{
var list = Web.Controllers.HomeController.asList;
Web.Controllers.HomeController.asList = new List <ViewModels.vm_AccessStatistics>();
var mlist_2 = (from l in list where l.WebSiteID == "2" select l).ToList();
if (mlist_2.Count > 0)
{
Model.AccessStatistics model = Logic.AccessStatistics.GetAS(2);
Model.AccessStatistics as_2 = new Model.AccessStatistics
{
WebSiteID = 2
};
if (model != null)
{
as_2.ASCount = model.ASCount + mlist_2.Count;
Logic.AccessStatistics.UpdateAS(as_2);
}
else
{
as_2.ASCount = mlist_2.Count;
Logic.AccessStatistics.InsertAS(as_2);
}
}
var mlist_5 = (from l in list where l.WebSiteID == "5" select l).ToList();
if (mlist_5.Count > 0)
{
Model.AccessStatistics model = Logic.AccessStatistics.GetAS(5);
Model.AccessStatistics as_5 = new Model.AccessStatistics
{
WebSiteID = 5
};
if (model != null)
{
as_5.ASCount = model.ASCount + mlist_5.Count;
Logic.AccessStatistics.UpdateAS(as_5);
}
else
{
as_5.ASCount = mlist_5.Count;
Logic.AccessStatistics.InsertAS(as_5);
}
}
}
public static int UpdateAS(Model.AccessStatistics inModel)
{
string sql = @" UPDATE Web_AccessStatistics SET ASCount = @inASCount WHERE WebSiteID = @inWebSiteID ";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inWebSiteID", SqlDbType.Int, 32),
new SqlParameter("@inASCount", SqlDbType.BigInt, 64)
};
paras[0].Value = inModel.WebSiteID;
paras[1].Value = inModel.ASCount;
int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras);
return(result);
}
public static int InsertAS(Model.AccessStatistics inModel)
{
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO Web_AccessStatistics ( ");
sql.Append(" WebSiteID, ASCount ) VALUES ( ");
sql.Append(" @inWebSiteID, @inASCount ) ");
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inWebSiteID", SqlDbType.Int, 32),
new SqlParameter("@inASCount", SqlDbType.BigInt, 64)
};
paras[0].Value = inModel.WebSiteID;
paras[1].Value = inModel.ASCount;
int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras);
return(result);
}
public static Model.AccessStatistics GetAS(int inWebSiteID)
{
string sql = @" SELECT * FROM Web_AccessStatistics WHERE WebSiteID = @inWebSiteID ";
SqlParameter para = new SqlParameter("@inWebSiteID", SqlDbType.Int, 32)
{
Value = inWebSiteID
};
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql, para);
Model.AccessStatistics model = null;
if (dt.Rows.Count > 0)
{
model = new Model.AccessStatistics
{
WebSiteID = Convert.ToInt32(dt.Rows[0]["WebSiteID"]),
ASCount = Convert.ToInt32(dt.Rows[0]["ASCount"])
};
}
return(model);
}
/// <summary>
/// 更新网站访问信息
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public static int UpdateAS(Model.AccessStatistics inModel)
{
return(Data.AccessStatistics.UpdateAS(inModel));
}
/// <summary>
/// 添加网站访问信息
/// </summary>
/// <param name="inModel"></param>
/// <returns></returns>
public static int InsertAS(Model.AccessStatistics inModel)
{
return(Data.AccessStatistics.InsertAS(inModel));
}
