public List <WJ_AppointmentModel> GetAppointmentList(WJ_AppointmentFilter filter, out int total) { using (DataProvider dp = new DataProvider()) { var list = from a in dp.WJ_Appointment join b in dp.WJ_Tender on a.TenderId equals b.Id select new WJ_AppointmentModel { Id = a.Id, PersonName = a.PersonName, ContactTel = a.ContactTel, ContactEmail = a.ContactEmail, OrderTime = a.OrderTime, OrderMessage = a.OrderMessage, BelongType = a.BelongType, CreateTime = a.CreateTime, TenderName = b.ProName }; if (filter.PersonName.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.PersonName.Contains(filter.PersonName)); } if (filter.ContactTel.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.ContactTel.Contains(filter.ContactTel)); } if (filter.ContactEmail.IsNotNullOrWhiteSpace()) { list = list.Where(m => m.ContactTel.Contains(filter.ContactEmail)); } total = list.Count(); return(list.OrderByDescending(m => m.CreateTime).Skip(filter.Skip).Take(filter.PageSize).ToList()); } }
public ActionResult GetAppointmentList(WJ_AppointmentFilter filter) { var data = service.GetAppointmentList(filter, out int total); return(Json(new TableDataModel(total, data))); }