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