public IHttpActionResult UserMaintain([FromUri] UserMaintainModel model)
{
try
{
string name = model.SearchKey == null ? "" : model.SearchKey.ToString();
Expression <Func <v_Jusoft_PcSysUser, bool> > where = w => (string.IsNullOrEmpty(name) || w.Name.Contains(name)) ||
(string.IsNullOrEmpty(name) || w.PsnMobilePhone.Contains(name)) || (string.IsNullOrEmpty(name) || w.DepName.Contains(name));
var List = dbContext.v_Jusoft_PcSysUser.Where(where);
var Data = List.Select(p => new
{
p.id,
p.Name,
p.DepName,
p.PsnMobilePhone,
p.LockoutEnabled,
Roles = dbContext.AC_SysUsers.Where(o => o.Id == p.id).Select(k => new
{
roles = k.AC_SysRoles.Select(s => new
{
s.Name
}).ToList()
}),
}).OrderBy(p => p.id).ToList().ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(Data));
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public object UserMaintain(UserMaintainModel model)
{
ResultPageData rs = new ResultPageData();
try
{
var List = dbContext.v_Jusoft_PcSysUser.Where(p => true);
if (!string.IsNullOrEmpty(model.Name))
{
List = List.Where(p => p.Name.Contains(model.Name));
}
if (!string.IsNullOrEmpty(model.Phone))
{
List = List.Where(p => p.PsnMobilePhone.Contains(model.Phone));
}
var Data = List.Select(p => new
{
p.id,
p.Name,
p.DepName,
p.PsnMobilePhone,
p.LockoutEnabled,
Roles = dbContext.AC_SysUsers.Where(o => o.Id == p.id).Select(k => new
{
roles = k.AC_SysRoles.Select(s => new
{
s.Name
}).ToList()
}),
}).OrderBy(p => p.id).ToPagedList(model.PageIndex, model.PageSize);
rs.Data = Data;
rs.PageIndex = model.PageIndex;
rs.PageCount = Data.PageCount;
rs.HasNextPage = Data.HasNextPage;
rs.TotalItemCount = Data.TotalItemCount;
return(Json(rs));
}
catch (Exception ex)
{
rs.Code = 1001;
rs.strResult = ex.Message;
return(Json(rs));
}
}
