QFD2/QFD/dbService/NodeMatrixService.h

#ifndef NODEMATRIXSERVICE_H
#define NODEMATRIXSERVICE_H
#include "ClassSet.h"

class NodeMatrixService
{
public:
    NodeMatrixService(QObject *parent = nullptr);
    /*单个节点信息新增*/
    //添加信息
    bool AddNodeMatrixInfo(const NodeMatrixInfo &nodeMatrixInfo);
    /*批量节点信息新增*/
    bool AddNodeMatrixInfoList(const QList<NodeMatrixInfo *> &jbInfoList);

    /*批量节点信息新增----专家端*/
    bool AddNodeMatrixInfoList2(const QList<NodeMatrixInfo *> &jbInfoList);

    /*修改节点值*/
    bool UpdateNodeMatrixNodeValue(const NodeMatrixInfo &nodeMatrixInfo);
    /*批量修改节点值*/
    bool UpdateNodeMatrixNodeValueList(const QList<NodeMatrixInfo *> jbInfoList);

    /*批量修改节点值--专家端*/
    bool UpdateNodeMatrixNodeValueList2(const QList<NodeMatrixInfo *> jbInfoList);
    /*根据专家姓名查询对应的节点信息*/
    bool QueryNodeMatrixListByExpertName(QList<NodeMatrixInfo *> *nodeMatrixInfoList, QString expertName);
    bool QueryNodeMatrixListByExpertNameAndEngineerId(QString expertName, int engineerId, QString tableMsg,
                                                      QString mark);
    /*根据专家id查询对应的节点信息*/
    bool QueryNodeMatrixListByExpertIdAndEngineerId(QString expertId, int engineerId, QString tableMsg);
    /*根据专家名称和工程ID查询对应的节点信息*/
    bool QueryNodeMatrixListByExpertNameAndEngineerId(QList<NodeMatrixInfo *> *nodeMatrixInfoList, QString expertName,
                                                      int engineerId);
    /*根据专家名称和工程ID查询对应的节点信息--专家端*/
    bool QueryNodeMatrixListByExpertNameAndEngineerId2(QString expertName, int engineerId, QString tableMsg,
                                                       QString mark, int tabIndex);

    bool QueryNodesByExpertNameAndEngineerId2(QList<NodeMatrixInfo *> *nodeMatrixInfoList, QString expertName,
                                              int engineerId, QString tableMsg, QString mark, int tabIndex);

    /*根据专家id和工程ID查询对应的节点信息*/
    bool QueryNodeMatrixListByExpertIdAndEngineerId(QList<NodeMatrixInfo *> *nodeMatrixInfoList, int expertId,
                                                    int engineerId, QString tableMsg);
    /*判断专家是否已录入数据*/
    bool QueryNodeValueByUserIdAndEngineerId(int experId, int engineerId);

    /*根据专家id和工程ID查询对应的节点信息 ---专家端*/
    bool QueryNodeMatrixListByExpertIdAndEngineerId2(QList<NodeMatrixInfo *> *nodeMatrixInfoList, int expertId,
                                                     int engineerId, QString tableMsg);
    /*根据专家编号查询对应的节点信息*/
    bool QueryNodeMatrixListByExpertId(QList<NodeMatrixInfo *> *nodeMatrixInfoList, int expertId);
    /*根据工程编号查询节点矩阵信息*/
    bool QueryNodeMatrixListByEngineerId(QList<NodeMatrixInfo *> *nodeMatrixInfoList, int engineerId);
    /*根据工程编号删除节点信息*/
    bool DeleteNodeMatrixListByEngineerId(int engineerId);
    /*根据专家姓名删除节点信息*/
    bool DeleteNodeMatrixListByExpertName(QString expertName);
    /*根据专家编号删除节点信息*/
    bool DeleteNodeMatrixListByExpertId(int expertId);

    /*根据指标体系类型和工程ID查询实测数据信息*/
    bool QueryMeaureDataByProjectAndIndex(QList<NodeMatrixInfo *> *dataList, QString index, int projId);

    /*根据指标体系类型和工程ID查询专家数据信息*/
    bool QueryExpertDataByProjectAndIndex(QList<NodeMatrixInfo *> *dataList, QString index, int projId);

    /*根据指标体系类型和工程ID查询专家数据信息*/
    /* dataSource, 0:专家数据, 1:实测数据*/
    bool QueryDataByProjectAndIndex(QList<NodeMatrixInfo *> *dataList, QString index, int projId, int dataSource);

    /*修改节点值*/
    bool UpdateMeasureData(const NodeMatrixInfo &info);

    /*删除实测数据*/
    bool deleteMeasureData(int projId, QString index, QString uuid);

    bool deleteExpertData(int projId, int expertId);

    /*查询是否已录入数据*/
    bool hasMeasureData(int projId, QString index);
    bool hasExpertData(int projId, QString index, int expertId);
};

#endif  // NODEMATRIXSERVICE_H