public JqGridResult <VipMemberItem> SearchVipMembers(VipSearchRequest request, int companyid)
{
var baseResult = string.IsNullOrEmpty(request.Phone) ? this.vipmemberQ.Entities.Where(o => o.CompanyID == companyid) :
this.vipmemberQ.Entities.Where(o => o.CompanyID == companyid && o.PhoneNum.Contains(request.Phone));
int totalCount = baseResult.Count();
var rows = baseResult.OrderBy(o => o.UpdateTime).Skip(request.SkipNum).Take(request.Rows).AsEnumerable().Select(o => new VipMemberItem
{
PhoneNum = o.PhoneNum,
Amount = o.Amount,
Gender = o.Gender ? "男" : "女",
NickName = o.NickName,
UpdateTime = o.UpdateTime.ToString("D"),
Remark = o.Remark,
ID = o.ID
}).ToList();
return(new JqGridResult <VipMemberItem>(request.Rows, request.Page, totalCount, rows));
}
public JsonResult Members(VipSearchRequest searchRequest)
{
var model = this.vipService.SearchVipMembers(searchRequest, this.webContext.CurrentUser.Company.ID);
return(Json(model, JsonRequestBehavior.AllowGet));
}
