📄 main.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace counter
{
/// <summary>
/// main 的摘要说明。
/// </summary>
public class main : System.Web.UI.Page
{
public static DataView dv;
public static DataView dv1;
public static string mNameEn;
public int intvtotal;
public int intold_count;
public string strvfirst;
public int intvonline;
public int intvtoday;
public int intvyesterday;
public int intvthisyear;
public int intvthismonth;
public double dblvdays;
public double dblvdayavg;
public int intvguess;
public int intvuser;
public int inthigh;
public string strhightime;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(Session["master"]==null) Session["master"]="";
DataSet myds = new DataSet();
myds = counter.SQLConn.ExecuteSqlForDataSet("select * from CounterInfo");
dv=myds.Tables[0].DefaultView;
mNameEn=dv[0].Row["myNameEn"].ToString();
intold_count=int.Parse(dv[0].Row["old_count"].ToString());
if(Session["whatcan"]==null) Session["whatcan"]=dv[0].Row["whatcan"].ToString();
if(Session["master"].ToString() != "master" && int.Parse(Session["whatcan"].ToString()) < 1) Response.Redirect("help.aspx?id=004&error=本统计系统管理员不允许访客查看任何信息。");
//开始处理统计数据
DataSet myds1= new DataSet();
myds1=counter.SQLConn.ExecuteSqlForDataSet("select vtop,starttime,vhigh,vhightime from CountContent");
dv1=myds1.Tables[0].DefaultView;
dv1.Table.AcceptChanges();
if(dv1.Count==0)
{
Response.Redirect("help.aspx?id=007&error=统计系统还没有启用,尚不能查看统计报告。");
}
else
{
//总访问数、开始访问日期、最高访问数、最高访问数发生日期(从简数据库读取)
intvtotal = int.Parse(dv1[0].Row["vtop"].ToString());
strvfirst = dv1[0].Row["starttime"].ToString();
if(intvtotal == 0) Response.Redirect("help.aspx?id=007&error=统计系统还没有启用,尚不能查看统计报告。");
inthigh=int.Parse(dv1[0].Row["vhigh"].ToString());
strhightime=DateTime.Parse(dv1[0].Row["vhightime"].ToString()).Date.ToShortDateString();
dv1.Dispose();
//在线人数(从主数据库读取)
DateTime newtime=DateTime.Now.AddHours(int.Parse(dv[0].Row["adjtime"].ToString())).AddMinutes(-20);
myds1=counter.SQLConn.ExecuteSqlForDataSet("select vip from CounterView where vtime >='" + newtime + "' group by vip");
dv1=myds1.Tables[0].DefaultView;
dv1.Table.AcceptChanges();
intvonline=dv1.Count;
dv1.Dispose();
//今日访问量、昨日访问量(从简数据库读取)
myds1=counter.SQLConn.ExecuteSqlForDataSet("Select today,yesterday from CountContent");
dv1=myds1.Tables[0].DefaultView;
dv1.Table.AcceptChanges();
if(dv1.Count!=0)
{
intvtoday=int.Parse(dv1[0].Row["today"].ToString());
intvyesterday=int.Parse(dv1[0].Row["yesterday"].ToString());
}
else
{
intvtoday=0;
intvyesterday=0;
}
dv1.Dispose();
//今年访问量(从主数据库读取)
myds1=counter.SQLConn.ExecuteSqlForDataSet("Select vyear from CounterView where vyear="+int.Parse(DateTime.Now.AddHours(int.Parse(dv[0].Row["adjtime"].ToString())).Year.ToString()));
dv1=myds1.Tables[0].DefaultView;
dv1.Table.AcceptChanges();
intvthisyear=dv1.Count;
dv1.Dispose();
//本月访问量
myds1=counter.SQLConn.ExecuteSqlForDataSet("Select vmonth from CounterView where vmonth="+int.Parse(DateTime.Now.AddHours(int.Parse(dv[0].Row["adjtime"].ToString())).Month.ToString()));
dv1=myds1.Tables[0].DefaultView;
dv1.Table.AcceptChanges();
intvthismonth=dv1.Count;
dv1.Dispose();
//访问天数、平均每天访问量
dblvdays=DateTime.Now.AddHours(int.Parse(dv[0].Row["adjtime"].ToString())).Subtract(DateTime.Parse(strvfirst)).TotalDays;
dblvdayavg=intvtotal/dblvdays;
double dbcf=System.Math.Pow(10,int.Parse(dv[0].Row["mPrecision"].ToString()));
dblvdays=(int)(dblvdays*dbcf+0.5)/dbcf;
dblvdayavg=(int)(dblvdayavg*dbcf+0.5)/dbcf;
//预计今日访问量
double dblvdaylong=DateTime.Now.AddHours(int.Parse(dv[0].Row["adjtime"].ToString())).Subtract(DateTime.Now.AddHours(int.Parse(dv[0].Row["adjtime"].ToString())).Date).TotalDays;
intvguess=(int)(((intvtoday/dblvdaylong)+intvyesterday)/2+0.5);
if(intvguess<intvtoday) intvguess=(int)((intvtoday/dblvdaylong)+0.5);
//当前用户放量
System.Web.HttpCookie readcookie=Request.Cookies[mNameEn];
if(readcookie != null && readcookie.Values["lao"]!=null)
{
intvuser=int.Parse(readcookie.Values["lao"].ToString());
}
else
{
intvuser=0;
}
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -