public List <WJ_Customer> GetCustomerList(WJ_CustomerFilter filter, out int total) { using (DataProvider dp = new DataProvider()) { var list = dp.WJ_Customer.Where(m => true); if (filter.CusName.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.CusName.Contains(filter.CusName)); } if (filter.PhoneNo.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.PhoneNo.Contains(filter.PhoneNo)); } total = list.Count(); return(list.OrderByDescending(m => m.RegTime).ThenByDescending(m => m.CreateTime).Skip(filter.Skip).Take(filter.PageSize).ToList()); } }
public ActionResult GetCustomerList(WJ_CustomerFilter filter) { var data = service.GetCustomerList(filter, out int total); return(Json(new TableDataModel(total, data))); }