#include "SysConfigDao.h"

SysConfigDao::SysConfigDao(QObject *parent) : BaseDao(parent)
{

}


QVector<QVariantMap> SysConfigDao::findAllRecord()
{
    // 新建查询
    QSqlQuery query(ConnectionManager::getInstance()->getConnection());

    // 查询语句
    QString sql = "SELECT * FROM SYS_CONFIG";

    // 执行查询
    query.exec(sql);

    // 返回结果
    QVector<QVariantMap> result;

    // 遍历查询结果
    while (query.next()) {
        QVariantMap item;

        item.insert("id", query.value("id").toLongLong());
        item.insert("value", query.value("value").toString());
        item.insert("name", query.value("name").toString());
        item.insert("description", query.value("description").toString());

        result.append(item);
    }

    return result;
}

QVariantMap SysConfigDao::findRecordById(QString id)
{
    QVariantMap item;
    return item;
}


QVector<QVariantMap> SysConfigDao::findRecordsByProperty(QString properName, QVariant properValue)
{
    QVector<QVariantMap> result;
    return result;
}

QString SysConfigDao::save(QVariantMap object)
{
    return "0";
}

bool SysConfigDao::edit(QVariantMap newObject, QString id)
{
    return false;
}

bool SysConfigDao::dele(QString id)
{
    return false;
}