protected void Page_Load(object sender, EventArgs e) { if (Session["Manage_Level"] == null || Session["UserID"] == null || Session["Receipt"] == null) { Server.Transfer("Login.aspx"); } else { //读取数据 SqlConnection conn = new SqlConnection(); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter("select Trans_Value,Trans_Order from ERS_Trans where Trans_Type='Deposit' order by Trans_Order", SqlHelper.Conn); sda.Fill(ds, "Deposit"); PagedDataSource pds = new PagedDataSource(); pds.DataSource = ds.Tables["Deposit"].DefaultView; pds.AllowPaging = true; //允许分页 pds.PageSize = 10; //单页显示项数 int CurPage; if (Request.QueryString["Page"] != null) { CurPage = Convert.ToInt32(Request.QueryString["Page"]); } else { CurPage = 1; } pds.CurrentPageIndex = CurPage - 1; int Count = pds.PageCount; lblCurrentPage.Text = "Current Page:" + CurPage.ToString(); labPage.Text = Count.ToString(); if (Count > 1) { this.first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1"; this.last.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(Count); } if (!pds.IsFirstPage) { up.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1); } if (!pds.IsLastPage) { next.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); } //Repeater Deposit_table.DataSource = pds; Deposit_table.DataBind(); } }
public void getdate(string Station) { //读取数据 SqlConnection conn = new SqlConnection(); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter("select Trans_Value,Trans_Order from ERS_Trans where Trans_Type='Deposit' and Trans_Station='" + Station + "' order by Trans_Order", SqlHelper.Conn); sda.Fill(ds, "Deposit"); PagedDataSource pds = new PagedDataSource(); pds.DataSource = ds.Tables["Deposit"].DefaultView; pds.AllowPaging = true; //允许分页 pds.PageSize = 10; //单页显示项数 int CurPage; if (Request.QueryString["Page"] != null) { CurPage = Convert.ToInt32(Request.QueryString["Page"]); } else { CurPage = 1; } pds.CurrentPageIndex = CurPage - 1; int Count = pds.PageCount; lblCurrentPage.Text = "Current Page:" + CurPage.ToString(); labPage.Text = Count.ToString(); if (Count > 1) { this.first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1"; this.last.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(Count); } if (!pds.IsFirstPage) { up.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1); } if (!pds.IsLastPage) { next.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); } //Repeater Deposit_table.DataSource = pds; Deposit_table.DataBind(); }