public IActionResult DataManageExport(DataManageSearch dataManage) { var properties = new PropertyByName <DataManage>[] { new PropertyByName <DataManage>("Id", d => d.Id), new PropertyByName <DataManage>("ProductNum", d => d.ProductNum), new PropertyByName <DataManage>("DataType", d => d.DataType), new PropertyByName <DataManage>("DataAddress", d => d.DataAddress), new PropertyByName <DataManage>("Count", d => d.Count), new PropertyByName <DataManage>("Remark", d => d.Remark), new PropertyByName <DataManage>("OrderId", d => d.OrderId) }; var result = _unitOfWork.GetRepository <DataManage>().GetEntities(); if (!string.IsNullOrEmpty(dataManage.ProductNum)) { result = result.Where(i => i.ProductNum.Contains(dataManage.ProductNum)); } var bytes = _exportImportService.ExportToXlsx(properties, result); return(File(bytes, MimeTypes.TextXlsx, "DataManage.xlsx")); }
public IActionResult Export() { var properties = new PropertyByName <DataManage>[] { new PropertyByName <DataManage>("Id", d => d.Id), new PropertyByName <DataManage>("Name", d => d.ProductNum), new PropertyByName <DataManage>("Age", d => d.Count) }; var list = new List <DataManage>() { new DataManage() { Id = 1, ProductNum = "wenqing1", Count = 18 }, new DataManage() { Id = 2, ProductNum = "wenqing2", Count = 19 }, new DataManage() { Id = 3, ProductNum = "wenqing3", Count = 20 }, new DataManage() { Id = 4, ProductNum = "wenqing4", Count = 21 }, new DataManage() { Id = 5, ProductNum = "wenqing5", Count = 22 } }; var bytes = _exportImportService.ExportToXlsx(properties, list); return(File(bytes, MimeTypes.TextXlsx, "DataManage.xlsx")); }