<% id=int(request.QueryString("id")) menu=int(request.QueryString("menu")) if(id-0=0)then if(menu-0=0)then sql="select * from articles order by id desc" else sql="select *,(select channel from [channel] where channel.id="&menu&")as menu_name from articles where style='"&menu&"' order by id desc" end if 'response.Write(sql) set rsp=server.CreateObject("adodb.recordset") rsp.CursorLocation=3 rsp.LockType=1 set rsp.ActiveConnection=conn rsp.open sql if(rsp.eof and rsp.bof)then else %>
您现在的位置是:首页 > 产品中心 > <%if(menu-0=0)then%> 展示首页 <%else%> <%=rsp("menu_name")%> <%end if%> <%if(menu-0=0)then%> 展示首页 <%else%> <%=rsp("menu_name")%> <%end if%>
<% call pageInit(rsp,12,currentPage,pageSize) do while not rsp.eof if (pageSize<=0)then exit do end if pageSize=PageSize-1 %> <% rsp.movenext loop %>
<%call pagination(rsp,currentPage)%>
<% end if rsp.close set rsp=nothing else sql="select * from articles where id="& id set rsp=conn.execute(sql) if(rsp.eof and rsp.bof)then else sql="select * from channel where id="& rsp("style") 'response.Write(sql) set rst=conn.execute(sql) %>
您现在的位置是:首页 > 产品中心 > <%=rst("channel")%> <%=rsp("title")%>
<% rst.close set rst=nothing id=request("id") set rsh=server.createobject("adodb.recordset") set rs=server.createobject("adodb.recordset") if id<>"" then rsh.open "select * from articles where id="&id,conn,1,3 sql="select articles.*,channel.channel from articles,channel where articles.id="&id&" and channel.id=val(articles.style)" else rsh.open "select top 1 * from articles order by tj desc,hits desc,updatetime desc",conn,1,3 sql="select top 1 * from articles order by tj desc,hits desc,updatetime desc" end if rsh("hits")=rsh("hits")+1 rsh.update rs.open sql,conn,1,1 if not rs.eof then content=rs("content") title=rs("title") pic=rs("pic") pic1=rs("pic1") pic2=rs("pic2") else response.write "" end if rs.close set rs=nothing %> <% set rs=server.createobject("adodb.recordset") sql="select top 1 * from pic where pid='"&id&"' order by click,id" rs.open sql,conn,1,1 if not rs.eof then%>

细节展示

<% do while not rs.eof %> " src="<%=rs("pic")%>" width="600" height="500" /> <% rs.movenext loop rs=nothing rs.close%>
    <% set rs=server.createobject("adodb.recordset") sql="select * from pic where pid='"&id&"' order by click,id" rs.open sql,conn,1,1 if not rs.eof then do while not rs.eof %>
  • '" src="<%=rs("pic")%>" width="120"/>
  • <% rs.movenext loop end if rs=nothing rs.close%>
<%end if%>

产品详情

<%=content%>
<% if pic1<>"" then %>

产品尺寸图

<% end if if pic2<>"" then %>

架构示意图

<% end if %>
<% end if rsp.close set rsp=nothing end if %>