public DataTable get_list(int psize)
{
int page = 1;
int pagesize = psize;
PageCurrent pc = new PageCurrent();
page = pc.get("page");
DataTable dt;
if (typeId > 0)
{
int recordcount = findcount("article", "classId=" + typeId.ToString());
pageBox = pc.page_list("?page=", pagesize, recordcount);
dt = find("article", page, pagesize, "id desc",
"classId", 1, 8, typeId
);
}
else
{
int recordcount = findcount("article", "");
pageBox = pc.page_list("?page=", pagesize, recordcount);
dt = find("article", page, pagesize, "id desc"
);
}
return dt;
}
/**/
/// <summary>
/// 当前页号
/// </summary>
public int PageCurrent
{
get { return(_pageCurrent); }
set { _pageCurrent = value; }
}
/// <summary>
/// 设置页面大小
/// </summary>
private void GetPageCount()
{
if (this.NMax > 0)
{
this.PageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(this.NMax) / Convert.ToDouble(this.PageSize)));
lblPageCount.Text = " / " + PageCount.ToString();
lblPageCount1.Text = " ，共 " + PageCount.ToString() + " 页";
//lblPageCount1.Text = "Page no: " + PageSize.ToString() + ",Total:" + PageCount.ToString() + " pages";
}
else
{
this.PageCount = 0;
}
}
/// <summary>
/// 控件状态初始化
/// </summary>
public void init()
{
//清空页号的列表
cmbPagecount.Items.Clear();
this.PageCount = 1;
_pageCurrent = 1;
lblPageCount.Text = "";
lblcurentpage.Text = "";
lblPageCount1.Text = "";
if (toolStripComboBox1.Text == null || toolStripComboBox1.Text.Length == 0)
{
toolStripComboBox1.Text = _pageSize.ToString();
}
}
/**/
/// <summary>
/// 翻页控件数据绑定的方法 关键是这步，都是调用这里
/// </summary>
public void Bind()
{
if (this.EventPaging != null)
{
this.NMax = this.EventPaging(new EventPagingArg(this.PageCurrent));
}
if (this.PageCurrent > this.PageCount)
{
this.PageCurrent = this.PageCount;
}
if (this.PageCount == 1)
{
this.PageCurrent = 1;
}
lblcurentpage.Text = PageCurrent.ToString();
lblRecordCount.Text = "共有 " + NMax.ToString() + " 条记录";
//lblRecordCount.Text = "Total: " + NMax.ToString() + " records";
btnPrev.Enabled = true;
btnFirst.Enabled = true;
btnLast.Enabled = true;
btnNext.Enabled = true;
if (this.PageCurrent == 1)
{
this.btnPrev.Enabled = false;
this.btnFirst.Enabled = false;
}
if (this.PageCurrent == this.PageCount)
{
this.btnLast.Enabled = false;
this.btnNext.Enabled = false;
}
if (this.NMax == 0)
{
btnNext.Enabled = false;
btnLast.Enabled = false;
btnFirst.Enabled = false;
btnPrev.Enabled = false;
}
if (cmbPagecount.Items.Count == 0)
{
cmbPagecount.Items.Clear();
for (int i = 1; i <= PageCount; i++)
{
cmbPagecount.Items.Add(i.ToString());
}
}
cmbPagecount.SelectedIndex = PageCurrent - 1;
}
protected void setBind(object sender, EventArgs e)
{
AlbumDal al = new AlbumDal();
int page = 1;
int pagesize = 10;
PageCurrent pc = new PageCurrent();
page = pc.get("page");
DataTable dt = al.GetList(page, pagesize);
int recordcount = findcount("album");
Pageer.value = pc.page_list("?page=", pagesize, recordcount);
detail.DataSource = dt;
detail.DataBind();
}
private void setBind()
{
int pagesize = 10;
int page = 1;
PageCurrent pc = new PageCurrent();
page = pc.get("page");
int recordcount = findcount("JM");
Pageer.value = pc.page_list("?page=", pagesize, recordcount);
DataTable dt = find("JM", page, pagesize);
list.DataSource = dt;
list.DataBind();
}
public DataTable get_list()
{
int pagesize = 9;
PageCurrent pc = new PageCurrent();
int page = pc.get("page");
int recordcount = findcount("product");
pageBox = pc.page_list("?page=", pagesize, recordcount);
DataTable dt = find("product", page, pagesize,"id desc");
return dt;
}
public List<ProductInfo> search()
{
ProductDal pro = new ProductDal();
int id = 0;
gnum(ref id, "tid");
int page = 1;
int pagesize = 12;
PageCurrent pc = new PageCurrent();
page = pc.get("page");
List<JoleYe.Model.ProductInfo> list = pro.view_list(id,page,pagesize);
int recordcount = pro.recordcount;
pageBox = pc.page_list("?page=", pagesize, recordcount);
return list;
}
public DataTable get_list()
{
int id = 0;
gnum(ref id,"tid");
int page = 1;
int pagesize = 12;
PageCurrent pc = new PageCurrent();
page = pc.get("page");
int recordcount = findcount("produce","typeId="+id);
pageBox = pc.page_list("?page=", pagesize, recordcount);
DataTable dt = find("produce", page, pagesize,"showId,id desc",
"typeId",1,8,id.ToString());
//DataTable dt = new DataTable();
return dt;
}
private void setBind(object sender, EventArgs e)
{
int pagesize = 10;
int page = 1;
PageCurrent pc = new PageCurrent();
page = pc.get("page");
int classid = 0;
gnum(ref classid, "classid");
ArticleDal dal = new ArticleDal();
detail.DataSource = dal.get_list(classid, page, pagesize);
detail.DataBind();
int recordcount = dal.getcount;
Pageer.value = pc.page_list("?classid=" + classid + "&page=", pagesize, recordcount);
}
protected void Page_Load(object sender, EventArgs e)
{
string app = gform("app");
MemberDal mb = new MemberDal();
if (app == "drop")
{
int id = gformNum("id");
mb.drop(id);
showMessage("删除成功");
}
int page = 1;
gnum(ref page, "page");
int pagesize = 10;
list.DataSource = mb.get_list(page,pagesize);
list.DataBind();
int recordcount = mb.findcount("member", "");
PageCurrent pg = new PageCurrent();
pageBox = pg.page_list("?page=", pagesize, recordcount);
}
private void setBind()
{
int pagesize = 10;
int page = 1;
int recordcount=2;
PageCurrent pc = new PageCurrent();
page = pc.get("page");
wd.Value = keyword;
//DataTable dt = find("view_product", page, pagesize, " showId ,id desc");
ProductDal p = new ProductDal();
Pageer.value = pc.page_list("?page=", pagesize, recordcount);
detail.DataSource = p.view_list(page, pagesize, 0, keyword);
detail.DataBind();
}
