/// <summary> /// Ð޸Ŀ¼ÊÔÆÀ·Ö״̬ /// </summary> /// <param name="examJudgeStatus">¿¼ÊÔÆÀ·Ö״̬</param> /// <returns>Êý¾Ý¿âÊÜÓ°ÏìµÄÐÐÊý</returns> public int UpdateExamJudgeStatus(ExamJudgeStatus examJudgeStatus) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_EXAM_JUDGE_STATUS_U"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_exam_judge_status_id", DbType.Int32, examJudgeStatus.ExamJudgeStatusId); db.AddInParameter(dbCommand, "p_status_name", DbType.String, examJudgeStatus.StatusName); db.AddInParameter(dbCommand, "p_description", DbType.String, examJudgeStatus.Description); db.AddInParameter(dbCommand, "p_is_default", DbType.Int32, examJudgeStatus.IsDefault); db.AddInParameter(dbCommand, "p_score_rate", DbType.Decimal, examJudgeStatus.ScoreRate); db.AddInParameter(dbCommand, "p_memo", DbType.String, examJudgeStatus.Memo); return(db.ExecuteNonQuery(dbCommand)); }
/// <summary> /// °´¿¼ÊÔÆÀ·Ö״̬IDÈ¡¿¼ÊÔÆÀ·Ö״̬ /// </summary> /// <param name="examJudgeStatusId">¿¼ÊÔÆÀ·Ö״̬ID</param> /// <returns>¿¼ÊÔÆÀ·Ö״̬</returns> public ExamJudgeStatus GetExamJudgeStatus(int examJudgeStatusId) { ExamJudgeStatus examJudgeStatus = null; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_EXAM_JUDGE_STATUS_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_exam_judge_status_id", DbType.Int32, examJudgeStatusId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { examJudgeStatus = CreateModelObject(dataReader); break; } } return(examJudgeStatus); }
/// <summary> /// Ð޸Ŀ¼ÊÔÆÀ·Ö״̬ /// </summary> /// <param name="examJudgeStatus">¿¼ÊÔÆÀ·Ö״̬</param> /// <returns>Êý¾Ý¿âÊÜÓ°ÏìµÄÐÐÊý</returns> public int UpdateExamJudgeStatus(ExamJudgeStatus examJudgeStatus) { return(dal.UpdateExamJudgeStatus(examJudgeStatus)); }
/// <summary> /// ÐÂÔö¿¼ÊÔÆÀ·Ö״̬ /// </summary> /// <param name="examJudgeStatus">¿¼ÊÔÆÀ·Ö״̬</param> /// <returns>Êý¾Ý¿âÊÜÓ°ÏìµÄÐÐÊý</returns> public int AddExamJudgeStatus(ExamJudgeStatus examJudgeStatus) { return(dal.AddExamJudgeStatus(examJudgeStatus)); }