/// <summary>
///
/// </summary>
/// <param name="pageIdex"></param>
/// <param name="pageSize"></param>
/// <param name="pageTable"></param>
/// <param name="pageColumn"></param>
/// <param name="codition"></param>
/// <param name="key"></param>
/// <param name="controlName"></param>
/// <param name="orderKey2">排序列名</param>
/// <param name="sortType">排序方向0 降序 1 升序</param>
public void PageBind(int pageIdex, int pageSize, string pageTable, string pageColumn, string codition, string key, string controlName, string orderKey2, int sortType)
{
this.Pageindex = pageIdex;
this.PageSize = pageSize;
this.PageTable = pageTable;
this.PageColumn = pageColumn;
this.Condition = codition;
this.key = key;
this.ControlName = controlName;
this.OrderKey = orderKey2;
this.SortType = sortType;
BLL.other.Company.ProductTreeList dao = new BLL.other.Company.ProductTreeList();
string columns = ViewState["PageColumn"] == null || ViewState["PageColumn"].ToString() == "" ? "*" : ViewState["PageColumn"].ToString();
string conod = ViewState["Conodition"] == null || ViewState["Conodition"].ToString() == "" ? "1=1" : ViewState["Conodition"].ToString();
string orderkey = ViewState["key"] == null || ViewState["key"].ToString() == "" ? "1" : ViewState["key"].ToString();
int rescordcount = 0;
int pagecounts = 0;
DataTable tab = dao.GetDataTablePage_SmsBll(Convert.ToInt32(ViewState["PageIndex"]), Convert.ToInt32(ViewState["PageSize"]), ViewState["PageTable"].ToString(), columns, conod, orderkey, orderKey2, sortType, out rescordcount, out pagecounts);
ViewState["PageCount"] = pagecounts;
StringBuilder sb = new StringBuilder();
if (tab.Rows.Count > 0)
{
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001045", "共") + "<b> " + rescordcount + "</b> " + bs.GetTran("001049", "条记录"));
sb.Append(bs.GetTran("000156", "第") + " <b> " + (int.Parse(ViewState["PageIndex"].ToString()) + 1) + "</b> " + bs.GetTran("001055", "页"));
sb.Append(bs.GetTran("001045", "共") + " <b> " + pagecounts + "</b> " + bs.GetTran("001055", "页"));
dropPageList.Items.Clear();
for (int i = 0; i < pagecounts; i++)
{
dropPageList.Items.Add(new ListItem((i + 1).ToString(), (i).ToString()));
}
dropPageList.SelectedIndex = int.Parse(ViewState["PageIndex"].ToString());
//dropPageList.SelectedItem.Value =ViewState["PageIndex"].ToString();
int size = Convert.ToInt32(ViewState["PageSize"]);
if (rescordcount > size)
{
pageS.Visible = true;
}
else
{
pageS.Visible = false;
}
InitBindData = true;
}
else
{
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001595", "没有查询到数据"));
pageS.Visible = false;
}
this.lbl.Text = sb.ToString();
CheckBtn();
}
public void PageBindGroup(int pageIdex, int pageSize, string pageTable, string pageColumn, string codition, string key, string group, string controlName)
{
this.Pageindex = pageIdex;
this.PageSize = pageSize;
this.PageTable = pageTable;
this.PageColumn = pageColumn;
this.Condition = codition;
this.key = key;
this.ControlName = controlName;
this.Group = group;
BLL.other.Company.ProductTreeList dao = new BLL.other.Company.ProductTreeList();
string columns = ViewState["PageColumn"] == null || ViewState["PageColumn"].ToString() == "" ? "*" : ViewState["PageColumn"].ToString();
string conod = ViewState["Conodition"] == null || ViewState["Conodition"].ToString() == "" ? "1=1" : ViewState["Conodition"].ToString();
string orderkey = ViewState["key"] == null || ViewState["key"].ToString() == "" ? "1" : ViewState["key"].ToString();
int rescordcount = 0;
int pagecounts = 0;
string pageTable111 = ViewState["PageTable"].ToString();
DataTable tab = dao.GetDataTablePage_SmsBllgroup(Convert.ToInt32(ViewState["PageIndex"]), Convert.ToInt32(ViewState["PageSize"]), ViewState["PageTable"].ToString(), columns, conod, orderkey, group, out rescordcount, out pagecounts);
ViewState["PageCount"] = pagecounts;
StringBuilder sb = new StringBuilder();
if (tab.Rows.Count > 0)
{
string asg = ViewState["ControlName"].ToString();
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001045", "共") + "<b> " + rescordcount + "</b> " + bs.GetTran("001049", "条记录"));
sb.Append(bs.GetTran("000156", "第") + " <b> " + (int.Parse(ViewState["PageIndex"].ToString()) + 1) + "</b> " + bs.GetTran("001055", "页"));
sb.Append(bs.GetTran("001045", "共") + " <b> " + pagecounts + "</b> " + bs.GetTran("001055", "页"));
txt_page.Text = (int.Parse(ViewState["PageIndex"].ToString()) + 1).ToString();
int size = Convert.ToInt32(ViewState["PageSize"]);
if (rescordcount > size)
{
pageS.Visible = true;
}
else
{
pageS.Visible = false;
}
InitBindData = true;
div2.Visible = true;
}
else
{
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001595", "没有查询到数据"));
pageS.Visible = false;
div2.Visible = false;
}
this.lbl.InnerHtml = sb.ToString();
CheckBtn();
}
/// <summary>
/// 汪华(20091004所写)按照关键字排序（为GridView排序事件服务）
/// </summary>
/// <param name="pageIdex"></param>
/// <param name="pageSize"></param>
/// <param name="pageTable"></param>
/// <param name="pageColumn"></param>
/// <param name="codition"></param>
/// <param name="key"></param>
/// <param name="ascOrDesc"></param>
/// <param name="controlName"></param>
public void PagingSort(int pageIdex, int pageSize, string pageTable, string pageColumn, string codition, string key, bool ascOrDesc, string controlName)
{
this.Pageindex = pageIdex;
this.PageSize = pageSize;
this.PageTable = pageTable;
this.PageColumn = pageColumn;
this.Condition = codition;
this.key = key;
this.AscOrDesc = ascOrDesc;
this.ControlName = controlName;
BLL.other.Company.ProductTreeList dao = new BLL.other.Company.ProductTreeList();
string columns = ViewState["PageColumn"] == null || ViewState["PageColumn"].ToString() == "" ? "*" : ViewState["PageColumn"].ToString();
string conod = ViewState["Conodition"] == null || ViewState["Conodition"].ToString() == "" ? "1=1" : ViewState["Conodition"].ToString();
string orderkey = ViewState["key"] == null || ViewState["key"].ToString() == "" ? "1" : ViewState["key"].ToString();
int rescordcount = 0;
int pagecounts = 0;
DataTable tab = dao.GetCustomersDataPage_Sort(Convert.ToInt32(ViewState["PageIndex"]), Convert.ToInt32(ViewState["PageSize"]), ViewState["PageTable"].ToString(), columns, conod, orderkey, ascOrDesc, out rescordcount, out pagecounts);
ViewState["PageCount"] = pagecounts;
StringBuilder sb = new StringBuilder();
if (tab.Rows.Count > 0)
{
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001045", "共") + "<b> " + rescordcount + "</b> " + bs.GetTran("001049", "条记录"));
sb.Append(bs.GetTran("000156", "第") + " <b> " + (int.Parse(ViewState["PageIndex"].ToString()) + 1) + "</b> " + bs.GetTran("001055", "页"));
sb.Append(bs.GetTran("001045", "共") + " <b> " + pagecounts + "</b> 页");
txt_page.Text = (int.Parse(ViewState["PageIndex"].ToString()) + 1).ToString();
//dropPageList.SelectedItem.Value =ViewState["PageIndex"].ToString();
int size = Convert.ToInt32(ViewState["PageSize"]);
if (rescordcount > size)
{
pageS.Visible = true;
}
else
{
pageS.Visible = false;
}
InitBindData = true;
}
else
{
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001595", "没有查询到数据"));
pageS.Visible = false;
}
this.lbl.Text = sb.ToString();
CheckBtn();
}
public void PageBind_sort()
{
BLL.other.Company.ProductTreeList dao = new BLL.other.Company.ProductTreeList();
string columns = ViewState["PageColumn"] == null || ViewState["PageColumn"].ToString() == "" ? "*" : ViewState["PageColumn"].ToString();
string conod = ViewState["Conodition"] == null || ViewState["Conodition"].ToString() == "" ? "1=1" : ViewState["Conodition"].ToString();
string orderkey = ViewState["key"] == null || ViewState["key"].ToString() == "" ? "1" : ViewState["key"].ToString();
string orderkey2 = (ViewState["orderkey"] == null || ViewState["orderkey"].ToString() == "") ? "id" : ViewState["orderkey"].ToString();
int sortType = ViewState["sortType"] == null ? 0 : (int)ViewState["sortType"];
int rescordcount = 0;
int pagecounts = 0;
DataTable tab = dao.GetDataTablePage_SmsBll(Convert.ToInt32(ViewState["PageIndex"]), Convert.ToInt32(ViewState["PageSize"]), ViewState["PageTable"].ToString(), columns, conod, orderkey, orderkey2, sortType, out rescordcount, out pagecounts);
ViewState["PageCount"] = pagecounts;
StringBuilder sb = new StringBuilder();
if (tab.Rows.Count > 0)
{
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001045", "共") + " <b>" + rescordcount + "</b> " + bs.GetTran("001049", "条记录"));
sb.Append(bs.GetTran("000156", "第") + " <b>" + (int.Parse(ViewState["PageIndex"].ToString()) + 1) + "</b> " + bs.GetTran("001055", "页"));
sb.Append(bs.GetTran("001045", "共") + "<b> " + pagecounts + "</b>" + bs.GetTran("001055", "页"));
txt_page.Text = (int.Parse(ViewState["PageIndex"].ToString()) + 1).ToString();
if (rescordcount > Convert.ToInt32(ViewState["PageSize"]))
{
pageS.Visible = true;
}
else
{
pageS.Visible = false;
}
InitBindData = true;
div2.Visible = true;
}
else
{
PageBindshow(ViewState["ControlName"].ToString(), tab);
sb.Append(bs.GetTran("001595", "没有查询到数据"));
pageS.Visible = false;
div2.Visible = false;
}
this.lbl.InnerHtml = sb.ToString();
CheckBtn();
}
//private void PageBindshow(string ControlName, DataTable table)
//{
// if (Page.FindControl(ControlName) is GridView)
// {
// GridView giv = Page.FindControl(ControlName) as GridView;
// giv.DataSource = table;
// giv.DataBind();
// }
// if (Page.FindControl(ControlName) is Repeater)
// {
// Repeater rep = Page.FindControl(ControlName) as Repeater;
// rep.DataSource = table;
// rep.DataBind();
// }
// if (Page.FindControl(ControlName) is DataList)
// {
// DataList dts = Page.FindControl(ControlName) as DataList;
// dts.DataSource = table;
// dts.DataBind();
// }
// if (Page.FindControl(ControlName)is DataGrid)
// {
// DataGrid giv = Page.FindControl(ControlName) as DataGrid;
// giv.DataSource = table;
// giv.DataBind();
// }
//}
public DataTable PageBind()
{
BLL.other.Company.ProductTreeList dao = new BLL.other.Company.ProductTreeList();
string columns = ViewState["PageColumn"] == null || ViewState["PageColumn"].ToString() == "" ? "*" : ViewState["PageColumn"].ToString();
string conod = ViewState["Conodition"] == null || ViewState["Conodition"].ToString() == "" ? "1=1" : ViewState["Conodition"].ToString();
string orderkey = ViewState["key"] == null || ViewState["key"].ToString() == "" ? "1" : ViewState["key"].ToString();
int rescordcount = 0;
int pagecounts = 0;
tab = dao.GetDataTablePage_SmsBll(Convert.ToInt32(ViewState["PageIndex"]), Convert.ToInt32(ViewState["PageSize"]), ViewState["PageTable"].ToString(), columns, conod, orderkey, out rescordcount, out pagecounts);
//ViewState["PageCount"] = pagecounts;
//StringBuilder sb = new StringBuilder();
if (tab.Rows.Count > 0)
{
// PageBindshow(ViewState["ControlName"].ToString(), tab);
// sb.Append(bs.GetTran("001045", "共") + " <b>" + rescordcount + "</b> " + bs.GetTran("001049", "条记录"));
// sb.Append(bs.GetTran("000156", "第") + " <b>" + (int.Parse(ViewState["PageIndex"].ToString()) + 1) + "</b> " + bs.GetTran("001055", "页"));
// sb.Append(bs.GetTran("001045", "共") + "<b> " + pagecounts + "</b>" + bs.GetTran("001055", "页"));
// txt_page.Text = (int.Parse(ViewState["PageIndex"].ToString()) + 1).ToString();
// if (rescordcount > Convert.ToInt32(ViewState["PageSize"]))
// {
// pageS.Visible = true;
// }
// else
// {
// pageS.Visible = false;
// }
// InitBindData = true;
// div2.Visible = true;
//}
//else
//{
// PageBindshow(ViewState["ControlName"].ToString(), tab);
// sb.Append(bs.GetTran("001595", "没有查询到数据"));
// pageS.Visible = false;
// div2.Visible = false;
}
//this.lbl.InnerHtml = sb.ToString();
//CheckBtn();
return(tab);
}
