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();
}
