public UserTileControl(UserData userData, ObservableCollection<RoleData> roles, bool isNewUser, Action<bool, UserData> AddSuccessAction)
        {
            try
            {
                InitializeComponent();
                this._IsNewUser = isNewUser;
                this._user = userData;
                this._roles = roles;
                this.RoleName_List.ItemsSource = this._roles;
                this._UpdateSuccessAction = AddSuccessAction;
                if (isNewUser)
                {
                    this.UserName.Text = "";
                    this.NewPassword.Password = string.Empty;
                    this.Confirm.Password = string.Empty;
                }
                else
                {
                    this.NewPassword.Password = "12345678";
                    this.Confirm.Password = "12345678";
                    this.UserName.Text = userData.UserName;
                    foreach (RoleData item in userData.Roles)
                    {
                        this.RoleName_List.SelectedItems.Add(item);
                    }
                }

            }
            catch (Exception ex)
            {
                Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "UserTileControl.\r\n{0}", ex.ToString());
            }
        }
 public UserTileControl(Guid userId, string userName, int roleId,string roleName,bool isNewUser,Action<UserData> AddSuccessAction)
 {
     this._isNewUser = isNewUser;
     this._user = new UserData();
     this._user.UserId = userId;
     this._user.RoleId = roleId;
     this._user.UserName = userName;
     this._user.RoleName = roleName;
     this._AddSuccessAction = AddSuccessAction;
     InitializeComponent();
     if (isNewUser)
     {
         this.Edit_Click(null, null);
         this.ChangePassword_Click(null, null);
         this.Cancel.Visibility = System.Windows.Visibility.Hidden;
     }
     else
     {
         this.UserName.Text = userName;
         this.RoleName_Text.Text = roleName;
         this.UserName.IsReadOnly = true;
         this.NewPassword.IsReadOnly = true;
         this.RoleName_List.SelectedValue = roleId;
     }
 }
 public static bool AddNewUser(UserData user, string password)
 {
     string encryptPassword = UserDataAccess.GetMd5EncryptPassword(password);
     using (SqlConnection sqlConnection = DataAccess.GetSqlConnection())
     {
         SqlCommand command = sqlConnection.CreateCommand();
         command.CommandText = string.Format("INSERT INTO dbo.Users(Id,[Name],[Password]) VALUES('{0}','{1}','{2}') INSERT INTO dbo.UserInRole(UserId,RoleId) VALUES ('{3}',{4})",user.UserId,user.UserName,encryptPassword,user.UserId,user.RoleId);
         command.CommandType = System.Data.CommandType.Text;
         command.ExecuteNonQuery();
     }
     return true;
 }
 public void DeleteUser(bool isSuccess,UserData user)
 {
     try
     {
         if (isSuccess)
         {
             this.UserManager.Items.Remove(new UserTileControl(user, false, DeleteUser));
         }
     }
     catch (Exception ex)
     {
         Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "UserManager/DeleteUser.\r\n{0}", ex.ToString());
     }
 }
 public void AddUserSuccess(UserData user)
 {
     try
     {
         XamTile tile = new XamTile();
         tile.CloseAction = TileCloseAction.DoNothing;
         tile.Header = user.UserName;
         tile.Content = new UserTileControl(user.UserId, user.UserName, user.RoleId, user.RoleName, false, AddUserSuccess);
         this.UserManager.Items.Add(tile);
     }
     catch (Exception ex)
     {
         Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "AddUserSuccess.\r\n{0}", ex.ToString());
     }
 }
        public UserTileControl(UserData userData, bool isNewUser, Action<bool,UserData> DeleteUser)
        {
            InitializeComponent();
            this._isNewUser = isNewUser;
            this._user = new UserData();
            this._user.UserId = userData.UserId;
            this._user.RoleId = userData.RoleId;
            this._user.UserName = userData.UserName;
            this._user.RoleName = userData.RoleName;
            this._DeleteUser = DeleteUser;

            this.UserName.Text = userData.UserName;
            this.RoleName_Text.Text = userData.RoleName;
            this.UserName.IsReadOnly = true;
            this.NewPassword.IsReadOnly = true;
            this.RoleName_List.SelectedValue = userData.RoleId;
        }
 public void AddUserSuccess(bool isNewUser, UserData user)
 {
     try
     {
         UserModel newUser = new UserModel();
         newUser.UserId = user.UserId;
         newUser.UserName = user.UserName;
         foreach (RoleData item in user.Roles)
         {
             newUser.Roles += item.RoleName + ";";
         }
         this._users.Add(newUser);
         //this.UserManager.Items.Add(tile);
     }
     catch (Exception ex)
     {
         Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "AddUserSuccess.\r\n{0}", ex.ToString());
     }
 }
        public UserTileControl(Guid userId, string userName, int roleId, string roleName, bool isNewUser, ObservableCollection<RoleData> role, Action<bool, UserData> AddSuccessAction)
        {
            this._IsNewUser = isNewUser;
            this._user = new UserData();
            this._user.UserId = userId;
            this._user.UserName = userName;
            this._roles = role;
            this._UpdateSuccessAction = AddSuccessAction;
            InitializeComponent();
            this.RoleName_List.ItemsSource = this._roles;
            if (isNewUser)
            {
                this.Cancel.Visibility = System.Windows.Visibility.Hidden;
            }
            else
            {
                this.UserName.Text = userName;

                this.RoleName_List.SelectedItem = roleId;
                this.RoleName_List.ItemsSource = this._roles;
            }
        }
 public bool UpdateUsers(UserData user, string password, bool isNewUser)
 {
     try
     {
         if (isNewUser)
         {
             UserDataAccess.AddNewUser(user, password);
             return true;
         }
         else
         {
             UserDataAccess.EditUser(user, password);
             return false;
         }
     }
     catch (Exception ex)
     {
         Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "UpdateUsers.\r\n{0}", ex.ToString());
         return false;
     }
 }
 public static List<UserData> GetUserData()
 {
     List<UserData> data = new List<UserData>();
     using (SqlConnection sqlConnection = DataAccess.GetSqlConnection())
     {
         SqlCommand command = sqlConnection.CreateCommand();
         command.CommandText = "SELECT u.Id,u.[Name],r.Id,r.RoleName FROM dbo.Users u INNER JOIN dbo.UserInRole uir ON uir.UserId = u.Id INNER JOIN dbo.Roles r ON r.Id = uir.RoleId";
         command.CommandType = System.Data.CommandType.Text;
         SqlDataReader reader = command.ExecuteReader();
         while (reader.Read())
         {
             UserData user = new UserData();
             user.UserId = (Guid)reader.GetValue(0);
             user.UserName = reader.GetValue(1).ToString();
             user.RoleId = (int)reader.GetValue(2);
             user.RoleName = reader.GetValue(3).ToString();
             data.Add(user);
         }
     }
     return data;
 }
 public static bool EditUser(UserData user, string password)
 {
     string commandText = "UPDATE dbo.Users SET";
     if (!string.IsNullOrEmpty(user.UserName))
     {
         commandText += string.Format("[Name]='{0}'",user.UserName);
     }
     if (string.IsNullOrEmpty(password))
     {
         commandText += string.Format("[Password]=N'{0}'", UserDataAccess.GetMd5EncryptPassword(password));
     }
     commandText += string.Format("WHERE Id='{0}'", user.UserId);
     if (user.RoleId!=0)
     {
         commandText += string.Format("UPDATE dbo.UserInRole SET RoleId = {0} WHERE UserId='{1}'", user.RoleId, user.UserId);
     }
     using (SqlConnection sqlConnection = DataAccess.GetSqlConnection())
     {
         SqlCommand command = sqlConnection.CreateCommand();
         command.CommandText = commandText;
         command.CommandType = System.Data.CommandType.Text;
         command.ExecuteNonQuery();
     }
     return true;
 }
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Button btn = sender as Button;
            try
            {
                Guid userId = (Guid)btn.Tag;
                UserModel userModel = this._users.Single(u => u.UserId == userId);
                if (userId != Guid.Empty)
                {
                    if (btn.Name == "Edit")
                    {
                        UserData user = new UserData();
                        user.UserId = userModel.UserId;
                        user.UserName = userModel.UserName;
                        string[] roles = userModel.Roles.Split(';');
                        foreach (string item in roles)
                        {
                            RoleData role = this._roles.SingleOrDefault(r => r.RoleName == item);
                            if (role != null)
                            {
                                user.Roles.Add(role);
                            }
                        }
                        UserTileControl tile = new UserTileControl(user, this._roles, false, this.AddUserSuccess);
                        this.UseManagerFrame.Children.Add(tile);
                        tile.IsModal = true;
                        tile.Show();
                        tile.BringToFront();
                    }
                    else if (btn.Name == "Delete")
                    {

                        if (MessageBox.Show(App.MainFrameWindow, string.Format("确认删除{0}用户吗", userModel.UserName), "Warnning", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No) == MessageBoxResult.Yes)
                        {
                            ConsoleClient.Instance.DeleteUser(userId, this.DeleteUser);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "UserManagerButton_Click.\r\n{0}{1}", btn.Name, ex.ToString());
            }
        }
 public static bool AddNewUser(UserData user, string password)
 {
     string encryptPassword = UserDataAccess.GetMd5EncryptPassword(password);
     string roles = string.Empty;
     bool isSuccess = false;
     foreach (RoleData role in user.Roles)
     {
         roles += (role.RoleId + ",");
     }
     SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@userId", user.UserId), new SqlParameter("@userName", user.UserName), new SqlParameter("@password",encryptPassword), new SqlParameter("@roles",roles) };
     using (SqlConnection sqlConnection = DataAccess.GetInstance().GetSqlConnection())
     {
         using (SqlTransaction transaction = sqlConnection.BeginTransaction())
         {
             using (SqlCommand command = sqlConnection.CreateCommand())
             {
                 command.CommandText = "[dbo].[User_AddNew]";
                 command.Transaction = transaction;
                 command.CommandType = System.Data.CommandType.StoredProcedure;
                 command.Parameters.Add(new SqlParameter("@userId", user.UserId));
                 command.Parameters.Add(new SqlParameter("@userName", user.UserName));
                 command.Parameters.Add(new SqlParameter("@password", encryptPassword));
                 command.Parameters.Add(new SqlParameter("@roles", roles));
                 command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int) { Direction = ParameterDirection.ReturnValue });
                 command.ExecuteNonQuery();
                 int returnValue = (int)command.Parameters["@RETURN_VALUE"].Value;
                 isSuccess = (returnValue == 0);
                 if (isSuccess)
                 {
                     transaction.Commit();
                 }
             }
         }
     }
     return isSuccess;
 }
        private void EndAddNewUser(bool isSuccess)
        {
            try
            {
                this.Dispatcher.BeginInvoke((Action<bool>)delegate(bool result)
                 {
                     if (!result)
                     {
                         this.Message.Foreground = Brushes.Red;
                         this.Message.Content = "录入失败";
                     }
                     else
                     {
                         this.UserName.Text = "";
                         this.NewPassword.Text = "";
                         this.Confirm.Text = "";
                         this.Message.Foreground = Brushes.Green;
                         this.Message.Content = "录入成功";
                         UserData user = new UserData();
                         this._AddSuccessAction(this._user);
                     }
                 }, isSuccess);
            }
            catch (Exception ex)
            {
                Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "EndAddNewUser.\r\n{0}", ex.ToString());

            }
        }
        private void Submit_Click(object sender, System.Windows.RoutedEventArgs e)
        {
            try
            {
                if (this.CheckSubmitData())
                {
                    UserData user = new UserData();
                    string password = string.Empty;
                    foreach (var item in this.RoleName_List.SelectedItems)
                    {
                            user.Roles.Add((RoleData)item);
                    }
                    if (this._IsNewUser)
                    {
                        this._user.UserId = Guid.NewGuid();
                        password = this.NewPassword.Password;
                        this._user.Roles=user.Roles;
                        this._user.UserName = this.UserName.Text;
                    }
                    else
                    {
                        if (this.NewPassword.Password != "12345678")
                        {
                            password = this.NewPassword.Password;
                        }
                    }
                    user.UserId = this._user.UserId;
                    user.UserName = this._user.UserName;
                    ConsoleClient.Instance.UpdateUser(user, password, this._IsNewUser, EndUpdateUser);

                }
            }

            catch (Exception ex)
            {
                Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "Submit_Click.\r\n{0}", ex.ToString());
            }
        }
 public static bool EditUser(UserData user, string password, out Dictionary<string, List<FuncPermissionStatus>> permissions)
 {
     permissions = new Dictionary<string, List<FuncPermissionStatus>>();
     string roles = string.Empty;
     bool isSuccess = false;
     foreach (RoleData role in user.Roles)
     {
         roles += (role.RoleId + ",");
     }
     using (SqlConnection sqlConnection = DataAccess.GetInstance().GetSqlConnection())
     {
         using (SqlTransaction transaction = sqlConnection.BeginTransaction())
         {
             using (SqlCommand command = sqlConnection.CreateCommand())
             {
                 command.CommandText = "[dbo].[Users_Update]";
                 command.Transaction = transaction;
                 command.CommandType = System.Data.CommandType.StoredProcedure;
                 command.Parameters.Add(new SqlParameter("@userId", user.UserId));
                 if (!string.IsNullOrEmpty(user.UserName))
                 {
                     command.Parameters.Add(new SqlParameter("@userName", user.UserName));
                 }
                 if (!string.IsNullOrEmpty(password))
                 {
                     string encryptPassword = UserDataAccess.GetMd5EncryptPassword(password);
                     command.Parameters.Add(new SqlParameter("@password", encryptPassword));
                 }
                 if (user.Roles.Count != 0)
                 {
                     command.Parameters.Add(new SqlParameter("@roles", roles));
                 }
                 command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int) { Direction = ParameterDirection.ReturnValue });
                 using (SqlDataReader reader = command.ExecuteReader())
                 {
                     if (!string.IsNullOrEmpty(roles))
                     {
                         while (reader.Read())
                         {
                             FuncPermissionStatus func = new FuncPermissionStatus { Code = reader["Code"].ToString(), HasPermission = (bool)reader["Status"] };
                             if (int.Parse(reader["Level"].ToString()) == 1)
                             {
                                 if (!permissions.ContainsKey("root"))
                                 {
                                     permissions.Add("root", new List<FuncPermissionStatus>());
                                 }
                                 permissions["root"].Add(func);
                             }
                             else
                             {
                                 if (!permissions.ContainsKey(reader["Parent"].ToString()))
                                 {
                                     permissions.Add(reader["Parent"].ToString(), new List<FuncPermissionStatus>());
                                 }
                                 permissions[reader["Parent"].ToString()].Add(func);
                                 //permissions.Add(reader["Parent"].ToString(), );
                             }
                         }
                     }
                 }
                 int returnValue = (int)command.Parameters["@RETURN_VALUE"].Value;
                 isSuccess = (returnValue == 0);
                 if (isSuccess)
                 {
                     transaction.Commit();
                 }
             }
         }
     }
     return isSuccess;
 }
 public static List<UserData> GetUserData()
 {
     List<UserData> data = new List<UserData>();
     using (SqlConnection sqlConnection = DataAccess.GetInstance().GetSqlConnection())
     {
         SqlCommand command = sqlConnection.CreateCommand();
         command.CommandText = "SELECT u.Id,u.[Name] FROM dbo.Users u SELECT uir.UserId,uir.RoleId,r.RoleName FROM dbo.UserInRole uir INNER JOIN dbo.Roles r ON r.Id = uir.RoleId";
         command.CommandType = System.Data.CommandType.Text;
         SqlDataReader reader = command.ExecuteReader();
         while (reader.Read())
         {
             UserData user = new UserData();
             user.UserId = (Guid)reader["Id"];
             user.UserName = reader["Name"].ToString();
             data.Add(user);
         }
         reader.NextResult();
         while (reader.Read())
         {
             RoleData role = new RoleData();
             role.RoleId = (int)reader["RoleId"];
             role.RoleName = reader["RoleName"].ToString();
             data.Find(u=>u.UserId==(Guid)reader["UserId"]).Roles.Add(role);
     }
     }
     return data;
 }
        private void Submit_Click(object sender, System.Windows.RoutedEventArgs e)
        {
            try
            {
                if (this.CheckSubmitData())
                {
                    UserData user = new UserData();
                    RoleData role = (RoleData)this.RoleName_List.SelectedItem;

                    if (this._isNewUser)
                    {
                        user.UserId = Guid.NewGuid();
                        user.UserName = this.UserName.Text;
                        user.RoleId = role.RoleId;
                        user.RoleName = role.RoleName;
                        this._user = user;
                        string password = this.NewPassword.Text;
                        ConsoleClient.Instance.UpdateUser(user, password, this._isNewUser, EndAddNewUser);
                    }
                    else
                    {
                        user.UserId = this._user.UserId;
                        user.UserName = this.UserName.Text;
                        if (this._user.UserName == this.UserName.Text)
                        {
                            user.UserName = string.Empty;
                        }
                        if (role.RoleId != this._user.RoleId)
                        {
                            user.RoleId = role.RoleId;
                            user.RoleName = role.RoleName;
                        }
                        else
                        {
                            user.RoleId = 0;
                            user.RoleName = string.Empty;
                        }

                        string password = string.Empty;
                        if (this.ChangePassword.Visibility == System.Windows.Visibility.Hidden)
                        {
                            password = this.NewPassword.Text;
                        }
                        ConsoleClient.Instance.UpdateUser(user, password, false, EndAddNewUser);
                    }
                }
            }
            catch (Exception ex)
            {
                Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "Submit_Click.\r\n{0}", ex.ToString());
            }
        }
示例#19
0
 public void UpdateUser(UserData user, string password,bool isNewUser, Action<bool> EndUpdateUser)
 {
     this._ServiceProxy.BeginUpdateUsers(user, password,isNewUser, delegate(IAsyncResult ar)
     {
         bool isSuccess = this._ServiceProxy.EndUpdateUsers(ar);
         EndUpdateUser(isSuccess);
     }, null);
 }
        private void AddUser_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                UserData user = new UserData();
                UserTileControl newUserDialog = new UserTileControl(user, this._roles, true, AddUserSuccess);
                this.UseManagerFrame.Children.Add(newUserDialog);
                newUserDialog.IsModal = true;
                newUserDialog.Show();
                newUserDialog.BringToFront();

            }
            catch (Exception ex)
            {
                Logger.TraceEvent(System.Diagnostics.TraceEventType.Error, "AddUser_Click.\r\n{0}", ex.ToString());
            }
        }