📄 orders_list.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
response.redirect "error.asp?error=001"
end if
%>
<%
'开始删除操作
if request("action")="del" then
page=request("page")
conn.execute "delete * from 56770_orders where id=" & request("id")
url="orders_list.asp?page=" & page
response.redirect url
end if
%>
<html>
<head>
<title>后台管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#FFFFFF" vspace="0" hspace="0">
<tr bgcolor="#FFCC33">
<td height="27" background="images/admin_bg_1.gif" bgcolor="#FFFFFF">.:: 您可以在这里进行用户订单相关操作</td>
</tr>
</table>
<table border="0" cellspacing="1" cellpadding="2" bgcolor="#FFFFFF" width="100%" align="center">
<tr align="center">
<tr align="center">
<td width="7%" bgcolor="#6699CC" height="25">ID</td>
<td width="26%" bgcolor="#6699CC">订单号</td>
<td width="10%" bgcolor="#6699CC">支付金额</td>
<td width="10%" bgcolor="#6699CC">支付方式</td>
<td width="22%" bgcolor="#6699CC">订购日期</td>
<td colspan="3" bgcolor="#6699CC">操作</td>
</tr>
<%
user_id=request("user_id")
order_number=request("order_number")
sql="select * from 56770_orders where user_id<>'' "
if user_id<>"" then sql=sql + " and user_id='"&user_id&"'"
if order_number<>"" then sql=sql + " and order_number like '%"&order_number&"%'"
sql=sql + " order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql, conn, 3, 3
if rs.eof then
%>
<tr align="center" bgcolor="#B0CBE6">
<td colspan="8" height="50">该用户至今没有任何定单信息！</td>
</tr>
<%else%>
<%
if not isempty(request("page"))then
pagecount=cint(request("page"))
else
pagecount=1
end if
rs.pagesize=10
rs.AbsolutePage=pagecount
%>
<% do while not rs.eof %>
<tr align="center">
<td bgcolor="#B0CBE6" width="7%" height="25"><%=rs("id")%></td>
<td width="26%" bgcolor="#B0CBE6"><%=rs("order_number")%></td>
<td width="10%" bgcolor="#B0CBE6"><%=rs("summoney")%></td>
<td width="10%" bgcolor="#B0CBE6"><%=rs("paymenttype")%></td>
<td width="22%" bgcolor="#B0CBE6"><%=rs("order_time")%></td>
<td width="9%" bgcolor="#B0CBE6">[<a href="orders_viwes.asp?id=<%=rs("id")%>">详情</a>]</td>
<td width="8%" bgcolor="#B0CBE6">[<a href="orders_list.asp?action=del&id=<%=rs("id")%>&user_name=<%=user_name%>&page=<%=cstr(pagecount)%>">删除</a>]</td>
<td width="8%" bgcolor="#B0CBE6">[<a href="orders.asp?id=<%=rs("id")%>">状态</a>]</td>
</tr>
<tr>
<td height="25" colspan="8" bgcolor="#D1E1F1">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="14%">订单状态：</td>
<td width="29%">
<%
if rs("order_zt")=true then
order_zt="<font color=#FF0000>已经发货</font>"
else
order_zt="尚未发货"
end if
if rs("order_zf")=true then
order_zf="<font color=#FF0000>已经支付</font>"
else
order_zf="尚未支付"
end if
response.write order_zf & "," & order_zt
%>
</td>
<td width="23%">订单检测：</td>
<td width="34%">
<%if rs("order_cw")=true then
order_cw="<font color=#FF0000>无效订单</font>"
else
order_cw="有效订单"
end if
response.write order_cw%>
</td>
</tr>
</table>
</td>
</tr>
<%
rs.movenext
i=i+1
if i >= rs.pagesize then exit do
loop
%>
<tr>
<form action="orders_list.asp" method="post">
<td height="35" colspan="9" bgcolor="#D6DFF7">
<div align="center"> 共 <b><%=rs.recordcount%></b> 张订单, 页次: <b><font color=red><%=pagecount%></font>/<%=rs.pagecount%></b>,
当前从第
<%
if pagecount <= 1 then
response.write "<font color=red>1</font>"
else
response.write "<font color=red>" & pagecount*rs.pagesize-rs.pagesize+1 & "</font>"
end if
%>
张开始。
<% if pagecount=1 and rs.pagecount<>pagecount and rs.pagecount<>0 then%>
<a href="orders_list.asp?user_name=<%=user_name%>&page=<%=cstr(pagecount+1)%>">
下一页</a>
<% end if %>
<% if rs.pagecount>1 and rs.pagecount=pagecount then %>
<a href="orders_list.asp?user_name=<%=user_name%>&page=<%=cstr(pagecount-1)%>">
上一页</a>
<%end if%>
<% if pagecount<>1 and rs.pagecount<>pagecount then%>
<a href="orders_list.asp?user_name=<%=user_name%>&page=<%=cstr(pagecount-1)%>">
上一页</a><ahref="orders_list.asp?user_name=<%=user_name%>&page=<%=cstr(pagecount+1)%>">
下一页</a>
<% end if%>
直接到第
<select name="page">
<%for i=1 to rs.pagecount%>
<option value="<%=i%>"><%=i%></option>
<%next%>
</select>
页
<input type="submit" name="go" value="Go">
<input type="hidden" name="user_name" value=<%=user_name%>>
</div>
</td>
</form>
</tr>
</table>
<%
end if
rs.close
set rs=nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -