📄 glsales.asp
字号:
<% myself=request.servervariables("path_info")%>
<!--#include file="../inc/conn.asp" -->
<!--#include file="checkadmin_top.asp" -->
<% if request("submit")="删除选中的订单" then
for each k in request("sel")
CommandText="delete from sales where id="&k&""
Conn.Execute (CommandText)
next
end if
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../inc/test.css" type="text/css">
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form2" method="post" action="searchsales.asp">
<table width="100%" border="0" cellspacing="1" cellpadding="5">
<tr align="center">
<td colspan="5" bgcolor="#f1f1f1">订单查询</td>
</tr>
<tr>
<td width="15%" align="center">关键字：</td>
<td><input name="keyword" type="text" id="keyword2"></td>
<td width="15%" align="center">查询条件按：</td>
<td><select name="stype" id="stype">
<option value="1">-订单号码-</option>
<option value="2">-收货人名-</option>
<option value="3">-订购时间-</option>
<option value="4">-产品名称-</option>
<option value="0" selected>-请选择 -</option>
</select></td>
<td width="15%"><input name="Submit" type="submit" id="Submit" value="查询"></td>
</tr>
</table>
</form>
<table width="80%" border="0" align="center" cellpadding="5" cellspacing="1">
<tr>
<td><font color="#FF0000"> 注：如果查询条件为时间，清输入关键字的格式参照：2003/3/3，输入“trues”就可以查找所有已处理的订单，输入“falses”就可查找所有未处理的订单。</font></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td align="center" bgcolor="#f1f1f1">已有订单列表</td>
</tr>
<tr>
<td>
<%
set rs=Server.CreateObject("Adodb.RecordSet")
sql="select id,senddate,cl from sales order by id desc"
rs.open sql,conn,3,3
if rs.eof then
response.write""
else
rs.Pagesize=20
page=clng(request("page"))
if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs.Absolutepage=page
%>
<form name="form1" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="10%"> </td>
<td align="center" width="50%">订单号码</td>
<td align="center" width="20%">订购时间</td>
<td align="center">操作管理</td>
<td align="center" width="10%">订单状态</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="5" bgcolor="#000000">
<%do while not rs.eof
id=rs("id")
salesid=year(date())+month(date())+(day(date())+id)
%>
<tr bgcolor="#FFFFFF">
<td width="10%" bgcolor="#FFFFFF" align="center">
<input type="checkbox" name="sel" value="<%=id%>">
</td>
<td width="50%" align="center"><font color="#FF0000"> <%=salesid%></font></td>
<td width="20%" align="center"><%=rs("senddate")%></td>
<td align="center"><a href="#" onMouseDown="MM_openBrWindow('viewsales.asp?id=<%=id%>','','width=600,height=500')">查看详情</a></td>
<td align="center" width="10%"><%if rs("cl")=false then
response.write"未处理"
else
response.write"已处理"
end if%></td>
</tr>
<%i=i+1
if i>20 then exit do
rs.movenext
loop
%>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<input type="submit" name="Submit" value="删除选中的订单">
<%
if page<>1 then %>
<a href=<%=myself%>?page=1>第一页</a>
<a href=<%=myself%>?page=<%=(page-1)%>>上一页</a>
<%
end if
if page<>rs.pagecount then
%>
<a href=<%=myself%>?page=<%=(page+1)%>>下一页</a>
<a href=<%=myself%>?page=<%=rs.pagecount%>>最后一页</a>
<% end if %>
<font style="font-size:9pt"> </font><font style="font-size:9pt">页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font> 共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<%
end if%>
</body>
</html>
<!--#include file="checkadmin_bottom.asp" -->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -