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