/// <summary>
/// 列表数据绑定
/// </summary>
/// <param name="pageIndex"></param>
private void BindGridView(int pageIndex)
{
string sqlWhere = " b.CompanyType !=" + SystemSet._ARCHIVE;
if (!String.IsNullOrWhiteSpace(txtLoginName.Text.Trim()))
{
sqlWhere += " And a.LoginName like '%" + txtLoginName.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtUserName.Text.Trim()))
{
sqlWhere += " And a.UserName like '%" + txtUserName.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtCompanyName.Text.Trim()))
{
sqlWhere += " And b.CompanyName like '%" + txtCompanyName.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtGcmc.Text.Trim()))
{
sqlWhere += " And d.gcmc like '%" + txtGcmc.Text.Trim() + "%' ";
}
if (!String.IsNullOrWhiteSpace(txtGcdd.Text.Trim()))
{
sqlWhere += " And d.gcdd like '%" + txtGcdd.Text.Trim() + "%' ";
}
if (ddlUserType.SelectedValue != "0")
{
sqlWhere += " And lower(a.UserType)='" + ddlUserType.SelectedValue.Trim().ToLower() + "' ";
}
if (PublicModel.isSuperAdmin()) //超级管理员
{
sqlWhere += " And b.Area_Code like '" + Common.Session.GetSession("OLD_AREA_CODE") + "%' ";
}
else if (PublicModel.isArchiveUser()) //馆里用户
{
sqlWhere += " And b.Area_Code like '" + Common.Session.GetSession("AREA_CODE") + "%' ";
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = userBLL.GetCompanyUserList(sqlWhere, pageSize, pageIndex, out itemCount);
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}