procductfind.asp

诚信商店系统源代码

<%@LANGUAGE="VBScript"%>
<!--#include file="../public/wxl_conn.asp"-->
<!--#include file="../public/PublicFunction.asp"-->
<%
response.expires = 0
Const PageSize=18
Page=CInt(request("Page"))
if Page<=0 then Page=1
wxl=request("wxl")
int_mbrID=request("int_mbrID")

HtmlHead("会员查询")
%>
<table border="1" width="550" cellpadding="3" cellspacing="0" bgcolor="#D6D3CE" bordercolordark="#FFFFFF" bordercolorlight="#808080" align="center" >
<form name=form1 action="procductmng.asp" method="POST">
<tr>
	<td width=80>查询条件:</td>
	<td>
		<select name='QueryType'>
			<option value='A2'>品牌名</option>
			<option value='A3'>品牌类别</option>
			<option value='A4'>规格、型号</option>
			<option value='A5'>商品名称描述</option>
			<option value='A6'>商品特性</option>
			<option value='A7'>商品技术指标</option>
			<option value='A8'>功能说明</option>
			<option value='A9'>卖点推荐</option>
			<option value='A10'>产地</option>
			<option value='A11'>包装数</option>
			<option value='A12'>包装尺寸</option>
			<option value='A13'>包装重量</option>
			<option value='A19'>供货商</option>
			<option value='A20'>数量单位</option>
			<option value='A21'>产品安全、资质认证证书号</option>
			<option value='A25'>货源信息</option>
		</select>
	</td>
</tr>
<td width=80>关&nbsp;键&nbsp;字:</td>
<td><input type='text' name='QueryString' value='' size=40></td>
</tr>
<tr>                                                                                                      
    <td width="80">商品分类：</td>
    <td  align="left">
	<select name='str_pKindPID' id="str_pKindPID"><option value="">--不限分类--</option>
<%
set tmpSql=conn.execute("select * from web_ProKind order by str_pKindID")
while not tmpSql.eof
	response.write "<option value='"&tmpSql(0)&"'>"
	for i=1 to len(tmpSql(0))
		response.write "&nbsp;"
	next
	response.write tmpSql("str_pKindName")&"</option>"
	tmpSql.movenext
wend
%>	
	</select>
    </td>
</tr>
</table>
          <table border="0" width="100%" cellspacing="0" cellpadding="0" bgcolor="#D6D3CE">
            <tr>
              <td height="6"></td>
            </tr>
            <tr>
              <td height="2" align="center">
			  <input type="submit" value="  查 询" name="B1" class="submit" style="width:60; height:25;">&nbsp;&nbsp;  
                &nbsp; <input type="reset" value="  返 回" name="B2" class="submit" style="width:60; height:25;" onClick="history.back();"></td> 
            </tr>
            <tr>
              <td height="6"></td>
            </tr>
          </table>
	<input type='hidden' name='wxl' value=''>

	</form>
<%
HtmlEnd
%>