using HNWD.Pregrant.Model;
using System.Collections.Generic;

namespace HNWD.Pregrant.DataAccess
{
    public class WD_MessageInfoDataAccess : GenericDataAccess<WD_MessageInfo>
    {
        private WD_MessageInfo wd_MessageInfo = null;

        public WD_MessageInfoExt ext = new WD_MessageInfoExt();

        private WD_MessageInfoDataAccess(WD_MessageInfo wd_MessageInfo)
        {
            this.wd_MessageInfo = wd_MessageInfo;
        }

        private readonly static WD_MessageInfoDataAccess wd_MessageInfoDataAccess = new WD_MessageInfoDataAccess(null);
        private readonly static object lockobj = new object();

        public static WD_MessageInfoDataAccess GetInstance()
        {
            lock (lockobj)
            {
                return wd_MessageInfoDataAccess;
            }
        }

        public List<WD_MessageInfo> QueryAll()
        {
            string strSql = " select TOP 5 [MESSAGE_CONTENT],[MESSAGE_DATETIME] from [WD_MessageInfo] order by [ID] DESC ";

            ext.messageDataList = this.Query(strSql, new WD_MessageInfo());
            ext.messageDataList.ForEach(f => f.bSuccess = this.bSuccess);
            ext.messageDataList.ForEach(f => f.Code = this.Code);
            ext.messageDataList.ForEach(f => f.Message = this.Message);
            ext.messageDataList.ForEach(f => f.Rows = this.Rows);

            ext.bSuccess = this.bSuccess;
            ext.Code = this.Code;
            ext.Message = this.Message;
            ext.Rows = this.Rows;

            return ext.messageDataList;
        }
    }
}