QFD2/QFD/dbService/DBServiceSet.h

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

class DBServiceSet
{
public:
    explicit DBServiceSet(QObject *parent = nullptr);
    //////////////////////common-start////////////////////
    int getNextId(QString tableName);
    //////////////////////common-start////////////////////

    //////////////////////节点权重值持久化-start////////////////////

    /*单个节点信息新增*/
    //添加信息
    bool AddNodeWeightInfo(const DemandWeight &demandWeight);
    /*批量节点信息新增*/
    bool AddNodeWeightInfoList(const QList<DemandWeight *> &demandWeightList);
    /*修改节点值*/
    bool UpdateNodeValue(const DemandWeight &demandWeight);
    /*批量修改节点值*/
    bool UpdateNodeValueList(const QList<DemandWeight *> demandWeightList);

    bool QueryByTableIndexAndTableMsg(int expertId, int engineerId, int tableIndex, QString tableMsg);
    bool QueryByTableIndexAndTableMsg(QString expertId, int engineerId, int tableIndex, QString tableMsg);

    bool QueryByTableIndexAndTableMsgAndPage(QString expertId, int engineerId, int tableIndex, QString tableMsg,
                                             int page);

    bool QueryByTableIndexAndTableMsg(QList<DemandWeight *> *demandWeightList, int expertId, int engineerId,
                                      int tableIndex, QString tableMsg);

    bool QueryByTableIndexAndTableMsg(QList<DemandWeight *> *demandWeightList, QString expertId, int engineerId,
                                      int tableIndex, QString tableMsg);

    bool QueryByPageIndexAndTableMsg(QList<DemandWeight *> *demandWeightList, QString expertId, int engineerId,
                                     int pageIndex, QString tableMsg);

    bool updateValidByExperIdAndEngineerId(int expertId, int engineerId);

    bool QuerySecondDemandWeightByEngineerId(QList<DemandWeight *> *demandWeightList, int expertId, int engineerId,
                                             QString tableMsg);

    bool QuerySecondDemandWeightByEngineerIdAndMaxPage(QList<DemandWeight *> *demandWeightList, int expertId,
                                                       int engineerId, QString tableMsg);

    bool QuerySecondDemandWeightByEngineerId(QList<DemandWeight *> *demandWeightList, QString expertIds, int engineerId,
                                             QString tableMsg);

    // bool QueryFirstDemandWeightByEngineerId(QList<DemandWeight *> *demandWeightList, int expertId, int engineerId,
    // QString tableMsg);

    bool QueryFirstDemandWeightByEngineerId(QList<DemandWeight *> *demandWeightList, int expertId, int engineerId,
                                            QString tableMsg);

    bool QueryLastDemandWeightByEngineerId(QList<DemandWeight *> *demandWeightList, int expertId, int engineerId,
                                           QString tableMsg, int tableIndex);

    bool QueryFirstDemandWeightByEngineerId(QList<DemandWeight *> *demandWeightList, QString expertIds, int engineerId,
                                            QString tableMsg);

    bool QueryLastPageDemandWeightByEngineerId(QList<DemandWeight *> *demandWeightList, QString expertIds,
                                               int engineerId, QString tableMsg, int page);

    //////////////////////common-start////////////////////

    ////////////////////方案持久化-start////////////////////
    bool AddSchemeInfoList(const QList<SchemaEval *> &schemaEvalList);
    bool DeleteSchemeByEngineerId(int engineerId);
    bool QuerySchemeInfoByEngineerId(QList<SchemaEval *> *schemeList, int engineerId);

    //////////////////////common-start////////////////////

    //////////////////////技术重要度持久化-start////////////////////

    //添加信息
    bool AddTechnicalImportInfo(const TechnicalImport &technicalImport);
    bool AddTechnicalImportInfoList(const QList<TechnicalImport *> &technicalImportList);

    /*批量修改节点值*/
    bool UpdateTechnicalImportInfoList(const QList<TechnicalImport *> technicalImportList);

    bool QueryTechnicalImportInfoByEngineerId(QList<TechnicalImport *> *technicalImportList, int expertId,
                                              int engineerId);

    bool QueryTechnicalImportInfoByEngineerId(int expertId, int engineerId);

    //////////////////////common-start////////////////////

    //////////////////////节点矩阵信息表-start////////////////////
    /*单个节点信息新增*/
    //添加信息
    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);
    //////////////////////节点矩阵信息表-end/////////////////////

    //////////////////////评估方案表-start////////////////////
    //添加信息
    bool AddPlanInfo(const PlanInfo &planInfo);
    /*修改评估方案信息*/
    bool UpdatePlanInfo(const PlanInfo &planInfo);
    /*根据评估方案id查询评估方案信息*/
    bool QueryPlanInfoById(PlanInfo *planInfo, int planId);
    /*根据列名称和列值模糊查询评估方案信息,列名称为实体类中的属性名称*/
    bool QueryPlanListByColumnAndColumnValue(QList<PlanInfo *> *planInfoList, QString columnName, QString columnValue);
    bool QueryPlanList(QList<PlanInfo *> *planInfoList);
    /*根据评估方案编号删除评估方案信息*/
    bool DeletePlanById(int planId);
    //////////////////////评估方案表-end////////////////////

    //////////////////////评估方案指标体系关系表-start////////////////////
    //添加信息
    // bool AddIndexSetPlanInfo(const IndexSetPlanInfo &planInfo);
    bool AddIndexSetPlanInfoList(const QList<IndexSetPlanInfo *> planInfoList);
    /*修改信息*/
    bool UpdateIndexSetPlanInfo(const IndexSetPlanInfo &planInfo);
    bool UpdateIndexSetPlanInfoList(const QList<IndexSetPlanInfo *> planInfoList);
    /*根据id查询信息*/
    bool QueryIndexSetPlanInfo(IndexSetPlanInfo *planInfo, int Id);
    /*根据列名称和列值模糊查询信息,列名称为实体类中的属性名称*/
    bool QueryIndexSetPlanListByColumnAndColumnValue(QList<IndexSetPlanInfo *> *planInfoList, QString columnName,
                                                     QString columnValue);
    /*根据编号删除关联信息*/
    bool DeleteIndexSetPlanById(int Id);
    bool DeleteIndexSetPlanByPlanId(int planId);
    bool DeleteIndexSetPlanByIndexSetId(int indexSetId);
    //////////////////////评估方案指标体系关系表-end////////////////////
};

#endif  // DBSERVICESET_H