//主表显示 public DataTable SetBtnEnabled(int PageIndex, string SqlCmd, string Filter, int pageSize, GridView dgview, LinkButton btnFirst, LinkButton btnPre, LinkButton btnNext, LinkButton btnLast, LinkButton btnToPage, Label lblCurrentPage, UpdatePanel UpdatePanel1) { int pageCount = 0; int totalCount = 0; BLL.BLLBase bll = new BLL.BLLBase(); DataTable dtView = bll.GetDataPage(SqlCmd, PageIndex, pageSize, out totalCount, out pageCount, new DataParameter[] { new DataParameter("{0}", Filter) }); if (ViewState["CurrentPage"].ToString() == "0" || int.Parse(ViewState["CurrentPage"].ToString()) > pageCount) { ViewState["CurrentPage"] = pageCount; } if (dtView.Rows.Count == 0) { SetGridViewEmptyRow(dgview, dtView); btnFirst.Enabled = false; btnPre.Enabled = false; btnNext.Enabled = false; btnLast.Enabled = false; btnToPage.Enabled = false; lblCurrentPage.Visible = false; } else { dgview.DataSource = dtView; dgview.DataBind(); btnLast.Enabled = true; btnFirst.Enabled = true; btnToPage.Enabled = true; if (int.Parse(ViewState["CurrentPage"].ToString()) > 1) { btnPre.Enabled = true; } else { btnPre.Enabled = false; } if (int.Parse(ViewState["CurrentPage"].ToString()) < pageCount) { btnNext.Enabled = true; } else { btnNext.Enabled = false; } lblCurrentPage.Visible = true; lblCurrentPage.Text = "共 [" + totalCount.ToString() + "] 笔记录 第 [" + ViewState["CurrentPage"] + "] 页 共 [" + pageCount.ToString() + "] 页"; } ViewState[FormID + "_MainFormData"] = dtView; return(dtView); }
void GridDataBind() { dtLog = bll.GetDataPage("Security.SeleteOperatorLog", pageIndex, pageSize, out totalCount, out pageCount, new DataParameter[] { new DataParameter("{0}", filter), new DataParameter("{1}", OrderByFields) }); if (dtLog.Rows.Count == 0) { dtLog.Rows.Add(dtLog.NewRow()); gvMain.DataSource = dtLog; gvMain.DataBind(); int columnCount = gvMain.Rows[0].Cells.Count; gvMain.Rows[0].Cells.Clear(); gvMain.Rows[0].Cells.Add(new TableCell()); gvMain.Rows[0].Cells[0].ColumnSpan = columnCount; gvMain.Rows[0].Cells[0].Text = "没有符合以上条件的数据,请重新查询 "; gvMain.Rows[0].Visible = true; } else { this.gvMain.DataSource = dtLog; this.gvMain.DataBind(); } ViewState["pageIndex"] = pageIndex; ViewState["totalCount"] = totalCount; ViewState["pageCount"] = pageCount; ViewState["filter"] = filter; ViewState["OrderByFields"] = OrderByFields; }
//protected void ddlPageSize_SelectedIndexChanged(object sender, EventArgs e) //{ // ViewState["PageSize"] = this.ddlPageSize.SelectedValue; // SetBtnEnabled(""); //} /// <summary> /// 浏览界面每页笔数 /// </summary> //private void BindPageSize() //{ // this.ddlPageSize.Items.Add(new ListItem("10", "10")); // this.ddlPageSize.Items.Add(new ListItem("20", "20")); // this.ddlPageSize.Items.Add(new ListItem("40", "40")); // this.ddlPageSize.Items.Add(new ListItem("50", "50")); //} /// <summary> /// 綁定GirdView /// </summary> /// <param name="pageIndex"></param> private void BindGrid(int pageIndex) { totalCount = bll.GetRowCount(TableView, filter); pageCount = GetPageCount(totalCount, pageSize); if (pageIndex == 0 || pageIndex > pageCount) { pageIndex = pageCount; } DataTable dt = bll.GetDataPage(pageIndex, pageSize, filter, orderBy, PrimaryKey, TableView, queryFields); if (dt.Rows.Count == 0) { dt.Rows.Add(dt.NewRow()); GridView1.DataSource = dt; GridView1.DataBind(); int columnCount = GridView1.Rows[0].Cells.Count; GridView1.Rows[0].Cells.Clear(); GridView1.Rows[0].Cells.Add(new TableCell()); GridView1.Rows[0].Cells[0].ColumnSpan = columnCount; GridView1.Rows[0].Cells[0].Text = "没有符合以上条件的数据,请重新查询 "; GridView1.Rows[0].Visible = true; this.btnFirst.Enabled = false; this.btnPre.Enabled = false; this.btnNext.Enabled = false; this.btnLast.Enabled = false; this.btnToPage.Enabled = false; this.lblPage.Visible = false; } else { this.GridView1.DataSource = dt; this.GridView1.DataBind(); this.btnLast.Enabled = true; this.btnFirst.Enabled = true; this.btnToPage.Enabled = true; if (pageIndex > 1) { this.btnPre.Enabled = true; } else { this.btnPre.Enabled = false; } if (pageIndex < pageCount) { this.btnNext.Enabled = true; } else { this.btnNext.Enabled = false; } lblPage.Visible = true; lblPage.Text = "共 [" + totalCount.ToString() + "] 笔记录 第 [" + pageIndex.ToString() + "] 页 共 [" + pageCount.ToString() + "] 页"; } }
//主表显示 public DataTable SetBtnEnabled(int PageIndex, string SqlCmd, string Filter, int pageSize, GridView dgview, LinkButton btnFirst, LinkButton btnPre, LinkButton btnNext, LinkButton btnLast, LinkButton btnToPage, Label lblCurrentPage, UpdatePanel UpdatePanel1) { int pageCount = 0; int totalCount = 0; BLL.BLLBase bll = new BLL.BLLBase(); DataTable dtView = bll.GetDataPage(SqlCmd, PageIndex, pageSize, out totalCount, out pageCount, new DataParameter[] { new DataParameter("{0}", Filter) }); if (ViewState["CurrentPage"].ToString() == "0" || int.Parse(ViewState["CurrentPage"].ToString()) > pageCount) ViewState["CurrentPage"] = pageCount; if (dtView.Rows.Count == 0) { SetGridViewEmptyRow(dgview, dtView); btnFirst.Enabled = false; btnPre.Enabled = false; btnNext.Enabled = false; btnLast.Enabled = false; btnToPage.Enabled = false; lblCurrentPage.Visible = false; } else { dgview.DataSource = dtView; dgview.DataBind(); btnLast.Enabled = true; btnFirst.Enabled = true; btnToPage.Enabled = true; if (int.Parse(ViewState["CurrentPage"].ToString()) > 1) btnPre.Enabled = true; else btnPre.Enabled = false; if (int.Parse(ViewState["CurrentPage"].ToString()) < pageCount) btnNext.Enabled = true; else btnNext.Enabled = false; lblCurrentPage.Visible = true; lblCurrentPage.Text = "共 [" + totalCount.ToString() + "] 笔记录 第 [" + ViewState["CurrentPage"] + "] 页 共 [" + pageCount.ToString() + "] 页"; } ViewState[FormID + "_MainFormData"] = dtView; return dtView; }