<!--#include file="conn.asp" -->
<!--#include file="inc/usdl.asp" -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=page_title%>用户管理中心.</title>
<link href="css.css" rel="stylesheet" type="text/css">
</head>

<body leftmargin="3" topmargin="0">

<!--#include file="head.asp" -->
<table width="763" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="763" height="19" valign="bottom"><font color="#990000">　→ </font>你当前位置：<a href="default.asp">首 
      页 </a>&gt;&gt;管理中心</td>
  </tr>
  <tr>
    <td height="1" background="images/2.jpg"></td>
  </tr>
</table>
<table width="763" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="175" valign="top"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td><div align="center"><img src="pic/manager.gif" width="174" height="70" border="1"></div></td>
        </tr>
        <tr> 
          <td height="17" bgcolor="#EEEEEE"> <div align="center">欢迎: <font color="#FF0000"><strong><%= session("us") %></strong></font> 光临</div></td> 
        </tr>
        <tr> 
          <% us=session("us")
			sql="select * from user where userid='"&us&"'"
			rs.open sql,conn,1,1
			
			 %>
          <td><p><font color="#FF0000">您的账面存款：</font></p>
            <p>&nbsp;</p>
            <p align="center"><font color="#FF0000">￥ <%= rs("je") %></font></p> 
            <p align="center">&nbsp;</p>
            <p>客户等级: <font color="#FF0000"><%= rs("dl") %> 
              <% rs.close  %>
              </font></p></td>
        </tr>
        <tr>
          <td height="1" background="images/2.jpg"> </td>
        </tr>
      </table> 
	  <div align="center"> 
       <!--#include file="user_inc.asp" -->
      </div></td>
    <td width="1" background="images/1.jpg"> </td>
    <td width="587" valign="top"> 
      <table width="573" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="573">
            <p align="center"><a href="user.asp"><img src="images/mameger.gif" width="437" height="43"></a></p>
          </td>
        </tr>
        <tr> 
          <td><div align="left"><br>
              会员<font color="#FF0000"><strong><%= session("us") %></strong></font>帐户情况：</div></td>
        </tr>
        <tr>
          <td><hr width="98%" size="1" noshade color=#E8F8FF>
		  <% 
		  sql="select * from user where userid='"&us&"'"
		  rs.open sql,conn,1,1
		  if rs.eof then
		   Response.Write("查询出错")
		   Response.end
		   end if
		  
		   %>
            <table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CAE4FF" bordercolorlight="" bordercolordark="ffffff">
              <tr> 
                <td width="20%" height="24">目前身份：</td>
                <td colspan="3"><font color="#FF0000"><%= rs("dl")%></font></td>
              </tr>
              <tr> 
                <td height="22">帐户余额：</td>
                <td colspan="3"><font color="#000033"><%= rs("je") %> &nbsp;元</font></td>
              </tr>
			  <% rs.close
			   sql="select * from shop where userid='"&us&"'" 
			   rs.open sql,conn,1,1
			   s=0
			   jea=0
			   jeb=0
			   while not rs.eof
			   s=s+1
			    if rs("sx") then
			    jea=jea+rs("je")
			   else
			   jeb=jeb+rs("je")
			   end if
			   rs.movenext
			   wend
			   rs.close
			   %>
              <tr> 
                <td height="20">订单笔数：</td>
                <td colspan="3"><%= s %>&nbsp;</td>
              </tr>
              <tr> 
                <td height="23">已消费总额:</td>
                <td width="30%"><%= jea %>&nbsp;</td>
                <td width="20%">末付款总金额:</td>
                <td width="30%"><%= jeb %>&nbsp;</td>
              </tr>
              <tr> 
                <td height="23">购物总金额:</td>
                <td colspan="3"><%= jea+jeb %>&nbsp;</td>
              </tr>
            </table>
            <p>&nbsp;</p>
            <p><font color="#E8F8FF">ff</font></p>
            <p>&nbsp;</p></td>
        </tr>
      </table>
      <p><font color="#F5F5F5">ff</font></p></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
    <td colspan="2">&nbsp;</td>
  </tr>
</table>
<%
call CloseDatabase '关闭数据库链接
%>
<!--#include file="top.asp" -->

</body>
</html>





























