//主表显示
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;
}
