public bool UpdateScheduler(QuartzSchedulerModel model) { int count = 0; string sql = @"UPDATE Quartz_Scheduler SET SchedulerName=@SchedulerName ,Directory=@Directory ,FileName=@FileName ,Port=@Port WHERE SchedulerId=@SchedulerId"; SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@SchedulerId", model.SchedulerId), new SqlParameter("@SchedulerName", model.SchedulerName), new SqlParameter("@Directory", model.Directory), new SqlParameter("@FileName", model.FileName), new SqlParameter("@Port", model.Port) }; using (SqlConnection conn = new SqlConnection(DBConnection.ConnectionString)) { SqlCommand cmd = new SqlCommand(sql, conn); foreach (var p in ps) { cmd.Parameters.Add(p); } conn.Open(); count = cmd.ExecuteNonQuery(); conn.Close(); } return(count > 0); }
public ActionResult SaveScheduler(QuartzSchedulerModel model) { bool success = true; CallbackModel result; var dal = new SchedulerDAL(); try { if (dal.CheckSchedulerNameExists(model.SchedulerName, model.SchedulerId)) { return(Json(new CallbackModel(false, "SchedulerName必须唯一"))); } if (model.SchedulerId <= 0) { success = dal.AddScheduler(model); } else { success = dal.UpdateScheduler(model); } string msg = "保存成功"; if (success == false) { msg = "保存失败"; } return(Json(new CallbackModel(success, msg))); } catch (Exception ex) { return(Json(new CallbackModel(success, ex.Message))); } }
public bool AddScheduler(QuartzSchedulerModel model) { int count = 0; string sql = @"INSERT INTO Quartz_Scheduler( SchedulerName ,Directory ,FileName ,Port) VALUES ( @SchedulerName ,@Directory ,@FileName ,@Port )"; SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@SchedulerName", model.SchedulerName), new SqlParameter("@Directory", model.Directory), new SqlParameter("@FileName", model.FileName), new SqlParameter("@Port", model.Port), new SqlParameter("@IsEnable", model.IsEnable) }; using (SqlConnection conn = new SqlConnection(DBConnection.ConnectionString)) { SqlCommand cmd = new SqlCommand(sql, conn); foreach (var p in ps) { cmd.Parameters.Add(p); } conn.Open(); count = cmd.ExecuteNonQuery(); conn.Close(); } return(count > 0); }