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