Exemplo n.º 1
0
        public void AddUserInRole(string login, string roleName)
        {
            var user = GetUserInternal(login, true);
            var role = GetRoleInternal(roleName, true);

            if (!role.IsInSchema(user.Schema))
            {
                throw new Exception(String.Format("O papel {0} não faz parte do esquema ao qual o usuário {1} pertence.", roleName, login));
            }

            Sync(() =>
            {
                if (!user.IsInRole(role))
                {
                    var relation = new UserRoleRelation()
                    {
                        Login    = user.Login,
                        RoleName = role.Name
                    };
                    if (_store.Save(relation))
                    {
                        _usersInRole.Remove(role.Name);
                        _rolesForUser.Remove(user.Login);
                    }
                    else
                    {
                        throw new Exception("Não foi possivel adicionar o usuário ao papel.");
                    }
                }
            });
        }
        /// <summary>
        /// 添加用户
        /// </summary>
        /// <param name="u"></param>
        /// <returns></returns>
        public int UserInsert(string AccountName, string Pwd, string Sex, string Phone, DateTime CreTime, string OwnRole)
        {
            Users u = new Users();

            u.AccountName = AccountName;
            u.Pwd         = Pwd;
            u.Sex         = Sex;
            u.Phone       = Phone;
            u.CreTime     = CreTime;
            int i = user.UserAdd(u);

            var a      = OwnRole.Split(',');
            int userid = user.GetUserId();

            for (int j = 0; j < a.Length; j++)
            {
                UserRoleRelation relation = new UserRoleRelation();
                relation.UserId = userid;
                relation.RoleId = int.Parse(a[j]);
                int result = user.RARolesAdd(relation);
            }
            Users us = (Users)Session["User"];

            if (i > 0)
            {
                logs.Add(us.ID, "添加用户", 1);
            }
            else
            {
                logs.Add(us.ID, "添加用户", 0);
            }
            return(i);
        }
Exemplo n.º 3
0
        public override async Task <int> InsertAsync(ApplicationEntity obj)
        {
            using (var transaction = new TransactionScope(TransactionScopeOption.Required, TransactionScopeAsyncFlowOption.Enabled))
            {
                await base.InsertAsync(obj);

                var sql = obj.Account.ToSQLinqInsert(dialect: base.SqlDialect).ToSQL();
                await this.Connection.ExecuteAsync(sql.ToQuery(), sql.Parameters);

                var role = obj.UserRole.First();
                var rel  = new UserRoleRelation()
                {
                    Id     = this._idGenerator.NewId(),
                    RoleId = role.Id,
                    UserId = obj.Account.Id
                };

                var relInsert = rel.ToSQLinqInsert(dialect: base.SqlDialect);
                var relSql    = relInsert.ToSQL();
                var count     = await this.Connection.ExecuteAsync(relSql.ToQuery(), relSql.Parameters);

                obj.CallbackConfigs.ForEach(async x =>
                {
                    sql    = x.ToSQLinqInsert(dialect: base.SqlDialect).ToSQL();
                    count += await this.Connection.ExecuteAsync(sql.ToQuery(), sql.Parameters);
                });
                transaction.Complete();
                return(count);
            }
        }
