Example #1
0
        public int UpdateExamResultAnswerStation(RandomExamResultAnswerStation examResultAnswer)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string    sqlCommand = "USP_Random_EXAM_ANSWER_STA_U";
            DbCommand dbCommand  = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "p_Random_EXAM_result_id", DbType.Int32, examResultAnswer.RandomExamResultID);
            db.AddInParameter(dbCommand, "p_Random_EXAM_item_id", DbType.Int32, examResultAnswer.RandomExamItemID);
            db.AddInParameter(dbCommand, "p_answer", DbType.String, examResultAnswer.Answer);
            db.AddInParameter(dbCommand, "p_exam_time", DbType.Int32, examResultAnswer.ExamTime);
            db.AddInParameter(dbCommand, "p_judge_score", DbType.Decimal, examResultAnswer.JudgeScore);
            db.AddInParameter(dbCommand, "p_judge_status_id", DbType.Int32, examResultAnswer.JudgeStatusID);
            db.AddInParameter(dbCommand, "p_judge_remark", DbType.String, examResultAnswer.JudgeRemark);

            int nRecordAffected = db.ExecuteNonQuery(dbCommand);

            return(nRecordAffected);
        }
Example #2
0
 public int UpdateExamResultAnswerStation(RandomExamResultAnswerStation examResultAnswer)
 {
     return(dal.UpdateExamResultAnswerStation(examResultAnswer));
 }
Example #3
0
 public int AddExamResultAnswerStation(RandomExamResultAnswerStation examResultAnswer)
 {
     return(dal.AddExamResultAnswerStation(examResultAnswer));
 }