/// <summary>
/// 修改试题难度
/// </summary>
/// <param name="itemDifficulty">试题难度</param>
/// <returns>数据库受影响的行数</returns>
public int UpdateItemDifficulty(ItemDifficulty itemDifficulty)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ITEM_DIFFICULTY_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_item_difficulty_id", DbType.Int32, itemDifficulty.ItemDifficultyId);
db.AddInParameter(dbCommand, "p_difficulty_name", DbType.String, itemDifficulty.DifficultyName);
db.AddInParameter(dbCommand, "p_difficulty_value", DbType.String, itemDifficulty.DifficultyValue);
db.AddInParameter(dbCommand, "p_description", DbType.String, itemDifficulty.Description);
db.AddInParameter(dbCommand, "p_is_default", DbType.Int32, itemDifficulty.IsDefault);
db.AddInParameter(dbCommand, "p_memo", DbType.String, itemDifficulty.Memo);
return(db.ExecuteNonQuery(dbCommand));
}
/// <summary>
/// 查询所有试题难度
/// </summary>
/// <param name="bForSearchUse">
/// 是否供查询用，对于：
/// 一、是，则添加一提示项；
/// 二、否，则不添加提示项；
/// </param>
/// <returns>所有试题难度</returns>
public IList <ItemDifficulty> GetItemDifficulties(bool bForSearchUse)
{
if (!bForSearchUse)
{
return(GetItemDifficulties());
}
IList <ItemDifficulty> difficulties = GetItemDifficulties();
ItemDifficulty difficulty = new ItemDifficulty();
difficulty.DifficultyName = "-难度-";
difficulty.ItemDifficultyId = -1;
difficulties.Insert(0, difficulty);
return(difficulties);
}
/// <summary>
/// 按试题难度ID取试题难度
/// </summary>
/// <returns>试题难度</returns>
public ItemDifficulty GetItemDifficulty(int itemDifficultyId)
{
ItemDifficulty itemDifficulty = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ITEM_DIFFICULTY_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_item_difficulty_id", DbType.Int32, itemDifficultyId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
itemDifficulty = CreateModelObject(dataReader);
break;
}
}
return(itemDifficulty);
}
/// <summary>
/// 修改试题难度
/// </summary>
/// <param name="itemDifficulty">试题难度</param>
/// <returns>数据库受影响的行数</returns>
public int UpdateItemDifficulty(ItemDifficulty itemDifficulty)
{
return(dal.UpdateItemDifficulty(itemDifficulty));
}
public int DeleteItemDifficulty(ItemDifficulty itemDifficulty)
{
return(DeleteItemDifficulty(itemDifficulty.ItemDifficultyId));
}
/// <summary>
/// 新增试题难度
/// </summary>
/// <param name="itemDifficulty">试题难度</param>
/// <returns>数据库受影响的行数</returns>
public int AddItemDifficulty(ItemDifficulty itemDifficulty)
{
return(dal.AddItemDifficulty(itemDifficulty));
}
