/// <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> 页");
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();
}
