honor.asp

此系统都是基于ASP+ACCESS技术开发的电子商务平台,属于全自动化、全智能的在线方式管理、维护、更新的网站管理系统。此系统直接上传到你的网站空间就可以使用了

<!--#include file="Inc/syscode.asp"-->
<%
'=================================
'
'  冠龙网络科技有限公司
'  网址：http://www.glgk.com
'  电话 :[phone]
'  信箱：[e-mail]
'  QQ：53180986
'
'=================================
%>
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from honor order by id desc"
rs.open sqltext,conn,1,1

dim MaPerPage
MaPerPage=9

dim text,checkpage
text="0123456789"
Rs.PageSize=MaPerPage
for i=1 to len(request("page"))
checkpage=instr(1,text,mid(request("page"),i,1))
if checkpage=0 then
exit for
end if
next

If checkpage<>0 then
If NOT IsEmpty(request("page")) Then
CurrentPage=Cint(request("page"))
If CurrentPage < 1 Then CurrentPage = 1
If CurrentPage > Rs.PageCount Then CurrentPage = Rs.PageCount
Else
CurrentPage= 1
End If
If not Rs.eof Then Rs.AbsolutePage = CurrentPage end if
Else
CurrentPage=1
End if

call showpages
call list

If Rs.recordcount > MaPerPage then
call showpages
end if

'显示帖子的子程序
Sub list()%>
<!-- #include file="Inc/Head.asp" -->
<TABLE width="760" border=0 align="center" cellPadding=0 cellSpacing=0 bgcolor="#FFFFFF">
<TR> 
<TD width=196 vAlign=top bgcolor="#FFFFFF"> 
	<table width="92%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
		<tr>
			<td valign="top">

<!-- 会员登陆 -->
<!-- #include file="L_login.asp" -->
<!-- 公司荣誉 -->
<!-- #include file="L_honor.asp" -->
<!-- 邮件列表 -->
<!-- #include file="L_mail.asp" -->

			</td>
		</tr>
	</table> 
</TD>

<TD width=1 background=Img/kropki_pion_naBialym.gif><IMG height=2 src="img/1x1_pix.gif" width=1></TD>
<TD vAlign=top>
	<TABLE width="90%" border=0 align="right" cellPadding=0 cellSpacing=0>
<!-- 广告栏 -->
<!-- #include file="L_adcolumn.asp" -->

		<TR> 
			<TD colspan="3">
				<TABLE cellSpacing=0 cellPadding=0 width="555" border=0>
					<tr>
                      <td height="25" background="img/cnpt/bg.gif">&nbsp;&nbsp;<span style="font-weight: bold">&nbsp;公 司 荣 誉</span></td>
				  </tr>
				</TABLE>
			</TD>
		</TR>
		<TR> 
			<TD height=1 colspan="3" background=img/naBialym.gif><IMG height=1 src="img/1x1_pix.gif" width=10></TD>
		</TR>
		<TR> 
			<TD height="15" > </TD>
		</TR>
<%i=1 %>
		<TR> 
			<TD>
				<table width="100%" border="0" cellspacing="1" cellpadding="0">
<%i=1 %>
					<TR> 
<% Do While Not rs.EOF%>
						<TD>
							<table width="100%" border="0" cellspacing="0" cellpadding="0">
								<tr> 
									<td><div align="center"><img src="<%=rs("img")%>" width="250" height="200" alt=""></div></td>
								</tr>
								<tr> 
									<td height="10"></td>
								</tr>
								<tr> 
									<td><div align="center"><%=rs("title")%></div></td>
								</tr>
								<tr> 
									<td height="10"> </td>
								</tr>
							</table>
						</td>
<%if i mod 2 <>0 then%>
<%end if%>
<% if i mod 2 =0 then%>
					</TR>
					<tr> 
<%end if%>
<%  
'rs.MoveNext      
'i=i+1      
'Loop
'end sub   			      
%>
<%
i=i+1 
if i >= 10 then exit do 
rs.MoveNext 
loop
end sub
%>
					</tr>
				</table>
			</TD>
		</tr>
		<TR> 
			<TD height=1 colspan="3" background=img/naBialym.gif><IMG height=1 src="img/1x1_pix.gif" width=10></TD>
		</TR>
		<TR> 
			<TD height=25 colspan="3" bgcolor="#D8D8D8"> 
<%
Response.write "<strong><font color='#000000'>-> 全部-</font>"
Response.write "共</font>" & "<font color=#FF0000>" & Cstr(Rs.RecordCount) & "</font>" & "<font color='#000000'>条信息</font></strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
Response.write "<strong><font color='#000000'>第</font>" & "<font color=#FF0000>" & Cstr(CurrentPage) &  "</font>" & "<font color='#000000'>/" & Cstr(rs.pagecount) & "</font></strong>&nbsp;"
If currentpage > 1 Then
response.write "<strong><a href='Honor.asp?&page="+cstr(1)+"'><font color='#000000'>首页</font></a><font color='#ffffff'> </font></strong>"
Response.write "<strong><a href='Honor.asp?page="+Cstr(currentpage-1)+"'><font color='#000000'>上一页</font></a><font color='#ffffff'> </font></strong>"
Else
Response.write "<strong><font color='#000000'>上一页 </font></strong>"
End if
If currentpage < Rs.PageCount Then
Response.write "<strong><a href='Honor.asp?page="+Cstr(currentPage+1)+"'><font color='#000000'>下一页</font></a><font color='#ffffff'> </font>"
Response.write "<a href='Honor.asp?page="+Cstr(Rs.PageCount)+"'><font color='#000000'>尾页</font></a></strong>&nbsp;&nbsp;"
Else
Response.write ""
Response.write "<strong><font color='#000000'>下一页</font></strong>&nbsp;&nbsp;"
End if
%> 
			</TD>
		</TR>
	</TABLE>
</TD>

</TR>
</TABLE>
<!-- #include file="Inc/Foot.asp" -->
</BODY></HTML>