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 阅读(86) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航:
 

常用链接

留言簿(5)

随笔分类

随笔档案

搜索

  •  

最新评论

阅读排行榜

评论排行榜