<% Page=cint(request("page")) pagecount=page pageurl="case.asp" if request.querystring("page")="" then ipagecurrent=1 else ipagecurrent=cint(request.querystring("page")) end if sqlprod="select * from casemain where gb='ch' and online=true " if request("k_keywords")<>"" then sqlprod= sqlprod + " and prodid like'%"&trim(request("k_keywords"))&"%' " end if if request("Parentid")<>"" then sqlprod=sqlprod + " and gbseq='"&request("Parentid")&"'" end if if request("gbcode")<>"" then sqlprod = sqlprod + " and gbcode = '"&request("gbcode")&"'" end if if request("remark")="1" then sqlprod = sqlprod + " and remark = '1'" end if sqlprod = sqlprod + "order by xuhao asc " Set rsprod=Server.CreateObject("ADODB.RecordSet") MaxPage=12 rsprod.pagesize = MaxPage rsprod.cachesize = MaxPage rsprod.open sqlprod,conn,1,1 if rsprod.recordcount=1 then zid=rsprod("id") num=rsprod("prodnum") response.Redirect ("case.asp?ProdNum="&num&"&zid="&zid&"") end if if rsprod.bof and rsprod.eof then response.write "
no add!
" else '以下是调用公用的产品显示页面, %>
<% if rsprod.pagecount>1 then %> <% end if %> <% end if rsprod.close set rsprod=nothing end if %>