/**********************************************************
 * 說(shuō)明：發(fā)言信息類Message
 * 作者：
 * 創(chuàng)建日期：
 *********************************************************/

using System;
using System.Data;

using MyChatRoom.DataAccessLayer;

namespace MyChatRoom.BusinessLogicLayer
{
	/// <summary>
	/// Message 的摘要說(shuō)明。
	/// </summary>
	public class Message
	{

		/// <summary>
		/// 獲取事件最近的10條發(fā)言
		/// </summary>
		public static DataSet LoadTop10()
		{
			Database db=new Database();		//實(shí)例化一個(gè)Database類

			string sql="Select top 10 * from [Message] order by CreateTime desc";
			DataSet ds=db.GetDataSet(sql);//利用Database類的GetDataSet方法查詢最近的10條發(fā)言

			return ds;
		}

		/// <summary>
		/// 向數(shù)據(jù)庫(kù)中添加一條留言信息
		/// </summary>
		/// <param name="userName">用戶名</param>
		/// <param name="createTime">留言時(shí)間</param>
		/// <param name="content">留言內(nèi)容</param>
		/// <param name="color">顏色</param>
		/// <param name="emotion">表情</param>
		public void Add(string userName,string createTime,string content,string color,string emotion)
		{
			Database db=new Database();		//實(shí)例化一個(gè)Database類

			string sql="Insert Into [Message] Values( "
				+"'"+userName+"',"
				+"'"+createTime+"',"
				+"'"+content+"',"
				+"'"+color+"',"
				+"'"+emotion+"')";

			db.ExecuteSQL(sql);	//利用Database類的GetDataRow方法查詢用戶數(shù)據(jù)
		}
	}
}