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)));
}