Exemplo n.º 4
0
        public async Task <UserRoleRelation> QueryByRole(Guid roleId, Guid id)
        {
            UserRoleRelation relation = null;

            await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, true, false, _privilegeManagementConnectionFactory.CreateReadForPrivilegeManagement(), async (conn, transaction) =>
            {
                SqlTransaction sqlTran = null;
                if (transaction != null)
                {
                    sqlTran = (SqlTransaction)transaction;
                }

                using (SqlCommand commond = new SqlCommand()
                {
                    Connection = (SqlConnection)conn,
                    CommandType = CommandType.Text,
                    Transaction = sqlTran,
                    CommandText = string.Format(@"select {0},{1},{2} from [UserRoleRelation] as urr join [role] as r
                                                  on urr.[roleid]=r.[id] join [PrivilegeSystem] as s
                                                  on urr.[systemid]=s.[id] where urr.[id]=@id and urr.[roleid]", StoreHelper.GetUserRoleRelationSelectFields("urr"), StoreHelper.GetRoleSelectFields("r"), StoreHelper.GetPrivilegeSystemSelectFields("s"))
                })
                {
                    var parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier)
                    {
                        Value = id
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@roleid", SqlDbType.UniqueIdentifier)
                    {
                        Value = roleId
                    };
                    commond.Parameters.Add(parameter);

                    commond.Prepare();

                    SqlDataReader reader = null;

                    using (reader = await commond.ExecuteReaderAsync())
                    {
                        if (await reader.ReadAsync())
                        {
                            relation = new UserRoleRelation();
                            StoreHelper.SetUserRoleRelationSelectFields(relation, reader, "urr");
                            relation.Role = new Role();
                            StoreHelper.SetRoleSelectFields(relation.Role, reader, "r");
                            relation.System = new PrivilegeSystem();
                            StoreHelper.SetPrivilegeSystemSelectFields(relation.System, reader, "s");
                        }

                        reader.Close();
                    }
                }
            });

            return(relation);
        }
