public ActionResult Index()
{
var model = new MemberSearchViewModel();
return View(model);
}
public ActionResult getall(MemberSearchViewModel model, int page = 1, int rows = 10)
{
var query = MemberService.GetALL().Include(x => x.Department).Include(x => x.Group).Include(x => x.JobTitleCate);
if (!string.IsNullOrEmpty(model.Member_SearchName))
{
query = query.Where(x => x.NickName.Contains(model.Member_SearchName));
}
var count = query.Count();
var data = query.Select(x => new MemberListViewModel()
{
MemberID = x.MemberID,
MemberType = x.MemberType,
Mobile = x.Mobile,
Mobile1 = x.Mobile1,
Email = x.Email,
NickName = x.NickName,
AvtarUrl = x.AvtarUrl,
GroupID = x.GroupID,
GroupName = x.Group.Name,
DepartmentID = x.DepartmentID,
DepartmentName = x.Department.Name,
JobTitleID = x.JobTitleID,
JobTitleName = x.JobTitleCate.CateName,
IsLeader = x.IsLeader,
LastTime = x.LastTime,
LastIP = x.LastIP,
AddTime = x.AddTime,
OpenType = x.OpenType,
OpenID = x.OpenID,
AddIP = x.AddIP,
LoginCount = x.LoginCount,
Status = x.Status,
Sex = x.Sex,
AddBirthDay = x.AddBirthDay,
IsLeap = x.IsLeap,
BirthDay = x.BirthDay,
BirthDay1 = x.BirthDay1,
CityCode = x.CityCode,
CityCodeValue = x.CityCodeValue,
RealName = x.RealName,
Phone = x.Phone,
QQ = x.QQ,
MSN = x.MSN,
Address = x.Address,
Lat = x.Lat,
Lng = x.Lng,
Description = x.Description,
IDNumber = x.IDNumber,
JobExp = x.JobExp,
StudyExp = x.StudyExp,
FamilySituation = x.FamilySituation,
})
.OrderBy(x => x.MemberID)
.Skip((page - 1) * rows)
.Take(rows).ToList();
var obj = new
{
rows = data,
total = count
};
return Json(obj);
}