📄 manaccquerydateok.asp

📁 此程序为网上下载
💻 ASP
字号:
<%@ codepage ="936" %>
<%'On Error Resume Next
Response.Expires=0
nickname=Session("hxf_u_nickname")
grade=Int(Session("hxf_u_grade"))
if nickname="" then Response.Redirect "manerr.asp?id=100"
if grade<>12 then Response.Redirect "manerr.asp?id=130"
dt1=Trim(Request("date1"))
dt2=Trim(Request("date2"))
tp=Trim(Request("type"))
if dt1="" or dt2="" then Response.Redirect "manerr.asp?id=102"
if Not(IsDate(dt1) and IsDate(dt2)) then Response.Redirect "manerr.asp?id=311"
page=Request.QueryString("page")
if page="" then page=1
if Not(IsNumeric(page)) then page=1
if page<1 then page=1
page=int(page)
Set conn=Server.CreateObject("ADODB.CONNECTION")
Set rs=Server.CreateObject("ADODB.RecordSet")
connstr=Application("wsaxhg_connstr")
conn.open connstr
if tp="1" then
 sql="SELECT username,grade,times,value,regtime,lastip,lasttime FROM reginfo WHERE kill='0' AND regtime>'" & dt1 & "' AND regtime<'" & dt2 & "'"
else
 sql="SELECT username,grade,times,value,regtime,lastip,lasttime FROM reginfo WHERE kill='0' AND lasttime>'" & dt1 & "' AND lasttime<'" & dt2 & "'"
end if
rs.open sql,conn,1,1
rs.PageSize=15
totalrec=rs.RecordCount
totalpage=rs.PageCount
if page>totalpage then page=totalpage
if totalrec>0 then
 rs.AbsolutePage=page
 p=1+(page-1)*rs.PageSize
 Dim show()
 i=0
 j=1
 Do while (Not rs.Eof) and (i<rs.PageSize)
  Redim Preserve show(j),show(j+1),show(j+2),show(j+3),show(j+4),show(j+5),show(j+6)
  show(j)=rs("username")
  show(j+1)=rs("grade")
  show(j+2)=rs("times")
  show(j+3)=rs("value")
  show(j+4)=rs("regtime")
  show(j+5)=rs("lastip")
  show(j+6)=rs("lasttime")
  i=i+1
  j=j+7
 rs.MoveNext
 Loop
end if
rs.close
conn.close
set rs=nothing
set conn=nothing
dt3=server.URLEncode(dt1)
dt4=server.URLEncode(dt2)%><html>
<head>
<title>帐号管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="readonly/style.css">
</head>
<body bgcolor="#FFFFFF" class=p150>
<div align="center">
<h1><font color="0099FF">【帐号管理】</font></h1>
<font color="#FF0000">【按日期查询帐号】</font> <br>
<a href="manacc.asp">返回</a></div>
<hr noshade size="1" color=009900>
<b>［注意事项］</b><br>
　　找到 <font color=red><%=totalrec%></font> 个帐号符合从日期：<font color=red><%=dt1%></font> 到日期：<font color=red><%=dt2%></font>。<%if totalrec>0 then%> 
<hr noshade size="1" color=009900>
<div align=center>
<%for i=1 to totalpage
if page=i then
 Response.Write " [" & i & "]"
else
 Response.Write " <a href=manaccquerydateok.asp?type=" & tp & "&date1=" & dt3 & "&date2=" & dt4 & "&page=" & i & ">[" & i & "]</a>"
end if
next%></div>
<hr noshade size="1" color=009900>
<table border="0" cellspacing="1" cellpadding="6" bordercolorlight="#999999" bordercolordark="#FFFFFF" bgcolor="#319AFF" align="center" bordercolor="#319AFF">
  <tr bgcolor="#3399FF"> 
<td><font color="#FFFFFF">序</font></td>
<td><font color="#FFFFFF">用户名</font></td>
<td><font color="#FFFFFF">等级</font></td>
<td><font color="#FFFFFF">次数</font></td>
<td><font color="#FFFFFF">注册时间</font></td>
<td><font color="#FFFFFF">最后ＩＰ</font></td>
<td><font color="#FFFFFF">最后时间</font></td>
</tr>
<%for i=1 to UBound(show) step 7%> 
<tr onmouseout="this.bgColor='#F0F0F0';"onmouseover="this.bgColor='#DFEFFF';" bgcolor="#F0F0F0"> 
<td><%=(page-1)*15+(i+6)/7%></td>
<td><%=show(i)%></td>
<td><%=show(i+1)%></td>
<td><%=show(i+2)%></td>
<td><%=show(i+4)%></td>
<td><%=show(i+5)%></td>
<td><%=show(i+6)%></td>
</tr>
<%next%> 
</table>
<%end if%>
<hr noshade size="1" color=009900>
<div align=center class=cp><%Response.Write "序列号：<font color=blue>" & Application("wsaxhxf_c_sn") & "</font>，授权给：<font color=blue>" & Application("wsaxhxf_c_user") & "</font><br><font color=999999>" & Application("wsaxhxf_c_copyright") & "</font>"%></div>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -