lookxf.asp
来自「国内第一数字点卡销售程序。功能强大。 完整无错!数据文件经MD5加密!经严格测」· ASP 代码 · 共 62 行
ASP
62 行
<!--#include file="conn.asp"-->
<%
if session("admin_rank")<>1 and session("admin_rank")<>2 then
response.write("<script>alert('您无权查看本页,SORRY!');window.location=('login.asp')</script>")
response.end
end if
%>
<%
set rs=server.createobject("adodb.recordset")
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body style="background-color: #F0FBF1">
<div align="center">
<%user_name=srequest(request("user_name"),0)
sql="select * from sub where user_name='"&user_name&"' and sub_payok=true order by sub_id desc"
rs.open sql,conn,3,3
totalcash=0
if rs.eof then
%> 该会员暂且没有任何消费记录!
<%else%>
<br>
</div>
<table border="1" width="759" bordercolorlight="#C0C0C0" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF">
<tr>
<td align="center" height="26" width="111">用户名</td>
<td align="center" height="26" width="86">订单号</td>
<td align="center" height="26" width="78">产品名称</td>
<td align="center" height="26" width="74">收货人</td>
<td align="center" height="26" width="84">电 话</td>
<td align="center" height="26" width="98">邮 箱</td>
<td align="center" height="26" width="103">购买时间</td>
<td align="center" height="26" width="107">消费金额</td>
</tr>
<%totalcash=0
do while not rs.eof%>
<tr>
<td align="center" height="25" width="111"><%=rs("user_name")%></td>
<td align="center" height="25" width="86"><%=rs("sub_number")%> </td>
<td align="center" height="25" width="78"><%=rs("hw_name")%></td>
<td align="center" height="25" width="74"><%=rs("sub_to")%></td>
<td align="center" height="25" width="84"><%=rs("sub_tel")%></td>
<td align="center" height="25" width="98"><%=rs("sub_mail")%></td>
<td align="center" height="25" width="103"><%=rs("sub_date")%> </td>
<td align="center" height="25" width="107"><%=rs("sub_totalcash")%><%totalcash=totalcash+rs("sub_totalcash")%></td>
</tr>
<%rs.movenext
loop
%>
</table>
<br>
总计消费金额:<%=totalcash%><%end if%><%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?