/// <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> /// Шаблон который используем написано кустарно нужно давать Ун шаблона на вход!!! /// </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> /// Данные которые будут раскладываться на шаблоне /// </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); }
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); } }