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