public ActionResult ExportUserVoteStatistics()
{
var filter = SerializeHelper.JsonDeserializeFixed <ExportFilter>(Request.Form["queryString"]);
var result = _basisService.SearchUserVoteItem(filter.voteid);
var tables = new List <DataTable>
{
DataMapper.ListToDataTable(result)
};
var columns = new List <List <ColumnData> >
{
new List <ColumnData>
{
new ColumnData {
FieldName = "content", Width = 20, Title = "选项内容", HorizontalAlignment = HorizAlignments.Centered, VerticalAlignment = VertiAlignments.Centered
},
new ColumnData {
FieldName = "ext_val", Width = 20, Title = "选项备注", HorizontalAlignment = HorizAlignments.Centered, VerticalAlignment = VertiAlignments.Centered
},
new ColumnData {
FieldName = "username", Width = 20, Title = "用户姓名", HorizontalAlignment = HorizAlignments.Centered, VerticalAlignment = VertiAlignments.Centered
},
new ColumnData {
FieldName = "create_time", Width = 20, Title = "投票时间", ValueFormat = "yyyy-MM-dd", HorizontalAlignment = HorizAlignments.Centered, VerticalAlignment = VertiAlignments.Centered
},
}
};
string fileName = string.Empty;
var excelExport = new ExcelFileExporter();
byte[] excelByte = excelExport.CreateFile(tables, new List <string>()
{
"投票明细"
}, columns, null, out fileName, "投票明细");
fileName = "投票明细.xls";
return(File(new MemoryStream(excelByte), "application/ms-excel", fileName));
}
