using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.SessionState;

namespace WebApplication2
{
    public class Global : System.Web.HttpApplication
    {
        protected string fromEmailAddress = "wxrczkw@163.com";
        protected string fromEmailUser = "wxrczkw";
        protected string fromEmailPassWord = "******";
        protected string fromEmailSMTP = "smtp.163.com";
        void Application_Start(object sender, EventArgs e)
        {
            System.Timers.Timer timer = new System.Timers.Timer(10000); 
            timer.Elapsed += new System.Timers.ElapsedEventHandler(timer_Elapsed);
            timer.AutoReset = true;
            timer.Enabled = true;
        }

        void timer_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
        {
            if (DateTime.Now.Hour == 18)
            {
                ScanMember();
            }
        }

        void ScanMember()
        {
            IList<TradeSite.Member.Model.MemberInfo> memberinfolist = TradeSite.Member.BLL.Member.GetAll();
            if (memberinfolist.Count > 0)
            {
                foreach (TradeSite.Member.Model.MemberInfo memberinfo in memberinfolist)
                {
                    if (memberinfo.ID == 469)
                    {
                        SendMail(fromEmailAddress, memberinfo.EMail, "网站未登录提醒", "您已经一个月未登录本站了！【rczkw.com】");
                    }
                }
            }
        }

        public void SendMail(string MailFrom, string MailTo, string MailSubject, string MailContent)
        {
            System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();
            message.To.Add(MailTo);
            message.Subject = MailSubject;
            message.From = new System.Net.Mail.MailAddress(MailFrom);
            message.Body = MailContent;
            System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient("smtp.163.com");
            smtp.Credentials = new System.Net.NetworkCredential("wxrczkw", "******");
            try
            {
                smtp.Send(message);
                TradeSite.WebSiteSet.Model.IEmailQueueInfo4 emailinfo = new TradeSite.WebSiteSet.Model.EmailQueueInfo();
                emailinfo.strEmailTo = MailTo;
                emailinfo.strEmailFrom = MailFrom;
                emailinfo.strEmailSubject = MailSubject;
                emailinfo.strEmailBody = MailContent;
                emailinfo.dtCreateDate = DateTime.Now;
                emailinfo.dtSendDate = DateTime.Now;
                emailinfo.EmailBodyFormat = System.Web.Mail.MailFormat.Html;
                emailinfo.strEmailError = "";
                emailinfo.strURL = "";
                if (emailinfo != null)
                {
                    TradeSite.WebSiteSet.BLL.EmailQueue.Insert(emailinfo);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }

        /// <summary>
        /// 计算两个日期的时间间隔
        /// </summary>
        /// <param name="DateTime1">第一个日期和时间</param>
        /// <param name="DateTime2">第二个日期和时间</param>
        /// <returns>返回天数</returns>
        private int DateDiff(DateTime DateTime1, DateTime DateTime2)
        {
            int dateDiff = 0;
            TimeSpan ts1 = new TimeSpan(DateTime1.Ticks);
            TimeSpan ts2 = new TimeSpan(DateTime2.Ticks);
            TimeSpan ts = ts1.Subtract(ts2).Duration();
            dateDiff = Convert.ToInt32(ts.Days);
            return dateDiff;
        } 
        protected void Session_Start(object sender, EventArgs e)
        {

        }

        protected void Application_BeginRequest(object sender, EventArgs e)
        {
            
        }

        protected void Application_AuthenticateRequest(object sender, EventArgs e)
        {

        }

        protected void Application_Error(object sender, EventArgs e)
        {

        }

        protected void Session_End(object sender, EventArgs e)
        {

        }

        protected void Application_End(object sender, EventArgs e)
        {

        }
    }
}

try
{
    if (emailinfo != null)
    {
        //换成这样写法也不行
        TradeSite.WebSiteSet.BLL.EmailQueue bll = (TradeSite.WebSiteSet.BLL.EmailQueue)Assembly.Load("TradeSite.WebSiteSet.Component").CreateInstance("TradeSite.WebSiteSet.BLL.EmailQueue");
        bll.InsertData(emailinfo);
    }
}
catch (Exception ex)
{
    throw ex;   
}

//BLL层
public static void Insert(IEmailQueueInfo4 info)
        {
            IDAL.IEmailQueue dal = DALFactory.EmailQueue.Create();
            dal.Insert(info);
        }

//DAL层
 public void Insert(IEmailQueueInfo4 info)
        {
            if (info != null)
            {
                GetInsertParameters(info);
                ExecuteNonQuery();
            }
        }

 private void GetInsertParameters(IEmailQueueInfo4 info)
        {
            cmd = db.GetSqlStringCommand(SQL_INSERT);
            db.AddInParameter(cmd, PARM_PRIVORITY,   DbType.Int32, (int)info.EmailPriority);
            db.AddInParameter(cmd, PARM_BODY_FORMAT, DbType.Int32, info.EmailBodyFormat);
            db.AddInParameter(cmd, PARM_TO,          DbType.String, info.strEmailTo);
            db.AddInParameter(cmd, PARM_CC,          DbType.String, info.strEmailCc);
            db.AddInParameter(cmd, PARM_BCC,         DbType.String, info.strEmailBcc);
            db.AddInParameter(cmd, PARM_FROM,        DbType.String, info.strEmailFrom);
            db.AddInParameter(cmd, PARM_SUBJECT,     DbType.String, info.strEmailSubject);
            db.AddInParameter(cmd, PARM_BODY,        DbType.String, info.strEmailBody);
            db.AddInParameter(cmd, PARM_CREAT_DATE,  DbType.DateTime, info.dtCreateDate = DateTime.Now);
            db.AddInParameter(cmd, PARM_SEND_DATE,   DbType.DateTime, info.strSendDate);
            db.AddInParameter(cmd, PARM_STATUS,      DbType.Int32, (int)info.esEmailStatus);
            db.AddInParameter(cmd, PARM_URL,         DbType.String, HttpContext.Current.Request.RawUrl);
            db.AddInParameter(cmd, PARM_ERROR,       DbType.String, info.strEmailError);

        }

 public void ExecuteNonQuery()
        {
            if (db != null && cmd != null)
            {
                db.ExecuteNonQuery(cmd);
            }
        }

//BLL层
public static void Insert(IEmailQueueInfo4 info)
        {
            IDAL.IEmailQueue dal = DALFactory.EmailQueue.Create();
            if (dal == null)
            {
                throw new Exception("dal is null");
            }
            else
            {
                dal.Insert(info);
            }
        }

        public void InsertData(IEmailQueueInfo4 info)
        {
            IDAL.IEmailQueue dal = DALFactory.EmailQueue.Create();
            if (dal == null)
            {
                throw new Exception("dal is null");
            }
            else
            {
                dal.Insert(info);
            }
        }

TradeSite.WebSiteSet.BLL.EmailQueue bll = (TradeSite.WebSiteSet.BLL.EmailQueue)Assembly.Load("TradeSite.WebSiteSet.Component").CreateInstance("TradeSite.WebSiteSet.BLL.EmailQueue");
                    if (bll == null)
                    {
                        throw new Exception("bll is null");
                    }
                    else
                    {
                        bll.InsertData(emailinfo);
                    }