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