/// <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));
}
