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