public ActionResult DownloadReport(ActivitySignUpListViewModel model)
{
model.activity = db.activity.Where(x => x.sqno == model.activitySqno).FirstOrDefault();
IQueryable <ActivitySignUp> query = db.activitySignUp.Where(x => x.activitysqno == model.activitySqno);
if (model.searchText != null && model.searchText.Trim().Length > 0)
{
query = query.Where(x =>
x.name.Contains(model.searchText) ||
x.email1.Contains(model.searchText) ||
x.email2.Contains(model.searchText) ||
x.mobile.Contains(model.searchText) ||
x.phone.Contains(model.searchText));
}
List <ActivitySignUp> list = query.OrderBy(x => x.sqno).ToList();
MemoryStream memoryStream = new MemoryStream();
try
{
ActivitySignUpListReport report = new ActivitySignUpListReport();
IWorkbook wb = report.create(list);
wb.Write(memoryStream);
}
catch (Exception e)
{
ViewBag.ErrorMessage = e.Message;
}
return(File(memoryStream.ToArray(), "application/vnd.ms-excel", "報名列表.xls"));
}
public ActionResult SignUpList(int sqno)
{
ActivitySignUpListViewModel model = new ActivitySignUpListViewModel();
model.activitySqno = sqno;
return(SignUpList(model));
}
public ActionResult SignUpList(ActivitySignUpListViewModel model)
{
model.activity = db.activity.Where(x => x.sqno == model.activitySqno).FirstOrDefault();
IQueryable <ActivitySignUp> query = db.activitySignUp.Where(x => x.activitysqno == model.activitySqno);
if (model.searchText != null && model.searchText.Trim().Length > 0)
{
query = query.Where(x =>
x.name.Contains(model.searchText) ||
x.email1.Contains(model.searchText) ||
x.email2.Contains(model.searchText) ||
x.mobile.Contains(model.searchText) ||
x.phone.Contains(model.searchText));
}
model.activitySignUpPagedList = query.OrderBy(x => x.sqno).ToPagedList(model.pageNumber - 1, model.pageSize);
return(View(model));
}
