product_form2.asp

用ASP写的电子购物系统

<% REM ######################################################################### %>
<% REM                                                                           %>
<% REM   PRODUCT_FORM2.ASP                                                       %>
<% REM   商品组合查询表单                                                        %>
<% REM   EPRO E-Commerce Solution 1.0                                            %>
<% REM   Copyright (c) 1999-2000 EPRO(GUANGZHOU) Co,Ltd.  All rights reserved.   %>
<% REM                                                                           %>
<% REM ######################################################################### %>

<% REM   query form: %>
<form method="post" name=form1 >
  <input type="hidden" name="DoQuery" value="YES">	
  <table border="0" cellspacing="0">
    <tr>
      <td  class="mainleft">编号</td>
      <td  class="mainright"><input type="text" name="product_no" size="20"></td>
    </tr>
    <tr>
      <td class="mainleft">名称</td>
      <td class="mainright"><input type="text" name="name" size="20"></td>
    </tr>
    <tr>
      <td class="mainleft">分类</td>
      <TD  class="mainright" VALIGN=TOP colspan=2>
	      <SELECT NAME="level_id">
	         <option value="0">全部商品</option>
          <%              
             cmdTemp.CommandText = "select * from product_level WHERE parent_id='0'"
             Set rsDept = Server.CreateObject("ADODB.Recordset")
             rsDept.Open cmdTemp, , adOpenKeyset, adLockReadOnly
             If rsDept.RecordCount > 0 Then 
				While Not rsDept.EOF %>
					<% = mscsPage.Option(Cstr(rsDept("level_id").Value),0) %> <% = rsDept("name").Value %>
                    <% rsDept.MoveNext
                Wend
             End If
           %>
           </SELECT>
        </TD>                
    </tr>
    <tr>
      <td class="mainleft">价格</td>
      <td class="mainright"><input type="text" name="price1" size="8">至<input type="text"
      name="price2" size="8"></td>
    </tr>
    <tr>
      <td class="mainleft">品牌</td>
      <td class="mainright"><input type="text" name="brand" size="20"></td>
    </tr>
  </table>
  <table border="0" cellspacing="0" >
    <tr>
      <td><div align="center"><center><p><input type="submit" value="查询"
      name="Ok"></td>
 <td><div align="right"><p><input type="reset" value="重填" name="Cancle"></td>
    </tr>
  </table>
</form>