private void buttonUpdate_Click(object sender, EventArgs e)
{
if (listBoxTasks.SelectedItem == null)
{
return;
}
SchemaInfo schemaInfo = listBoxTasks.SelectedItem as SchemaInfo;
TaskManage.Schema schema = null;
try
{
QueryResult qResult = GlobalSetting.DataAccess.Excute("exec SP_GetSchema {0}", new object[] { schemaInfo.SchemaId });
if (qResult.DataSet.Tables[0].Rows.Count > 0)
{
string xmlStr = qResult.DataSet.Tables[0].Rows[0]["Schema"].ToString();
schema = TaskManage.Schema.ConvertFromString(xmlStr);
}
else
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
TaskManage.FrmCreateSchema frmCreateSchema = new TaskManage.FrmCreateSchema();
frmCreateSchema.Text = "Update task scheduler";
frmCreateSchema.SchemaId = schemaInfo.SchemaId;
frmCreateSchema.Schema = schema;
if (frmCreateSchema.ShowDialog() == DialogResult.OK)
{
try
{
GlobalSetting.DataAccess.Excute("exec SP_RemoveSchema {0}", new object[] { schemaInfo.SchemaId });
string xmlStr = frmCreateSchema.Schema.ConvertToString();
GlobalSetting.DataAccess.Excute("exec SP_AddSchema {0}", xmlStr);
List();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
public void Run()
{
Global.UserRightProvider.CanDo(Right.RightItem.ManageDB);
if (Parameters.Count != 1)
{
throw new ArgumentException("Parameter 1 is Schema xml string. ");
}
string xmlStr = Parameters[0];
TaskManage.Schema schema = TaskManage.Schema.ConvertFromString(xmlStr);
ScheduleTaskMgr.ScheduleMgr.Add(schema);
OutputMessage(string.Format("Add schema successul, SchemaId={0}.", schema.SchemaId));
}
