📄 order2.asp

📁 网上购物系统 asp+sql server 2005
💻 ASP
字号:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="manage.css" type="text/css">
</head>
<BODY background="../images/admin/back.gif">
<form name=form1 action=order1.asp method=post>
<input type=hidden name=search value="yes">
<input type=hidden name=sql value="">
</form>
<%
session("sql")=""
'response.write request("userid")
'response.end
if request("action")="ok" then
  sql=""
  if request("Status")<>"" then sql=sql & " and a.Status='"&request("Status")&"'"
  if request("ordernum")<>"" then sql=sql & " and a.OrderNum='"&request("ordernum")&"'"
  if request("userid")<>"" then sql=sql & " and a.UserId='"&request("userid")&"'"
  if request("recname")<>"" then sql=sql & " and a.RecName like '%"&request("recname")&"%'"
  if request("RecMail")<>"" then sql=sql & " and a.RecMail='"&request("RecMail")&"'"
  if request("RecPhone")<>"" then sql=sql & " and a.RecPhone='"&request("RecPhone")&"'"
  if request("CompPhone")<>"" then sql=sql & " and a.CompPhone='"&request("CompPhone")&"'"
  if request("address")<>"" then sql=sql & " and a.RecAddress='"&request("address")&"'"
  if request("ZipCode")<>"" then sql=sql & " and a.ZipCode='"&request("ZipCode")&"'"

  if request("ordertime")<>"" then sql=sql & " and Datediff(d,a.OrderTime,getdate())<="&request("ordertime")

  session("sql")=sql
'response.write session("sql")
'response.end
  response.write "<script language='javascript'>"
  response.write "document.form1.submit();"
  response.write "</script>"
  response.end

end if
%>

<table width="98%" border="1"  style="border-collapse: collapse; border-style: dotted; border-width: 0px"  bordercolor="#333333" cellspacing="0" cellpadding="2">
<form name="search" action=order2.asp method=post>
<tr><td colspan=2 class=td height=18>搜索订单</td></tr>
<tr><td width=20% align=center>根据订单状态</td><td><select name='Status'>
	<option value=''>请选择订单状态</option>
<option value='0'>新订单</option><option value='11'>会员自行取消</option><option value='12'>无效单，已取消</option><option value='2'>已确认，待付款</option><option value='3'>已发货，待收货</option><option value='88'>在线支付成功</option><option value='99'>订单完成</option>
</select></td></tr>

<tr><td width=20% align=center> 根据订单号
</td><td><input type=text name=ordernum size=25 maxlength=12></td></tr>

<tr><td width=20% align=center> 根据提交订单的会员ID
</td><td><input type=text name=userid size=25 maxlength=16></td></tr>
<td width=20% align=center>根据收货人姓名
</td><td><input type=text name=recname size=25 maxlength=20></td></tr>
<td width=20% align=center>根据电子邮箱
</td><td><input type=text name=RecMail size=25 maxlength=100></td></tr>
<td width=20% align=center>根据联系电话
</td><td><input type=text name=RecPhone size=25 maxlength=20></td></tr>
<td width=20% align=center>根据移动电话
</td><td><input type=text name=CompPhone size=25 maxlength=20></td></tr>
<td width=20% align=center>根据联系地址
</td><td><input type=text name=address size=25 maxlength=100></td></tr>
<td width=20% align=center>根据邮政编码
</td><td><input type=text name=ZipCode size=25 maxlength=8></td></tr>
<td width=20% align=center>根据提交订单时间
</td><td><input type="radio" name="ordertime" value="1">今天 &nbsp; <input type="radio" name="ordertime" value="2">昨天 &nbsp; <input type="radio" name="ordertime" value="7">一周内 &nbsp; <input type="radio" name="ordertime" value="30">一月内 &nbsp; <input type="radio" name="ordertime" value="">全部 &nbsp; </td></tr>
<tr><td colspan=2><INPUT name="action" TYPE="hidden" value="ok"><INPUT name=actionok TYPE="submit" value="开始搜索"></td></tr>
</form>
</table>
<br><font color=red>※提示：</font><br>支持模糊搜索，可根据一个或多个条件进行搜索，非搜索条件可空出。

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -