EDM开发之一：系统概述

edm的需求

公司的EDM软件已经很多年了，需要更新程序并添加一些功能。功能描述：暂时内部使用，要有登陆及权限过滤功能；发送邮件和问卷检测功能。

概述

新需求中程序属于一个流程中的子系统，所以对扩展有要求，登陆时考虑到高并发和容灾，拟采用多进程方式，于是将session记录到数据库里；

发送邮件过程中，由于要发送的邮箱属于10W级，而SMTP服务器限制较多（同一Ip/邮箱，一段时间发送数量上线，发送速度限制，每天部分邮局发送数量上限），对于发送时数据的整理要求较高，还要检测导入的邮箱是否有错误，历史上是否有退订和发送失败中的再次发送不可能成功邮箱的记录，排除不可能成功的邮箱；

问卷需要对导入的文件进行检测是否有多、缺、乱的格式，并生成可访问的链接。

框架搭建

1、框架模型：

原本是想试验一下领域驱动模型来设计，不过最后把自己绕进去了，出不来了，待到有所成的时候再写吧。这里简要的介绍一下：

 Models就不用说了，数据库模型；

Commons里面是一些公共类和页面显示数据模型；

using System;
using System.Collections.Generic;

namespace Commons.DTO
{
    public class SendTypePages
    {
        public int Id { get; set; }
        public string CustomerName { get; set; }
        public string EdmName { get; set; }
        public string Person { get; set; }
        public string EdmUrl { get; set; }
        public string DesignUrl { get; set; }
        public string EmailUrl { get; set; }
        public string SetTime { get; set; }
        public string SendStatus { get; set; }
    }

    public class StopSendType
    {
        public int Id { get; set; }
        public string EdmBeginUrl { get; set; }
        public string SendStatus { get; set; }
        public string EdmName { get; set; }
    }

    public class SendTypeStatis
    {
        public string EdmName { get; set; }
        public string EdmNewUrl { get; set; }
        public string SetTime { get; set; }
        public int? TotalCounts { get; set; }
        public string SendStatus { get; set; }
        public string CustomerName { get; set; }
        public double TheBackCount { get; set; }
        public double TheArriveCount { get; set; }
        public double TheOpenCount { get; set; }
        public double EdmBeginUrl { get; set; }
        public double TheOpenTimesCount { get; set; }
        public double TheSendCount { get; set; }
        public double TheTotalCount { get; set; }
        public double TheUnableCount { get; set; }
        public string TheArriveProcent { get; set; }
        public string TheOpenProcent { get; set; }
    }

    public class TheBackEmailPage
    {
        public int Id { get; set; }
        public string CustomerName { get; set; }
        public string EdmName { get; set; }
        public string Email { get; set; }
        public string Reason { get; set; }
        public string SetTime { get; set; }
    }

    public class JsonDate
    {
        public int id { get; set; }
        public string text { get; set; }
        public List<JsonDate> children { get; set; }
    }

    public class CustomerList
    {
        public int Id { get; set; }
        public string CustomerName { get; set; }
        public string Remarks { get; set; }
        public string Phone { get; set; }
        public string Email { get; set; }
        public string Enterprise { get; set; }
        public string Setion { get; set; }
    }

    public class QuestionnaireList
    {
        public int Id { get; set; }
        public string CustomerName { get; set; }
        public string Name { get; set; }
        public int ReportTimes { get; set; }
        public int GetBackTimes { get; set; }
        public string UpTime { get; set; }
    }

    public class CustomerDto
    {
        public int Id { get; set; }
        public string CustomerName { get; set; }
        public string Phone { get; set; }
        public string Email { get; set; }
        public string Remarks { get; set; }
        public string Enterprise { get; set; }
        public string Setion { get; set; }
    }

    public class SendTest
    {
        public int Id { get; set; }
        public string Email { get; set; }
        public int IsOpen { get; set; }
        public int IsReturn { get; set; }
        public string TheBackReason { get; set; }
    }

    public class SendTypeEmailDto
    {
        public string QqEmail { get; set; }
        public string WangyiEmail { get; set; }
        public string TomEmail { get; set; }
        public string SinaEmail { get; set; }
        public string SohuEmail { get; set; }
        public string OtherEmail { get; set; }
    }
}

IRepository里是基础的crud和分页获取数据；

public class Repository<T> where T : class ,new()
{
    readonly DbContext _entities = EfContextFactory.GetCurrentDbContext();
    public void InsertOrUpdate(T entity)
    {
        _entities.Set<T>().AddOrUpdate(entity);
    }

    public void Delete(IEnumerable<T> entity)
    {
        foreach (var en in entity)
        {
            _entities.Set<T>().Remove(en);
        }
    }

    public IEnumerable<T> GetEntity(Func<T, bool> commandText)
    {
        var model = _entities.Set<T>().Where(commandText);
        return model;
    }

    public IEnumerable<T> GetEntitiesForPaging(int pageNumber, int pageSize, Func<T, object> orderName, Func<T, bool> commandText, out int count)
    {
        var model = _entities.Set<T>()
                    .Where(commandText)
                    .OrderBy(orderName).ToList();
        var list = model.Skip((pageNumber - 1) * pageSize)
                    .Take(pageSize)
                    .ToList();
        count = model.Count;
        return list;
    }

    public void Insert(string sql, params object[] paramters)
    {
        //entities.Database.SqlQuery<T>( sql, paramters);
        _entities.Database.ExecuteSqlCommand(sql, paramters);
    }

    public bool SaveChange()
    {
        return _entities.SaveChanges() > 0;
    }
}

Dal则是继承IRepository的方法；

namespace DAL
{
    public class UserRepository : IRepository.Repository<Models.UserInfo>, IRepository.IRepository<Models.UserInfo>
    {
        public List<string> GetEntities(string sql, params object[] paramters)
        {
            using (var entities = new Model1Container())
            {
                return entities.Database.SqlQuery<string>(sql, paramters).ToList();
            }
        }
    }
}

Bll将数据库数据进行整理获得前台需要的数据；

//创建发送表
public void CreateEmailTable(string sendTableName)
{
    var sql = "CREATE TABLE [dbo].[" + sendTableName + "] " +
              "([Id] int IDENTITY(1,1) NOT NULL," +
              "[Email] nvarchar(max)  NOT NULL," +
              "[IsSend] int NULL ," +
              "[IsArrive] int NULL ," +
              "[IsOpen] int  NULL," +
              "[IsReturnEmail] int  NULL," +
              "[TheBackReason] nvarchar(128)  NULL ," +
              "[EmailType] nvarchar(128)  NULL )";
    _sendTypeRepository.Insert(sql);
}

//导入email，通过txt和excel格式
public void BulkEmail(string sendTableName, string path)
{
    var sql = "BULK INSERT lxtest2.dbo.LoginTxt " +//要导入的数据库目标表
              "FROM '" + path + "'  " +         //文本源数据文件
              "WITH ( " +
              "FIELDTERMINATOR = ';',  " +    //列结束符
              "ROWTERMINATOR = '\r\n'    " +    //行结束符 
              ")";
    //SqlParameter[] sqlParameters =
    //{
    //    new SqlParameter { ParameterName = "a", Value = 1 },
    //    new SqlParameter { ParameterName = "b", Value = 2 }
    //};

    _sendTypeRepository.Insert(sql);
    RemoveEmail(sendTableName);

}