QFD2/QFD/dbService/UserService.h

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

class UserService
{
public:
    explicit UserService(QObject *parent = nullptr);
    //添加信息
    int AddUserInfo(const QFUser &userInfo);
    /*修改用户信息*/
    bool UpdateUserInfo(const QFUser &userInfo);
    bool UpdateUserPassword(QString userNo, QString password);
    bool UpdateUserById(QString userNo, QString password, int id);
    /*根据用户id查询用户信息*/
    bool QueryUserInfoById(QFUser *userInfo, int userId);
    bool QueryUserInfoByUnserInfo(const QFUser &paramInfo, QFUser &queryInfo);
    // int QueryUserInfoByUserNoAndPhone(QString);
    /*根据列名称和列值模糊查询用户信息,列名称为实体类中的属性名称*/
    bool QueryUserListByColumnAndColumnValue(QList<QFUser *> *userInfoList, QString columnName, QString columnValue);
    bool QueryUserList(QList<QFUser *> *userInfoList);
    bool QueryUserListNotAdmin(QList<QFUser *> *userInfoList);
    /*根据用户编号删除用户信息*/
    bool DeleteUserById(int Id);
    bool QueryUserByNoAndPassword(QFUser *userInfo, QString userNo, QString password);
    bool QueryUserByNo(QFUser *userInfo, QString userNo);
    /*获取工程用户列表*/
    bool QueryUserListByEngineerId(QList<QFUser> &userInfoList, int engineerId);

    //删除除管理管外的所有用户
    bool DeleteUserByRole(int roleType);

    //专家本地库查询信息
    bool QueryUserInfoById2(QFUser *userInfo, int userId);

    bool UpdateUserInfo2(const QFUser &userInfo);

    int AddUserInfo2(const QFUser &userInfo);

    bool DeleteAllUser();
};

#endif  // USERSERVICE_H