/// <summary>
/// 查询列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public FuncResult Select(SearchSysUserInfo model)
{
IOrderedQueryable <SysUserInfo> query = _context.SysUserInfo.
Where(a =>
(
(string.IsNullOrWhiteSpace(model.User_Account) || a.UserAccount.Contains(model.User_Account)) &&
(string.IsNullOrWhiteSpace(model.User_Name) || a.UserName.Contains(model.User_Name))
)
).OrderByDescending(e => e.CreationDate);
int total = query.Count();
var data = query.Skip(model.limit * model.page).Take(model.limit).ToList().Select(e => new
{
User_Id = e.UserId,
User_Account = e.UserAccount,
User_Name = e.UserName,
User_Org_Id = e.UserOrgId,
User_Group_Names = e.UserGroupNames,
User_Email = e.UserEmail,
User_Password = e.UserPassword,
User_Mobile_No = e.UserMobile,
CreationDate = e.CreationDate.ToString("yyyy-MM-dd HH:mm:ss")
});
return(new FuncResult()
{
IsSuccess = true, Content = new { data, total }
});
}
public FuncResult Select([FromBody] SearchSysUserInfo model)
{
model.page--; if (model.page < 0)
{
model.page = 0;
}
return(userInfoService.Select(model));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public FuncResult Select(SearchSysUserInfo model)
{
IOrderedQueryable <SysUserInfo> query = _context.SysUserInfos.
Where(a =>
(
(string.IsNullOrWhiteSpace(model.User_Account) || a.User_Account.Contains(model.User_Account)) &&
(string.IsNullOrWhiteSpace(model.User_Name) || a.User_Name.Contains(model.User_Name)) &&
(model.User_Is_Ldap == null || a.User_Is_Ldap == model.User_Is_Ldap) &&
(model.User_Ower == null || model.User_Ower == 0 || a.User_Ower == (UserOwerType)model.User_Ower)
)
).OrderByDescending(e => e.Creation_Date);
int total = query.Count();
var data = query.Skip(model.limit * model.page).Take(model.limit).ToList().Select(e => new
{
e.User_Id,
e.User_Account,
e.User_Name,
e.User_Org_Id,
e.User_Group_Names,
e.User_Email,
e.User_Is_Ldap,
e.User_Password,
e.User_Is_Lock,
e.User_Mobile_No,
User_Ower = e.User_Ower.GetDescription(),
e.Language_Code,
Eff_Start_Date = e.Eff_Start_Date.ToShortDateString(),
Eff_End_Date = e.Eff_End_Date.ToShortDateString(),
Creation_Date = e.Creation_Date.ToShortDateString()
});
return(new FuncResult()
{
IsSuccess = true, Content = new { data, total }
});
}
