public static ReviewsInfo GetRatingAndReviewInfo(AdvisorDetailInfo detailInfo)
{
RatingAndReviewManager ratingAndReviewManager = new RatingAndReviewManager();
ReviewsInfo reviewseviewsInfo = ratingAndReviewManager.GetReviewsInfoForAdvisor(detailInfo);
ratingAndReviewManager.GetReviews(reviewseviewsInfo);
ReviewsPaging reviewaPaging = new ReviewsPaging();
reviewaPaging.SortType = ReviewsPaging.SortTypeNone;
ratingAndReviewManager.SortReviews(reviewseviewsInfo, reviewaPaging);
return(reviewseviewsInfo);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ReviewsInfo model)
{
string sql = "UPDATE [Reviews] SET [NewsID] = @0,[ReviewContent] = @1,[ReviewName] = @2,[Email] = @3,[replyID] = @4 WHERE [ID]=@5";
int rows = DBHelp.ExecuteNonQuery(sql, DBHelp.Databasetype.SQL2005.ToString(), CommandType.Text, model.NewsID, model.ReviewContent, model.ReviewName, model.Email, model.replyID, model.ID);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ReviewsInfo model)
{
string sql = "insert into Reviews([NewsID],[ReviewContent],[ReviewName],[Email],[replyID])" +
" values (@0,@1,@2,@3,@4) select @@identity";
object obj = DBHelp.ExecuteScalar(sql, DBHelp.Databasetype.SQL2005.ToString(), CommandType.Text, model.NewsID, model.ReviewContent, model.ReviewName, model.Email, model.replyID);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ReviewsInfo GetModel(int ID)
{
string sql = "select top 1 * from Reviews where [ID]=@0";
ReviewsInfo model = new ReviewsInfo();
DataSet ds = DBHelp.ExecteDataSet(sql, DBHelp.Databasetype.SQL2005.ToString(), CommandType.Text, ID);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void GetReviewByID(string userid)
{
//建立数据库连接
MySqlConnection conn = new MySqlConnection(connStr);
try
{ //建立连接，打开数据库
conn.Open();
string sqlstr =
"SELECT ReviewID,RRating,Content FROM Reviews WHERE Uid = @para1";
MySqlCommand cmd = new MySqlCommand(sqlstr, conn);
//通过设置参数的形式给SQL 语句串值
cmd.Parameters.AddWithValue("para1", userid);
//cmd.Parameters.AddWithValue("para2", password);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string ReviewID = reader.GetString(0);
int ReviewRating = reader.GetInt32(1);
string ReviewContent = reader.GetString(2);
ReviewsInfo tmp = new ReviewsInfo()
{
UserID = userid, ReviewRating = ReviewRating, ReviewContent = ReviewContent, ReviewID = ReviewID
};
reviewlist.Add(tmp);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
conn.Close(); //关闭连接
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ReviewsInfo DataRowToModel(DataRow row)
{
ReviewsInfo model = new ReviewsInfo();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["NewsID"] != null && row["NewsID"].ToString() != "")
{
model.NewsID = int.Parse(row["NewsID"].ToString());
}
if (row["ReviewContent"] != null)
{
model.ReviewContent = row["ReviewContent"].ToString();
}
if (row["ReviewName"] != null)
{
model.ReviewName = row["ReviewName"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["replyID"] != null && row["replyID"].ToString() != "")
{
model.replyID = int.Parse(row["replyID"].ToString());
}
}
return(model);
}
