📄 user_detail.asp
字号:
<!--#include file="conn.asp"--><!--#include file="Check.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<head>
<title>用户详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>BODY {
FONT-SIZE: 10pt
}
TD {
FONT-SIZE: 10pt
}
a { text-decoration: none; color: #6600CC }
a:hover { text-decoration: underline; color: #0000FF }
</STYLE>
<script language="javascript">
</script>
</head>
<%
id=request("id")
page=request("page")
set rs=server.createobject("adodb.recordset")
sqltext="select * from RegUser where Id=" & id
rs.open sqltext,conn,1,1
%>
<body bgcolor="#FFFFFF" text="#000000" background="../pic/bg.jpg">
会员基本资料：
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#666666" bordercolordark="#FFFFFF">
<tr>
<td width="24%" bgcolor="#EEEEEE"> <div align="right"><span
class=main1>会员帐号：</span></div></td>
<td width="30%"> <%=rs("UserId")%></td>
<td width="19%" bgcolor="#EEEEEE"> <div align="right"><span
class=main1>会员姓名：</span></div></td>
<td width="27%"> <%=rs("Name")%></td>
</tr>
<tr>
<td bgcolor="#EEEEEE"> <div align="right"><span
class=main1>密 码：</span></div></td>
<td> <%=rs("PassWD")%></td>
<td bgcolor="#EEEEEE"> <div align="right"><span
class=main1>性 别：</span></div></td>
<td> <%=rs("Sex")%></td>
</tr>
<tr>
<td bgcolor="#EEEEEE"> <div align="right"><span
class=main1>电子信箱：</span></div></td>
<td> <%=rs("Email")%></td>
<td bgcolor="#EEEEEE"> <div align="right"><span
class=main1>邮政编码：</span></div></td>
<td> <%=rs("Zip")%></td>
</tr>
<tr>
<td bgcolor="#EEEEEE"><div align="right"><span
class=main1>联系电话：</span></div></td>
<td> <%=rs("Phone")%></td>
<td bgcolor="#EEEEEE"><div align="right"><span
class=main1>注册时间：</span></div></td>
<td> <%=rs("RegTime")%></td>
</tr>
<tr>
<td bgcolor="#EEEEEE"><div align="right"><span
class=main1>发货地址：</span></div></td>
<td colspan="3"> <%=rs("Address")%></td>
</tr>
</table>
<%
UserId=rs("UserId")
rs.close:set rs=nothing
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
%>
<br>
会员统计信息：<br>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#8686FF" bordercolordark="#FFFFFF">
<tr>
<td width="24%" align="right" bgcolor="#DFF9FF">发出的订单数：</td>
<td width="30%"> <%=my_form%> (张)</td>
<td width="19%" align="right" bgcolor="#DFF9FF">成功交易订单：</td>
<td width="27%"> <%=my_okform%> (张)</td>
</tr>
<tr>
<td align="right" bgcolor="#DFF9FF">全部订单总额：</td>
<td> <%=my_sum%> (元)</td>
<td align="right" bgcolor="#DFF9FF">已付订单总额：</td>
<td> <%=my_oksum%> (元)</td>
</tr>
<tr>
<td align="right" bgcolor="#DFF9FF">登陆网站次数：</td>
<td> <%=look_count%> (次)</td>
<td align="right" bgcolor="#DFF9FF"><font color=#000000>最后一次访问：</font></td>
<td> <%=lastTime%></td>
</tr>
</table>
<div align="center"><br>
<input type="button" value=" 返回 " name="B4" onClick="javascript:window.history.go(-1)"></form> </p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -