Global.asax

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ Application Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import  Namespace="System.Data.SqlClient" %>

<script runat="server">

    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) 
    { 
        // 在出现未处理的错误时运行的代码