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