/// <summary> /// 查询指定页数的数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFind_Click(object sender, EventArgs e) { if (txtPage.Text.Trim() == "") { untCommon.InfoMsg("请输入所要查询的页数。"); return; } try { curPage = int.Parse(this.txtPage.Text); } catch (FormatException) { untCommon.InfoMsg("所要查询的页数请输入数字。"); return; } if (curPage > TotalPage || curPage < 1) { untCommon.InfoMsg("没有您所要查询的页数。"); return; } DataTable dat = EpMgr.getEqList((curPage - 1) * pageCount, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 查询所有信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolbtnSearchAll_Click(object sender, EventArgs e) { curPage = 1; DataTable dat = EpMgr.getEqList(0, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; this.toolStrip3.Enabled = true; } }
/// <summary> /// 首页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFirst_Click(object sender, EventArgs e) { curPage = 1; DataTable dat = EpMgr.getEqList(0, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 刷新数据 /// </summary> private void DataRefresh() { DataTable dat = EpMgr.getEqList((curPage - 1) * pageCount, pageCount); if (dat != null) { TotalPage = this.getTotalPage();//得到数据的总页数 //绑定数据 dbgEq.DataSource = dat; } this.lblTotalpage.Text = "共" + TotalPage.ToString() + "页"; this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 下一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnNext_Click(object sender, EventArgs e) { if (curPage < TotalPage) { curPage++; } DataTable dat = EpMgr.getEqList((curPage - 1) * pageCount, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 初始化资产表 /// </summary> private void InitDbgEq() { curPage = 1; DataTable dat = EpMgr.getEqList(0, pageCount); if (dat != null) { this.dbgEqSet(); //绑定数据 dbgEq.DataSource = dat; dbgEq.ScrollBars = ScrollBars.Both; } }