public ActionResult Index() { //匯出資料欄位 var exportColumns = ExportColumnAttributeHelper <ProductViewModel> .GetExportColumns() .Select(c => new SelectListItem() { Value = c.ColumnName, Text = c.Name, Selected = true }) .ToList(); ViewBag.ExportColumns = exportColumns; //要匯出的資料 var exportData = db.Products.OrderBy(x => x.ProductID).ToList(); Mapper.CreateMap <Product, ProductViewModel>() .ForMember(d => d.SupplierName, o => o.MapFrom(s => s.Supplier.CompanyName)) .ForMember(d => d.CategoryName, o => o.MapFrom(s => s.Category.CategoryName)) .ForMember(d => d.Discontinued, o => o.MapFrom(s => s.Discontinued ? "已停止" : "--")); var result = Mapper.Map <List <ProductViewModel> >(exportData); return(View(result)); }
public ActionResult Index() { //匯出資料欄位 var exportColumns = ExportColumnAttributeHelper <CustomerViewModel> .GetExportColumns() .Select(c => new SelectListItem() { Value = c.ColumnName, Text = c.Name, Selected = true }) .ToList(); ViewBag.ExportColumns = exportColumns; //要匯出的資料 var exportData = db.Customers.OrderBy(x => x.CustomerID).ToList(); Mapper.CreateMap <Customer, CustomerViewModel>(); var result = Mapper.Map <List <CustomerViewModel> >(exportData); return(View(result)); }