salerecorder.asp
来自「国内第一数字点卡销售程序。功能强大。 完整无错!数据文件经MD5加密!经严格测」· ASP 代码 · 共 44 行
ASP
44 行
<!--#include file="conn.asp"-->
<%
if session("admin_rank")<>1 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">
<%
set rs1=conn.execute("select sum(sub_totalcash) from sub where sub_payok=true")
set rs2=conn.execute("select sum(sub_totalcash) from sub where sub_payok=true and sub_cz='1'")
set rs3=conn.execute("select sum(hw_count) from sub where sub_payok=true and sub_cz='1'")
set rs4=conn.execute("select sum(sub_totalcash) from sub where sub_payok=true and sub_cz='0'")
set rs5=conn.execute("select sum(hw_count) from sub where sub_payok=true and sub_cz='0'")
sql="select sub_id from sub where sub_payok=true order by sub_id DESC"
rs.open sql,conn,3,3
%><b>总销售额:</b><%=rs1(0)%>
<br>
<br>
<b>在线充值总金额:</b><%=rs2(0)%>
<br>
<br><b>在线充值销售数量:</b><%=rs3(0)%>
<br>
<br>
<b>游戏卡销售额:</b><%=rs4(0)%>
<br>
<br>
<b>游戏卡销售数量:<%=rs5(0)%>
</b>
<br> <br><b>订单数量:<%=rs.recordcount%>
</b>
<br>
<br>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?