| | |
| | | { |
| | | UserRoleRelHelper.SaveUserRoleRel(sqliteHelper, Roles, SelectedUser, null, null); |
| | | } |
| | | |
| | | public void DeleteUserByUsername(string username) |
| | | { |
| | | sqliteHelper.ExecuteBatchSql(new List<string> { |
| | | $"DELETE FROM user WHERE username = '{username}';", |
| | | $"DELETE FROM user_role_rel WHERE username = '{username}';" |
| | | }); |
| | | } |
| | | |
| | | public void DeleteUserByUsernames(IEnumerable<string> usernames) |
| | | { |
| | | List<string> sqls = new List<string>(); |
| | | foreach (string username in usernames) |
| | | { |
| | | sqls.Add($"DELETE FROM user WHERE username = '{username}';"); |
| | | sqls.Add($"DELETE FROM user_role_rel WHERE username = '{username}';"); |
| | | } |
| | | sqliteHelper.ExecuteBatchSql(sqls); |
| | | } |
| | | } |
| | | } |