日期:2014-05-18 浏览次数:20399 次
void Application_Start(object sender, EventArgs e) { // 在应用程序启动时运行的代码 int count = 0; int day_count = 0; int year = 0; int month = 0; int day = 0; DateTime today = DateTime.Now; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["lianxiConnectionString"].ConnectionString); conn.Open(); SqlDataAdapter sda1 = new SqlDataAdapter("select [count] from [webcount]",conn); DataSet ds = new DataSet(); sda1.Fill(ds); //取总访问数 if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; count = Convert.ToInt32(dr["count"].ToString()); } ds.Clear(); SqlDataAdapter sda2 = new SqlDataAdapter("select * from [day_count]",conn); sda2.Fill(ds); //取每天访问数 if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; day_count = Convert.ToInt32(dr["day_count"].ToString()); year = Convert.ToInt32(dr["year"].ToString()); month = Convert.ToInt32(dr["month"].ToString()); day = Convert.ToInt32(dr["day"].ToString()); } //日期不同,则day_count为0 if (today.Year != year || today.Month != month || today.Day != day) day_count = 0; Application["count"] = count; Application["day_count"] = day_count; } void Application_End(object sender, EventArgs e) { // 在应用程序关闭时运行的代码 } void Application_Error(object sender, EventArgs e) { // 在出现未处理的错误时运行的代码 } void Session_Start(object sender, EventArgs e) { // 在新会话启动时运行的代码 Application.Lock();//锁定Application int count = 0; int day_count = 0; int year = 0; int month = 0; int day = 0; DateTime today = DateTime.Now; year = today.Year; month = today.Month; day = today.Day; //访问次数都加1 count = (int)Application["count"]; day_count=(int)Application["day_count"]; count++; day_count++; Application["count"] = count; Application["day_count"] = day_count; //更新数据库 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["lianxiConnectionString"].ConnectionString); conn.Open(); SqlCommand cmd1 = new SqlCommand("update [webcount] set [count]='"+count+"'",conn); cmd1.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand("update [day_count] set [day_count]='"+day_count+"',[year]='"+year+"',[month]='"+month+"',[day]='"+day+"'",conn); cmd2.ExecuteNonQuery(); Application.UnLock();//解锁 } void Session_End(object sender, EventArgs e) { // 在会话结束时运行的代码。 // 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为 // InProc 时,才会引发 Session_End 事件。如果会话模式设置为 StateServer // 或