QFD2/QFD/dbService/ProjectService.h

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

class ProjectService
{
public:
    ProjectService(QObject *parent = nullptr);
    //添加项目
    int AddProjectInfo(const ProjectInfo &projectInfo);
    //更新项目
    bool UpdateProjectInfo(const ProjectInfo &projectInfo);
    //根据ID更新脑图ID
    bool UpdateDemandById(int enjId, int demandId);
    bool UpdateProgrammeById(int enjId, int programmeId);
    bool UpdateGeneralById(int enjId, int generalId);

    /*根据项目id查询项目信息*/
    bool QueryProjectById(ProjectInfo *proJectInfo, int id);

    /*根据项目名称查询项目*/
    bool QueryProjectByName(QString name);

    //查询所有
    bool QueryAll(QList<ProjectInfo *> *projectInfoList);

    //根据id删除
    bool DeleteById(int id);

    //分页查询
    bool SelectAllByPage(QList<ProjectInfo *> *projectInfoList, int &totalPages, int page, int pageSize, QString name);
};

#endif  // PROJECTSERVICE_H