<!--#include file="conn.asp"-->
<%
	'检查访问的来源是否合法
	call checkPrePage()
	
	'检查用户访问的权限
	call checkuser(1)

	strM_ID=Session("UserID")
	
	strSQL="Select * from v_member Where m_AgentName=" & strM_ID
	rs.open strSQL,conn,1,1
	%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>打印--用户资料清单</title>
<link href="common/styleMain.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td align="center"><table width="810" height="236" border="0" cellpadding="0" cellspacing="1">
        <tr> 
          <td height="44" colspan="10" align="center"><font size="4" face="黑体">用 
            户 资 料 清 单</font></td>
        </tr>
        <tr valign="top"> 
          <td height="40" colspan="10">打印时间：<%=now()%></td>
        </tr>
        <tr> 
          <td width="40" height="18" align="center"><font face="黑体">ID</font></td>
          <td width="87"><font face="黑体">账号</font></td>
          <td width="133"><font face="黑体">公司名称</font></td>
          <td width="85"><font face="黑体">电话</font></td>
          <td width="99"><font face="黑体">传真</font></td>
          <td width="127"><font face="黑体">电子邮箱</font></td>
          <td width="58"><font face="黑体">OICQ</font></td>
          <td width="59"><font face="黑体">注册时间</font></td>
          <td width="53"><font face="黑体">使用期限</font></td>
          <td width="48" align="right"><font face="黑体">余额(￥)</font></td>
        </tr>
        <tr> 
          <td height="18" colspan="10" align="center">-----------------------------------------------------------------------------------------------------------------------------------</td>
        </tr>
        <%
		for i=1 to rs.recordcount
			if rs.eof then exit for
			strcolor="#FFFFFF"
			if i mod 2 >0 then strcolor="#F5F5F5"
		%>
        <tr bgcolor="<%=strcolor%>"> 
          <td height="22" align="center"><%=Trim(rs("id"))%></td>
          <td height="22"><%=Trim(rs("m_name"))%></td>
          <td height="22"><%=Trim(rs("w_ComName"))%></td>
          <td height="22"><%=Trim(rs("w_tel"))%></td>
          <td height="22"><%=Trim(rs("w_fax"))%></td>
          <td height="22"><%=Trim(rs("w_Mail"))%></td>
          <td height="22"><%=Trim(rs("m_OICQ"))%></td>
          <td height="22"><%=Year(rs("m_regdate")) & "/" & Month(rs("m_regdate")) & "/" & Day(rs("m_regdate"))%></td>
          <td height="22"><%=Year(rs("m_expire")) & "/" & Month(rs("m_expire")) & "/" & Day(rs("m_expire"))%></td>
          <td height="22" align="right"><%=Trim(rs("m_money"))%></td>
        </tr>
        <%
			rs.movenext
		next
		rs.close
		set rs=Nothing
		%>
        <tr> 
          <td height="18" colspan="10">&nbsp;</td>
        </tr>
        <tr> 
          <td height="18" colspan="10" align="center">-----------------------------------------------------------------------------------------------------------------------------------</td>
        </tr>
        <tr> 
          <td height="49" colspan="10" align="right">打印时间：<%=now()%></td>
        </tr>
      </table></td>
  </tr>
</table>
</body>
</html>
