📄 stat.asp
字号:
<%@ LANGUAGE = VBScript %>
<!--#include file="conn.asp"-->
<!--#include file="checklogin.asp"-->
<%
AllPoints = 0
AllDownlinePoints = 0
TotalPoints = 0
AllSignupBonus = 0
AllPersonalDollars = 0
AllDollarsCredits = 0
AllDollarsDebits = 0
AllDollars = 0
AllDownLineDollars = 0
TotalDollars = 0
rs.open "select * from member",Conn
While not rs.eof
AllPoints = rs ("SignupPoints") + rs ("Points") + rs ("PointsCredits") - rs ("PointsDebits") + AllPoints
AllDownLinePoints = rs ("Points1") + rs ("Points2") + rs ("Points3") + rs ("Points4") + rs ("Points5") + rs ("Points6") + AllDownlinePoints
AllSignupBonus = rs ("SignupBonus") + AllSignupBonus
AllPersonalDollars = rs ("Dollars") + AllPersonalDollars
AllDollarsCredits = rs ("DollarsCredits") + AllDollarsCredits
AllDollarsDebits = rs ("DollarsDebits") + AllDollarsDebits
AllDollars = rs ("SignupBonus") + rs ("Dollars") + rs ("DollarsCredits") - rs ("DollarsDebits") + AllDollars
AllDownLineDollars = rs ("Dollars1") + rs ("Dollars2") + rs ("Dollars3") + rs ("Dollars4") + rs ("Dollars5") + rs ("Dollars6") + AllDownlineDollars
rs.movenext
wend
rs.close
TotalPoints = AllPoints + AllDownlinePoints
TotalDollars = AllDollars + AllDownlineDollars
Conn.close
Set Conn = nothing
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link REL="StyleSheet" HREF="../tjscripts.css" TYPE="text/css" MEDIA="screen">
<title><%= SiteTitle %>后台管理系统</title>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<table border="1" cellspacing="1" width="760" bordercolor="#0033CC">
<tr>
<td width="100%" height="31" bgcolor="#FFCC00"><b>统计兑换</b></td>
</tr>
<tr>
<td width="100%">
<form method="POST" action="stat2.asp">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="95%">
<tr>
<td width="50%" height="30">所有个人点数：</td>
<td width="50%" height="30"><input type="text" name="AllPoints" size="20" value="<%= AllPoints %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有下线提成点数：</td>
<td width="50%" height="30"><input type="text" name="AllDownlinePoints" size="20" value="<%= AllDownlinePoints %>"></td>
</tr>
<tr>
<td width="50%" height="30">合计总点数：</td>
<td width="50%" height="30"><input type="text" name="TotalPoints" size="20" value="<%= TotalPoints %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有注册奖励现金：</td>
<td width="50%" height="30"><input type="text" name="AllSignupBonus" size="20" value="<%= AllSignupBonus %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有个人所得现金：</td>
<td width="50%" height="30"><input type="text" name="AllPersonalDollars" size="20" value="<%= AllPersonalDollars %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有奖励增加现金：</td>
<td width="50%" height="30"><input type="text" name="AllDollarsCredits" size="20" value="<%= AllDollarsCredits %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有支付扣除现金：</td>
<td width="50%" height="30"><input type="text" name="AllDollarsDebits" size="20" value="<%= AllDollarsDebits %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有个人现金：</td>
<td width="50%" height="30"><input type="text" name="AllDollars" size="20" value="<%= AllDollars %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有下线提成现金：</td>
<td width="50%" height="30"><input type="text" name="AllDownLineDollars" size="20" value="<%= AllDownLineDollars %>"></td>
</tr>
<tr>
<td width="50%" height="30">合计未支付总现金：</td>
<td width="50%" height="30"><input type="text" name="TotalDollars" size="20" value="<%= TotalDollars %>"></td>
</tr>
<tr>
<td width="50%" height="30">所有用于点数兑换的收入：（单位：元）</td>
<td width="50%" height="30"><input type="text" name="Income" size="20"></td>
</tr>
<tr>
<td width="100%" height="30" colspan="2" align="center"></td>
</tr>
<tr>
<td width="100%" height="30" colspan="2" align="center">
<input type="submit" value="计算" name="Button"></td>
</tr>
</table>
</div>
</form>
</td>
</tr>
<tr>
<td width="100%" align="center"><a href="javascript:history.back();"><b>返回</b></a></td>
</tr>
</table>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -