public async Task <HttpResponseMessage> ToPlainExcel(ChartRequest request, CancellationToken token)
{
var resultTable = await ChartLogic.ExecuteChartAsync(request, token);
byte[] binaryFile = PlainExcelGenerator.WritePlainExcel(resultTable, QueryUtils.GetNiceName(request.QueryName));
var fileName = request.ChartScript.ToString() + " " + QueryUtils.GetKey(request.QueryName) + TimeZoneManager.Now.ToString("yyyyMMdd-HHmmss") + ".xlsx";
return(FilesController.GetHttpReponseMessage(new MemoryStream(binaryFile), fileName));
}
public async Task <HttpResponseMessage> ToPlainExcel(QueryRequestTS request, CancellationToken token)
{
var queryRequest = request.ToQueryRequest();
ResultTable queryResult = await DynamicQueryManager.Current.ExecuteQueryAsync(queryRequest, token);
byte[] binaryFile = PlainExcelGenerator.WritePlainExcel(queryResult, QueryUtils.GetNiceName(queryRequest.QueryName));
var fileName = request.queryKey + TimeZoneManager.Now.ToString("yyyyMMdd-HHmmss") + ".xlsx";
return(FilesController.GetHttpReponseMessage(new MemoryStream(binaryFile), fileName));
}
public async Task <FileStreamResult> ToPlainExcel([Required, FromBody] QueryRequestTS request, CancellationToken token)
{
var queryRequest = request.ToQueryRequest();
ResultTable queryResult = await QueryLogic.Queries.ExecuteQueryAsync(queryRequest, token);
byte[] binaryFile = PlainExcelGenerator.WritePlainExcel(queryResult, QueryUtils.GetNiceName(queryRequest.QueryName));
var fileName = request.queryKey + TimeZoneManager.Now.ToString("yyyyMMdd-HHmmss") + ".xlsx";
return(FilesController.GetFileStreamResult(new MemoryStream(binaryFile), fileName));
}
public ActionResult ToExcelPlain(QueryRequest request)
{
if (!Finder.IsFindable(request.QueryName))
{
throw new UnauthorizedAccessException(NormalControlMessage.ViewForType0IsNotAllowed.NiceToString().FormatWith(request.QueryName));
}
ResultTable queryResult = DynamicQueryManager.Current.ExecuteQuery(request);
byte[] binaryFile = PlainExcelGenerator.WritePlainExcel(queryResult, QueryUtils.GetNiceName(request.QueryName));
return(File(binaryFile, MimeMapping.GetMimeMapping(".xlsx"), Finder.ResolveWebQueryName(request.QueryName) + ".xlsx"));
}
public async Task <FileStreamResult> ToPlainExcel([Required, FromBody] QueryRequestTS request, CancellationToken token)
{
ExcelPermission.PlainExcel.AssertAuthorized();
var queryRequest = request.ToQueryRequest(SignumServer.JsonSerializerOptions);
ResultTable queryResult = await QueryLogic.Queries.ExecuteQueryAsync(queryRequest, token);
byte[] binaryFile = PlainExcelGenerator.WritePlainExcel(queryResult, QueryUtils.GetNiceName(queryRequest.QueryName));
var fileName = request.queryKey + Clock.Now.ToString("yyyyMMdd-HHmmss") + ".xlsx";
return(FilesController.GetFileStreamResult(new MemoryStream(binaryFile), fileName));
}
public ActionResult ExportData()
{
var request = ExtractChartRequestCtx(null).Value;
if (!Finder.IsFindable(request.QueryName))
{
throw new UnauthorizedAccessException(ChartMessage.Chart_Query0IsNotAllowed.NiceToString().FormatWith(request.QueryName));
}
var resultTable = ChartLogic.ExecuteChartAsync(request, CancellationToken.None).Result;
byte[] binaryFile = PlainExcelGenerator.WritePlainExcel(resultTable, QueryUtils.GetNiceName(request.QueryName));
return(File(binaryFile, MimeMapping.GetMimeMapping(".xlsx"), Finder.ResolveWebQueryName(request.QueryName) + ".xlsx"));
}
public static byte[] ExecutePlainExcel(QueryRequest request, string title)
{
ResultTable queryResult = QueryLogic.Queries.ExecuteQuery(request);
return(PlainExcelGenerator.WritePlainExcel(queryResult, title));
}
public static async Task <byte[]> ExecutePlainExcelAsync(QueryRequest request, string title, CancellationToken token)
{
ResultTable queryResult = await QueryLogic.Queries.ExecuteQueryAsync(request, token);
return(PlainExcelGenerator.WritePlainExcel(queryResult, title));
}
