/// <summary>
/// 获取用户不分页数据列表
/// </summary>
/// <param name="code">编码</param>
/// <param name="type">1：角色 2：岗位</param>
public List <TbUser> GetUserGridList(UserListRequset param)
{
try
{
return(TbUserRoleRepository.GetUserGridList(param));
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 获取用户不分页数据列表
/// </summary>
/// <param name="code">编码</param>
/// <param name="type">1：角色 2：岗位</param>
public static List <TbUser> GetUserGridList(UserListRequset param)
{
var where = new Where <TbUser>();
var userCode = new List <string>();
if (param.type == 1)
{
userCode = TbUserRoleRepository.Query(p => p.RoleCode == param.code).Select(p => p.UserCode).Distinct().ToList();
}
else
{
userCode = Repository <TbPositionUser> .Query(p => p.PositionCode == param.code).Select(p => p.UserCode).Distinct().ToList();
}
if (userCode.Count > 0)
{
where.And(d => d.UserCode.NotIn(userCode));
}
if (!string.IsNullOrEmpty(param.keyword))
{
where.And(d => d.UserCode.Like(param.keyword));
where.Or(d => d.UserName.Like(param.keyword));
}
param.records = Repository <TbUser> .Count(where);
try
{
var orderBy = OrderByOperater.ASC;
if (param.sord.Equals("desc"))
{
orderBy = OrderByOperater.DESC;
}
var orderByClip = new OrderByClip(param.sidx, orderBy);//排序字段
return(Repository <TbUser> .Query(where, orderByClip, param.sord, param.rows, param.page).ToList());
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 获取不分页的用户列表数据
/// </summary>
/// <param name="code">编码</param>
/// <param name="type">1：角色 2：岗位</param>
/// <returns></returns>
public ActionResult GetUserGridList(UserListRequset request)
{
var data = _userRole.GetUserGridList(request);
return(Content(data.ToJson()));
}
