图书管理流量统计部分

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class flow : System.Web.UI.Page
{
   
    static string strconn = "Data Source=localhost;database=BOOKS;integrated security=SSPI";
    SqlConnection conn = new SqlConnection(strconn);
    SqlCommand cmd;
    protected void Page_Load(object sender, EventArgs e)
    {
            if (!IsPostBack)
        {
          
             ShowDigital();
        }
    }
    private void ShowDigital()
    {
        string SQLCount = "SELECT COUNT(*) FROM ip";
        ConnectionDB();
        cmd = new SqlCommand(SQLCount, conn);
        SqlDataReader reader = cmd.ExecuteReader();
        reader.Read();
        string totalNumber = reader[0].ToString();
     
        int Total = Int32.Parse(totalNumber);
        reader.Close();
        if (totalNumber == "0")
        {
            total.InnerHtml="网站总访问量:<img src='img/0.gif'/>人";
            today.InnerHtml = "今日访问量:<img src='img/0.gif'/>人";
            day.InnerHtml = "网站已运行:<img src='img/0.gif'/>天";
            avg.InnerHtml = "平均访问量:<img src='img/0.gif'/>人";
            CurrentUser.InnerHtml="当前访客数量:<img src='img/0.gif'/>人";
            return;
        }
        //显示总流量
        total.InnerHtml="网站总访问量:"+returnImage(totalNumber)+"人";
        //查询当天的访问量
        string SQLToday="SELECT COUNT(*) FROM ip where YEAR(time)=YEAR(getdate()) and "+
            "MONTH(time)=MONTH(getdate()) AND DAY(time)=DAY(getdate())";
        cmd.CommandText=SQLToday;
        reader=cmd.ExecuteReader();
        reader.Read();
        today.InnerHtml="今日访问量:"+returnImage(reader[0].ToString())+"人";

        reader.Close();
        //网站运行天数
        //由于该表数据一般不会被删除，因此可以直接查询第一条记录的时间作为网站开始运行的霎时间
        string totalDaySQL = "SELECT time FROM ip where id = 27";
        TimeSpan sp = new TimeSpan();
        cmd.CommandText = totalDaySQL;
        reader = cmd.ExecuteReader();
        reader.Read();
        sp=DateTime.Now.Subtract(DateTime.Parse(reader[0].ToString()));
        string spToStr = sp.TotalDays.ToString();
        string TotalDayNumber = spToStr.Substring(0, spToStr.IndexOf('.'));
        int days = Int32.Parse(TotalDayNumber);
        reader.Close();
        if (TotalDayNumber == "0")
            TotalDayNumber = "1";
        day.InnerHtml = "网站已运行:" + returnImage(TotalDayNumber) + "天";


        //平均访问量
        int avgNumber;
        if (days == 0)
            avgNumber = Total;
        else
            avgNumber = Total / days;
        if (avgNumber < 1)
            avgNumber = 1;
        avg.InnerHtml = "平均访问量" + returnImage(avgNumber.ToString()) + "人";


        //当前在线用户数量
        //显示当前在线人数
        string useCounter = Application["current_user"].ToString();
        string n="";
        for (int i = 0; i < useCounter.Length; i++)
        {
            n= useCounter.Substring(i,1);
            CurrentUser.InnerHtml = "当前在线用户数:" + returnImage(n)+"人";
        }

        CloseConnection();

    }
    private string returnImage(string number)
    {
        string showTotal="";
        for(int i=0;i<number.Length;i++)
        {
            switch(number[i].ToString())
            {
                case "1":
                    showTotal += "<img alt='lib' src='image/1.gif' style='width: 39px; height: 39px' />";
                    break;
                case "2":
                    showTotal += "<img alt='lib' src='image/2.gif' style='width: 39px; height: 39px' />";
                    break;
                case "3":
                    showTotal += "<img alt='lib' src='image/3.gif' style='width: 39px; height: 39px' />";
                    break;
                case "4":
                    showTotal += "<img alt='lib' src='image/4.gif' style='width: 39px; height: 39px' />";
                    break;
                case "5":
                    showTotal += "<img alt='lib' src='image/5.gif' style='width: 39px; height: 39px' />";
                    break;
                case "6":
                    showTotal += "<img alt='lib' src='image/6.gif' style='width: 39px; height: 39px' />";
                    break;
                case "7":
                    showTotal += "<img alt='lib' src='image/7.gif' style='width: 39px; height: 39px' />";
                    break;
                case "8":
                    showTotal += "<img alt='lib' src='image/8.gif' style='width: 39px; height: 39px' />";
                    break;
                case "9":
                    showTotal += "<img alt='lib' src='image/9.gif' style='width: 39px; height: 39px' />";
                    break;
                default:
                    showTotal += "<img alt='lib' src='image/0.gif' style='width: 39px; height: 39px' />";
                    break;
            }
          
        }
        return showTotal;
    }
     private void ConnectionDB()
    {
        if (conn == null)
        {
            conn = new SqlConnection(strconn);
        }
        if (conn.State == ConnectionState.Closed)
        {
            conn.Open();
        }
    }
    private void CloseConnection()
    {
        conn.Close();
    }
}