protected void buttonOK_Click(object sender, EventArgs e)
{
try
{
if (CheckInput())
{
var scheduleQueryInfo = new ScheduleQueryInfo();
scheduleQueryInfo.sName = this.txtName.Text.Trim();
scheduleQueryInfo.iTimeInterval = Convert.ToInt32(this.txtTimeInterval.Text);
if (this.IsModifyAction)
{
int id;
int.TryParse(Request["Iden"], out id);
scheduleQueryInfo.iIden = id;
QueryHelper.ModifyScheduleQuery(scheduleQueryInfo);
Response.Clear();
ClientScript.RegisterStartupScript(this.GetType(), string.Empty,
string.Format("<script type=\"text/javascript\">alert('{0}');location.href='Default.aspx';</script>", "修改成功!"));
}
else
{
scheduleQueryInfo.iIden = QueryHelper.NewIden("smScheduleQuery");
QueryHelper.AddScheduleQuery(scheduleQueryInfo);
Response.Clear();
ClientScript.RegisterStartupScript(this.GetType(), string.Empty,
string.Format("<script type=\"text/javascript\">alert('{0}');location.href='Default.aspx';</script>", "添加成功!"));
}
}
else
{
hasError = true;
}
}
catch (System.Exception ex)
{
hasError = true;
errorMsg = ex.Message;
}
}
public static void AddScheduleQuery(ScheduleQueryInfo scheduleQueryInfo)
{
var connectionString = WebConfig.GetConnectionString();
string sql = "insert smScheduleQuery(iIden, sName, iTimeInterval) values({0},'{1}',{2})";
SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, string.Format(sql, scheduleQueryInfo.iIden, scheduleQueryInfo.sName, scheduleQueryInfo.iTimeInterval));
}
public static void ModifyScheduleQuery(ScheduleQueryInfo scheduleQueryInfo)
{
var connectionString = WebConfig.GetConnectionString();
string sql = "update smScheduleQuery set sName='{1}', iTimeInterval={2} where iIden={0}";
SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, string.Format(sql, scheduleQueryInfo.iIden, scheduleQueryInfo.sName, scheduleQueryInfo.iTimeInterval));
}
