<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>XXX</title><meta Name="keywords" content="XXX">
<meta Name="description" content="XXX">
<link href="../../images/ay_leven.css" rel="stylesheet" type="text/css" />
</head>
<!--#include file="conn.asp"-->
<body>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" class="content">
<tr>
<td background="../../images/hori_line1.gif" width="1"></td>
<td valign="top">
<table width="93%" border="0" align="center" bordercolorlight="white" class="content">
<tr>
<%
Dim perpage
perpage=6
dim page,moveto
page=request.querystring("page")
if page="" or not isnumeric(page) then
page=1
end if
moveto=perpage*(page-1)
set rs=server.CreateObject("ADODB.RecordSet")
sql="select * from products order by orders asc,createdate desc"
rs.open sql,conn,1,1
if not rs.eof then rs.move moveto
for j=1 to perpage
if rs.eof then exit for
%>
<td valign="top" align="center">
<table width="228" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="46%" align="center" valign="middle" class="b2"><a href="product.asp?ID=<%=rs("ProductId")%>"><img src="<%= rs("small_pic") %>" width="64" height="64" border="0" /></a></td>
<td width="54%" align="left" valign="middle"><p class="s1">工程编号：<%=rs("Productid")%></p>
<p class="s1">工程名称：<a href="product.asp?ID=<%=rs("ProductId")%>"><font color="#000000"><%=rs("ProductName")%></font></a></p></td>
</tr>
</table></td>
<%
rs.movenext
if j mod 2=0 then response.write "</tr><tr>"
next
%>
</tr>
<tr>
<td colspan="3" align="center">
<%
if page>1 then
response.write "<a href=" & request.servervariables("SCRIPT_NAME") & "?ID=" & qs & "&Style=" & name & "&page=" & page-1 & ">上一页" & "</a>"
else
response.write "上一页"
end if
%>
<%
if not rs.eof then
response.write "<a href=" & request.servervariables("SCRIPT_NAME") & "?ID=" & qs & "&Style=" & name & "&page=" & page+1 & ">下一页</a>"
else
response.write "下一页"
end if
%>
</td>
</tr>
<%rs.close%>
</table>
<table width="93%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><hr size="1" /></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
当前位置：