private object PageUser(HttpContext context, PagedUserArgs <UserInfo> query) { var server = context.GetInstanceFromItems <UserRoleBLL>(); query = server.List(query); var json = new Json(query); json.ClassName = string.Empty; return(json.ToJsonString()); }
/// <summary> /// 根据角色 取用户 /// </summary> /// <param name="context"></param> /// <returns></returns> private object PageUser(HttpContext context) { var query = new PagedUserArgs <UserInfo>(); query.PageIndex = context.Request.Form["PageIndex"].ToInt32(1); query.PageSize = context.Request.Form["PageSize"].ToInt32(10); query.NameIn = context.Request.Form["Name"]; query.Role = context.Request.Form["Role"].ToInt64(); query.IsInRole = context.Request.Form["IsIn"].ToInt32() > 0; return(this.PageUser(context, query)); }
private string PageUser(HttpContext context) { PagedUserArgs <UserInfo> query = new PagedUserArgs <UserInfo>(); query.PageIndex = context.Request.Form["PageIndex"].ToInt32(1); query.PageSize = context.Request.Form["PageSize"].ToInt32(10); query.NameIn = context.Request.Form["Name"].Trim(); var server = context.GetInstanceFromItems <UserBLL>(); query = server.List(query); var json = new Json(query); json.ClassName = ""; return(json.ToJsonString()); }
private string PageResult(HttpContext context) { PagedUserArgs <UserInfo> query = new PagedUserArgs <UserInfo>(); query.PageIndex = context.Request.Form["PageIndex"].ToInt32(1); query.PageSize = context.Request.Form["PageSize"].ToInt32(20); query.NameIn = context.Request.Form["Name"].Trim(); query.FullNameIn = context.Request.Form["FullName"].Trim(); query.Sex = context.Request.Form["Sex"].ToInt32(0); var server = context.GetInstanceFromCache <UserBLL>(); //server.SavePassword(1000, "admin"); query = server.List(query); var json = new Json(query); json.ClassName = ""; return(json.ToJsonString()); }
public PagedUserArgs <UserInfo> List(PagedUserArgs <UserInfo> query) { if (query == null) { query = new PagedUserArgs <UserInfo>(); } var db = this.GetDatabase(); IQueryable <UserInfo> rs = this.GetQueryable(query, db.UserInfo); query.ResultCount = rs.Count(); rs = rs.OrderByDescending(item => item.Id); if (query.PageIndex > 0 && query.PageSize > 0) { rs = rs.Skip((query.PageIndex - 1) * query.PageSize).Take(query.PageSize); } query.Results = rs.ToArray(); var dataTable = new System.Data.DataTable(); dataTable.Columns.Add("Id", Int64.MinValue.GetType()); dataTable.Columns.Add("Name", string.Empty.GetType()); dataTable.Columns.Add("FullName", string.Empty.GetType()); foreach (var data in query.Results) { var dataRow = dataTable.NewRow(); dataRow["Id"] = data.Id; dataRow["Name"] = data.Name; dataRow["FullName"] = data.FullName; dataTable.Rows.Add(dataRow); } var array = dataTable.ToArray <UserInfo>(); var list = dataTable.ToList <UserInfo>(); return(query); }
public PagedUserArgs <UserInfo> List(PagedUserArgs <UserInfo> query) { if (query == null) { return(new PagedUserArgs <UserInfo>()); } var db = this.GetDatabase(); var rs = db.UserInfo.Where(item => 1 == 1); if (!string.IsNullOrEmpty(query.NameIn)) { rs = rs.Where(item => item.Name.Contains(query.NameIn)); } if (query.IsInRole) { rs = rs.Where(item => db.UserRole.Any(obj => obj.User == item.Id && obj.Role == query.Role)); } else { rs = rs.Where(item => !db.UserRole.Any(obj => obj.User == item.Id && obj.Role == query.Role)); } query.ResultCount = rs.Count(); rs = rs.OrderByDescending(item => item.Id); if (query.PageIndex > 0 && query.PageSize > 0) { rs = rs.Skip((query.PageIndex - 1) * query.PageSize).Take(query.PageSize); } query.Results = rs.ToArray(); return(query); }
public IQueryable <UserInfo> GetQueryable(PagedUserArgs <UserInfo> query, IQueryable <UserInfo> rs) { if (query == null) { return(rs); } if (!string.IsNullOrEmpty(query.NameIn)) { rs = rs.Where(item => item.Name.Contains(query.NameIn)); } if (!string.IsNullOrEmpty(query.FullNameIn)) { rs = rs.Where(item => item.FullName.Contains(query.FullNameIn)); } if (query.Sex > 0) { rs = rs.Where(item => item.Sex == query.Sex); } return(rs); }
public PagedUserArgs <UserInfo> List(PagedUserArgs <UserInfo> query) { return(UserDAL.List(query)); }