📄 myinfo.asp

📁 一套很早的多用户电子商务程序
💻 ASP
字号:
 <%@ language="vbscript"%>
<%response.Expires = 0%>
<!--#include file="conn.asp"-->
<%
If Session("LoginSuccess")="" Then
Response.Write ("<script>alert('对不起，你还没有登录,不能查看统计信息!');javascript:window.close()</script>")
response.end()
end if
UserId=Session("LoginSuccess")
set rs=server.createobject("adodb.recordset")
sql="select * from RegUser where UserId='" &UserId& "'"
rs.open sql,conn,1,1
RegTime=rs("RegTime")
lastTime=rs("lastTime")
look_count=rs("look_count")
rs.close

set rs=server.createobject("adodb.recordset")
sql="select User_Id from OrderList where User_Id='" &UserId& "'"
rs.open sql,conn,1,1
my_form =rs.recordcount
rs.close

set rs=server.createobject("adodb.recordset")
sql="select User_Id from OrderList where User_Id='" &UserId& "' and f_send='已发货'"
rs.open sql,conn,1,1
my_okform =rs.recordcount
rs.close

set rs=server.createobject("adodb.recordset")
sql="select sum(amount) from OrderList where User_Id='" &UserId& "'"
rs.open sql,conn,1,1
my_sum=rs(0)
rs.close

set rs=server.createobject("adodb.recordset")
sql="select sum(amount) from OrderList where User_Id='" &UserId& "' and f_send='已发货'"
rs.open sql,conn,1,1
my_oksum=rs(0)
if typename(my_oksum)="Null" then my_oksum=0
rs.close
%>
<html>
<head>
<title>会员管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>BODY {
	FONT-SIZE: 9pt
}
TD {
	FONT-SIZE: 9pt
}
a            { text-decoration: none; color: #000000 }
a:hover      { text-decoration: underline; color: #0000FF }
</STYLE>
<SCRIPT language=JavaScript>
</SCRIPT>
</head>

<body bgcolor="#FFFFFF" text="#000000" background="../pic/bg.jpg">
<div align="center"><font color="#FF0000"><b>我　的　统　计　信　息</b></font> <br>
  <TABLE class=main cellPadding=4 width=500 border="1" cellspacing="0" bordercolorlight="#0000FF" bordercolordark="#FFFFFF">
    <TBODY>
      <TR> 
        <TD width=139 align="right">会员申请日期：</TD>
        <TD width="412"> 　 <%=RegTime%></TD>
      </TR>
      <tr> 
        <TD width=139 align="right"><FONT color=#000000>最后一次访问：</FONT></TD>
        <TD width="412">　 <%=lastTime%></TD>
      </tr>
      <TR> 
        <TD width=139 align="right">登陆网站次数：</TD>
        <TD width="412"> 　 <%=look_count%> (次)</TD>
      </TR>
      <TR> 
        <TD width=139 align="right">发出的订单数：</TD>
        <TD width="412"> 　 <%=my_form%> (张)</TD>
      </TR>
      <TR> 
        <TD width=139 align="right">成功交易订单：</TD>
        <TD width="412">　 <%=my_okform%> (张)</TD>
      </TR>
      <TR> 
        <TD align="right">全部订单总额：</TD>
        <TD> 　 <%=my_sum%> (元)</TD>
      </TR>
      <TR> 
        <TD width=139 align="right">已付订单总额：</TD>
        <TD width="412"> 　 <%=my_oksum%> (元)</TD>
      </TR>
    </TBODY>
  </TABLE>
  <br>
  <a href="javascript:window.close()">关闭窗口</a> </div>
</body>
</html>
<%
conn.close
%>
⌨️ 快捷键说明

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