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)); }