protected void buttonOK_Click(object sender, EventArgs e) { try { if (CheckInput()) { var scheduleQueryHdrInfo = new ScheduleQueryHdrInfo(); scheduleQueryHdrInfo.sName = this.txtName.Text.Trim(); scheduleQueryHdrInfo.iQueryId = Convert.ToInt32(this.txtQueryId.Text); scheduleQueryHdrInfo.iPageSize = Convert.ToInt32(this.txtPageSize.Text); scheduleQueryHdrInfo.iFontSize = Convert.ToInt32(this.txtFontSize.Text); scheduleQueryHdrInfo.sSql = this.txtSQL.Value.Trim(); if (this.IsModifyAction) { int id; int.TryParse(Request["Iden"], out id); scheduleQueryHdrInfo.iIden = id; QueryHelper.ModifyScheduleQueryHdr(scheduleQueryHdrInfo); Response.Clear(); ClientScript.RegisterStartupScript(this.GetType(), string.Empty, string.Format("<script type=\"text/javascript\">alert('{0}');location.href='{1}';</script>", "修改成功!", Request.Url.PathAndQuery)); } else { scheduleQueryHdrInfo.iIden = QueryHelper.NewIden("smScheduleQueryHdr"); QueryHelper.AddScheduleQueryHdr(scheduleQueryHdrInfo); Response.Clear(); ClientScript.RegisterStartupScript(this.GetType(), string.Empty, string.Format("<script type=\"text/javascript\">alert('{0}');location.href='{1}';</script>", "添加成功!", "AddScheduleQueryHdr.aspx?Action=m&Iden=" + scheduleQueryHdrInfo.iIden.ToString())); } } else { hasError = true; } } catch (System.Exception ex) { hasError = true; errorMsg = ex.Message; } }
public static void AddScheduleQueryHdr(ScheduleQueryHdrInfo scheduleQueryHdrInfo) { var sql = "INSERT dbo.smScheduleQueryHdr(iIden, sName, iQueryId, sSql, iPageSize, iFontSize) values(@iIden, @sName, @iQueryId, @sSql, @iPageSize, @iFontSize)"; var connectionString = WebConfig.GetConnectionString(); var param = new SqlParameter[6]; param[0] = new SqlParameter("@iIden", scheduleQueryHdrInfo.iIden); param[1] = new SqlParameter("@sName", scheduleQueryHdrInfo.sName); param[2] = new SqlParameter("@iQueryId", scheduleQueryHdrInfo.iQueryId); param[3] = new SqlParameter("@sSql", scheduleQueryHdrInfo.sSql); param[4] = new SqlParameter("@iPageSize", scheduleQueryHdrInfo.iPageSize); param[5] = new SqlParameter("@iFontSize", scheduleQueryHdrInfo.iFontSize); SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql, param); }
public static void ModifyScheduleQueryHdr(ScheduleQueryHdrInfo scheduleQueryHdrInfo) { var sql = @" update smScheduleQueryHdr set sName=@sName, iQueryId=@iQueryId, sSql=@sSql, iPageSize=@iPageSize, iFontSize=@iFontSize where iIden=@iIden"; var connectionString = WebConfig.GetConnectionString(); var param = new SqlParameter[6]; param[0] = new SqlParameter("@iIden", scheduleQueryHdrInfo.iIden); param[1] = new SqlParameter("@sName", scheduleQueryHdrInfo.sName); param[2] = new SqlParameter("@iQueryId", scheduleQueryHdrInfo.iQueryId); param[3] = new SqlParameter("@sSql", scheduleQueryHdrInfo.sSql); param[4] = new SqlParameter("@iPageSize", scheduleQueryHdrInfo.iPageSize); param[5] = new SqlParameter("@iFontSize", scheduleQueryHdrInfo.iFontSize); SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql, param); }