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