Global

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Security; using System.Web.SessionState; using System.Text.RegularExpressions; using System.Data; namespace Web {     public class Global : System.Web.HttpApplication     {                 protected void Application_Start(object sender, EventArgs e)         {             DataTable dtS = DBUtility.DbHelperSQL.Query("select * from 表名").Tables[0];             DataTable dtT = DBUtility.DbHelperSQL.Query("select * from 表名").Tables[0];             int count = dtS.Rows.Count + dtT.Rows.Count;             Application.Add("total", count);             Application.Add("online", 0);         }           protected void Session_Start(object sender, EventArgs e)         {             Application.Lock();//关闭会话，解决同时发生的情况             Application["total"] = (int)Application["total"] + 1;//总的访问量加1             Application["online"] = (int)Application["online"] + 1;//当前在线人数加1             Application.UnLock();         }           protected void Application_BeginRequest(object sender, EventArgs e)         {             // 非法字符过滤             Security.FilterModule.Filter(Request);         }           protected void Application_AuthenticateRequest(object sender, EventArgs e)         {           }           protected void Application_Error(object sender, EventArgs e)         {           }           protected void Session_End(object sender, EventArgs e)         {             Application.Lock();//锁             Application["online"] = (int)Application["online"] - 1;//当前在线人数减1             if(Session["usertype"].ToString()=="student")             {                 DataTable dt = DBUtility.DbHelperSQL.Query("select * from 表名 where  Day(CreateTime)=Day(getdate()) and UserName='" + Session["username"] + "'").Tables[0];                 if (dt.Rows.Count > 0)                 {                     smodel = sbll.GetModel(int.Parse(dt.Rows[0]["Id"].ToString()));                     smodel.Online = false;                     smodel.ExitTime = DateTime.Now;                     smodel.UpdateTime = DateTime.Now;                     sbll.Update(smodel);                 }             }             if (Session["usertype"].ToString() == "teacher")             {                 DataTable dt = DBUtility.DbHelperSQL.Query("select * from 表名 where Day(CreateTime)=Day(getdate()) and UserName='" + Session["username"] + "'").Tables[0];                 if (dt.Rows.Count > 0)                 {                     tmodel = tbll.GetModel(int.Parse(dt.Rows[0]["Id"].ToString()));                     tmodel.Online = false;                     tmodel.ExitTime = DateTime.Now;                     tmodel.UpdateTime = DateTime.Now;                     tbll.Update(tmodel);                 }             }             Application.UnLock();//解锁         }           protected void Application_End(object sender, EventArgs e)         {           }     } }