JavaScript连接SqlServer并实现分页(二)

//总记录数
function sumRecord()
{
  var conn= Server.CreateObject("ADODB.connection");
  var rs= Server.CreateObject("adodb.recordset");
  conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");
  var sql = "select count(*) as RecordCount from baoming";
  rs.open(sql,conn);
  TotalRecords = rs('RecordCount');   
}

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