public HttpResponseMessage ToPlainExcel(QueryRequestTS request)
{
var queryRequest = request.ToQueryRequest();
ResultTable queryResult = DynamicQueryManager.Current.ExecuteQuery(queryRequest);
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 <ResultTable> ExecuteQuery(QueryRequestTS request, CancellationToken token)
{
var result = await DynamicQueryManager.Current.ExecuteQueryAsync(request.ToQueryRequest(), token);
return(result);
}
public async Task <ResultTable> ExecuteQuery([Required, FromBody] QueryRequestTS request, CancellationToken token)
{
var result = await QueryLogic.Queries.ExecuteQueryAsync(request.ToQueryRequest(), token);
return(result);
}
public ResultTable ExecuteQuery(QueryRequestTS request)
{
return DynamicQueryManager.Current.ExecuteQuery(request.ToQueryRequest());
}
public ResultTable ExecuteQuery(QueryRequestTS request)
{
return(DynamicQueryManager.Current.ExecuteQuery(request.ToQueryRequest()));
}