public ActionResult GetExcel(CustomersQueryViewModel cond = null) { using (var wb = GetExcelFile(cond)) { // Add ClosedXML.Extensions in your using declarations return(wb.Deliver($"ExportCustomer_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx")); } }
private XLWorkbook GetExcelFile(CustomersQueryViewModel cond = null) { List <CustomersViewModel> list = CustomerRepo.Search(cond.Query, cond.Paging, cond.Sort).Select(x => new CustomersViewModel() { Address = x.地址, ClientName = x.客戶名稱, CompanyNumber = x.統一編號, CustomerTypeName = x.客戶類別.類別名稱, Email = x.Email, Fax = x.傳真, Phone = x.電話, Id = x.Id }).ToList(); return(ClosedXmlHelper.ToClosedXmlExcel(list)); }
public ActionResult Index(CustomersQueryViewModel cond = null) { CustomersQueryViewModel result = new CustomersQueryViewModel(); if (cond == null) { //預設排序 result.Sort.Column = "Id"; result.Sort.Sort = "desc"; } var customerList = CustomerRepo.Search(cond.Query, cond.Paging, cond.Sort).Select(x => new CustomersViewModel() { Address = x.地址, ClientName = x.客戶名稱, CompanyNumber = x.統一編號, CustomerTypeName = x.客戶類別.類別名稱, Email = x.Email, Fax = x.傳真, Phone = x.電話, Id = x.Id }); result.Paging.Count = CustomerRepo.SearchCount(cond.Query); result.Customers = new StaticPagedList <CustomersViewModel>(customerList, cond.Paging.Page, cond.Paging.Take, result.Paging.Count); result.CustomerTypeList = CustomerTypeRepo.All().ToList().Select(x => new SelectListItem() { Text = x.類別名稱, Value = x.Id.ToString(), Selected = cond != null ? cond.Query.CustomerTypeId.HasValue ? x.Id == cond.Query.CustomerTypeId.Value ? true : false : false : false }).ToList(); result.Paging.Take = cond.Paging.Take; result.Query = cond.Query; return(View(result)); }