string dbpath = Server.MapPath("db/count.mdb");
DbAccess db = new DbAccess(dbpath);
#region "添加"
string url = Convert.ToString(Request.UrlReferrer);
string ip = Convert.ToString(Request.UserHostAddress);
//判断
string sqlsel = string.Format("select count(*) from record where ip='{0}'",ip);
int coun = Convert.ToInt32(db.GetDataTable(sqlsel).Rows[0][0].ToString());
bool add=false;
if(coun>0)
{
sqlsel = string.Format("select [date] from record where ip='{0}'order by date desc",ip);
DateTime dt = Convert.ToDateTime(db.GetDataTable(sqlsel).Rows[0]["date"].ToString());
DateTime now = DateTime.Now;
TimeSpan ts = now-dt;
double time = ts.TotalHours;
if(time>2)
{
add=true;
}
else
{
}
}
else
{
add=true;
}
//添加
if(add)
{
string sqladd = string.Format("insert into record(url,ip) values('{0}','{1}')",url,ip);
db.ReturnState(sqladd);
}
#endregion
#region 显示
DataSet ds = new DataSet();
ds=db.GetDataSet("select count(*) from record");
this.coun=Convert.ToString(ds.Tables[0].Rows[0][0]);
#endregion
DateTime now = DateTime.Now;
DateTime ot = DateTime.Now.AddDays(3);
long al = now.Ticks;
long ot1 = ot.Ticks;
Response.Write(al);
Response.Write("<br>");
Response.Write(ot1);
Response.Write("<br>");
Response.Write(ot1-al);
Response.Write("<br>");
Response.Write(((ot1-al)/10000/1000)/(60*60*24));//相差几天
文章来源:
http://www.cnblogs.com/wangdetian168/archive/2008/06/25/1230015.html
posted on 2010-09-28 11:00
sanmao 阅读(130)
评论(0) 编辑 收藏