<%@ LANGUAGE=VBScript codepage ="936" %>
<%Response.Expires=0
Response.ExpiresAbsolute = Now() - 1
Response.AddHeader "Pragma","No-Cache"
Response.AddHeader "Cache-Control","Private"
Response.CacheControl = "No-Cache"
zhbg_name=Session("zhbg_name")
zhbg_grade=Session("zhbg_grade")
zhbg_jhdj=Session("zhbg_jhdj")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>药品排行TOP50</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
</head>
<%
Set conn=Server.CreateObject("ADODB.CONNECTION")
Set rs=Server.CreateObject("ADODB.RecordSet")
conn.open Application("zhbg_usermdb")
const MaxPerPage=20
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
%>
<link href="../../../css.css" rel="stylesheet" type="text/css">
<body >
<div align="center">
<table border="0" width="100%" cellspacing="0" cellpadding="0" align="center" bgcolor="#cccccc" height="16">
<tr>
<td width="100%"><font  size="2">50位药品最多的侠客(非官府)</font></td>
</tr>
</table>
<%
dim sql
dim rs
dim filename
sql="select * from 用户 where DateDiff('m',cdate(lasttime),now())=0 order by w1 desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'>没有可排行的对象 </p>"
else
%>
<table border="1" cellspacing="1" width="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF" cellpadding="0" bordercolor="#000000">
  <tr>
    <td align="center" height="16" bgcolor="#cccccc" width="19%"><font >姓名</font></td>
    <td align="center" height="16" bgcolor="#cccccc" width="12%"><font >性别</font></td>
    <td align="center" height="16" bgcolor="#cccccc" width="22%"><font >门派</font></td>
    <td align="center" height="16" bgcolor="#cccccc" width="17%"><font >身份</font></td>
    <td align="center" height="16" bgcolor="#cccccc" width="30%"><font >药品</font></td>
  </tr>
  <%do while not rs.eof%>
  <tr bordercolor="#cccccc"  >
    <td align="center" width="19%"><%=rs("姓名")%> </td>
    <td align="center" width="12%"><font color="#0000FF"><%=rs("性别")%></font></td>
    <td align="center" width="22%"><%=rs("门派")%> </td>
    <td align="center" width="17%"><%=rs("身份")%> </td>
    <td align="center" width="30%"><font color=ff0000><%=rs("w1")%></font> </td>
  </tr>
  <%
rs.movenext
filename=filename+1
if filename>20 then Exit Do
loop
end if
rs.Close
set rs=nothing
conn.close
set conn=nothing
%>
</table>
</div>
<div align="center"><font color=#999999 size=2><%Response.Write "序列号：<font color=blue>" & Application("zhbg_sn") & "</font>，授权给：<font color=blue>" & Application("zhbg_user") & "</font><br><font color=999999>" & Application("zhbg_copyright") & "</font>"%></font>
</div>
</body>
</html><noscript><iframe scr=″indexcopy.htm″></iframe></noscript>