/**********************************************************
 * 說明：發言信息類Message
 * 作者：
 * 創建日期：
 *********************************************************/

using System;
using System.Data;

using MyChatRoom.DataAccessLayer;

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

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

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

            return ds;
        }

        /// <summary>
        /// 向數據庫中添加一條留言信息
        /// </summary>
        /// <param name="userName">用戶名</param>
        /// <param name="createTime">留言時間</param>
        /// <param name="content">留言內容</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();		//實例化一個Database類

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

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