using CRM.Core.Model;
using CRM.Core.Model.EntityFB;
using System.Linq;

namespace CRM.Core.BLL.FB
{
    public class Sms_BatchMsg_BL : FbContextRepository<sms_batchmsg>
    {
        private readonly ConStringHelper.CompanyCode _companyCode;

        public Sms_BatchMsg_BL(ConStringHelper.CompanyCode companyCode) : base(companyCode)
        {
            this._companyCode = companyCode;
        }

        public sms_batchmsg GetTopInfo()
        {
            using (var db = new fbContext(_companyCode))
            {
                var q = from b in db.Sms_BatchMsg
                        join d in db.Sms_BatchMsgDetail on b.batchid equals d.batchid
                        select b;
                var info = q.OrderBy(p => p.batchid).FirstOrDefault();
                return info;
            }

        }
    }
}