using Cksoft.Data;
using DllEapEntity;
using System;
using System.Collections.Generic;
using System.Text;

namespace DllEapDal
{
     public class AnnouncementDal
    {
        private IDatabase CurrDb = null;

        public AnnouncementDal(IDatabase db)
        {
            CurrDb = db;
        }

        public string Update(Announcement announcement)
        {

           int i= CurrDb.UpdateFor<Announcement>(announcement, string.Empty);
            if (i==1)
            {
                return "修改成功";
            }else return "修改失败";
        }

        public string Add(Announcement announcement)
        {
            int i= CurrDb.InsertFor<Announcement>(announcement, string.Empty);
            if (i== 1)
            {
                return "新增成功";
            }else return "新增失败";
        }

        public IEnumerable<Announcement> Get()
        {
            string sql = "select * from Announcement order by id desc LIMIT 1";
            IEnumerable<Announcement> data = CurrDb.FindList<Announcement>(sql);
            return data;
        }
    }
}