学步园

//总记录数<br /> function sumRecord()<br /> {<br /> var conn= Server.CreateObject("ADODB.connection");<br /> var rs= Server.CreateObject("adodb.recordset");<br /> conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");<br /> var sql = "select count(*) as RecordCount from baoming";<br /> rs.open(sql,conn);<br /> TotalRecords = rs('RecordCount');<br /> }</p> <p>function baoming()<br /> {<br /> //计算总的页数<br /> TotalPages = (((TotalRecords % PageSize) == 0) ? (TotalRecords / PageSize)<br /> : (TotalRecords / PageSize + 1));<br /> //获取传参过来的页数<br /> var toppage;<br /> var home = Request.Form("home");<br /> var up = Request.Form("up");<br /> var uppage = parseInt(Request.Form("uppage"));<br /> var down = Request.Form("down");<br /> var downpage = parseInt(Request.Form("downpage"));</p> <p> if(home=="首页")<br /> {<br /> CurPageNum = 1;<br /> }else if(up=="上一页")<br /> {<br /> toppage = uppage;<br /> //Response.Write("<mce:script type="text/javascript"><!--<br /> alert('"+toppage+"');<br /> // --></mce:script>");<br /> CurPageNum = toppage-1;<br /> //Response.Write("<mce:script type="text/javascript"><!--<br /> alert('"+CurPageNum+"');<br /> // --></mce:script>");<br /> if(CurPageNum <= 0)<br /> {<br /> CurPageNum = 1;<br /> }<br /> }else if(down=="下一页")<br /> {<br /> toppage = downpage;<br /> //Response.Write("<mce:script type="text/javascript"><!--<br /> alert('"+toppage+"');<br /> // --></mce:script>");<br /> CurPageNum = toppage+1;<br /> //Response.Write("<mce:script type="text/javascript"><!--<br /> alert('"+CurPageNum+"');<br /> // --></mce:script>");<br /> if (CurPageNum >= TotalPages)<br /> {<br /> CurPageNum = TotalPages;<br /> }<br /> }<br /> var conn= Server.CreateObject("ADODB.connection");<br /> var rs= Server.CreateObject("adodb.recordset");<br /> conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");<br /> var sql = "select top "+PageSize+" truename,activeid,chrtel,CONVERT(varchar(30),dtappenddate,20) as dtappenddate from baoming where id not in(select top "+(PageSize*(CurPageNum-1))+" id from baoming order by id desc) order by id desc";<br /> rs.open(sql,conn);<br /> var i =0; </p> <p> if(TotalRecords < 1)<br /> {<br /> Response.write("<mce:script type="text/javascript"><!--<br /> alert('没有记录');<br /> // --></mce:script>");<br /> }else<br /> {<br /> while(!rs.EOF && i<PageSize)<br /> {<br /> i++;<br /> Response.Write("<tr align='center'>");<br /> Response.Write("<td>"+i +"</td>");<br /> Response.Write("<td>"+ rs('truename') +"</td>");<br /> Response.Write("<td>"+ getActiveNameById(rs('activeid')) +"</td>");<br /> Response.Write("<td>"+ rs('chrtel') +"</td>");<br /> Response.Write("<td>"+ rs('dtappenddate') +"</td>");<br /> Response.Write("</tr>");<br /> rs.movenext;<br /> }<br /> }<br /> rs.close();<br /> conn.close();<br /> rs=null;<br /> conn=null;<br /> }</p> <p>function page()<br /> {<br /> Response.Write("<form action='huodong.asp' method='post'><table width='98%' border='0' align='right' cellpadding='0' cellspacing='0'>");<br /> Response.Write("<tr>");<br /> Response.Write("<td>");<br /> Response.Write("<input type='submit' name='home' value='首页'/>");<br /> Response.Write("<input type='hidden' name='homepage' value='1'/>");<br /> Response.Write("<input type='submit' name='up' value='上一页'/>");<br /> Response.Write("<input type='hidden' name='uppage' value='"+(CurPageNum-1)+"'/>");<br /> Response.Write("<input type='submit' name='down' value='下一页'/>");<br /> Response.Write("<input type='hidden' name='downpage' value='"+(CurPageNum+1)+"'/>");<br /> Response.Write("<input type='hidden' name='ChrName' value='"+username+"'/>");<br /> Response.Write("<input type='hidden' name='ChrPwd' value='"+password+"'/>");<br /> //Response.Write("<input type='submit' name='last' value='最后一页'/>");<br /> Response.Write("</td>");<br /> Response.Write("</tr>");<br /> Response.Write("</table></form>");<br /> }