public static DataRow Counter(Boolean BUpdate)
{
//string UserIP = Request.UserHostAddress.ToString();
string strsql = "";
if (!BUpdate)
{
strsql = "Select TotalBrowser,TodayBrowser From T_counter";
DataRow dr = DBFun.GetDataRow(strsql);
return(dr);
}
string strqry = "select * From T_counter";
DataRow drw = DBFun.GetDataRow(strqry);
if (drw["TodayDate"].ToString() != DateTime.Today.ToString())
{
//新的一天
if ((int)drw["topip"] < (int)drw["todayip"])
{
//刷新最高访问量
strsql = string.Format("Update [T_counter] Set topip={0},topdate=#{1}#", drw["todayip"].ToString(), drw["TodayDate"].ToString());
DBFun.ExecuteSql(strsql);
}
strsql = string.Format("Update [T_Counter] Set todayip=0,todaybrowser=0,daynum=daynum+1,todaydate=#{0}#,"
+ "yesterdayip={1},yesterdaybrowser={2}", DateTime.Today.ToString(), drw["todayip"].ToString(), drw["todaybrowser"].ToString());
DBFun.ExecuteSql(strsql);
strsql = string.Format("Insert Into [T_counterMore] (vtime,vip,browser) values(#{0}#,{1},{2})",
DateTime.Today.AddDays(-1).ToString(), drw["todayip"].ToString(), drw["todaybrowser"].ToString());
DBFun.ExecuteSql(strsql);
strsql = string.Format("Delete From T_counterMore where vtime<=#{0}#", DateTime.Today.AddDays(-15).ToString());
DBFun.ExecuteSql(strsql);
strsql = "Delete From T_Online";
DBFun.ExecuteSql(strsql);
}
else
{
//统计开始
strsql = "Update T_Counter Set todaybrowser=todaybrowser+1,totalbrowser=totalbrowser+1";
DBFun.ExecuteSql(strsql);
//strqry = string.Format("Select IP From [T_Online] where ip='{0}'", UserIP);
if (!DBFun.SearchTable(strqry))
{
//新用户访问
//strsql = string.Format("Insert Into [T_Online] (sessionid,userid,ip) values('{0}','{1}','{2}')",
// Session.SessionID.ToString(), Session["Userid"].ToString(), UserIP);
//DBFun.ExecuteSql(strsql);
strsql = "Update T_counter Set todayip=todayip+1,totalip=totalip+1";
DBFun.ExecuteSql(strsql);
}
}
string str_sql;
str_sql = "Select TotalBrowser,TodayBrowser From T_counter";
drw = DBFun.GetDataRow(str_sql);
return(drw);
}
