/// <summary>
/// G
/// </summary>
/// <returns></returns>
public async Task <string> ServerList(FullSetting setting)
{
var connect = setting.Db == "Work" ? _parametrService.ConectWork : _parametrService.ConectTest;
var selectfull = new SelectFull();
return(await Task.Factory.StartNew(() => selectfull.SqlSelect(connect, setting)));
}
/// <summary>
/// Обработка всех комманд с сервера и возврат данных надо тестить
/// </summary>
/// <param name="command">WCf модель взаимодействия с сайтом</param>
/// <returns></returns>
public async Task <string> ModelSqlSelect(AngularModel command)
{
var connect = command.Db == "Work" ? _parametrService.ConectWork : _parametrService.ConectTest;
var selectfull = new SelectFull();
return(await Task.Factory.StartNew(() => selectfull.SqlSelect(connect, command)));
}
/// <summary>
/// Выгрузка сводной таблицы
/// </summary>
/// <param name="inn">ИНН</param>
/// <returns></returns>
public async Task <Stream> LoadFileSummarySales(string inn)
{
return(await Task.Factory.StartNew(() =>
{
var selectFull = new SelectFull(_parameterConfig.ConnectionString);
return selectFull.GenerateSummarySales(_parameterConfig.PathSaveTemplate, inn);
}));
}
//Функции для сайта IFNS
public async Task <Face> SqlFaceError()
{
var selectfull = new SelectFull();
return
(await Task.Factory.StartNew(
() =>
selectfull.FaceError(_parametrService.ConnectionString,
SqlLibaryIfns.SqlSelect.SqlFaceMergin.FaceSelectError.FaceError)));
}
/// <summary>
/// Подгрузка БДК Статистики
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public async Task <string> LoaderBdk(FullSetting setting)
{
var selectfull = new SelectFull();
switch (setting.Db)
{
case "Work":
var sqlconnect = new SqlConnectionType();
return
(await Task.Factory.StartNew(
() =>
selectfull.BdkSqlSelect(_parametrService.ConectWork,
((ServiceWcf)
sqlconnect.SelectFullParametrSqlReader(_parametrService.ConectWork,
ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf),
ModelSqlFullService.ParamCommand("7"))).ServiceWcfCommand.Command)));
default:
return(null);
}
}
/// <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)));
}
/// <summary>
/// Получение выборки для генерации командя на сайте
/// </summary>
/// <param name="setting">Параметры</param>
/// <returns></returns>
public async Task <string> ModelServiceCommand(FullSetting setting)
{
var selectfull = new SelectFull();
return(await Task.Factory.StartNew(() => selectfull.ServiceCommand(_parametrService.ConectWork, setting)));
}
