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