/// <summary> /// Вытаскиваем внутреннею команду с сайта /// </summary> /// <param name="setting">Параметры</param> /// <returns></returns> private ServiceWcf Service(FullSetting setting) { var sqlConnect = new SqlConnectionType(); return ((ServiceWcf) sqlConnect.SelectFullParametrSqlReader(ConnectionString, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(setting.Id.ToString()))); }
/// <summary> /// Вытягивание выборки на сайт для подставления в нее параметров данных /// </summary> /// <param name="conectionstring">Строка соединения</param> /// <param name="setting">Параметры настройки</param> /// <returns></returns> public string ServiceCommand(string conectionstring, FullSetting setting) { var sqlconnect = new SqlConnectionType(); SerializeJson serializeJson = new SerializeJson(); return(serializeJson.JsonLibary( (ServiceWcf) sqlconnect.SelectFullParametrSqlReader(conectionstring, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(setting.ParamService.IdCommand.ToString())))); }
/// <summary> /// Подгрузка БДК Статистики /// </summary> /// <param name="setting"></param> /// <returns></returns> public async Task <string> LoaderBdk(FullSetting setting) { var selectFull = new SelectFull(_parameterService.ConectWork); switch (setting.Db) { case "Work": var sqlconnect = new SqlConnectionType(); return (await Task.Factory.StartNew( () => selectFull.BdkSqlSelect( ((ServiceWcf) sqlconnect.SelectFullParametrSqlReader(_parameterService.ConectWork, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("7"))).ServiceWcfCommand.Command))); default: return(null); } }
/// <summary> /// Данные которые будут раскладываться на шаблоне /// </summary> /// <param name="conectionstring">Строка соединения с сервером</param> /// <param name="connecttestsqlcommand">Строка соединения с таблицей комманд для запроса данных</param> /// <param name="setting">Настроики пользователя</param> /// <returns></returns> public Report ReportBdk(string conectionstring, string connecttestsqlcommand, FullSetting setting) { try { var sqlconnect = new SqlConnectionType(); Dictionary <string, string> listparametr = new Dictionary <string, string>(); GenerateParametrSql.GenerateParametrSql sql = new GenerateParametrSql.GenerateParametrSql(); if (setting.ParametrBdkOut.D85DateStart != DateTime.MinValue) { sql.CreateParamert(ref listparametr, setting.ParametrBdkOut.GetType(), setting.ParametrBdkOut); } return((Report)sqlconnect.SelectFullParametrSqlReader(conectionstring, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connecttestsqlcommand, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("11"))).ServiceWcfCommand.Command, typeof(Report), listparametr)); } catch (Exception e) { Loggers.Log4NetLogger.Error(e); } return(null); }
/// <summary> /// Процедуры предпроверки /// </summary> /// <param name="connection">Строка соединения</param> /// <param name="seting">Настройки</param> /// <returns></returns> public async Task <string> TaskSqlProcedureSoprovod(string connection, FullSetting seting) { var sqlconnect = new SqlConnectionType(); GenerateParametrSql.GenerateParametrSql sql = new GenerateParametrSql.GenerateParametrSql(); Dictionary <string, string> listparametr = new Dictionary <string, string>(); if (seting.ParamPredproverka.N441 != 0) { sql.CreateParamert(ref listparametr, seting.ParamPredproverka.GetType(), seting.ParamPredproverka); } switch (seting.Id) { case 1: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("15"))).ServiceWcfCommand.Command, listparametr))); case 2: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("16"))).ServiceWcfCommand.Command, listparametr))); case 3: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("17"))).ServiceWcfCommand.Command, listparametr))); default: return(null); } }
/// <summary> /// Выбор процедуры в зависимости от настроек: /// 1 - Процедура добавления значения на добавления а название под ун 3 /// 2 - Процедура запуска процесса решений а название под ун 4 /// 3 - Процедура запуска инкассовых поручений а название под ун 5 /// Процесс генерации параметров для процедуры нужно улучшить!!!! /// </summary> /// <param name="connection">Строка соединения</param> /// <param name="seting">Настойки</param> /// <returns>Строка с ответа с сервера</returns> public async Task <string> TaskSqlProcedure(string connection, FullSetting seting) { var sqlconnect = new SqlConnectionType(); Dictionary <string, int> listparametr = new Dictionary <string, int>(); if (seting.ParametrReshen.D270 != 0) { listparametr.Add("@D270", seting.ParametrReshen.D270); } switch (seting.Id) { case 1: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("3"))).ServiceWcfCommand.Command, listparametr))); case 2: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("4"))).ServiceWcfCommand.Command, listparametr))); case 3: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("5"))).ServiceWcfCommand.Command, listparametr))); default: return(null); } }
public async Task <DataSet> TaskSqlProcedureKam5(string connection, FullSetting seting) { var sqlconnect = new SqlConnectionType(); GenerateParametrSql.GenerateParametrSql sql = new GenerateParametrSql.GenerateParametrSql(); Dictionary <string, string> listparametr = new Dictionary <string, string>(); if (seting.ReportRvs.Qvartal != 0) { sql.CreateParamert(ref listparametr, seting.ReportRvs.GetType(), seting.ReportRvs); } switch (seting.ParamService.IdCommand) { case 28: return(await await Task.Factory.StartNew(() => sqlconnect.ProcedureReturnTable(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(seting.ParamService.IdCommand.ToString()))).ServiceWcfCommand.Command, seting.ModelUser.UserNameGuide, listparametr))); default: return(null); } }
/// <summary> /// Процедуры выполнения создания КРСБ /// </summary> /// <param name="connection">Строка соединения</param> /// <param name="seting">Настройки</param> /// <returns></returns> public async Task <string> TaskSqlProcedureKrsb(string connection, FullSetting seting) { var sqlconnect = new SqlConnectionType(); Dictionary <string, dynamic> listparametr = new Dictionary <string, dynamic>(); if (seting.DeloCreate.DateDelo != System.DateTime.MinValue) { listparametr.Add("@DateStart", seting.DeloCreate.DateDelo.Date); } if (seting.DeloCreate.D3979 != 0) { listparametr.Add("@D3979", seting.DeloCreate.D3979); } if (!String.IsNullOrWhiteSpace(seting.DeloCreate.Okato)) { listparametr.Add("@Okato", seting.DeloCreate.Okato); } switch (seting.ParamService.IdCommand) { case 22: if (seting.DeloPriem.DelaPriem.Count > 0) { //Добавляем в таблицу данные для дальнейшего анализа AddKrsb krsb = new AddKrsb(); krsb.CreateDeloAnalizKrsb(seting.DeloPriem.DelaPriem); } return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(seting.ParamService.IdCommand.ToString()))).ServiceWcfCommand.Command, listparametr))); case 23: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(seting.ParamService.IdCommand.ToString()))).ServiceWcfCommand.Command, listparametr))); case 24: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(seting.ParamService.IdCommand.ToString()))).ServiceWcfCommand.Command, listparametr))); case 25: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(seting.ParamService.IdCommand.ToString()))).ServiceWcfCommand.Command, listparametr))); case 27: return(await Task.Factory.StartNew(() => sqlconnect.StartingProcedure(connection, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(connection, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand(seting.ParamService.IdCommand.ToString()))).ServiceWcfCommand.Command, listparametr))); default: return(null); } }
/// <summary> /// Создание процесса Прием КРСБ Наследника Массово /// </summary> /// <param name="conectstring">Строка соединения</param> /// <param name="setting">Настройки</param> /// <returns></returns> public string CreateKrsb(string conectstring, FullSetting setting) { try { var delocreate = new AddKrsb(); var sqlconnect = new SqlConnectionType(); SerializeJson serializeJson = new SerializeJson(); if (setting.DeloPriem.DelaPriem.Count > 0) { delocreate.CreateDelo(setting.DeloPriem.DelaPriem); sqlconnect.StartingProcedure <string, string>(conectstring, ((ServiceWcf) sqlconnect.SelectFullParametrSqlReader(conectstring, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("19"))).ServiceWcfCommand.Command); return(serializeJson.JsonLibary((CreateDela)sqlconnect.SelectFullParametrSqlReader <string, string>(conectstring, ((ServiceWcf) sqlconnect.SelectFullParametrSqlReader(conectstring, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("20"))).ServiceWcfCommand.Command, typeof(CreateDela)))); } Loggers.Log4NetLogger.Error(new Exception("Нет дел для создания процессов!!!")); return(null); } catch (Exception e) { Loggers.Log4NetLogger.Error(e); return(null); } }
/// <summary> /// Выгрузка модели телефонного справочника /// </summary> /// <param name="logic">Логика выборки</param> /// <param name="listparametr">Параметры</param> /// <returns>Возвращает объект для превращения его в схему</returns> public object GenerateSchemeXsdSql <TKey, TValue>(LogicaSelect logic, Dictionary <TKey, TValue> listparametr = null) { var sqlConnect = new SqlConnectionType(); switch (logic.Id) { case 10: TelephoneHelp telephoneHelp = new TelephoneHelp { TelephonHeaders = ((TelephoneHelp)sqlConnect.SelectFullParametrSqlReader(ConnectionString, logic.SelectUser, typeof(TelephoneHelp), ModelSqlFullService.ParamCommand("1"))).TelephonHeaders, TelephonBody = ((TelephoneHelp) sqlConnect.SelectFullParametrSqlReader(ConnectionString, logic.SelectUser, typeof(TelephoneHelp), ModelSqlFullService.ParamCommand("2"))).TelephonBody }; return(telephoneHelp); case 12: Book book = new Book { BareCodeBook = new BareCodeBook(), Organization = ((Book)sqlConnect.SelectFullParametrSqlReader(ConnectionString, logic.SelectUser, typeof(Book), listparametr)).Organization }; return(book); default: return(null); } }
/// <summary> /// Шаблон который используем написано кустарно нужно давать Ун шаблона на вход!!! /// </summary> /// <param name="conectionstring">Строка соединения</param> /// <param name="setting">Параметры шаблона</param> /// <returns></returns> public Document Template(string conectionstring, FullSetting setting) { var sqlconnect = new SqlConnectionType(); Dictionary <string, string> listparametr = new Dictionary <string, string>(); GenerateParametrSql.GenerateParametrSql sql = new GenerateParametrSql.GenerateParametrSql(); if (setting.UseTemplate.IdTemplate != 0) { sql.CreateParamert(ref listparametr, setting.UseTemplate.GetType(), setting.UseTemplate); } return((Document)sqlconnect.SelectFullParametrSqlReader(conectionstring, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(conectionstring, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("10"))).ServiceWcfCommand.Command, typeof(Document), listparametr)); }
/// <summary> /// Возвращает название инспекции по номеру инспекции FullSetting.Inspection.Number /// </summary> /// <param name="conectionstring">Строка соединения</param> /// <param name="N279">Номер инспекции</param> /// <returns>Название инспекции</returns> public Insp Inspection(string conectionstring, string N279) { var sqlconnect = new SqlConnectionType(); Dictionary <string, string> listparametr = new Dictionary <string, string>(); listparametr.Add("@N279", N279); return((Insp)sqlconnect.SelectFullParametrSqlReader(conectionstring, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(conectionstring, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("30"))).ServiceWcfCommand.Command, typeof(Insp), listparametr)); }
/// <summary> /// Выбор файла для передачи /// </summary> /// <param name="path">Путь к файлу</param> /// <param name="filename">Имя файла</param> /// <param name="conectionstring">Строка соединения с БД для формирования таблицы</param> /// <returns></returns> public async Task <Stream> SelectDonloadsFile(string path, string filename, string conectionstring = null, DataSet dataSet = null) { var sqlconnect = new SqlConnectionType(); var xlsx = new ReportExcel(); switch (filename) { case "Требования.xlsx": if (File.Exists(Path.Combine(path, filename))) { return (await Task.Factory.StartNew <Stream>( () => DonloadFile(Path.Combine(path, filename)))); } return(null); case "Бдк.xlsx": xlsx.ReportSave(path, "Бдк", "Бдк", sqlconnect.ReportQbe(conectionstring, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(conectionstring, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("6"))).ServiceWcfCommand.Command)); if (File.Exists(Path.Combine(path, filename))) { return (await Task.Factory.StartNew <Stream>( () => DonloadFile(Path.Combine(path, filename)))); } xlsx.Dispose(); return(null); case "Истребование.xlsx": xlsx.ReportSave(path, "Истребование", "Не доделки по документам", sqlconnect.ReportQbe(conectionstring, ((ServiceWcf)sqlconnect.SelectFullParametrSqlReader(conectionstring, ModelSqlFullService.ProcedureSelectParametr, typeof(ServiceWcf), ModelSqlFullService.ParamCommand("18"))).ServiceWcfCommand.Command)); if (File.Exists(Path.Combine(path, filename))) { return (await Task.Factory.StartNew <Stream>( () => DonloadFile(Path.Combine(path, filename)))); } xlsx.Dispose(); return(null); case "Камеральный №5.xlsx": xlsx.ReportSave(path, "Камеральный №5", "Отчет", dataSet); if (File.Exists(Path.Combine(path, filename))) { return (await Task.Factory.StartNew <Stream>( () => DonloadFile(Path.Combine(path, filename)))); } xlsx.Dispose(); return(null); default: return(null); } }