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