int CurrentPage;//当前页数
  int PageSize;   //每页条数
  int PageCount;  //总页数
  int RecordCount;//总条数


  
  private void Page_Load(object sender, System.EventArgs e)
  {
   PageSize=16; //每页为16条记录
   if(!IsPostBack)
   {
    if(Session["ji"]==null||Session["ji"].ToString()=="")
    {
     Response.Write("<script language = javascript>window.open('Login.aspx','_top')</script>");
    }
    else
    {
    
     DataListBind();
    Page.DataBind();
    CalculateRecord();
  
 }
      }

  }

  public void LinkButton_Click(Object sender, CommandEventArgs e)//自己编写的按钮点击事件
  {
   CurrentPage =(int)ViewState["PageIndex"];//获得当前页索引
   PageCount = (int)ViewState["PageCount"];//获得总页数

   int inpage=0;
   string cmd = e.CommandName;

   //判断cmd,以判定翻页方向


   switch (cmd)
   {
    case "prev"://上一页
     if (CurrentPage > 0)CurrentPage--;
     break;

    case "next":
     if (CurrentPage < (PageCount - 1)) CurrentPage++;//下一页
     break;

    case "first"://第一页
     CurrentPage = 0;
     break;

    case "end"://最后一页
     CurrentPage = PageCount - 1;
     break;

    case "jump"://跳转到第几页
     try
     {
      inpage=int.Parse(TextBox2.Text.Trim());
                 }
     catch
     {
      Response.Write("<script>alert('只能输入数字!!!')</script>");
      return;
     }     
    if (this.TextBox2.Text.Trim()== "" || Int32.Parse(this.TextBox2.Text.Trim()) > PageCount ||Int32.Parse(this.TextBox2.Text.Trim())<0)//如果输入数字为空或超出范围则返回
     {
      return;
     }
     else
     {                   
      CurrentPage = Int32.Parse(this.TextBox2.Text.ToString()) - 1;
      break;
     }
   }
   ViewState["PageIndex"] = CurrentPage;//获得当前页

   //重新将DataList绑定到数据库
//CalculateRecord();
  DataListBind(); 

  }

  public void  CalculateRecord()
  {
              
   //不可以放在初始化条件之前就绑定,那样的话,如果仅有一页的数据,“下一页”页仍然显示
   CurrentPage = 0;//当前页习惯设为0
   ViewState["PageIndex"] = 0;//页索引也设为0


   //计算总共有多少记录
   RecordCount =com.kecount();
           
   //计算总共有多少页
   if (RecordCount % PageSize == 0)
   {
    PageCount = RecordCount / PageSize;
   }
   else
   {
    PageCount = RecordCount / PageSize + 1;
   }

   this.TotalLbl.Text = PageCount.ToString();//显示总页数
   ViewState["PageCount"] = PageCount;//会话session 对整个 application 有效 ,而视图状态 viewstate相当于某个页面的 session
   this.DataListBind();

  }
  public void DataListBind()
  {

   string zhuang="zhuang";
   int StartIndex = CurrentPage * PageSize;
   if(StartIndex<0)
   {
    StartIndex=0;
   
   }

          DataSet ds=com.kehu1(StartIndex,PageSize,zhuang);
      
   DataList1.DataSource=ds.Tables["zhuang"].DefaultView;
    
   DataList1.DataBind();
   
    this.PreviousLB.Enabled = true;
    this.NextLB.Enabled = true;
    if (CurrentPage == (PageCount - 1)) this.NextLB.Enabled = false;//当为最后一页时,下一页链接按钮不可用
    if (CurrentPage == 0) this.PreviousLB.Enabled = false;//当为第一页时,上一页按钮不可用
    this.CurrentLbl.Text = (CurrentPage + 1).ToString();//当前页数
   
  }

  private void DataList1_UpdateCommand_1(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
  {
   Response.Redirect("addkefu.aspx?type=2"+"&id="+DataList1.DataKeys[e.Item.ItemIndex].ToString());
  }

  private void DataList1_DeleteCommand_1(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
  {
   
  
             DataTable url=com.kehusele(int.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString())).Tables[0];

   ViewState["name"]=Server.MapPath("..\\kehu\\"+url.Rows[0]["name"].ToString());

   bool dele=com.delekehu(int.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString()));
   if(dele==true)
   {
    Response.Write("<script>alert('删除成功!!!')</script>");
    FileInfo finfo = new FileInfo(ViewState["name"].ToString());
    if(finfo.Exists)
    {
     finfo.Delete();
    }
   
   }
   else
   {
   Response.Write("<script>alert('删除失败!!!')</script>");
   }
   CalculateRecord();

    DataListBind();
  }

  private void DataList1_ItemDataBound_1(object sender, System.Web.UI.WebControls.DataListItemEventArgs e)
  {
   if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
   {
    
    //判断删除按扭
    Button Button2=(Button)e.Item.FindControl("Button2");
    Button2.Attributes.Add("onclick","return confirm('确定要删除吗??')");
    
   }
  }

  
  public String Imger1
  {
   
   get {return _imger1;}
  set {_imger1=value;}
}

 
 }
}

HTML
<td><FONT face="宋体" size="2"><asp:linkbutton id="FirstLB" runat="server" OnCommand="LinkButton_Click" CommandName="first">第一页</asp:linkbutton><asp:linkbutton id="PreviousLB" runat="server" OnCommand="LinkButton_Click" CommandName="prev">上一页</asp:linkbutton><asp:linkbutton id="NextLB" runat="server" OnCommand="LinkButton_Click" CommandName="next">下一页</asp:linkbutton><asp:linkbutton id="EndLB" runat="server" OnCommand="LinkButton_Click" CommandName="end">最后一页</asp:linkbutton>共
       <asp:label id="TotalLbl" runat="server" ForeColor="#FF8000"></asp:label>页 当前第
       <asp:label id="CurrentLbl" runat="server" ForeColor="#FF8000"></asp:label>页
       <asp:linkbutton id="JumpLB" runat="server" OnCommand="LinkButton_Click" CommandName="jump">跳到</asp:linkbutton>第
       <asp:TextBox id="TextBox2" runat="server" Width="63px"></asp:TextBox>页</FONT></td>

posted on 2007-12-20 23:37  风语战士  阅读(621)  评论(0编辑  收藏  举报