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