/// <summary> /// 添加专业类型 /// </summary> /// <param name="specility">专业信息</param> public void AddStudentSpecility(StudentSpecility specility) { try { string strSql = "insert into usta_StudentSpecility("; strSql += "specilityName) "; strSql += " values ("; strSql += "@specilityName)"; SqlParameter[] parameters = { new SqlParameter("@specilityName", SqlDbType.NVarChar,50)}; parameters[0].Value = specility.specilityName; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
/// <summary> /// 修改学生专业 /// </summary> /// <param name="specility">学生专业</param> public void UpdateStudentSpecility(StudentSpecility specility) { try { string strSql = "update usta_StudentSpecility set specilityName=@specilityName where specilityId=@specilityId"; SqlParameter[] parameters = new SqlParameter[2]{ new SqlParameter("@specilityId",specility.specilityId), new SqlParameter("@specilityName",specility.specilityName), }; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
/// <summary> /// 根据专业主键查找 /// </summary> /// <param name="specilityeId">专业主键</param> /// <returns>专业信息</returns> public StudentSpecility FindStudentSpecilityById(int specilityeId) { StudentSpecility model = null; string commandstring = "select specilityId,specilityName from usta_StudentSpecility where specilityId=@specilityId"; SqlParameter[] parameters = new SqlParameter[1]{new SqlParameter("@specilityId",specilityeId) }; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, commandstring, parameters); if (dr.Read()) { model = new StudentSpecility { specilityId = int.Parse(dr["specilityId"].ToString().Trim()), specilityName = dr["specilityName"].ToString().Trim() }; } dr.Close(); conn.Close(); return model; }