<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%> <!--#include file="connect.asp"--> <!--#include file="news.asp"--> <% var DataSet,sql,DataList; var i=0; var j=0; DataList=new News(); DataSet=Server.CreateObject("Adodb.recordset"); sql="select * from News where ngroup='集團新聞' order by id desc"; DataSet.Open(sql,DataConn,1,1); //是否有數據 if ((DataSet.eof)&&(DataSet.bof)) { Response.Write("<BR>" ); Response.Write("=== 暫無 ==="); Response.Write("<BR><BR>"); Response.End(); } //記錄總數 NumRecords=DataSet.RecordCount; //設定每頁最大記錄數 PageSize=3; //總頁數 NumPages=Math.ceil(NumRecords/PageSize); //當前頁 i=Request.QueryString("CurrentPageID").Count; if (i==0) { CurrentPageID=1; } else { CurrentPageID=parseInt(Request.QueryString("CurrentPageID")); }
//初始化 PreviousPageID=CurrentPageID-1; NextPageID=CurrentPageID+1; HomePage=1; EndPage=NumPages; //內容列表 DataSet.MoveFirst; DataSet.Move((CurrentPageID-1)*PageSize,1); while (!DataSet.eof && j<PageSize) { Response.Write("<a href=show.asp?id="+DataSet("id")+" target=\"_blank\">"+DataSet("subject")+"</a><br>"); j=j+1; DataSet.MoveNext; } //設定URL if (CurrentPageID == HomePage) { Response.Write("<p class='Normal'><a href=list.asp?CurrentPageID="+HomePage+">首頁</a> "); Response.Write("上一頁 "); Response.Write("<a href=list.asp?CurrentPageID="+NextPageID+">下一頁</a> "); Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾頁</a> </p>"); } else if (CurrentPageID == EndPage) { Response.Write("<p class='Normal'><a href=list.asp?CurrentPageID="+HomePage+">首頁</a> "); Response.Write("<a href=list.asp?CurrentPageID="+PreviousPageID+">上一頁</a> "); Response.Write("下一頁 "); Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾頁</a> </p>"); } else { Response.Write("<p class='Normal'><a href=list.asp?CurrentPageID="+HomePage+">首頁</a> "); Response.Write("<a href=list.asp?CurrentPageID="+PreviousPageID+">上一頁</a> "); Response.Write("<a href=list.asp?CurrentPageID="+NextPageID+">下一頁</a> "); Response.Write("<a href=list.asp?CurrentPageID="+EndPage+">尾頁</a> </p>"); } %>
|