📄 right.asp
字号:
<!--#include file="conn.asp" -->
<!--#include file="Cookies.asp"-->
<html>
<head>
<title>星星二手市场</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style1 {color: #FF0000}
.style2 {color: #0000FF}
-->
</style>
</head>
<body>
<%on error resume next %>
<h1><center class="style1">
<p class="style4">欢迎使用管理系统</p>
</center>
</h1>
<%
dim rs,usercout,vipcount
set rs=server.CreateObject("adodb.recordset")
usercount="select * From user"
vipcount="select * From user where usertype=1"
rs.open usercount,conn,1
cout=rs.RecordCount
rs.close
rs.open vipcount,conn,1
vipcout=rs.RecordCount
rs.close
%>
<a href="user_manage.asp" class="style2">注册用户管理</a>：
<table width="587" border="1" bordercolor="#0066CC">
<tr>
<th width="198" scope="col">
用户总数</th>
<th width="171" scope="col">
普通用户</th>
<th width="233" scope="col">
vip用户</th>
</tr>
<tr>
<th height="23">
<%response.Write cout %>
</th>
<th>
<%response.Write(cout-vipcout) %>
</th>
<th>
<% response.Write vipcout %>
</th>
</tr>
</table>
<p></p>
<% dim count,no,countNum,noNum
count="select * From user_order"
no="select * From user_order where isdiposal=0"
rs.open count,conn,1
countNum=rs.Recordcount
rs.close
rs.open no,conn,1
noNum=rs.Recordcount
rs.close
%>
<a href="user_order.asp" class="style2">货物定单管理</a>：
<table width="586" border="1" bordercolor="#0066CC">
<tr>
<th width="183" scope="col">
用户定单总数</th>
<th width="162" scope="col">
未处理定单数</th>
<th width="219" scope="col">
已处理定单数</th>
</tr>
<tr>
<th>
<%response.Write(countNum) %>
</th>
<th>
<font color="#FF0000"><%response.Write (noNum) %> </font> </th>
<th>
<% response.Write(countNum-noNum) %>
</th>
</tr>
</table>
<p></p>
<%
count="select * From info"
no="select * From info where isdiposal=0"
rs.open count,conn,1
countNum=rs.RecordCount
rs.close
rs.open no,conn,1
noNum=rs.RecordCount
rs.close
%>
<a href="info_manage.asp" class="style2">发布信息管理</a>：
<table width="586" border="1" bordercolor="#0099CC">
<tr>
<th width="183" scope="col">
发布信息总数</th>
<th width="162" scope="col">
未处理发布信息数</th>
<th width="219" scope="col">
已处理发布信息数</th>
</tr>
<tr>
<th scope="row">
<%response.Write(countNum) %>
</th>
<th>
<font color="#FF0000"><%response.Write(noNum) %></font>
</th>
<th>
<%response.Write(countNum-noNum) %>
</th>
</tr>
</table>
<p></p>
<%
dim saleNum,nosaleNum
nosaleNum=0
saleNum=0
count="select * from goods"
rs.open count,conn,1
do while not rs.eof
nosaleNum=nosaleNum+rs("inventory")
saleNum=saleNum+rs("sale_num")
rs.movenext
loop
%>
<span class="style4">
<a href="goods_manage.asp" class="style2">货物发布管理</a></span>:
<table width="586" border="1" bordercolor="#3366CC">
<tr>
<th width="183" scope="col">
发布物品总数</th>
<th width="162" scope="col">
未卖出物品数</th>
<th width="219" scope="col">
已卖出物品数</th>
</tr>
<tr>
<th>
<%response.Write(nosaleNum+saleNum) %>
</th>
<th>
<%response.Write(nosaleNum) %>
</th>
<th>
<%response.Write(saleNum) %>
</th>
</tr>
</table>
<p></p>
<%
count="select * From indict"
no="select * From indict where isdiposal=0"
rs.open count,conn,1
countNum=rs.Recordcount
rs.close
rs.open no,conn,1
noNum=rs.Recordcount
rs.close
%>
<span class="style4">
<a target="main" href="gbook.asp" class="style2">投诉反馈管理</a></span>：
<table width="586" border="1" bordercolor="#3366CC">
<tr>
<th width="183" scope="col">
用户投诉总数</th>
<th width="162" scope="col">
未处理用户投诉数</th>
<th width="219" scope="col">
已处理用户投诉数</th>
</tr>
<tr>
<th scope="row">
<%response.Write(countNum) %>
</th>
<th>
<font color="#FF0000"><%response.Write(noNum) %></font>
</th>
<th>
<%response.Write(countNum-noNum) %>
</th>
</tr>
</table>
<p></p>
<%
Num="select * from announce"
rs.open Num,conn,1
%>
<span class="style4">
<a href="announce_manage.asp" target="main" class="style2">网站公告管理</a></span>：
<table width="190" border="1" bordercolor="#0066CC">
<tr>
<th width="180" scope="col">
发布公告总数</th>
</tr>
<tr>
<th scope="row">
<%response.Write rs.Recordcount %>
</th>
</tr>
</table>
<%
rs.Close
set rs=nothing
closedb
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -