public void DownInteraction(ReqGetReportViewPage req)
{
req.Page = new ReqPage();
#region 第一个文件
var item = ReportBo.GetCommentItem(req.ItemId, req.CreatedBy, req.PublishDate, req.Page);
var FileName = "第一个文件名称";
DataTable dt = new DataTable();//创建的第一个table
dt.TableName = "第一个文件名称";
dt.Columns.Add("列名");
foreach (var data in item.Items)
{
var dr = dt.NewRow();
dr["列名"] = data.CName;//赋值
dt.Rows.Add(dr);
}
#endregion
#region 第二个文件名称
var itemView = ReportBo.GetViewItem(req.ItemId, req.CreatedBy, req.PublishDate, req.Page);
DataTable dtView = new DataTable();//创建的第二个table
dtView.TableName = "第二个文件名称";
dtView.Columns.Add("列名");
foreach (var data in itemView.Items)
{
var dr = dtView.NewRow();
dr["列名"] = data.CName;
dtView.Rows.Add(dr);
}
#endregion
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.Tables.Add(dtView);
MemoryStream stream = new MemoryStream();
OpenXMLExcel.CreateExcelDocument(stream, ds);
Response.WriteDownloadStream(FileName, stream);
}