set rs = dataExecute("SELECT * FROM Leaf_10 WHERE node_id='"&node_id&"'and Is_display<>0 and node_id<>1 and node_id<>2 and node_id<>3 order by Leaf_id desc",dsn_app)
else
set rs = dataExecute("SELECT * FROM Leaf_10 WHERE Is_display<>0 and Is_display<>0 and node_id<>1 and node_id<>2 and node_id<>3 order by Leaf_id desc",dsn_app)
end if
%><%
'set rs = dataExecute("SELECT * FROM product_show_10 WHERE PD_sort_id='"&node_id&"' and PD_display=0 order by PD_sort_id desc",dsn_app)
'set rs = dataExecute("select top 4 picture_6.leaf_id as leaf_id, picture_6.picture_name as picture_name, picture_6.alt as alt,leaf_6.Brief,leaf_6.Title from leaf_6,picture_6 where picture_6.leaf_id=leaf_6.leaf_id and leaf_6.Node_id=26 order by leaf_6.leaf_id desc",dsn_app)
if not rs.eof then
If Request("PageNo")="" then
PageNo=1
Else
PageNo=clng(Request("PageNo"))
End If
rs.AbsolutePage = PageNo '记录集的当前页
y=0
For x = 1 to rs.PageSize
If rs.eof then
Exit For
Else
y=y+1
%>
<tr align="left" valign="top" >
<td height="56"> <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#D6D7C1" class="85795416">
<tr align="center" valign="middle" bgcolor="#f1f1f1">
<td width="123" height="27"><strong>产品名称</strong></td>
<td width="63"><strong>规格</strong></td>
<td width="65"><strong>单价</strong></td>
</tr>
<tr align="center" valign="middle" bgcolor="#f1f1f1">
<td height="20"><%if len(trim(rs("Title")))>=6 then
Response.Write(left(rs("Title"),6))
else
Response.Write(rs("Title"))
end if
%></td>
<td><%if len(trim(rs("Title")))>=6 then
Response.Write(left(rs("Title"),6))
else
Response.Write(rs("Title"))
end if
%></td>
<td><%
if session("username")<>"" then
if len(trim(rs("cpccj")))>=6 then
Response.Write(left(rs("cpccj"),6))
else
Response.Write(rs("cpccj"))
end if
else
if len(trim(rs("cpgg")))>=6 then
Response.Write(left(rs("cpgg"),6))
else
Response.Write(rs("cpgg"))
end if
end if
%></td>
</tr>
</table> </td>
</tr>
<%
rs.MoveNext
End If
Next
else
%>
<tr><td> <%Response.Write("暂无信息!")%></td></tr>
<%
end if
%>
</table>
<%
if TotalPages>1 then
%>
<table width="300" border="0" cellspacing="0" cellpadding="0" class="85795416">
<form name="form1" method="post" action="/chinese/cpzx/hyzx_n.asp">
<tr>
<td bgcolor="#999999"><img src="/images/spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" >共<%=TotalRecs%>个
<%if PageNo=1 then%>
[首 页] [上一页]
<% else %>
[<a href=hyzx_n.asp?PageNo=1&node_id=<%=node_id%> class="title0">首 页</a>] [<a href=hyzx_n.asp?PageNo=<%=(PageNo-1)%>&node_id=<%=node_id%> class="title0">上一页</a>]
<%end if
if TotalPages-PageNo<1 then%>
[下一页] [末 页]
<%else%>
[<a href=hyzx_n.asp?PageNo=<%=(PageNo+1)%>&node_id=<%=node_id%> class="title0">下一页</a>] [<a href=hyzx_n.asp?PageNo=<%=TotalPages%>&node_id=<%=node_id%> class="title0">末 页</a>]
<%end if%>
</td>
</tr>
</form>
</table>
<%
end if
rs.close
set rs=nothing
%>
</body>
</html>