#include "SysDictDao.h"


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

}

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

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

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

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

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

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

        result.append(item);
    }

    return result;
}

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


QVariantMap SysDictDao::findChildDictByCode(QString code)
{
    // 新建查询
    QSqlQuery query(ConnectionManager::getInstance()->getConnection());

    // 查询语句
    QString sql = "SELECT * FROM SYS_DICT where PID = (SELECT ID FROM SYS_DICT WHERE CODE = :code)";
    query.prepare(sql);
    query.bindValue(":code", code);

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

    // 返回结果
    QVariantMap result;

    // 遍历查询结果
    while (query.next()) {
        result.insert(query.value("code").toString(), query.value("name").toString());
    }

    return result;
}

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

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

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