ysmoney.asp
来自「国内第一数字点卡销售程序。功能强大。 完整无错!数据文件经MD5加密!经严格测」· ASP 代码 · 共 92 行
ASP
92 行
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
%>
<%
if session("admin_rank")<>1 and session("admin_rank")<>3 then
response.write("<script>alert('您无权查看本页,SORRY!');window.location=('login.asp')</script>")
response.end
end if
%><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">
<form method="POST" action="ysmoney.asp">
<div align="center">
<table border="0" width="97%" cellspacing="1" bordercolorlight="#2F94F9" bordercolordark="#FFFFFF">
<tr>
<td>输入订单号:
<input type="text" name="keywords" size="12" > <input type="submit" value="查看订单" name="B4" > </td>
</tr>
</table>
</div>
</form>
<%keywords=trim(request("keywords"))
set rsq=conn.execute("select sum(PaidAmount) from receive where MerchantOrderNumber like '%"&keywords&"%'")
totalcash=rsq(0)
if rsq(0)&"1"="1" then totalcash=0
%>
共收到金额<b><font color="#FF0000"> <%=totalcash%></font></b>元
<br><br><br>
<%
sql="select * from receive where MerchantOrderNumber like '%"&keywords&"%' order by sub_id DESC"
rs.open sql,conn,3,3
if rs.eof then
response.write "暂且没有相关订单!"
response.end
end if
rs.pagesize=15
page = cint(request("page"))
if page = "" then page = 1
if page < 1 then page=1
if page >= rs.pagecount then page = rs.pagecount
rs.absolutepage = page
%>
<div align="center">
<table border="1" width="97%" cellspacing="0" height="98" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0">
<tr>
<td width="8%" align="center" height="30">
订单号</td>
<td width="10%" align="center" height="30">
付款金额</td>
<td width="11%" align="center" height="30">
付款日期</td>
</tr>
<%
for i=1 to rs.pagesize
%>
<tr>
<td width="8%" align="center" height="25">
<%=rs("MerchantOrderNumber")%></td>
<td width="10%" align="center" height="25">
<%=rs("PaidAmount")%></td>
<td width="11%" align="center" height="25">
<%=rs("sub_date")%></td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
%>
<tr>
<td width="97%" style="padding-left: 10px" colspan="3">
<p align="center">共有记录<%=rs.recordcount%>条
<%=page%>/<%=rs.pagecount%> <A href="<%request.servervariables("document_name")%>?page=<%=page-1%>">上一页</A> <A href="<%request.servervariables("document_name")%>?page=<%=page+1%>">下一页</A> 转到第 <SELECT onchange="window.location='?page='+this.value" name=gopage>
<%for x=1 to rs.pagecount%>
<OPTION <%if x=page then%>selected<%end if%> value=<%=x%>><%=x%></OPTION>
<%next%>
</SELECT> 页
</div>
<%rs.close%>
</td>
</tr>
</table>
</div>
<%
set rs=nothing
conn.close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?