/// <summary>
/// Изменяем значения
/// </summary>
/// <param name="dbConnection"></param>
/// <param name="procedureTask"></param>
public static void ChangeProcedureTask(IDbConnection dbConnection,
DbProcedureTask procedureTask)
{
string function = "murr_downloader.change_procedure_task";
dbConnection.Execute(function,
new
{
in_procedure_task_id = procedureTask.ProcedureTaskId,
in_procedure_last_run = procedureTask.ProcedureLastRun,
in_procedure_next_run = procedureTask.ProcedureNextRun
},
commandType: CommandType.StoredProcedure);
}
/// <summary>
/// Добавляем процедуру
/// </summary>
/// <param name="dbConnection"></param>
/// <param name="procedureTask"></param>
/// <returns></returns>
public static long InsertProcedureTask(IDbConnection dbConnection,
DbProcedureTask procedureTask)
{
string function = "murr_downloader.insert_procedure_task";
return(dbConnection.Query <long>(function,
new
{
in_procedure_title = procedureTask.ProcedureTitle,
in_procedure_is_use = procedureTask.ProcedureIsUse,
in_procedure_params = new JsonParameter(procedureTask.ProcedureParams),
in_procedure_template = procedureTask.ProcedureTemplate,
in_procedure_last_run = procedureTask.ProcedureLastRun,
in_procedure_next_run = procedureTask.ProcedureNextRun
},
commandType: CommandType.StoredProcedure)
.First());
}
