sql="select * from SoftDown_SoftInfo where SoftID="&SoftID
 rs.open sql,conn,1,1
 DayDate=trim(rs("DayDate"))
 WeekDate=trim(rs("WeekDate"))
 MonthDate=trim(rs("MonthDate"))
 AllHits=trim(rs("AllHits"))
 avgGrade=trim(rs("avgGrade"))
 Points=rs("Points")
 '更新软件下载次数
 sql="update SoftDown_SoftLink set Hits=Hits+1 where Id=" & cstr(request.QueryString("ID"))
 conn.execute sql
 sql="update SoftDown_SoftInfo set AllHits=AllHits+1,DayHits=DayHits+1,WeekHits=WeekHits+1,MonthHits=Monthhits+1 where SoftId=" & SoftID
 conn.execute sql

 if datediff("H",DayDate,Now)>=24 then
 sql="update SoftDown_SoftInfo set DayDate=Now(),DayHits=1 where SoftId=" & SoftID
 conn.execute sql      
 end if

 if datediff("D",WeekDate,Now)>=7 then
 sql="update SoftDown_SoftInfo set WeekDate=Now(),WeekHits=1 where SoftId=" & SoftID
 conn.execute sql
 end if

 if datediff("D",MonthDate,Now)>=31 then
 sql="update SoftDown_SoftInfo set MonthDate=Now(),MonthHits=1 where SoftId=" & SoftID
    conn.execute sql
 end if

 rs.close