/// <summary> /// 根据用户的论坛分值得到用户的等级 /// </summary> /// <param name="UserScore">用户论坛分值</param> /// <returns>用户等级实例</returns> public OnLineTest.Model.UserRank GetModel(Users user) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserRankId,UserRankName,MinScore,MaxScore from UserRank "); strSql.Append(" where @UserScore between MinScore and MaxScore"); SqlParameter[] parameters = { new SqlParameter("@UserScore", SqlDbType.Int, 5) }; parameters[0].Value = user.UserScore; OnLineTest.Model.UserRank model = new OnLineTest.Model.UserRank(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(OnLineTest.Model.UserRank model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(OnLineTest.Model.UserRank model) { return(dal.Add(model)); }