Exemplo n.º 5
0
        public async Task Update(UserRoleRelation relation)
        {
            await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, false, false, _privilegeManagementConnectionFactory.CreateAllForPrivilegeManagement(), async (conn, transaction) =>
            {
                SqlTransaction sqlTran = null;
                if (transaction != null)
                {
                    sqlTran = (SqlTransaction)transaction;
                }

                using (SqlCommand commond = new SqlCommand()
                {
                    Connection = (SqlConnection)conn,
                    CommandType = CommandType.Text,
                    Transaction = sqlTran,
                    CommandText = @"update [UserRoleRelation] set [userkey]=@userkey,[systemid]=@systemid,[roleid]=@roleid,[modifytime]=getutcdate()
                                    where [id]=@id"
                })
                {
                    var parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier)
                    {
                        Value = relation.ID
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@userkey", SqlDbType.NVarChar, 150)
                    {
                        Value = relation.UserKey
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@systemid", SqlDbType.UniqueIdentifier)
                    {
                        Value = relation.System.ID
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@roleid", SqlDbType.UniqueIdentifier)
                    {
                        Value = relation.Role.ID
                    };
                    commond.Parameters.Add(parameter);

                    commond.Prepare();


                    await commond.ExecuteNonQueryAsync();
                }
            });
        }
Exemplo n.º 6
0
        /// <summary>
        /// Updates the specified user aggregate.
        /// </summary>
        /// <param name="aggregate">The user aggregate.</param>
        /// <exception cref="System.ArgumentNullException">When user aggregate is null.</exception>
        public void Update(DB.Models.User.User aggregate)
        {
            if (aggregate == null)
            {
                throw new ArgumentNullException("aggregate");
            }

            var user = _context.Users.Find(aggregate.Id);

            user.FirstName   = aggregate.FirstName;
            user.LastName    = aggregate.LastName;
            user.DateOfBirth = aggregate.DateOfBirth;
            user.Image       = aggregate.Image;
            user.Phone       = aggregate.Phone;
            user.IsDeleted   = aggregate.IsDeleted;

            foreach (var role in aggregate.Roles)
            {
                var newRole = new UserRoleRelation {
                    RoleId = role, UserId = aggregate.Id
                };
                var oldRole = _context.UserRoleRelations.FirstOrDefault(x => x.UserId == aggregate.Id);

                if (oldRole == null)
                {
                    _context.UserRoleRelations.Add(newRole);
                    continue;
                }

                if (oldRole.UserId == newRole.UserId &&
                    oldRole.RoleId == newRole.RoleId)
                {
                    continue;
                }

                _context.UserRoleRelations.Remove(oldRole);

                _context.UserRoleRelations.AddOrUpdate(newRole);
            }

            if (aggregate.Mood != null)
            {
                _context.Moods.AddOrUpdate(new UserMood {
                    Date = aggregate.Mood.Date, Rate = aggregate.Mood.Rate, UserId = aggregate.Id
                });
            }

            _context.SaveChanges();
        }
Exemplo n.º 7
0
        public async Task RoleAddOneUser(long roleId, long userId)
        {
            var rel = await this._userRoleRel.QueryFirstAsync(x => x.RoleId == roleId && x.UserId == userId);

            if (rel != null)
            {
                return;
            }
            rel = new UserRoleRelation
            {
                Id     = this._idGenerator.NewId(),
                UserId = userId,
                RoleId = roleId
            };
            await this._userRoleRel.InsertAsync(rel);
        }
Exemplo n.º 8
0
        /// <summary>
        /// 为权限系统从DbDataReader中赋值
        /// </summary>
        /// <param name="queue"></param>
        /// <param name="reader"></param>
        /// <param name="prefix"></param>
        public static void SetUserRoleRelationSelectFields(UserRoleRelation relation, DbDataReader reader, string prefix)
        {
            relation.ID = (Guid)reader[string.Format("{0}id", prefix)];

            if (reader[string.Format("{0}userkey", prefix)] != DBNull.Value)
            {
                relation.UserKey = reader[string.Format("{0}userkey", prefix)].ToString();
            }

            if (reader[string.Format("{0}createtime", prefix)] != DBNull.Value)
            {
                relation.CreateTime = (DateTime)reader[string.Format("{0}createtime", prefix)];
            }

            if (reader[string.Format("{0}modifytime", prefix)] != DBNull.Value)
            {
                relation.ModifyTime = (DateTime)reader[string.Format("{0}modifytime", prefix)];
            }
        }
Exemplo n.º 9
0
        public UserRoleRelation ToUserRoleRelation(string jsonData)
        {
            JsonResponseReader reader = new JsonResponseReader(jsonData);
            string             userId = reader.GetString("userId");
            string             roleId = reader.GetString("roleId");

            if (userId == null)
            {
                throw new NoNullAllowedException("未能正常解析用户ID");
            }

            if (roleId == null)
            {
                throw new NoNullAllowedException("未能正常解析等级ID");
            }

            var user = new UserRoleRelation(userId, roleId);

            return(user);
        }
Exemplo n.º 10
0
        public void AddRelationRole(Guid relationId, long userId, long relationUserId)
        {
            var relationRoles = _userRoleRelationRepository.GetAll().Where(x => x.RelationId == relationId).ToList();

            foreach (var item in relationRoles)
            {
                _userRoleRelationRepository.Delete(item);
            }
            var roles = _userRoleRepository.GetAll().Where(x => x.UserId == userId).ToList();

            foreach (var item in roles)
            {
                var info = new UserRoleRelation()
                {
                    RoleId     = item.RoleId,
                    UserId     = relationUserId,
                    RelationId = relationId
                };
                _userRoleRelationRepository.Insert(info);
            }
        }
Exemplo n.º 11
0
        public async Task QueryByRole(Guid roleId, Func <UserRoleRelation, Task> callback)
        {
            List <UserRoleRelation> relationList = new List <UserRoleRelation>();

            await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, true, false, _privilegeManagementConnectionFactory.CreateReadForPrivilegeManagement(), async (conn, transaction) =>
            {
                Int64?sequence = null;
                int pageSize   = 500;

                while (true)
                {
                    relationList.Clear();

                    SqlTransaction sqlTran = null;
                    if (transaction != null)
                    {
                        sqlTran = (SqlTransaction)transaction;
                    }

                    using (SqlCommand commond = new SqlCommand()
                    {
                        Connection = (SqlConnection)conn,
                        CommandType = CommandType.Text,
                        Transaction = sqlTran
                    })
                    {
                        if (!sequence.HasValue)
                        {
                            commond.CommandText = string.Format(@"select top (@pagesize) {0} from [UserRoleRelation] as urr join [Role] as r
                                                                  on urr.[roleid]=r.[id] join [PrivilegeSystem] as s
                                                                  on urr.[systemid]=s.[id] where r.[id]=@roleid order by urr.[sequence]", StoreHelper.GetUserRoleRelationSelectFields("urr"), StoreHelper.GetRoleSelectFields("r"), StoreHelper.GetPrivilegeSystemSelectFields("s"));
                        }
                        else
                        {
                            commond.CommandText = string.Format(@"select top (@pagesize) {0} from [UserRoleRelation] as urr join [Role] as r
                                                                  on urr.[roleid]=r.[id] join [PrivilegeSystem] as s
                                                                  on urr.[systemid]=s.[id] where r.[id]=@roleid and urr.[sequence]>@sequence order by urr.[sequence]", StoreHelper.GetUserRoleRelationSelectFields("urr"), StoreHelper.GetRoleSelectFields("r"), StoreHelper.GetPrivilegeSystemSelectFields("s"));
                        }

                        var parameter = new SqlParameter("@roleid", SqlDbType.UniqueIdentifier)
                        {
                            Value = roleId
                        };
                        commond.Parameters.Add(parameter);

                        parameter = new SqlParameter("@pagesize", SqlDbType.Int)
                        {
                            Value = pageSize
                        };
                        commond.Parameters.Add(parameter);

                        if (sequence.HasValue)
                        {
                            parameter = new SqlParameter("@sequence", SqlDbType.BigInt)
                            {
                                Value = sequence
                            };
                            commond.Parameters.Add(parameter);
                        }

                        commond.Prepare();

                        SqlDataReader reader = null;

                        using (reader = await commond.ExecuteReaderAsync())
                        {
                            while (await reader.ReadAsync())
                            {
                                var relation = new UserRoleRelation();
                                StoreHelper.SetUserRoleRelationSelectFields(relation, reader, "urr");
                                sequence      = (Int64)reader["urrsequence"];
                                relation.Role = new Role();
                                StoreHelper.SetRoleSelectFields(relation.Role, reader, "r");
                                relation.System = new PrivilegeSystem();
                                StoreHelper.SetPrivilegeSystemSelectFields(relation.System, reader, "s");
                                relationList.Add(relation);
                            }

                            reader.Close();
                        }
                    }

                    foreach (var relationItem in relationList)
                    {
                        await callback(relationItem);
                    }

                    if (relationList.Count != pageSize)
                    {
                        break;
                    }
                }
            });
        }
Exemplo n.º 12
0
        public async Task Add(UserRoleRelation relation)
        {
            await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, false, false, _privilegeManagementConnectionFactory.CreateAllForPrivilegeManagement(), async (conn, transaction) =>
            {
                SqlTransaction sqlTran = null;
                if (transaction != null)
                {
                    sqlTran = (SqlTransaction)transaction;
                }

                using (SqlCommand commond = new SqlCommand()
                {
                    Connection = (SqlConnection)conn,
                    CommandType = CommandType.Text,
                    Transaction = sqlTran
                })
                {
                    if (relation.ID == Guid.Empty)
                    {
                        commond.CommandText = @"insert into [UserRoleRelation]([id],[userkey],[systemid],[roleid],[createtime],[modifytime])
                                    values(default,@userkey,@systemid,getutcdate(),getutcdate());
                                    select @newid=[id] from [UserRoleRelation] where [sequence]=SCOPE_IDENTITY()";
                    }
                    else
                    {
                        commond.CommandText = @"insert into [UserRoleRelation]([id],[userkey],[systemid],[roleid],[createtime],[modifytime])
                                    values(@id,@userkey,@systemid,@roleid,getutcdate(),getutcdate())";
                    }

                    SqlParameter parameter;
                    if (relation.ID != Guid.Empty)
                    {
                        parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier)
                        {
                            Value = relation.ID
                        };
                        commond.Parameters.Add(parameter);
                    }
                    else
                    {
                        parameter = new SqlParameter("@newid", SqlDbType.UniqueIdentifier)
                        {
                            Direction = ParameterDirection.Output
                        };
                        commond.Parameters.Add(parameter);
                    }

                    parameter = new SqlParameter("@userkey", SqlDbType.NVarChar, 150)
                    {
                        Value = relation.UserKey
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@systemid", SqlDbType.UniqueIdentifier)
                    {
                        Value = relation.System.ID
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@roleid", SqlDbType.UniqueIdentifier)
                    {
                        Value = relation.Role.ID
                    };
                    commond.Parameters.Add(parameter);

                    commond.Prepare();


                    await commond.ExecuteNonQueryAsync();



                    if (relation.ID == Guid.Empty)
                    {
                        relation.ID = (Guid)commond.Parameters["@newid"].Value;
                    }
                }
            });
        }
Exemplo n.º 13
0
        /// <summary>
        /// 用户与角色关系添加
        /// </summary>
        /// <param name="rolePermissionRelation"></param>
        /// <returns></returns>
        public int RARolesAdd(UserRoleRelation userRoleRelation)
        {
            int result = DapperHelper.Insert <UserRoleRelation>(userRoleRelation);

            return(result);
        }
Exemplo n.º 14
0
        public static void Initialize(SchedulerZContext context)
        {
            context.Database.EnsureCreated();

            if (context.Users.Any())
            {
                return;
            }

            var user = new User()
            {
                Username      = "******",
                Password      = "******",
                Name          = "Admin",
                Avatar        = "https://gw.alipayobjects.com/zos/rmsportal/jZUIxmJycoymBprLOUbT.png",
                LastLoginIp   = "192.168.1.180",
                LastLoginTime = DateTime.Now,
                Status        = 1,
                CreateTime    = DateTime.Now,
                IsDelete      = false
            };

            context.Users.Add(user);
            context.SaveChanges();

            var role = new Role()
            {
                Identify   = "admin",
                Name       = "管理员",
                CreateTime = DateTime.Now,
            };

            context.Roles.Add(role);
            context.SaveChanges();

            var routers = new Router[] {
                new Router()
                {
                    Title      = "仪表盘",
                    Path       = "/dashboard",
                    Name       = "Dashboard",
                    Component  = "RouteView",
                    Permission = "dashboard",
                    Icon       = "dashboard",
                    Show       = true,
                    Redirect   = "/dashboard/workplace",
                    ParentId   = 0,
                    Sort       = 1000,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "工作台",
                    Path       = "/dashboard/workplace",
                    Name       = "Workplace",
                    Component  = "Workplace",
                    Permission = "dashboard",
                    Icon       = "",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 1,
                    Sort       = 1001,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "系统管理",
                    Path       = "/system",
                    Name       = "System",
                    Component  = "RouteView",
                    Permission = "system",
                    Icon       = "slack",
                    Show       = true,
                    Redirect   = "/system/user",
                    ParentId   = 0,
                    Sort       = 2000,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "用户管理",
                    Path       = "/system/user",
                    Name       = "User",
                    Component  = "User",
                    Permission = "system",
                    Icon       = "",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 3,
                    Sort       = 2001,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "角色管理",
                    Path       = "/system/role",
                    Name       = "Role",
                    Component  = "Role",
                    Permission = "system",
                    Icon       = "",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 3,
                    Sort       = 2002,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "权限管理",
                    Path       = "/system/permission",
                    Name       = "Permission",
                    Component  = "Permission",
                    Permission = "system",
                    Icon       = "",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 3,
                    Sort       = 2003,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "节点管理",
                    Path       = "/node",
                    Name       = "Node",
                    Component  = "RouteView",
                    Permission = "",
                    Icon       = "global",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 0,
                    Sort       = 3000,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "节点列表",
                    Path       = "/node/list",
                    Name       = "NodeList",
                    Component  = "NodeList",
                    Permission = "",
                    Icon       = "",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 7,
                    Sort       = 3001,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "服务列表",
                    Path       = "/node/services",
                    Name       = "Services",
                    Component  = "Services",
                    Permission = "",
                    Icon       = "",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 7,
                    Sort       = 3002,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "任务列表",
                    Path       = "/jobs",
                    Name       = "Jobs",
                    Component  = "Jobs",
                    Permission = "",
                    Icon       = "schedule",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 0,
                    Sort       = 4000,
                    CreateTime = DateTime.Now
                },
                new Router()
                {
                    Title      = "系统日志",
                    Path       = "/logs",
                    Name       = "Logs",
                    Component  = "Logs",
                    Permission = "",
                    Icon       = "file-search",
                    Show       = true,
                    Redirect   = "",
                    ParentId   = 0,
                    Sort       = 5000,
                    CreateTime = DateTime.Now
                }
            };

            context.Routers.AddRange(routers);
            context.SaveChanges();

            var userRoleRelation = new UserRoleRelation()
            {
                UserId = user.Id,
                RoleId = role.Id
            };

            context.UserRoleRelations.Add(userRoleRelation);

            var roleRouterRelations = new List <RoleRouterRelation>();

            foreach (var item in routers)
            {
                roleRouterRelations.Add(new RoleRouterRelation()
                {
                    RoleId   = role.Id,
                    RouterId = item.Id
                });
            }
            context.RoleRouterRelations.AddRange(roleRouterRelations);
            context.SaveChanges();
        }
Exemplo n.º 15
0
        public async Task <QueryResult <UserRoleRelation> > QueryByRoleAndUserKey(Guid roleId, string userKey, int page, int pageSize)
        {
            QueryResult <UserRoleRelation> result = new QueryResult <UserRoleRelation>();

            await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, true, false, _privilegeManagementConnectionFactory.CreateReadForPrivilegeManagement(), async (conn, transaction) =>
            {
                SqlTransaction sqlTran = null;
                if (transaction != null)
                {
                    sqlTran = (SqlTransaction)transaction;
                }

                using (SqlCommand commond = new SqlCommand()
                {
                    Connection = (SqlConnection)conn,
                    CommandType = CommandType.Text,
                    Transaction = sqlTran,
                    CommandText = string.Format(@"set @currentpage=@page
		                           select @count= count(*) from [UserRoleRelation] as urr join [Role] as r
                                   on urr.[roleid]=r.[id] join [PrivilegeSystem] as s
                                   on urr.[systemid]=s.[id] where r.[id]=@roleid and urr.[userkey] like @userkey

		                           if @pagesize*@page>=@count
			                          begin
				                           set @currentpage= @count/@pagesize
				                           if @count%@pagesize<>0
					                           begin
						                            set @currentpage=@currentpage+1
					                           end
				                           if @currentpage=0
					                           set @currentpage=1
			                          end
		                            else if @page<1 
			                           begin 
				                           set @currentpage=1
			                           end
	
                                    select {0},{1},{2} from [UserRoleRelation] as urr join [Role] as r
                                    on urr.[roleid]=r.[id] join [PrivilegeSystem] as s
                                    on urr.[systemid]=s.[id] where r.[id]=@roleid and urr.[userkey] like @userkey
                                    order by urr.[sequence] desc 
		                            offset (@pagesize * (@currentpage - 1)) rows 
		                            fetch next @pagesize rows only;"        , StoreHelper.GetUserRoleRelationSelectFields("urr"), StoreHelper.GetRoleSelectFields("r"), StoreHelper.GetPrivilegeSystemSelectFields("s"))
                })
                {
                    var parameter = new SqlParameter("@page", SqlDbType.Int)
                    {
                        Value = page
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@pagesize", SqlDbType.Int)
                    {
                        Value = pageSize
                    };

                    parameter = new SqlParameter("@roleid", SqlDbType.UniqueIdentifier)
                    {
                        Value = roleId
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@userKey", SqlDbType.NVarChar, 150)
                    {
                        Value = $"{userKey.ToSqlLike()}%"
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@count", SqlDbType.Int)
                    {
                        Direction = ParameterDirection.Output
                    };
                    commond.Parameters.Add(parameter);

                    parameter = new SqlParameter("@currentpage", SqlDbType.Int)
                    {
                        Direction = ParameterDirection.Output
                    };
                    commond.Parameters.Add(parameter);

                    commond.Prepare();


                    SqlDataReader reader = null;

                    using (reader = await commond.ExecuteReaderAsync())
                    {
                        while (await reader.ReadAsync())
                        {
                            var relation = new UserRoleRelation();
                            StoreHelper.SetUserRoleRelationSelectFields(relation, reader, "urr");
                            relation.Role = new Role();
                            StoreHelper.SetRoleSelectFields(relation.Role, reader, "r");
                            relation.System = new PrivilegeSystem();
                            StoreHelper.SetPrivilegeSystemSelectFields(relation.System, reader, "s");
                            result.Results.Add(relation);
                        }

                        reader.Close();

                        result.TotalCount  = (int)commond.Parameters["@count"].Value;
                        result.CurrentPage = (int)commond.Parameters["@currentpage"].Value;
                    }
                }
            });

            return(result);
        }
 /// <summary>
 /// 删除用户角色关联对象
 /// </summary>
 /// <param name="relation"></param>
 private void Remove(UserRoleRelation relation)
 {
     UnitOfWork.RegisterRemove<UserRoleRelation, int>(relation);
 }
        /// <summary>
        /// <see cref="IUserRoleRelationService"/>
        /// </summary>
        /// <param name="user"><see cref="IUserRoleRelationService"/></param>
        /// <param name="role"><see cref="IUserRoleRelationService"/></param>
        public void AddRelation(User user, Role role)
        {
            Guidance.ArgumentNotNull(user, "user");
            Guidance.ArgumentNotNull(role, "role");

            var relation = new UserRoleRelation(user, role);

            UnitOfWork.RegisterNew<UserRoleRelation, int>(relation);
        }
Exemplo n.º 18
0
        public JsonResult Register(UserRegisterViewModel model)
        {
            bool   success         = false;
            string message         = "";
            var    emailControl    = RegexExtension.EmailRegexControl(model.Email);
            var    passwordControl = PasswordControlExtension.PasswordControl(model.Password, model.RePassword);
            var    hasEmail        = db.Users.FirstOrDefault(x => x.Email == model.Email);

            if (hasEmail != null || !passwordControl || !passwordControl ||
                string.IsNullOrEmpty(model.Email) ||
                string.IsNullOrEmpty(model.Password) ||
                string.IsNullOrEmpty(model.RePassword) ||
                string.IsNullOrEmpty(model.Name) ||
                string.IsNullOrEmpty(model.Surname) ||
                string.IsNullOrEmpty(model.PhoneNumber))
            {
                if (hasEmail != null)
                {
                    success = false;
                    message = "Email adresi sistemimizde kayıtlıdır.";
                }
                if (!emailControl)
                {
                    success = emailControl;
                    message = "Emailinizi kontrol ediniz";
                }
                if (!passwordControl)
                {
                    success = passwordControl;
                    message = "Şifreler eşleşmiyor";
                }
                if (string.IsNullOrEmpty(model.Email) || string.IsNullOrEmpty(model.Password) || string.IsNullOrEmpty(model.RePassword) || string.IsNullOrEmpty(model.Name) || string.IsNullOrEmpty(model.Surname) || string.IsNullOrEmpty(model.PhoneNumber))
                {
                    message = "Boş alanları doldurunuz!";
                }
            }
            else
            {
                var userRegisterModel = new Users
                {
                    Email       = model.Email,
                    Password    = model.Password,
                    CreatedDate = DateTime.Now,
                    Name        = model.Name,
                    Surname     = model.Surname,
                    TelNo       = model.PhoneNumber
                };
                var user = db.Users.Add(userRegisterModel);

                var userRoleRelationModel = new UserRoleRelation()
                {
                    FkUserId     = user.Id,
                    FkUserRoleId = 2,
                    Status       = 1,
                    CreatedDate  = DateTime.Now,
                };
                db.UserRoleRelation.Add(userRoleRelationModel);
                db.SaveChanges();
                success = true;
                message = $"{user.Name } {user.Surname} Kayıt işlemi başarıyla gerçekleşti.";
            }


            var result = new ResultViewModel()
            {
                Message = message,
                Success = success
            };

            return(Json(result));
        }
Exemplo n.º 19
0
        /// <summary>
        /// 重载seed方法放入初始化数据
        /// </summary>
        /// <param name="context"></param>
        protected override void Seed(Bootstrap.Entity.Repository.EntityDBContext context)
        {
            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet<T>.AddOrUpdate() helper extension method
            //  to avoid creating duplicate seed data.

            if (context.UserSet.FirstOrDefault() == null)
            {
                //默认用户
                var defaultUser = new User {
                    Sex = User.Gender.男, NickName = "赵日天", UserName = "******", PassWord = "******"
                };
                context.UserSet.Add(defaultUser);
            }

            if (context.NavigationMenuSet.FirstOrDefault() == null)
            {
                //默认菜单
                var defaultMenuList = new List <NavigationMenu>()
                {
                    new NavigationMenu {
                        MenuName = "控制台", ShortName = "system_console", Url = "/Manage/Home/Index"
                    },
                    new NavigationMenu {
                        MenuName = "系统设置", ShortName = "system_set"
                    },
                    new NavigationMenu {
                        MenuName = "菜单管理", ShortName = "system_set_menu", Url = "/Manage/Menu/Index", ParentMenuId = 2
                    },
                    new NavigationMenu {
                        MenuName = "角色管理", ShortName = "system_set_role", Url = "/Manage/Role/Index", ParentMenuId = 2
                    },
                    new NavigationMenu {
                        MenuName = "用户管理", ShortName = "system_set_user", Url = "/Manage/User/Index", ParentMenuId = 2
                    }
                };
                defaultMenuList.ForEach(s => context.NavigationMenuSet.Add(s));
            }

            if (context.RoleSet.FirstOrDefault() == null)
            {
                //默认角色
                var defaultRoleList = new List <Role>()
                {
                    new Role {
                        RoleName = "管理员", RoleDesc = "管理员角色"
                    },
                    new Role {
                        RoleName = "用户", RoleDesc = "用户角色"
                    },
                };
                defaultRoleList.ForEach(s => context.RoleSet.Add(s));
            }

            if (context.UserRoleRelationSet.FirstOrDefault() == null)
            {
                //默认用户-角色
                var defaultUserRole = new UserRoleRelation
                {
                    RoleId = 1,
                    UserId = 1,
                };
                context.UserRoleRelationSet.Add(defaultUserRole);
            }

            if (context.RolePermissionRelationSet.FirstOrDefault() == null)
            {
                //默认角色-权限
                var defaultRolePermissionList = new List <RolePermissionRelation>
                {
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Home"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Home/Index"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Menu"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Menu/Index"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Menu/AddOrEidtMenuView"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Menu/GetMenuTree"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Menu/AddOrEidtMenu"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Menu/DeleteMenu"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/Index"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/AddOrEidtRoleView"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/ChangePermissionView"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/AddOrEditRole"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/BatchDeleteRole"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/GetRoleList"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/DeleteRole"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/GetRolePermissionList"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/Role/SaveRolePermission"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/User"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/User/Index"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/User/ChangePermissionView"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/User/AddOrEditUserView"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/User/GetUserList"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/User/SaveUserPermission"
                    },
                    new RolePermissionRelation {
                        RoleId = 1, PermissionName = "/Manage/User/SaveUserInfo"
                    },
                };
                defaultRolePermissionList.ForEach(s => context.RolePermissionRelationSet.Add(s));
            }

            if (context.UserPermissionRelationSet.FirstOrDefault() == null)
            {
                //默认用户-权限
                var defaultUserPermissionList = new List <UserPermissionRelation>
                {
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Home"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Home/Index"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Menu"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Menu/Index"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Menu/AddOrEidtMenuView"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Menu/GetMenuTree"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Menu/AddOrEidtMenu"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Menu/DeleteMenu"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/Index"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/AddOrEidtRoleView"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/ChangePermissionView"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/AddOrEditRole"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/BatchDeleteRole"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/GetRoleList"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/DeleteRole"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/GetRolePermissionList"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/Role/SaveRolePermission"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/User"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/User/Index"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/User/ChangePermissionView"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/User/AddOrEditUserView"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/User/GetUserList"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/User/SaveUserPermission"
                    },
                    new UserPermissionRelation {
                        UserId = 1, PermissionName = "/Manage/User/SaveUserInfo"
                    },
                };
                defaultUserPermissionList.ForEach(s => context.UserPermissionRelationSet.Add(s));
            }
            context.SaveChanges();
        }