/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { if (txtGradeCheckApplyReasonTitle.Text.Trim().Length == 0) { Javascript.GoHistory(-1, "请输入重修重考原因标题:)", Page); } else { DalOperationAboutGradeCheckApplyReason dal = new DalOperationAboutGradeCheckApplyReason(); StudentsGradeCheckApplyReason model = new StudentsGradeCheckApplyReason(); model.gradeCheckApplyReasonTitle = txtGradeCheckApplyReasonTitle.Text.Trim(); model.gradeCheckApplyReasonRemark = txtGradeCheckApplyReasonRemark.Text.Trim(); try { dal.Add(model);//添加 Javascript.RefreshParentWindow("添加重修重考原因成功!", "/Administrator/StudentManager.aspx?fragment=3", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "添加重修重考原因失败,请检查格式是否有误:(", Page); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(StudentsGradeCheckApplyReason model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into usta_StudentsGradeCheckApplyReason("); strSql.Append("gradeCheckApplyReasonTitle,gradeCheckApplyReasonRemark)"); strSql.Append(" values ("); strSql.Append("@gradeCheckApplyReasonTitle,@gradeCheckApplyReasonRemark);"); SqlParameter[] parameters = { new SqlParameter("@gradeCheckApplyReasonTitle", SqlDbType.NVarChar,50), new SqlParameter("@gradeCheckApplyReasonRemark", SqlDbType.NVarChar,200)}; parameters[0].Value = model.gradeCheckApplyReasonTitle; parameters[1].Value = model.gradeCheckApplyReasonRemark; return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(StudentsGradeCheckApplyReason model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update usta_StudentsGradeCheckApplyReason set "); strSql.Append("gradeCheckApplyReasonTitle=@gradeCheckApplyReasonTitle,"); strSql.Append("gradeCheckApplyReasonRemark=@gradeCheckApplyReasonRemark"); strSql.Append(" where gradeCheckApplyReasonId=@gradeCheckApplyReasonId"); SqlParameter[] parameters = { new SqlParameter("@gradeCheckApplyReasonTitle", SqlDbType.NVarChar,50), new SqlParameter("@gradeCheckApplyReasonRemark", SqlDbType.NVarChar,200), new SqlParameter("@gradeCheckApplyReasonId", SqlDbType.Int,4)}; parameters[0].Value = model.gradeCheckApplyReasonTitle; parameters[1].Value = model.gradeCheckApplyReasonRemark; parameters[2].Value = model.gradeCheckApplyReasonId; int rows = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }