📄 search_uorder.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!-- #include file="../common/conn.asp" -->
<!-- #include file="../common/status.html" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询客户订单信息</title>
<% if session("admin_id")="" then %>
您还没有登录或者您的权限不够，五秒钟后自动返回登录，如果您的浏览器没有自动返回，请<a href="../admin/login.html">点击登录</a>。
<meta http-equiv="refresh" content="5;url=login.html">
<% else %>
</head>
<body background="../img/searchBG.gif">
<div align="center">
<center>
<%
dim rs,sql
set rs=server.createobject("adodb.recordset")
%>
<form action="search_uorder_result.asp" method="post" name="myform" id="myform">
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" colspan="4">请选择查询客户订单信息的方式：</td>
</tr>
<tr>
<td height="25" width="20%"> </td>
<td width="25%"><input name="type" type="radio" value="userid" checked>
按照客户ID查询</td>
<td width="30%" align="center"><select name="userid" id="userid">
<%
sql="select distinct uof_userid from scott.user_orderform"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("uof_userid")%>"><%=rs("uof_userid")%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
<td width="25%"> </td>
</tr>
<tr>
<td height="25"> </td>
<td><input name="type" type="radio" value="pid">
按照产品型号查询</td>
<td align="center"><input name="pid" type="text" id="pid"></td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td><input name="type" type="radio" value="method">
按照付款方式查询</td>
<td align="center"><select name="method" id="method">
<%
sql="select distinct cof_method from scott.company_orderform"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("cof_method")%>"><%=rs("cof_method")%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td><input name="type" type="radio" value="method2">
按照送货方式查询 </td>
<td align="center"><select name="method2" id="method2">
<%
sql="select distinct cof_method2 from scott.company_orderform"
rs.open sql,connstr,1,1
do while not rs.eof
%>
<option value="<%=rs("cof_method2")%>"><%=rs("cof_method2")%></option>
<%
rs.movenext
loop
rs.close
%>
</select></td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td><input name="type" type="radio" value="detail"> 按照细节查询</td>
<td align="left"> <div align="center">
<select name="city" id="city">
<option value="1">按照总价查询</option>
<option value="2">按照生成时间查询</option>
<option value="3">按照是否发货查询</option>
</select>
</div></td>
<td align="left"><input name="detail1" type="text" id="detail1"></td>
</tr>
<tr>
<td height="25"> </td>
<td> </td>
<td align="center"> </td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td> </td>
<td align="center"> </td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td colspan="2" align="center"><input type="submit" name="Submit" value="搜索"></td>
<td align="right"> </td>
</tr>
<tr>
<td height="25"> </td>
<td colspan="2" align="center"> </td>
<td align="right"><a href="javascript:history.go(-1)">返回上一页</a></td>
</tr>
</table>
</form>
</center>
</div>
<% set rs=nothing %>
</body>
<% end if %>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -