示例#1
0
        public static void InitData()
        {
            var r1 = new Role()
            {
                Id = Guid.NewGuid().ToString(), Name = "管理员", IsEnabled = true, CreateTime = DateTime.Now
            };

            var u1 = new User()
            {
                Id = Guid.NewGuid().ToString(), Name = "管理员", Account = "admin", Password = DESEncrypt.DoubleEncrypt("123456"), IsEnabled = true, IsAdmin = true, CreateTime = DateTime.Now
            };

            var ur1 = new UserRole()
            {
                Id = Guid.NewGuid().ToString(), UserId = u1.Id, RoleId = r1.Id, CreateTime = DateTime.Now
            };

            var m1 = new Module()
            {
                ParentId = "0", Name = "门户管理", Icon = "layui-icon-home", IsMenu = true, SortCode = "01"
            };

            var m99 = new Module()
            {
                ParentId = "0", Name = "系统管理", Icon = "layui-icon-set", IsMenu = true, SortCode = "99"
            };


            var m101 = new Module()
            {
                ParentId = m1.Id, Name = "栏目管理", Url = "/Backadmin/Column/Index", IsMenu = true, SortCode = "0101"
            };
            var m102 = new Module()
            {
                ParentId = m1.Id, Name = "文章管理", Url = "/Backadmin/Article/Index", IsMenu = true, SortCode = "0102"
            };
            var m9901 = new Module()
            {
                ParentId = m99.Id, Name = "角色管理", Url = "/Backadmin/Role/Index", IsMenu = true, SortCode = "9901"
            };
            var m9902 = new Module()
            {
                ParentId = m99.Id, Name = "用户管理", Url = "/Backadmin/User/Index", IsMenu = true, SortCode = "9902"
            };


            var rm1 = new RoleAuthorize()
            {
                Id = Guid.NewGuid().ToString(), RoleId = r1.Id, ObjectId = m1.Id, Type = ModuleType.菜单, CreateTime = DateTime.Now
            };
            var rm101 = new RoleAuthorize()
            {
                Id = Guid.NewGuid().ToString(), RoleId = r1.Id, ObjectId = m101.Id, Type = ModuleType.菜单, CreateTime = DateTime.Now
            };
            var rm102 = new RoleAuthorize()
            {
                Id = Guid.NewGuid().ToString(), RoleId = r1.Id, ObjectId = m102.Id, Type = ModuleType.菜单, CreateTime = DateTime.Now
            };

            var rm99 = new RoleAuthorize()
            {
                Id = Guid.NewGuid().ToString(), RoleId = r1.Id, ObjectId = m99.Id, Type = ModuleType.菜单, CreateTime = DateTime.Now
            };
            var rm9901 = new RoleAuthorize()
            {
                Id = Guid.NewGuid().ToString(), RoleId = r1.Id, ObjectId = m9901.Id, Type = ModuleType.菜单, CreateTime = DateTime.Now
            };
            var rm9902 = new RoleAuthorize()
            {
                Id = Guid.NewGuid().ToString(), RoleId = r1.Id, ObjectId = m9902.Id, Type = ModuleType.菜单, CreateTime = DateTime.Now
            };



            var roles = new List <Role>()
            {
                r1
            };
            var users = new List <User>()
            {
                u1
            };
            var urs = new List <UserRole>()
            {
                ur1
            };
            var modules = new List <Module> {
                m1, m101, m102, m99, m9901, m9902
            };
            var rms = new List <RoleAuthorize>()
            {
                rm1, rm101, rm102, rm99, rm9901, rm9902
            };

            using (var context = DbConfig.GetDbInstance())
            {
                context.Ado.ExecuteCommand("exec sp_msforeachtable @Command1 ='truncate table ?'");
                context.Insertable(roles).ExecuteCommand();
                context.Insertable(users).ExecuteCommand();
                context.Insertable(urs).ExecuteCommand();
                context.Insertable(modules).ExecuteCommand();
                context.Insertable(rms).ExecuteCommand();
            }
        }