您现在的位置:首页 > 产品展示  
<% ' *********************************参数设置***************************** set mypg=new jcpageclass mypg.pagesize=12 '每页显示的产品数量 width=200 '产品图片的宽度 height=140 '产品图片的高度 num=3 '每行显示的产品数 classid=request("cid") sql="select * from prod where 1=1" imgprodPath="../imgprod/" if classid<>"" then sql2="select * from prodclass where parentid="&classid set rs2=server.CreateObject("adodb.recordset") rs2.open sql2,conn,1,1 allid="" while not (rs2.eof or rs2.bof) allid=allid&rs2("classid")&"," rs2.movenext wend rs2.close set rs2=nothing if allid="" then sql=sql&" and classid="&classid else allid=left(allid,len(allid)-1) sql=sql&" and classid in("&allid&")" end If end if sql=sql&" order by articleid , orderId desc" mypg.getconn=conn mypg.getsql=sql set rs=mypg.getrs i=0 %>
<% while not (rs.eof or rs.bof) and i"" then smallpicurl=imgprodPath&rs("smallpicurl") end if prodid=rs("articleid") prodname=rs("prodname") if len(prodname)>18 then prodname=left(prodname,16)&"..." end if tedian=rs("tedian") if rs("specialid")<>"" and rs("specialid")>0 then specialname=myidv2("prodspecial","specialid",rs("specialid"),"specialname") end if xinghao=rs("xinghao") %> <% i=i+1 if i mod num=0 and i <> mypg.pagesize then response.Write("") rs.movenext wend %>
<% =prodname %>
 
<% call mypg.showpage %>