DEMOMySql/MicroServices/Business/Buissness.UnitTest/InitialData/UnitTestInitialDataBuilder.cs

using Business.EntityFrameworkCore;
using Business.Models;
using Bussiness.Model.SIM;
using Bussiness.Model.SystemData;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Buissness.UnitTest.InitialData
{
    public class UnitTestInitialDataBuilder
    {
        public void Build(BusinessDbContext context)
        {
            //Add some people

            context.Book.AddRange(
                new Book { Name = "Isaac Asimov", Price=1, Description="111",TenantId=Guid.NewGuid() },
                new Book { Name = "Thomas More", Price = 2, Description = "222", TenantId = Guid.NewGuid() },
                new Book { Name = "George Orwell",Price = 3, Description = "333", TenantId = Guid.NewGuid() },
                new Book { Name = "Douglas Adams", Price = 4, Description = "444", TenantId = Guid.NewGuid() }
                );

            context.SaveChanges();

            context.sim_base.AddRange(
               new sim_base { sim_grade = "1", sim_level = 1, rise_cycle = (decimal?)0.5, interval_days = (decimal?)0.6, rise_time = DateTime.Now, factory_id = 10201, org_id = 102, tenant_id = 102 },
               new sim_base { sim_grade = "2", sim_level = 2, rise_cycle = (decimal?)0.5, interval_days = (decimal?)0.7, rise_time = DateTime.Now, factory_id = 10201, org_id = 102, tenant_id = 102 },
               new sim_base { sim_grade = "3", sim_level = 3, rise_cycle = (decimal?)0.5, interval_days = (decimal?)0.8, rise_time = DateTime.Now, factory_id = 10201, org_id = 102, tenant_id = 102 },
               new sim_base { sim_grade = "4", sim_level = 4, rise_cycle = (decimal?)0.5, interval_days = (decimal?)0.9, rise_time = DateTime.Now, factory_id = 10201, org_id = 102, tenant_id = 102 }
               );

            context.SaveChanges();

            context.sys_code.AddRange( 
                new sys_code { code_name = "1", code_rule = "ABP1", code_value =1, chinese_name ="测试编码规则", code_date = DateTime.Now },
                new sys_code { code_name = "2", code_rule = "ABP2", code_value = 1, chinese_name = "测试编码规则", code_date = DateTime.Now },
                new sys_code { code_name = "3", code_rule = "ABP3", code_value = 1, chinese_name = "测试编码规则", code_date = DateTime.Now },
                new sys_code { code_name = "4", code_rule = "ABP4", code_value = 1, chinese_name = "测试编码规则", code_date = DateTime.Now }
                );

            context.SaveChanges();

            context.sys_code_pre.AddRange(
                new sys_code_pre { code_name = "1", pre_name = context.sys_code.Single(p => p.code_name == "ABP1").code_rule, code_value = 1, code_date = DateTime.Now },
                new sys_code_pre { code_name = "1", pre_name = context.sys_code.Single(p => p.code_name == "ABP2").code_rule, code_value = 2, code_date = DateTime.Now },
                new sys_code_pre { code_name = "1", pre_name = context.sys_code.Single(p => p.code_name == "ABP3").code_rule, code_value = 3, code_date = DateTime.Now },
                new sys_code_pre { code_name = "1", pre_name = context.sys_code.Single(p => p.code_name == "ABP4").code_rule, code_value = 4, code_date = DateTime.Now }
                );

            context.SaveChanges();
        }
    }
}