search_orderlist.asp

一套集网上购物和商品管理为一体的强大的网上商店(商城)系统

<!--#include file="conn.asp" -->
<link href="../style.css" rel="stylesheet" type="text/css"> 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td align="center">订单查询</td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td> <table width="98%" border="0" cellspacing="0" cellpadding="5" bgcolor="#006600" align="center">
        <form name="formorder" method="post" action="search_orderlist_result.asp?searchflag=order" onSubmit="return chechform()">
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">1.按订单号查：</td>
            <td width="83%" bgcolor="#FFFFFF"> 
              <input name="searchkey" type="text" size="20"> 
              <input type="submit" name="Submit" value="开始查询"> <script language=javascript1.2>
<!--
function chechform()
{
if(formorder.searchkey.value==""){formorder.searchkey.focus();
alert("请输入你要查找的订单号！");
return false;
}
}
//-->
</script> </td>
          </tr>
        </form>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="98%" border="0" cellspacing="0" cellpadding="5" bgcolor="#006600" align="center">
        <form name="form2" method="post" action="search_orderlist_result.asp?searchflag=uid" onSubmit="return chechform2()">
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">2.认货人ID查：</td>
            <td width="83%" bgcolor="#FFFFFF"> <input name="searchkey2" type="text" id="searchkey2" size="20"> 
              <input type="submit" name="Submit3" value="开始查询"> <script language=javascript1.2>
<!--
function chechform2()
{
if(form2.searchkey2.value==""){form2.searchkey2.focus();
alert("请输入你要查找的订货人ID！");
return false;
}
}
//-->
</script> </td>
          </tr>
        </form>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="98%" border="0" cellspacing="0" cellpadding="5" bgcolor="#006600" align="center">
        <form name="form3" method="post" action="search_orderlist_result.asp?searchflag=xm" onSubmit="return chechform1()">
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">3.收货人姓名：</td>
            <td width="83%" bgcolor="#FFFFFF"> <input name="searchkey3" type="text" id="searchkey3" size="20"> 
              <input type="submit" name="Submit32" value="开始查询"> <script language=javascript1.2>
<!--
function chechform1()
{
if(form3.searchkey3.value==""){form3.searchkey3.focus();
alert("请输入你要查找的收货人姓名！");
return false;
}
}
//-->
</script> </td>
          </tr>
        </form>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td><table width="98%" border="0" cellspacing="0" cellpadding="5" bgcolor="#006600" align="center">
        <form name="form4" method="post" action="search_orderlist_result.asp?searchflag=ddate" onSubmit="return chechform4()">
          <tr> 
            <td width="17%" align="right" valign="top" bgcolor="#FFFFFF">4.按日期查询：</td>
            <td width="83%" bgcolor="#FFFFFF"> <input name="searchkey4" type="text" value="2004-10-10 00:00:00" size="20">
              至 
              <input name="searchkey5" type="text" id="searchkey5" value="<%=now()%>" size="20"> 
              <br> <br> <input name="select11" type="radio" class="input_no" value="1" checked>
              按下单时间 
              <input name="select11" type="radio" class="input_no" value="2">
              按收款时间 
              <input name="select11" type="radio" class="input_no" value="3">
              按发货时间<br> <br> <input type="submit" name="Submit322" value="开始查询"> 
              <script language=javascript1.2>
<!--
function chechform4()
{
if(form4.searchkey4.value==""){form4.searchkey4.focus();
alert("请输入你要查找的日期！");
return false;
}
}
//-->
</script> </td>
          </tr>
        </form>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="98%" border="0" cellspacing="0" cellpadding="3" bgcolor="#006600" align="center">
        <form name="form5" method="post" action="search_orderlist_result.asp?searchflag=area">
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">5.订单组合查询:</td>
            <td width="83%" bgcolor="#FFFFFF">&nbsp;</td>
          </tr>
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">省/市:</td>
            <td width="83%" bgcolor="#FFFFFF"> <select name=searchcity id="searchcity">
                <%
sql_temp="select * from Net008_province"
set rs_temp=server.createobject("adodb.recordset")
rs_temp.open sql_temp,conn,1,2
for i=1 to rs_temp.recordcount
	response.write"<OPTION value="&rs_temp("cityid")&">"&rs_temp("cityname")&"</OPTION>"
rs_temp.movenext
next
rs_temp.close
set rs_temp=nothing
%>
              </select> </td>
          </tr>
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">收货地址:</td>
            <td width="83%" bgcolor="#FFFFFF"> <input name="searchaddr" type="text" id="searchaddr" size="20"> 
            </td>
          </tr>
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">电话/手机:</td>
            <td width="83%" bgcolor="#FFFFFF"><input name="searchtel" type="text" id="searchtel" size="20"> 
              <input type="submit" name="Submit2" value="开始查询"></td>
          </tr>
          <tr> 
            <td width="17%" bgcolor="#FFFFFF" align="right">&nbsp;</td>
            <td width="83%" bgcolor="#FFFFFF">&nbsp;</td>
          </tr>
        </form>
      </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<br>
<br>