void IResultWriter.AfterExecuteReader(int fieldCount)
{
_logResultWriter.AfterExecuteReader(fieldCount);
var fileName = Path.GetTempFileName() + ".xlsx";
_excelPackage = new ExcelPackage(new FileInfo(fileName));
}
private void ExecuteReader(AsyncDataAdapterCommand asyncDataAdapterCommand, IDbCommand command)
{
_resultWriter.BeforeExecuteReader(asyncDataAdapterCommand);
IDataReader dataReader = null;
try
{
dataReader = command.ExecuteReader();
var fieldCount = dataReader.FieldCount;
_resultWriter.AfterExecuteReader(fieldCount);
var tableIndex = 0;
while (!_thread.IsStopRequested)
{
if (fieldCount > 0)
{
var schemaTable = dataReader.GetSchemaTable();
if (schemaTable != null)
{
Log.Trace("schemaTable:\r\n{0}", schemaTable.ToStringTableString());
if (asyncDataAdapterCommand.Query != null)
{
Parser.ParseResult(asyncDataAdapterCommand.Query.Results[tableIndex], out var name, out var fieldName);
schemaTable.TableName = name;
}
}
ReadTable(dataReader, schemaTable, tableIndex);
}
if (_rowCount >= _maxRecords || !dataReader.NextResult())
{
break;
}
tableIndex++;
}
}
finally
{
if (dataReader != null)
{
dataReader.Close();
var recordsAffected = dataReader.RecordsAffected;
_resultWriter.AfterCloseReader(recordsAffected);
}
}
}
void IResultWriter.AfterExecuteReader(int fieldCount) => _logResultWriter.AfterExecuteReader(fieldCount);
void IResultWriter.AfterExecuteReader(int fieldCount)
{
_logResultWriter.AfterExecuteReader(fieldCount);
DataSet = new DataSet();
}
void IResultWriter.AfterExecuteReader(int fieldCount)
{
_logResultWriter.AfterExecuteReader(fieldCount);
isJsonAuto = fieldCount == 1;
}