<!-- #include virtual = "/include/myopen.asp" -->
<%
	set RS = Server.CreateObject("ADODB.RecordSet")
	set RS1 = Server.CreateObject("ADODB.RecordSet")
%>
<%'类别填加
	'判断用户是否登陆过
	IF Request.Cookies ("Admin_name") = "" OR Request.Cookies ("Admin_Pass") ="" THEN
	'没有登陆
	Response.Redirect ("/manage/Admin_Login.ASP")
	END IF
	IF REQUEST("HOME") <> "" THEN
	Response.Redirect ("/manage/default.asp")
	END IF
	IF REQUEST("Add") <> "" THEN
	Response.Redirect ("/manage/name_add.asp")
	END IF
	'用户已经成功注册

  %>
<html>
<head>
<title>商品查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
td {  font-size: 9pt; line-height: 16pt}
-->
</style>
</head>

<body bgcolor="#FFFFFF">
<table width="200" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td> 
      <div align="center"><b><font color="#3333CC" size="3">商 品 查 询</font></b></div>
    </td>
  </tr>
</table>
<form method="post" action="name_search.asp">
  <table width="600" border="1" cellspacing="0" cellpadding="1" bordercolor="#CCFFFF" bordercolorlight="#66CCFF" bordercolordark="#FFFFFF" align="center">
    <tr bgcolor="#D5F1FB"> 
      <td width="113"> 
        <div align="center">商品编号：</div>
      </td>
      <td width="300"> 
        <input type="text" name="No1" size="12">
      </td>
    </tr>
    <tr bgcolor="#D5F1FB"> 
      <td width="113"> 
        <div align="center">商品名称：</div>
      </td>
      <td width="300"> 
        <input type="text" name="Lb" size="20">
      </td>
    </tr>
    <tr bgcolor="#D5F1FB"> 
      <td width="113"> 
        <div align="center">所属总类别：</div>
      </td>
      <td width="300"> 
        <select name="class1">
          <option value="">请选择该商品所属类别</option>
          <%
			SQL1 = "SELECT DISTINCT CLASS_NAME FROM CLASS"
			RS1.Open SQL1,CONN,adOpenKeyset ,adLockReadOnly
				IF RS1.RecordCount >0 THEN
					DO WHILE NOT RS1.EOF 
						
			%> 
          <option value="<%=RS1("CLASS_NAME")%>"><%=RS1("CLASS_NAME")%></option>
          <%
					RS1.MoveNext 
					LOOP
				END IF
			RS1.Close 
				%> 
        </select>
      </td>
    </tr>
    <tr bgcolor="#D5F1FB"> 
      <td width="113"> 
        <div align="center">所属次类别：</div>
      </td>
      <td width="300"> 
        <select name="class2">
          <option value="">请选择该商品所属类别</option>
          <%
			SQL1 = "SELECT DISTINCT CLASS_NAME FROM CLASS"
			RS1.Open SQL1,CONN,adOpenKeyset ,adLockReadOnly
				IF RS1.RecordCount >0 THEN
					DO WHILE NOT RS1.EOF 
						
			%> 
          <option value="<%=RS1("CLASS_NAME")%>"><%=RS1("CLASS_NAME")%></option>
          <%
					RS1.MoveNext 
					LOOP
				END IF
			RS1.Close 
				%> 
        </select>
      </td>
    </tr>
    <tr bgcolor="#D5F1FB"> 
      <td width="113"> 
        <div align="center">商品价格：</div>
      </td>
      <td width="300"> 介于 
        <input type="text" name="jg1" size="10">
        元 到 
        <input type="text" name="jg2" size="10">
        元之间 </td>
    </tr>
  </table>
  <div align="center"> 
    <input type="submit" name="search" value="查 询">
    <input type="submit" name="home" value="主 页">
    <input type="submit" name="add" value="增 加">
    <input type="reset" name="reset" value="重 填">
    <input type="button" name="Button" value="返 回" onClick="history.back()">
  </div>
</form>
</body>
</html>

