public void TestReturnObjectJson()
{
var logica = new EfDatabaseAutomation.Automation.SelectParametrSheme.LogicsSelectAutomation();
logica.SelectUser = "******";
var select = new SelectAll();
// var t = select.SqlModelAutomation<>(logica);
}
/// <summary>
/// Выборка
/// </summary>
/// <param name="sqlSelect">Запрос</param>
/// <returns></returns>
public async Task <string> Select(LogicsSelectAutomation sqlSelect)
{
return(await Task.Factory.StartNew(() =>
{
string model = null;
if (sqlSelect.SelectUser != null)
{
Type type = Type.GetType($"{sqlSelect.FindNameSpace}, {sqlSelect.NameDll}");
model = (string)typeof(SelectAll).GetMethod("SqlModelAutomation")?.MakeGenericMethod(type).Invoke(new SelectAll(), new object[] { sqlSelect });
}
return model;
}));
}
/// <summary>
/// Создание отчета на сервере
/// </summary>
/// <param name="sqlSelect">С генерированный запрос с клиента</param>
/// <returns></returns>
public async Task <Stream> GenerateFileXlsxSqlView(LogicsSelectAutomation sqlSelect)
{
var selectFull = new SelectFull(_parameterConfig.ConnectionString);
return(await Task.Factory.StartNew(() => selectFull.GenerateStreamToSqlViewFile(sqlSelect.SelectUser, "REPORTSQLSERVER", sqlSelect.SelectInfo, _parameterConfig.PathSaveTemplate)));
}