private void ExportMatrixData()
{
WfMatrix matrix = WfMatrixAdapter.Instance.Load(this.ExportKey);
matrix.Loaded = true;
switch (this.ExFormat)
{
case ExportFormat.Xlsx:
Response.Clear();
Response.ClearHeaders();
using (MemoryStream fileSteam = matrix.ExportToExcel2007(this.RoleAsPerson))
{
fileSteam.CopyTo(Response.OutputStream);
}
//Response.BinaryWrite(bytes);
//Response.ContentType = MediaTypeNames.Text.Xml;
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AppendHeader("CONTENT-DISPOSITION", "attachment;filename=" + matrix.ProcessKey + ".xlsx");
Response.Flush();
Response.End();
break;
case ExportFormat.Xml:
WorkbookNode workbook = matrix.ExportToExcelXml(this.RoleAsPerson);
workbook.Response(matrix.ProcessKey);
break;
}
}
private void ExportMatrixDefinition()
{
WfMatrixDefinition definition = WfMatrixDefinitionAdapter.Instance.Load(this.ExportKey);
WorkbookNode workbook = definition.ExportToExcelXml();
workbook.Response(definition.Key);
}
protected void generateMatrixButton_Click(object sender, EventArgs e)
{
WfMatrix matrix = CreateMatrix();
WorkbookNode workbook = matrix.ExportToExcelXml(false);
workbook.Response("Matrix");
}
private void ExportExcelXPXml()
{
SOARolePropertyDefinitionCollection definition = SOARolePropertyDefinitionAdapter.Instance.LoadByRoleID(ExportRoleProperty.DefinitionID);
string PropertySheetName = "Matrix";
WorkbookNode workbook = ExportToExcelXml(definition, PropertySheetName);
SOARole role = new SOARole(definition)
{
ID = RoleID
};
SOARolePropertyRowCollection rows = SOARolePropertiesAdapter.Instance.LoadByRole(role, definition);
if (rows.Count > 0)
{
FillMatrixRowsToWorksheet(workbook, rows);
}
workbook.Response(GetFileNameByRole(RoleID));
}
protected void generateButton_Click(object sender, EventArgs e)
{
WorkbookNode workbook = CreateMatrixDefinition().ExportToExcelXml();
workbook.Response("Matrix");
}
