/// <summary> /// modify QuartzSetting /// </summary> /// <param name="quartzSetting"></param> /// <returns></returns> public bool ModifyQuartzSetting(QuartzSetting quartzSetting) { var sql = @"UPDATE quartzsettings SET keyname=@keyname, typename=@typename, cronexpression=@cronexpression, validate=@validate WHERE id=@id;" ; using (var con = new SqlConnection(_connectionString)) { return(con.Execute(sql, quartzSetting) > 0); } }
/// <summary> /// add QuartzSetting /// </summary> /// <param name="quartzSetting">QuartzSetting</param> /// <returns></returns> public bool AddQuartzSetting(QuartzSetting quartzSetting) { var sql = @"INSERT INTO quartzsettings( keyname, typename, cronexpression, validate,createon) VALUES (@keyname, @typename, @cronexpression, @validate,@createon);" ; using (var con = new SqlConnection(_connectionString)) { quartzSetting.CreateOn = DateTime.Now; return(con.Execute(sql, quartzSetting) > 0); } }
public IActionResult ModifyQuartzSetting([FromBody] QuartzSetting QuartzSetting) { try { _logger.LogInformation($"modify Quartzsetting,keyname={QuartzSetting.KeyName}"); return(new JsonResult(new { result = true, data = _quartzProvider.ModifyQuartzSetting(QuartzSetting) })); } catch (Exception exc) { _logger.LogCritical(exc, exc.Message); return(new JsonResult(new { result = false, message = exc.Message })); } }