teachersmanagement/teachersinfotable.h at master · faellsa/teachersmanagement · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
#ifndef TEACHERSINFOTABLE_H
#define TEACHERSINFOTABLE_H

#include <QSqlDatabase>

class DataCenter;

struct TeacherInfo
{
	QString name;
	QString sex;
	QString nationality;
	QString origin;
	QString id;
	QString birthday;
	QString politicsStatus;
	QString partyTime;
	QString department;
	QString category;
	QString personnelNo;
	QString title;
	QString titleTime;
	QString rank;
	//QString rankTime;
	QString currentPositionTime;
	QString academicParttime;
	QString personnelPlan;
	QString honour;
	QString administrationParttime;
	QString otherParttime;
	QString graduateTrain;
	QString teacherTime;
	QString bachelorTime;
	QString masterTime;
	QString doctorTime;
	QString firstWorkTime;
	QString firstWorkPlace;
	QString whuTime;
	QString beAbroadExperience;
	QString retirementTime;
	QString email;
	QString officePhone;
	QString mobilePhone;
};

class TeachersInfoTable
{
public:
	TeachersInfoTable(const DataCenter& dataCenter);
	bool newTeacherInfo(const TeacherInfo &teacherInfo);
	bool queryTeacherInfo(QString conditionType,QString conditionValue,QVector<TeacherInfo*> &teacherInfo);
	bool deleteTeacherInfo(QString conditionType,QString conditionValue);

private:
	void createTable();

	QSqlDatabase m_Database;
};

#endif // TEACHERSINFOTABLE_H