D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:60: error: no matching function for call to 'service::DatabaseManager::executeNonQuery(QString&)'
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp: In function 'vo
id data::
UserControl::Login::createUserTable()':
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:60:35: error: no matching function for call to 'service::DatabaseManager::executeNonQuery(QString&)'
60 | db.executeNonQuery(createTableQuery);
| ~~~~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~
D:\QT_PROGRAM\LabNexus\pch.h:27: In file included from D:/QT_PROGRAM/LabNexus/pch.h:27,
In file included from D:/QT_PROGRAM/LabNexus/pch.h:27,
from D:/QT_PROGRAM/LabNexus/build/Desktop_Qt_6_8_2_MinGW_64_bit-Debug/CMakeFiles/LabNexus.dir/cmake_pch.hxx:5,
from <command-line>:
D:/QT_PROGRAM/LabNexus/service/database/databaseManager.h:41:14: note: cand
idate: 'bool service::DatabaseManager::executeNonQuery(const QString&, const QMap<QString, QVariant>&)'
41 | bool executeNonQuery(const QString &queryString,const QMap<QString, QVariant> ¶ms);
| ^~~~~~~~~~~~~~~
D:/QT_PROGRAM/LabNexus/service/database/databaseManager.h:41:14: note: cand
idate expects 2 arguments, 1 prov
ided
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:218: error: no matching function for call to 'service::DatabaseManager::executeNonQuery(QString&)'
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp: In function 'vo
id data::
UserControl::permission::createGroupTable()':
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:218:35: error: no matching function for call to 'service::DatabaseManager::executeNonQuery(QString&)'
218 | db.executeNonQuery(createTableQuery);
| ~~~~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~
D:/QT_PROGRAM/LabNexus/service/database/databaseManager.h:41:14: note: cand
idate: 'bool service::DatabaseManager::executeNonQuery(const QString&, const QMap<QString, QVariant>&)'
41 | bool executeNonQuery(const QString &queryString,const QMap<QString, QVariant> ¶ms);
| ^~~~~~~~~~~~~~~
D:/QT_PROGRAM/LabNexus/service/database/databaseManager.h:41:14: note: cand
idate expects 2 arguments, 1 prov
ided
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:235: error: no matching function for call to 'service::DatabaseManager::executeNonQuery(QString&)'
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp: In function 'vo
id data::
UserControl::permission::createUserGroupTable()':
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:235:35: error: no matching function for call to 'service::DatabaseManager::executeNonQuery(QString&)'
235 | db.executeNonQuery(createUserGroupTableQuery);
| ~~~~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~
D:/QT_PROGRAM/LabNexus/service/database/databaseManager.h:41:14: note: cand
idate: 'bool service::DatabaseManager::executeNonQuery(const QString&, const QMap<QString, QVariant>&)'
41 | bool executeNonQuery(const QString &queryString,const QMap<QString, QVariant> ¶ms);
| ^~~~~~~~~~~~~~~
D:/QT_PROGRAM/LabNexus/service/database/databaseManager.h:41:14: note: cand
idate expects 2 arguments, 1 prov
ided
mingw32-make.exe[2]:-1: *** [CMakeFiles\LabNexus.dir\build.make:429: CMakeFiles/LabNexus.dir/module/data/data_
UserControl.cpp.obj] Error 1
mingw32-make.exe[1]:-1: *** [CMakeFiles\Makefile2:114: CMakeFiles/LabNexus.dir/all] Error 2
mingw32-make.exe:-1: *** [Makefile:100: all] Error 2
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:60: error: Too few arguments to function call, expected 2, have 1
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:218: error: Too few arguments to function call, expected 2, have 1
D:\QT_PROGRAM\LabNexus\module\data\data_
UserControl.cpp:235: error: Too few arguments to function call, expected 2, have 1
关于该.cpp文件报错原因？
//
// Created by gouzuang on 25-7-6.
//
#include<pch.h>
#include "module/data/data_
UserControl.h"
namespace data::
UserControl {
vo
id dropDB() {
QFile dbFile(path);
if (dbFile.exists()) {
if (dbFile.remove()) {
log(LogLevel::INFO) << "数据库文件删除成功";
} else {
log(LogLevel::ERR) << "数据库文件删除失败";
}
} else {
log(LogLevel::INFO) << "数据库文件不存在";
}
}
vo
id buildDB() {
QFile dbFile(path);
if (!dbFile.exists()) {
if (dbFile.open(QIODevice::WriteOnly)) {
dbFile.close();
log(service::LogLevel::INFO) << "数据库文件创建成功";
} else {
log(service::LogLevel::ERR) << "数据库文件创建失败";
}
Login::createUserTable();
permission::createGroupTable();
permission::createUserGroupTable();
// 创建用户组
if (auto r = permission::createGroup("Student", ""); !r) {
log(LogLevel::ERR) << "创建组 Student 失败, 错误码:" << static_cast<int>(r.error());
}
if (auto r = permission::createGroup("Teacher", ""); !r) {
log(LogLevel::ERR) << "创建组 Teacher 失败, 错误码:" << static_cast<int>(r.error());
}
} else {
log(service::LogLevel::INFO) << "数据库文件已存在";
}
}
namespace Login {
vo
id createUserTable() {
service::DatabaseManager db(path);
if (!db.tableExists("users")) {
QString createTableQuery = R"(
CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
id_number TEXT
UNIQUE NOT NULL,
username TEXT NOT NULL,
password TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
status Text NOT NULL DEFAULT 'AllRight'
)
)";
db.executeNonQuery(createTableQuery);
}
}
std::expected<int,
UserControlError> isUserPasswordVal
id(const QString &
idNumber, const QString &password) {
service::DatabaseManager db(path);
log(service::LogLevel::INFO) << "开始验证用户密码: " <<
idNumber;
QString query = R"(
SELECT
id, password, status FROM users WHERE
id_number = ?
)";
auto results = db.executePreparedQueryAndFetchAll(query, {
idNumber});
if (results.isEmpty()) {
log(service::LogLevel::ERR) << "登录失败。用户不存在: " <<
idNumber;
return std::unexpected(
UserControlError::UserNotFound);
}
const auto& row = results.first();
int user
Id = row["
id"].toInt();
QString storedPassword = row["password"].toString();
QString status = row["status"].toString();
if (status != "AllRight") {
log(service::LogLevel::ERR) << "登录失败。用户状态异常: " <<
idNumber << " status: " << status;
return std::unexpected(
UserControlError::UserNotFound);
}
if (storedPassword != password) {
log(service::LogLevel::ERR) << "登录失败。密码错误: " <<
idNumber;
return std::unexpected(
UserControlError::IncorrectPassword);
}
log(service::LogLevel::INFO) << "登录成功。密码验证成功: " <<
idNumber;
currentUser
Id = user
Id;
return user
Id;
}
std::expected<int,
UserControlError> createNewUser(const QString &
idNumber, const QString &username,
const QString &password) {
service::DatabaseManager db(path);
if (!db.tableExists("users")) {
log(service::LogLevel::ERR) << "用户表不存在";
throw std::runtime_error("User table does not exist.");
}
auto user
Id = foundUser
IdBy
IdNumber(
idNumber);
if (user
Id.has_value()) {
log(service::LogLevel::INFO) << "用户已存在: " <<
idNumber;
return std::unexpected(
UserControlError::UserAlreadyExists);
}
QString insertQuery = R"(
INSERT INTO users(
id_number, username, password, status)
VALUES(?, ?, ?, 'AllRight')
)";
if (!db.executePreparedNonQuery(insertQuery, {
idNumber, username, password})) {
log(service::LogLevel::ERR) << "新用户创建失败: " <<
idNumber;
throw std::runtime_error("Failed to create new user.");
}
log(service::LogLevel::DATA) << "新用户创建成功: " <<
idNumber;
auto newUser
Id = foundUser
IdBy
IdNumber(
idNumber);
if (!newUser
Id.has_value()) {
throw std::runtime_error("Failed to retrieve new user
ID after creation.");
}
return newUser
Id.value();
}
std::expected<int,
UserControlError> createNewUser(const QString &
idNumber, const QString &username,
const QString &password,
const QString group) {
auto newUserResult = createNewUser(
idNumber, username, password);
if (!newUserResult) {
return std::unexpected(newUserResult.error());
}
if (group.isEmpty()) {
log(service::LogLevel::DATA) << "未指定组，用户创建成功但未添加到任何组";
return newUserResult.value();
}
log(service::LogLevel::DATA) << "尝试将用户添加到组: " << group;
auto addToGroupResult = permission::addUserToGroup(newUserResult.value(), group);
if (!addToGroupResult) {
log(service::LogLevel::ERR) << "用户 " << newUserResult.value() << " 添加到组 " << group << " 失败";
return std::unexpected(addToGroupResult.error());
}
return newUserResult.value();
}
std::expected<int,
UserControlError> foundUser
IdBy
IdNumber(const QString &
idNumber) {
service::DatabaseManager db(path);
QString query = "SELECT
id FROM users WHERE
id_number = ?";
auto results = db.executePreparedQueryAndFetchAll(query, {
idNumber});
if (results.isEmpty()) {
return std::unexpected(
UserControlError::UserNotFound);
}
return results.first()["
id"].toInt();
}
std::expected<bool,
UserControlError> deleteUserBy
Id(int user
Id) {
service::DatabaseManager db(path);
// 检查用户是否存在
QString checkQuery = R"(
SELECT
id FROM users WHERE
id = ?
)";
auto results = db.executePreparedQueryAndFetchAll(checkQuery, {user
Id});
if (results.isEmpty()) {
log(service::LogLevel::INFO) << "删除失败。用户不存在: " << user
Id;
return std::unexpected(
UserControlError::UserNotFound);
}
// 标记用户在 user_groups 中的关联为 Deleted
QString updateGroupsStatus = R"(
UPDATE user_groups SET status = 'Deleted' WHERE user_
id = ?
)";
db.executePreparedNonQuery(updateGroupsStatus, {user
Id});
// 标记用户为 Deleted
QString updateUserStatus = R"(
UPDATE users SET status = 'Deleted' WHERE
id = ?
)";
if (db.executePreparedNonQuery(updateUserStatus, {user
Id})) {
log(service::LogLevel::DATA) << "用户标记为已删除: " << user
Id;
return true;
}
log(service::LogLevel::ERR) << "标记用户删除失败: " << user
Id;
return std::unexpected(
UserControlError::DatabaseError);
}
std::expected<bool,
UserControlError> updateUserPassword(int user
Id, const QString &newPassword) {
service::DatabaseManager db(path);
QString updateQuery = R"(
UPDATE users
SET password = ?
WHERE
id = ?
)";
if (!db.executePreparedNonQuery(updateQuery, {newPassword, user
Id})) {
return std::unexpected(
UserControlError::DatabaseError);
}
log(service::LogLevel::DATA) << "用户" << user
Id << "密码更新成功: " << user
Id;
return true;
}
}
namespace permission {
vo
id createGroupTable() {
service::DatabaseManager db(path);
if (!db.tableExists("groups")) {
QString createTableQuery = R"(
CREATE TABLE groups(
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT
UNIQUE NOT NULL,
description TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
status TEXT NOT NULL DEFAULT 'AllRight'
)
)";
db.executeNonQuery(createTableQuery);
}
}
vo
id createUserGroupTable() {
service::DatabaseManager db(path);
if (!db.tableExists("user_groups")) {
QString createUserGroupTableQuery = R"(
CREATE TABLE user_groups(
user_
id INTEGER NOT NULL,
group_
id INTEGER NOT NULL,
status TEXT NOT NULL DEFAULT 'AllRight',
FOREIGN KEY(user_
id) REFERENCES users(
id),
FOREIGN KEY(group_
id) REFERENCES groups(
id),
PRIMARY KEY(user_
id, group_
id)
)
)";
db.executeNonQuery(createUserGroupTableQuery);
}
}
std::expected<bool,
UserControlError> createGroup(const QString &name, const QString &description) {
service::DatabaseManager db(path);
if (!db.tableExists("groups")) {
throw std::runtime_error("Group table does not exist.");
}
// 检查组是否已存在
QString checkGroupQuery = R"(
SELECT
id FROM groups WHERE name = ?
)";
auto results = db.executePreparedQueryAndFetchAll(checkGroupQuery, {name});
if (!results.isEmpty()) {
log(service::LogLevel::INFO) << "组已存在: " << name;
return std::unexpected(
UserControlError::GroupAlreadyExists);
}
QString insertQuery = R"(
INSERT INTO groups(name, description, status)
VALUES(?, ?, 'AllRight')
)";
if (db.executePreparedNonQuery(insertQuery, {name, description})) {
log(service::LogLevel::DATA) << "新组创建成功: " << name;
return true;
}
log(service::LogLevel::ERR) << "新组创建失败: " << name;
return std::unexpected(
UserControlError::DatabaseError);
}
std::expected<bool,
UserControlError> addUserToGroup(int user
Id, const QString &groupName) {
service::DatabaseManager db(path);
// 检查组是否存在
QString checkGroupQuery = R"(
SELECT
id FROM groups WHERE name = ?
)";
auto groupResults = db.executePreparedQueryAndFetchAll(checkGroupQuery, {groupName});
if (groupResults.isEmpty()) {
log(service::LogLevel::INFO) << "组不存在: " << groupName;
return std::unexpected(
UserControlError::GroupNotFound);
}
int group
Id = groupResults.first()["
id"].toInt();
// 检查用户是否已经在该组中
QString checkUserInGroupQuery = R"(
SELECT user_
id FROM user_groups WHERE user_
id = ? AND group_
id = ?
)";
auto userInGroupResults = db.executePreparedQueryAndFetchAll(checkUserInGroupQuery, {user
Id, group
Id});
if (!userInGroupResults.isEmpty()) {
log(service::LogLevel::INFO) << "用户 " << user
Id << " 已经在组 " << groupName << " 中";
return std::unexpected(
UserControlError::UserAlreadyInGroup);
}
// 将用户添加到组
QString insertUserGroupQuery = R"(
INSERT INTO user_groups(user_
id, group_
id, status)
VALUES(?, ?, 'AllRight')
)";
if (db.executePreparedNonQuery(insertUserGroupQuery, {user
Id, group
Id})) {
log(service::LogLevel::DATA) << "用户 " << user
Id << " 添加到组 " << groupName << " 成功";
return true;
}
log(service::LogLevel::ERR) << "用户 " << user
Id << " 添加到组 " << groupName << " 失败";
return std::unexpected(
UserControlError::DatabaseError);
}
QString getUserInWhichGroup(int user
Id) {
service::DatabaseManager db(path);
QString query = R"(
SELECT g.name
FROM groups g
JOIN user_groups ug ON g.
id = ug.group_
id
WHERE ug.user_
id = ?
)";
auto results = db.executePreparedQueryAndFetchAll(query, {user
Id});
QStringList groupNames;
for (const auto &row : results) {
groupNames.append(row["name"].toString());
}
return groupNames.join(", ");
}
bool isUserInGroup(int user
Id, const QString &groupName) {
service::DatabaseManager db(path);
QString query = R"(
SELECT COUNT(*)
FROM user_groups ug
JOIN groups g ON ug.group_
id = g.
id
WHERE ug.user_
id = ? AND g.name = ?
)";
auto results = db.executePreparedQueryAndFetchAll(query, {user
Id, groupName});
if (results.isEmpty()) {
return false;
}
return results.first()["COUNT(*)"].toInt() > 0;
}
}
namespace UserInfo {
std::expected<QString,UserInfoError> getUserNameBy
Id(int user
Id) {
service::DatabaseManager db(path);
QString query = "SELECT username FROM users WHERE
id = ?";
auto results = db.executePreparedQueryAndFetchAll(query, {user
Id});
if (results.isEmpty()) {
return std::unexpected(UserInfoError::UserNotFound);
}
return results.first()["username"].toString();
}
}
}
本文探讨了ASP.NET中动态UserControl的绑定问题，尤其是在postback情况下是否需要重新绑定数据。结论指出，在添加控件前后调用其方法均可，但避免使用IsPostBack条件判断。若必须使用，则应在子控件生成UniqueID后进行。
扫一扫
1235
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
