コード例 #1
0
        public SystemRole UpdateSystemRole(string systemRoleId, string roleName, EnumSystemRoleType roleType, SystemRolePermissions permissions, SystemRoleAssignments assignments)
        {
            if(string.IsNullOrEmpty(roleName))
            {
                throw new ArgumentNullException("roleName");
            }
            using(var db = _sqlConnectionInfo.GetDB())
            {
                var count = db.ExecuteScalar<int>("SELECT COUNT(*) FROM SystemRole WHERE RoleName=@0 AND ID<>@1", roleName, systemRoleId);
                if(count != 0)
                {
                    throw new ArgumentException("RoleName already exists: " + roleName);
                }
            }
            var item = this.GetDBItem(systemRoleId);
            item.RoleName = roleName;
            item.RoleType = roleType;
            item.PermissionsJson = (permissions ?? new SystemRolePermissions()).ToJson();
            item.SetUpdatedFields(_userIdentity.UserName);
            using(var db = _sqlConnectionInfo.GetDB())
            {
                db.Update("SystemRole", "ID", item, item.Id);

                if(assignments == null || assignments.UserNameList == null || assignments.UserNameList.Count == 0)
                {
                    db.Execute("DELETE FROM SystemRoleUser WHERE SystemRoleID=@0", systemRoleId);
                }
                else 
                {
                    var itemsToAdd = new List<string>();
                    var itemsToDelete = new List<SqlSystemRoleUser>();

                    foreach(var newUserName in assignments.UserNameList)
                    {
                        if(!item.SystemRoleUserList.Any(i=>i.UserName.Equals(newUserName, StringComparison.CurrentCultureIgnoreCase)))
                        {
                            itemsToAdd.Add(newUserName);
                        }
                    }
                    foreach(var oldUser in item.SystemRoleUserList)
                    {
                        if(!assignments.UserNameList.Contains(oldUser.UserName, StringComparer.CurrentCultureIgnoreCase))
                        {
                            itemsToDelete.Add(oldUser);
                        }
                    }
                    foreach(var newUserName in itemsToAdd)
                    {
                        var dbItem = new SqlSystemRoleUser
                        {
                            Id = Guid.NewGuid().ToString(),
                            SystemRoleId = systemRoleId, 
                            UserName = newUserName
                        };
                        db.Insert("SystemRoleUser", "ID", false, dbItem);
                    }
                    foreach(var oldUser in itemsToDelete)
                    {
                        db.Execute("DELETE FROM SystemRoleUser WHERE ID=@0", oldUser.Id);
                    }
                }
            }
            return this.GetSystemRole(item.Id);
        }
コード例 #2
0
 public SystemRole CreateSystemRole(string roleName, EnumSystemRoleType roleType, SystemRolePermissions permissions, SystemRoleAssignments assignments)
 {
     if(string.IsNullOrEmpty(roleName))
     {
         throw new ArgumentNullException("roleName");
     }
     using (var db = _sqlConnectionInfo.GetDB())
     {
         var count = db.ExecuteScalar<int>("SELECT COUNT(*) FROM SystemRole WHERE RoleName=@0", roleName);
         if (count != 0)
         {
             throw new ArgumentException("RoleName already exists: " + roleName);
         }
     }
     var item = new SqlSystemRole
     {
         Id = Guid.NewGuid().ToString(),
         RoleName = roleName, 
         RoleType = roleType,
         PermissionsJson = (permissions ?? new SystemRolePermissions()).ToJson(),
         //AssignmentsJson = (assignments ?? new SystemRoleAssignments()).ToJson()
     };
     item.SetCreatedFields(_userIdentity.UserName);
     using(var db = _sqlConnectionInfo.GetDB())
     {
         db.Insert("SystemRole", "ID", false, item);
         
         if(assignments != null && assignments.UserNameList != null)
         {
             foreach(var userName in assignments.UserNameList)
             {
                 var userItem = new SqlSystemRoleUser
                 {
                     Id = Guid.NewGuid().ToString(),
                     SystemRoleId = item.Id,
                     UserName = userName
                 };
                 db.Insert("SystemRoleUser", "ID", false, userItem);
             }
         }
     }
     return this.GetSystemRole(item.Id);
 }