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