/// <summary>
/// 用户数据绑定
/// 创建 2015-4-17
/// </summary>
private void BindGrid()
{
List <T_ADMIN> T_ADMIN_LIST = new List <T_ADMIN>();
//当前页数
int PageIndex = Grid1.PageIndex + 1;
//一页的数据条数
int PageSize = Grid1.PageSize;
//数据总条数
long allcount;
//分页拿到总数据
var queryall = new DapperExQuery <T_ADMIN>();
T_ADMIN_LIST = T_ADMIN_BLL.GetListByPage(queryall, "", PageIndex, PageSize, out allcount);
// 在名称中搜索
string searchText = ttbSearchMessage.Text.Trim();
if (!String.IsNullOrEmpty(searchText))
{
var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_NAME, OperationMethod.Equal, searchText)
.AndWhere(n => n.A_TRUE_NAME, OperationMethod.Equal, searchText);
T_ADMIN_LIST = T_ADMIN_LIST.Where(n => n.A_TRUE_NAME.Contains(searchText) || n.A_NAME.Contains(searchText)).ToList();
}
// 排除已经属于本角色的用户
int rolesid = 0;
if (Request.QueryString[requestStr].IsNum())
{
rolesid = Int32.Parse(Request.QueryString[requestStr]);
T_ROLES T_ROLES = new T_ROLES();
var queryrole = new DapperExQuery <T_ROLES>().AndWhere(n => n.ID, OperationMethod.Equal, rolesid);
T_ROLES = T_ROLES_BLL.GetEntity(queryrole);
List <T_ADMIN_ROLES> T_ADMIN_ROLES_LIST = new List <T_ADMIN_ROLES>();
var query1 = new DapperExQuery <T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, T_ROLES.R_CODE);
T_ADMIN_ROLES_LIST = T_ADMIN_ROLES_BLL.GetAllList(query1);
for (var i = 0; i < T_ADMIN_ROLES_LIST.Count; i++)
{
T_ADMIN_LIST = T_ADMIN_LIST.Where(n => n.A_CODE != T_ADMIN_ROLES_LIST[i].A_CODE).ToList();
}
// 在查询添加之后，获取总记录数
Grid1.RecordCount = Int32.Parse(allcount.ToString());
Grid1.DataSource = T_ADMIN_LIST;
Grid1.DataBind();
}
}
