62,047
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 函数实现分页的功能
/// </summary>
private void fuction()
{
var sourse = db.LeaveMsgs_Show();
int count = sourse.Count();
if (count % Page_Size == 0)
TotalPage.Text = (count / Page_Size).ToString();
else
TotalPage.Text = (count / Page_Size + 1).ToString();
DropDownList2.Items.Clear();
for (int i = 0; i < Convert.ToInt32(TotalPage.Text); i++)
{
DropDownList2.Items.Add("第" + (i + 1).ToString() + "页");
}
Total.Text = count.ToString();
LaPagesize.Text = Page_Size.ToString();
repdatabind();
}
/// <summary>
/// 数据绑定
/// </summary>
public void repdatabind()
{
if (Convert.ToInt32(CurrentPage.Text.ToString()) <= 1)
{
BtnUp.Enabled = false;
BtnUp1.Enabled = false;
}
else
{
BtnUp.Enabled = true;
BtnUp1.Enabled = true;
}
if (Convert.ToInt32(CurrentPage.Text.ToString()) >= Convert.ToInt32(TotalPage.Text))
{
BtnDown.Enabled = false;
BtnDown1.Enabled = false;
}
else
{
BtnDown.Enabled = true;
BtnDown1.Enabled = true;
}
var sourse = from a in db.LeaveMsgs_Show()
select new
{
a.LeaveMsgID,
a.Content,
a.photo,
a.PubTime,
a.XingMing,
a.ReMessage,
};
var show = sourse.Skip((Convert.ToInt32(CurrentPage.Text) - 1) * Page_Size).Take(Page_Size);
Repeater1.DataSource = show;
Repeater1.DataBind();
}
/// <summary>
/// 上一页
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnUp_Click(object sender, EventArgs e)
{
CurrentPage.Text = (Convert.ToInt32(CurrentPage.Text) - 1).ToString();
repdatabind();
}
/// <summary>
/// 下一页
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnDown_Click(object sender, EventArgs e)
{
CurrentPage.Text = (Convert.ToInt32(CurrentPage.Text) + 1).ToString();
repdatabind();
}
/// <summary>
/// 首页
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkBtnFirst_Click(object sender, EventArgs e)
{
CurrentPage.Text = "1";
repdatabind();
}
/// <summary>
/// 尾页
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkBtnLast_Click(object sender, EventArgs e)
{
CurrentPage.Text = TotalPage.Text;
repdatabind();
}
/// <summary>
/// 下拉框架,把内容换成数字
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
CurrentPage.Text = DropDownList2.SelectedItem.ToString().Replace("第", "").Replace("页", "");
repdatabind();
}