%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<% ClassID=request("ClassID")
search=request("search")
sename=CHECKSTR(request("searchname"))
protype01=request("protype")
if search="ok" then
search=CHECKSTR(search)
if protype01="0" or protype01="" then
sqll="select * from Product where ProductName like '%"&sename&"%' and class<>'004' order by Stock desc"
else
sqll="select * from Product where ProductName like '%"&sename&"%' and class<>'004' and left(Class,3)='"& protype01 &"' order by Stock desc"
end if
protitle="> 產(chǎn)品搜索"
else
if ClassID="" or isnull(ClassID) or not isnumeric(ClassID) then
if request("type")=1 then
sqll="select * from Product where NewProduct=1 and class<>'004' order by Stock desc"
else
sqll="select * from Product where class<>'004' order by Stock desc"
end if
protitle=""
else
if len(ClassID)=3 then
sqll="select * from Product where left(Class,3)='"&ClassID&"' and class<>'004' order by Stock desc"
set rs=server.CreateObject("adodb.recordset")
sql="select * from Class where NumberID='"&ClassID&"'"
rs.open sql,conn,1,1
protitle="> "&rs("class")
rs.close
set rs=nothing
else
sqll="select * from Product where Class='"&ClassID&"' and class<>'004' order by Stock desc"
set rs=server.CreateObject("adodb.recordset")
sql="select * from Class where NumberID='"&left(ClassID,3)&"'"
rs.open sql,conn,1,1
protitle="> "&rs("class")
rs.close
set rs=nothing
set rs=server.CreateObject("adodb.recordset")
sql="select * from Class where NumberID='"&ClassID&"'"
rs.open sql,conn,1,1
protitle=protitle&" > "&rs("class")
rs.close
set rs=nothing
end if
end if
end if %>
<%
set re=server.CreateObject("adodb.recordset")
re.open sqll,conn,1,1
if re.eof then
response.write "
產(chǎn)品正在添加中.....
"
else
%>
<%
re.pagesize=12
iCount=re.RecordCount '記錄總數(shù)
iPageSize=re.PageSize
maxpage=re.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
re.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if %>
<%i=0
do while not i/12=1
if re.eof then
exit do
end if
%>