public async Task <TData <List <UserEntity> > > GetPageList(UserListParam param, Pagination pagination) { TData <List <UserEntity> > obj = new TData <List <UserEntity> >(); if (param?.DepartmentId != null) { param.ChildrenDepartmentIdList = await departmentBLL.GetChildrenDepartmentIdList(null, param.DepartmentId.Value); } else { OperatorInfo user = await Operator.Instance.Current(); param.ChildrenDepartmentIdList = await departmentBLL.GetChildrenDepartmentIdList(null, user.DepartmentId.Value); } obj.Data = await userService.GetPageList(param, pagination); List <UserBelongEntity> userBelongList = await userBelongService.GetList(new UserBelongEntity { UserIds = obj.Data.Select(p => p.Id.Value).ParseToStrings <long>() }); List <DepartmentEntity> departmentList = await departmentService.GetList(new DepartmentListParam { Ids = userBelongList.Select(p => p.BelongId.Value).ParseToStrings <long>() }); foreach (UserEntity user in obj.Data) { user.DepartmentName = departmentList.Where(p => p.Id == user.DepartmentId).Select(p => p.DepartmentName).FirstOrDefault(); } obj.Total = pagination.TotalCount; obj.Tag = 1; return(obj); }
public JsonResult List([FromUri] UserListParam p) { var total = 0; var list = bll.List(p, out total); return(base.List(total, list.Select(o => new { ID = o.ID, Username = o.Username, Password = "******", Name = o.Name, Sex = o.Sex, DeptID = o.Dept == null ? 0 : o.Dept.ID, DeptName = o.Dept == null ? "" : o.Dept.Name, RoleID = o.Role == null ? 0 : o.Role.ID, RoleName = o.Role == null ? "" : o.Role.Name, Duty = o.Duty, Phone = o.Phone, Email = o.Email, Birthday = o.Birthday == null ? "" : o.Birthday.Value.ToString("yyyy-MM-dd"), Address = o.Address, FaceUrl = o.FaceUrl, AddTime = o.AddTime, Sort = o.Sort, Status = o.Status, Comment = o.Comment }).ToList <object>())); }
public async Task <IActionResult> GetPageListJson(UserListParam param, Pagination pagination) { // 测试总共23条数据 int total = 23; TData <List <UserEntity> > obj = new TData <List <UserEntity> >(); obj.TotalCount = total; obj.Result = new List <UserEntity>(); int id = (pagination.PageIndex - 1) * pagination.PageSize + 1; for (int i = id; i <= pagination.PageIndex * pagination.PageSize; i++) { if (i > total) { break; } obj.Result.Add(new UserEntity { Id = i, RealName = "用户" + i, Mobile = "15612345678", Email = "*****@*****.**", Birthday = DateTime.Now.ToString("yyyy-MM-dd"), LoginCount = new Random().Next(1, 100), UserStatus = i % 2 }); } obj.Tag = 1; return(Json(obj)); }
public async Task <List <UserEntity> > GetList(UserListParam param, OperatorInfo user) { var expression = ListFilter(param, user); var list = await this.BaseRepository().FindList(expression); return(list.ToList()); }
public async Task <TData <List <UserEntity> > > GetPageListJson([FromQuery] UserListParam param, [FromQuery] Pagination pagination) { var obj = await _userBLL.GetPageList(param, pagination); return(obj); }
public async Task <List <UserEntity> > GetPageList(UserListParam param, Pagination pagination) { var expression = ListFilter(param); var list = await this.BaseRepository().FindList(expression, pagination); return(list.ToList()); }
public async Task <IActionResult> GetPageListJson(UserListParam param, Pagination pagination) { OperatorInfo opuser = await Operator.Instance.Current(); TData <List <UserEntity> > obj = await userBLL.GetPageList(param, pagination, opuser); return(Json(obj)); }
public async Task <TData <List <UserEntity> > > GetList(UserListParam param) { TData <List <UserEntity> > obj = new TData <List <UserEntity> >(); obj.Data = await userService.GetList(param); obj.Tag = 1; return(obj); }
public async Task <TData <List <UserEntity> > > GetPageList(UserListParam param, Pagination pagination, OperatorInfo opuser, PlatformEnum platformEnum = PlatformEnum.Web) { TData <List <UserEntity> > obj = new TData <List <UserEntity> >(); if (platformEnum == PlatformEnum.Web) { if (param?.DepartmentId != null) { param.ChildrenDepartmentIdList = await departmentBLL.GetChildrenDepartmentIdList(null, param.DepartmentId.Value); } else { OperatorInfo user = await Operator.Instance.Current(); param.ChildrenDepartmentIdList = await departmentBLL.GetChildrenDepartmentIdList(null, user.DepartmentId.Value); } } obj.Data = await userService.GetPageList(param, pagination, opuser); if (platformEnum == PlatformEnum.Web) { List <UserBelongEntity> userBelongList = await userBelongService.GetList(new UserBelongEntity { UserIds = obj.Data.Select(p => p.Id.Value).ParseToStrings <long>() }); List <DepartmentEntity> departmentList = await departmentService.GetList(new DepartmentListParam { Ids = userBelongList.Select(p => p.BelongId.Value).ParseToStrings <long>() }); foreach (UserEntity user in obj.Data) { user.DepartmentName = departmentList.Where(p => p.Id == user.DepartmentId).Select(p => p.DepartmentName).FirstOrDefault(); } } else { foreach (UserEntity user in obj.Data) { List <UserBelongEntity> userBelongList = await userBelongService.GetList(new UserBelongEntity { UserId = user.Id }); List <UserBelongEntity> roleBelongList = userBelongList.Where(p => p.BelongType == UserBelongTypeEnum.Role.ParseToInt()).ToList(); if (roleBelongList.Count > 0) { user.RoleIds = string.Join(",", roleBelongList.Select(p => p.BelongId).ToList()); await GetRoleCodes(user); } } } obj.PageTotal = pagination.TotalPage; obj.Total = pagination.TotalCount; obj.Tag = 1; return(obj); }
public async Task <IActionResult> ExportUserJson(UserListParam param) { TData <string> obj = new TData <string>(); TData <List <UserEntity> > userObj = await userBLL.GetList(param); if (userObj.Tag == 1) { string file = new ExcelHelper <UserEntity>().ExportToExcel("用户列表.xls", "用户列表", userObj.Data, new string[] { "UserName", "RealName", "Gender", "Mobile", "Email" }); obj.Data = file; obj.Tag = 1; } return(Json(obj)); }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="p"></param> /// <param name="total"></param> /// <returns></returns> public IList <User> List(UserListParam p, out int total) { ICriterion query = Restrictions.Gt("Status", -1); // 用户名、姓名 if (!string.IsNullOrEmpty(p.name)) { var query1 = Restrictions.Like("Username", p.name, MatchMode.Anywhere); var query2 = Restrictions.Like("Name", p.name, MatchMode.Anywhere); var query3 = Restrictions.Or(query1, query2); query = Restrictions.And(query, query3); } // 部门 if (p.DeptID != null && p.DeptID != 0) { var query1 = Restrictions.Eq("Dept", new Dept { ID = p.DeptID.Value }); query = Restrictions.And(query, query1); } // 角色 if (p.RoleID != null && p.RoleID != 0) { var query1 = Restrictions.Eq("Role", new Role { ID = p.RoleID.Value }); query = Restrictions.And(query, query1); } // 状态 if (p.Status != null) { var query1 = Restrictions.Eq("Status", p.Status.Value); query = Restrictions.And(query, query1); } var list = dal.List(p.firstResult, p.maxResults, out total, query); return(list); }
/// <summary> /// 带条件查询所有 /// </summary> public async Task <List <UserEntity> > GetList(UserListParam param) { #region 查询条件 var query = _userEntityDB.AsQueryable(); /* * // 用户名 * if (!string.IsNullOrEmpty(param.UserName)) * query = query.Where(p => p.UserName.Contains(param.UserName)); * */ #endregion var data = await query.ToListAsync(); return(data); }
/// <summary> /// 分页查询 /// </summary> public async Task <List <UserEntity> > GetPageList(UserListParam param, Pagination pagination) { #region 查询条件 var query = _userEntityDB.AsQueryable(); // 用户名 if (!string.IsNullOrEmpty(param.UserName)) { query = query.Where(p => p.UserName.Contains(param.UserName)); } var q = from a in query join b in _departmentEntityDB.AsQueryable() on a.DepartmentId equals b.Id into ab from b in ab.DefaultIfEmpty() select new UserEntity { Id = a.Id, Birthday = a.Birthday, CreateTime = a.CreateTime, DepartmentId = a.DepartmentId, Email = a.Email, Gender = a.Gender, IsSystem = a.IsSystem, Mobile = a.Mobile, Remark = a.Remark, UserName = a.UserName, UserStatus = a.UserStatus, RealName = a.RealName, DepartmentName = b == null ? string.Empty : b.DepartmentName }; var data = await query.OrderByDescending(a => a.Id) .ToPagedListAsync(pagination.PageIndex, pagination.PageSize); #endregion // 分页参数赋值 pagination.TotalCount = data.TotalCount; return(data.Items.ToList()); }
private Expression <Func <UserEntity, bool> > ListFilter(UserListParam param) { var expression = LinqExtensions.True <UserEntity>(); if (param != null) { if (!string.IsNullOrEmpty(param.UserName)) { expression = expression.And(t => t.UserName.Contains(param.UserName)); } if (!string.IsNullOrEmpty(param.UserIds)) { long[] userIdList = TextHelper.SplitToArray <long>(param.UserIds, ','); expression = expression.And(t => userIdList.Contains(t.Id.Value)); } if (!string.IsNullOrEmpty(param.Mobile)) { expression = expression.And(t => t.Mobile.Contains(param.Mobile)); } if (param.UserStatus > -1) { expression = expression.And(t => t.UserStatus == param.UserStatus); } if (!string.IsNullOrEmpty(param.StartTime.ParseToString())) { expression = expression.And(t => t.BaseModifyTime >= param.StartTime); } if (!string.IsNullOrEmpty(param.EndTime.ParseToString())) { param.EndTime = (param.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime(); expression = expression.And(t => t.BaseModifyTime <= param.EndTime); } if (param.ChildrenDepartmentIdList != null && param.ChildrenDepartmentIdList.Count > 0) { expression = expression.And(t => param.ChildrenDepartmentIdList.Contains(t.DepartmentId.Value)); } } return(expression); }
public Task <List <UserEntity> > GetList(UserListParam param) { var list = GetBaseList(); return(list); }
private Expression <Func <UserEntity, bool> > ListFilter(UserListParam param, OperatorInfo user) { var expression = LinqExtensions.True <UserEntity>(); if (param != null) { if (!user.IsAdminOrDev) { expression = expression.And(t => t.ParentId == user.UserId); } if (param.CurUserId > 0) { expression = expression.And(t => t.Id != (long)param.CurUserId); } if (!string.IsNullOrEmpty(param.UserName)) { expression = expression.And(t => t.UserName.Contains(param.UserName)); } if (!string.IsNullOrEmpty(param.UserIds)) { long[] userIdList = TextHelper.SplitToArray <long>(param.UserIds, ','); expression = expression.And(t => userIdList.Contains(t.Id.Value)); } if (!string.IsNullOrEmpty(param.Mobile)) { expression = expression.And(t => t.Mobile.Contains(param.Mobile)); } if (param.UserStatus > -1) { expression = expression.And(t => t.UserStatus == param.UserStatus); } if (!string.IsNullOrEmpty(param.StartTime.ParseToString())) { expression = expression.And(t => t.BaseModifyTime >= param.StartTime); } if (!string.IsNullOrEmpty(param.EndTime.ParseToString())) { param.EndTime = (param.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime(); expression = expression.And(t => t.BaseModifyTime <= param.EndTime); } if (param.ChildrenDepartmentIdList != null && param.ChildrenDepartmentIdList.Count > 0) { expression = expression.And(t => param.ChildrenDepartmentIdList.Contains(t.DepartmentId.Value)); } string delegetZoneId = ""; if (!string.IsNullOrEmpty(param.Provoice.ParseToString()) && param.Provoice.ParseToString() != "-1") { delegetZoneId = param.Provoice; } if (!string.IsNullOrEmpty(param.City.ParseToString()) && param.City.ParseToString() != "-1") { delegetZoneId = "-" + param.City; } if (!string.IsNullOrEmpty(param.Xian.ParseToString()) && param.Xian.ParseToString() != "-1") { delegetZoneId = "-" + param.Xian; } if (!string.IsNullOrEmpty(delegetZoneId)) { expression = expression.And(t => t.DelegetZoneId.Contains(delegetZoneId)); } } return(expression); }
public async Task <IActionResult> GetPageListJson(UserListParam param, Pagination pagination) { TData <List <UserEntity> > obj = await userBLL.GetPageList(param, pagination); return(Json(obj)); }
public async Task <TData <List <UserEntity> > > GetListJson([FromQuery] UserListParam param) { var obj = await _userBLL.GetList(param); return(obj); }