<%
set rs=server.createobject("ADODB.Recordset")
sql="select * from P_info where p_other = 0 "
classType = request("classType")
smallclass = request("smallclass")
key = request("key")
if classType <> "" then
	sql = sql & " and p_type = '"&classType&"'"
end if
if smallclass <> "" then
	sql = sql & " and p_small_type = '"&smallclass&"'"
end if
if key <> "" then
	sql = sql & " and p_name like '%"&key&"%'"
end if

sql = sql & " order by p_id desc"
rs.open sql,conn,1,1

if not isempty(request("page")) then   
pagecount=cint(request("page"))   
else   
pagecount=1
end if

%>
                                                  <%
rs.close
set rs=nothing
%>	<table width="98%"  border="0" cellpadding="0" cellspacing="0">
  <TBODY>
    <TR> 
      <TD height=5 colspan="2"></TD>
    </TR>
    <TR> 
      <TD  align="center" valign="top">
          <form action="OrderPost.asp" method="post" name="form0" target="_self">
            <input class=put  name="bookpost" type="hidden" value="bookpost">
            <tr> 
              <td  height="30" align="center" valign="middle">&nbsp;&nbsp;客户名称 ： <span class="style6"><font color="#FF0000">*</font></span></td>
              <td height="20" align="left"><input class=put  name="company" type="text" id="company2" size="50" maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="30" align="center" valign="middle">&nbsp;&nbsp;联系地址 ： <span class="style6"><font color="#FF0000">*</font></span></td>
              <td height="20" align="left"><input class=put  name="addr" type="text" id="addr2" size="50" maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="30" align="center">&nbsp;&nbsp;联系电话 ： <span class="style6"><font color="#FF0000">*</font></span></td>
              <td height="30" align="left"><input class=put  name="tel" type="text" id="tel2" size="50" maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="30" align="center">联系传真 ：</td>
              <td height="30" align="left"><input class=put  name="fax" type="text" id="fax2" size="50" maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="30" align="center">联 系 人 ： </td>       
              <td height="30" align="left"><input class=put  name="linkman" type="text" id="linkman2" size="50"  maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="30" align="center">&nbsp;&nbsp;产品名称 ： <span class="style6"><font color="#FF0000">*</font></span></td>
              <td height="30" align="left"><input class=put  name="proname" type="text" id="proname2" size="50" maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="30" align="center">&nbsp;&nbsp;产品编号 ： <span class="style6"><font color="#FF0000">*</font></span></td>
              <td height="30" align="left"><input class=put  name="proxh" type="text" id="proxh2" size="50" maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="30" align="center">&nbsp;&nbsp;订购数量 ： <span class="style6"><font color="#FF0000">*</font></span></td>
              <td height="-2" align="left"><input class=put  name="num" type="text" id="num2" size="50" maxlength="50" class="input"></td>
            </tr>
            <tr> 
              <td height="12" align="center" valign="top">备 　 注 ： </td>      
              <td height="0" align="left" ><textarea name="bz" cols="50" rows="8" id="textarea2" style="font-size：12px"   class="put"></textarea>

            </tr>
            <tr> 
              <td height="30" align="center">&nbsp;&nbsp;订购日期 ： </td>
              <td height="30" align="left"  ><input class=put  name="ordertime" type="text" id="ordertime2" value="<%=now()%>" size="50" maxlength="50" ></td>
            </tr>
            <tr align="center" valign="middle"> 
              <td height="60" colspan="2" align="center"><input class=put  type="submit" name="Submit2" value="确认" class="button"> 
                &nbsp;&nbsp;&nbsp;&nbsp; <input class=put  type="reset" name="Submit2" value="重写" class="button"></td>      
            </tr>
          </form>
        </table>