// @nuget: EntityFramework

// @nuget: Newtonsoft.Json

using System;

using System.Linq;

using System.Data.Entity;

using System.Collections.Generic;

using Newtonsoft.Json;

using System.ComponentModel.DataAnnotations.Schema;

​

​

public class Program

{

    public static void Main()

    {

        using (var ctx = new SchoolContext())

        {

            //添加种子数据

            SmsMessageModels s1 = new SmsMessageModels { Name = "s1"};

            SmsMessageModels s2 = new SmsMessageModels { Name = "s2"};

            ctx.SmsMessageModels.AddRange(new List<SmsMessageModels> { s1,s2});         

            ctx.SaveChanges();  

            WeChatTemplateSettings w1 = new WeChatTemplateSettings { Name = "w1"};

            WeChatTemplateSettings w2 = new WeChatTemplateSettings { Name = "w2"};

            ctx.WeChatTemplateSettings.AddRange(new List<WeChatTemplateSettings> { w1,w2}); 

            ctx.SaveChanges(); 

​

            MessagePushSettings m1 = new MessagePushSettings { Name = "m1"};

            MessagePushSettings m2 = new MessagePushSettings { Name = "m2"};

            ctx.MessagePushSettings.AddRange(new List<MessagePushSettings> { m1,m2});   

            ctx.SaveChanges();  

            //指定消息推送模板

            m1.SmsMessageModel = s1;

            m2.WeChatTemplateSetting = w1;

            ctx.SaveChanges(); 

​

​

            //Console.WriteLine(JsonConvert.SerializeObject(ctx.Grades.ToList()));

            //Console.WriteLine(JsonConvert.SerializeObject(ctx.Students.ToList()));

​

            /*解决循环依赖*/

            JsonSerializerSettings setting = new JsonSerializerSettings()

            {

                ReferenceLoopHandling = ReferenceLoopHandling.Ignore,

                Formatting = Formatting.None

            };

            //消息推送

            Console.WriteLine("消息推送");

            foreach(MessagePushSettings i in ctx.MessagePushSettings){

                Console.WriteLine(JsonConvert.SerializeObject(i,setting));

            }

            //FiddleHelper.WriteTable("MessagePushSettings", ctx.MessagePushSettings);

            //短信模板

            Console.WriteLine("短信模板");

            foreach(SmsMessageModels i in ctx.SmsMessageModels){

                Console.WriteLine(JsonConvert.SerializeObject(i,setting));

            }

            //FiddleHelper.WriteTable("SmsMessageModels", ctx.SmsMessageModels);

            //微信模板

            Console.WriteLine("微信模板");

            foreach(WeChatTemplateSettings i in ctx.WeChatTemplateSettings){

                Console.WriteLine(JsonConvert.SerializeObject(i,setting));

                //Console.WriteLine(JsonConvert.SerializeObject(i.Students,setting));

            }

            //FiddleHelper.WriteTable("WeChatTemplateSettings", ctx.WeChatTemplateSettings);

        }

    }

}

​

public class SchoolContext: DbContext 

{

    public SchoolContext() : base(FiddleHelper.GetConnectionStringSqlServer()) // passed dotnetfiddle specific connction string

    {

    }

    public DbSet<MessagePushSettings> MessagePushSettings { get; set; }

    public DbSet<SmsMessageModels> SmsMessageModels { get; set; }

    public DbSet<WeChatTemplateSettings> WeChatTemplateSettings { get; set; }

}

​

public class MessagePushSettings

{

    public int Id { get; set; }

    public string Name { get; set; }

    /*

        [Required]

        [Comment("租户ID")]

        public Guid TenantId { get; set; }

        [Required]

        [Column(TypeName = "tinyint")]

        [Comment("推送类型(0-微信,1-短信)")]

        public Int16 PushType { get; set; }

        [Required]

        [Comment("推送间隔(分)")]

        public int PushInterval { get; set; }

        [Required]

        [Column(TypeName = "time")]

        [Comment("推送开始时段(时：分：秒)")]

        public TimeSpan PushStartTime { get; set; }

        [Required]

        [Column(TypeName = "time")]

        [Comment("推送结束时段(时：分：秒)")]

        public TimeSpan PushEndTime { get; set; }

        */

        //外键关联

​

        //[Comment("消息唯一标识WeChatTemplateId,SmsTemplateId")]

        //[ForeignKey("SmsMessageModel")]

    /**/

        [ForeignKey("SmsMessageModel")]

        public int SmsMessageModelId { get; set; }

        [ForeignKey("WeChatTemplateSetting")]

        public int WeChatTemplateSettingId { get; set; }

​

        //短信模板

        [InverseProperty("MessagePushSettings")]

        public SmsMessageModels SmsMessageModel { get; set; }

        //微信模板

        [InverseProperty("MessagePushSettings")]

        public WeChatTemplateSettings WeChatTemplateSetting { get; set; }

}

public class SmsMessageModels

{

    public int Id { get; set; }

    public string Name { get; set; }

        /*

        [Required]

        [Comment("短信接口ID，联合主键1,短信接口外键")]

        [MaxLength(BaseServiceConsts.MaxIdLength)]

        public Guid SmsInterfaceId { get; set; }

        [Required]

        [Comment("模板名称")]

        [MaxLength(BaseServiceConsts.MaxNameLength)]

        public string SmsTemplateName { get; set; }

        [Required]

        [Comment("消息类型，如短信注册、余额告警")]

        [MaxLength(BaseServiceConsts.MaxNameLength)]

        public string MessageType { get; set; }

        [Required]

        [Comment("阿里云签名（模板类型），如“电管家”,数据字典值")]

        [MaxLength(BaseServiceConsts.MaxNameLength)]

        public string SmsSignName { get; set; }

        [Required]

        [Comment("区域码")]

        [MaxLength(BaseServiceConsts.MaxSmsAreCode)]

        public string SmsAreCode { get; set; }

        [Required]

        [Comment("已申请消息模板ID")]

        [MaxLength(BaseServiceConsts.MaxSmsAccessKeyId)]

        public string SmsAccessKeyId { get; set; }

        [Required]

        [Comment("消息内容")]

        [MaxLength(BaseServiceConsts.MaxSmsTemplate)]

        public string SmsTemplate { get; set; }

        [JsonIgnore]

        //[InverseProperty("SmsMessageModels")]

        public SmsConfig SmsConfig { get; set; }

        */

        //消息推送

        //[JsonIgnore]

        [InverseProperty("SmsMessageModel")]

        public ICollection<MessagePushSettings> MessagePushSettings { get; set; }

}

public class WeChatTemplateSettings

{

    public int Id { get; set; }

    public string Name { get; set; }

        /*

        [NotNull]

        [ForeignKey("OfficialSettings")]

        public Guid OfficialId { get; set; }

        [NotNull]

        public string MessageType { get; set; }

        [NotNull]

        public string TemplateId { get; set; }

        [NotNull]

        public string Name { get; set; }

        [NotNull]

        public string Template { get; set; }

        [JsonIgnore]

        public WeChatOfficialSettings OfficialSettings { get; set; }

        */

        //消息推送

        //[JsonIgnore]

        [InverseProperty("WeChatTemplateSetting")]

        public ICollection<MessagePushSettings> MessagePushSettings { get; set; }

}

​

​

​