def fetchexp(self): model = modelFile.Model() model.connect2db() result = model.show_work_exp(self.currentID) self.rowindex = 0 self.record = [] if len(result) == 0: t1 = QLineEdit() t2 = QLineEdit() t3 = QLineEdit() t4 = QLineEdit() t5 = QPushButton("添加") t5.setFixedWidth(150) t5.setFixedHeight(30) t5.setObjectName(str(self.rowindex)) t5.clicked.connect(self.add_exp_tuple) self.grid.addWidget(t1, self.rowindex + 3, 1) self.grid.addWidget(t2, self.rowindex + 3, 2) self.grid.addWidget(t3, self.rowindex + 3, 3) self.grid.addWidget(t4, self.rowindex + 3, 4) self.grid.addWidget(t5, self.rowindex + 3, 5) self.record.append([t1, t2, t3, t4, t5]) return for item in result: work_place = item[1] title = item[2] start_day = str(item[3]) end_day = str(item[4]) t1 = QLineEdit(work_place) t2 = QLineEdit(title) t3 = QLineEdit(start_day) t4 = QLineEdit(end_day) t5 = QPushButton("更新") t5.setObjectName(str(self.rowindex)) t5.setFixedWidth(100) t5.setFixedHeight(30) t5.clicked.connect(self.updateLine) t6 = QPushButton("删除") t6.setObjectName(str(self.rowindex)) t6.setFixedWidth(100) t6.setFixedHeight(30) t6.clicked.connect(self.delete_tuple) self.grid.addWidget(t1, self.rowindex + 3, 1) self.grid.addWidget(t2, self.rowindex + 3, 2) self.grid.addWidget(t3, self.rowindex + 3, 3) self.grid.addWidget(t4, self.rowindex + 3, 4) self.grid.addWidget(t5, self.rowindex + 3, 5) self.grid.addWidget(t6, self.rowindex + 3, 6) self.rowindex += 1 self.record.append([t1, t2, t3, t4, t5, t6]) self.grid.addWidget(self.updateBtn, self.rowindex + 3, 1)
def upload(self): # 参数二是默认的打开路径设置文件扩展名过滤,注意用双分号间隔 file_, filetype = QFileDialog.getOpenFileName( self, "选取文件", "/Users/mohaitao/Desktop/pics", "All Files (*);;Image Files (*.jpg)") print(file_) model = modelFile.Model() model.connect2db() model.updatePortrait(self.currentID, file_) QMessageBox.information(self, "提醒", "头像修改成功!", QMessageBox.Yes) self.fetchinfo()
def updateGrp(self): sender = self.sender() rowindex = int(sender.objectName()) fri_mail = self.record[rowindex][1].text() grp_name = self.record[rowindex][3].text() print(fri_mail, grp_name) model = modelFile.Model() model.connect2db() model.updateGrp(self.currentID, fri_mail, grp_name) self.showfriends()
def bottomAddGrp(self): grp_name, ok = QInputDialog.getText(self, "新增分组", "请输入新的分组名:", QLineEdit.Normal, "这是默认值") if not ok: return model = modelFile.Model() model.connect2db() result = model.existGrp(grp_name) if len(result) != 0: QMessageBox.information(self, "分组信息", "这个分组已存在哦", QMessageBox.Yes) return model.addGrp(self.currentID, grp_name) self.showfriends()
def updateLine(self): model = modelFile.Model() model.connect2db() sender = self.sender() rowindex = sender.objectName() rowindex = int(rowindex) workplace = self.record[rowindex][0].text() title = self.record[rowindex][1].text() startdate = self.record[rowindex][2].text() enddate = self.record[rowindex][3].text() model.update_work_exp(self.currentID, workplace, title, startdate, enddate) self.fetchexp()
def modifyinfo(self): # 邮箱是不能修改的,通过邮箱定位tuple,进行更新 name, gender, birth, address = \ self.nametxt.text(), self.gendertxt.currentText(), \ self.birthtxt.text(), self.addresstxt.text() print(name, gender, birth, address) model = modelFile.Model() model.connect2db() status = model.modifyinfo(name, gender, birth, address, str(self.currentID)) if status == 0: QMessageBox.information(self, "提醒", "修改成功!", QMessageBox.Yes, QMessageBox.Yes) self.fetchinfo()
def bottomDeGrp(self): grp_name, ok = QInputDialog.getText(self, "删除分组", "请输入删除的分组名:", QLineEdit.Normal, "这是默认值") if not ok: return if grp_name == "默认分组": return model = modelFile.Model() model.connect2db() status = model.chGrp(self.currentID, grp_name) if status == 1: QMessageBox.information(self, "分组信息", "没有这个分组诶", QMessageBox.Yes) if status == 0: QMessageBox.information(self, "分组信息", "修改成功", QMessageBox.Yes) self.showfriends()
def updateLine(self): model = modelFile.Model() model.connect2db() sender = self.sender() rowindex = sender.objectName() rowindex = int(rowindex) level = self.record[rowindex][0].text() school = self.record[rowindex][1].text() degree = self.record[rowindex][2].text() startdate = self.record[rowindex][3].text() enddate = self.record[rowindex][4].text() model.update_edu_exp(self.currentID, level, school, degree, startdate, enddate) self.fetchexp()
def showfriends(self): model = modelFile.Model() model.connect2db() friends = model.showfriends(self.currentID) self.row = 0 self.record = [] if len(friends) == 0: self.grid.addWidget(self.searchBtn, self.row + 3, 1) self.grid.addWidget(self.addGrpBtn, self.row + 3, 2) return for item in friends: fri_email = item[1] grp_name = item[2] fri_info = model.usrinfo(fri_email) fri_name = fri_info[0] fri_addr = fri_info[4] t1 = QLabel(fri_name) t2 = QLabel(fri_email) t3 = QLabel(fri_addr) t4 = QLineEdit(grp_name) t5 = QPushButton("修改分组") t5.setObjectName(str(self.row)) t5.setFixedWidth(100) t5.setFixedHeight(30) t5.clicked.connect(self.updateGrp) t6 = QPushButton("删除") t6.setObjectName(str(self.row)) t6.setFixedWidth(100) t6.setFixedHeight(30) t6.clicked.connect(self.deleteFri) self.grid.addWidget(t1, self.row + 3, 1) self.grid.addWidget(t2, self.row + 3, 2) self.grid.addWidget(t3, self.row + 3, 3) self.grid.addWidget(t4, self.row + 3, 4) self.grid.addWidget(t5, self.row + 3, 5) self.grid.addWidget(t6, self.row + 3, 6) self.row += 1 self.record.append([t1, t2, t3, t4, t5, t6]) self.grid.addWidget(self.searchBtn, self.row + 3, 1) self.grid.addWidget(self.addGrpBtn, self.row + 3, 2) self.grid.addWidget(self.deGrpBtn, self.row + 3, 3)
def fetchinfo(self): model = modelFile.Model() model.connect2db() info = model.usrinfo(self.currentID) name, gender, birth, email, address, imgPath = \ info[0], info[1], info[2], info[3], info[4], info[6] """设置部件的文本内容""" self.nametxt.setText(name) self.gendertxt.setCurrentText(gender) self.birthtxt.setDate(QDate.fromString(str(birth), 1)) self.emailtxt.setText(email) self.addresstxt.setText(address) pix = QPixmap(imgPath) icon = QIcon() icon.addPixmap(pix, QIcon.Normal, QIcon.Off) self.imgLB.setIcon(icon) self.imgLB.setIconSize(QSize(240, 240))
def modelsignup(self): name = self.nameLineEdit.text() email = self.emailLineEdit.text() passwd = self.passLineEdit.text() model = modelFile.Model() model.connect2db() if model.checkemail(email): model.signup(name, None, None, email, None, passwd) print( QMessageBox.information(self, "提醒", "您已成功注册账号!", QMessageBox.Yes, QMessageBox.Yes)) self.signal.emit(name) else: print( QMessageBox.warning(self, "警告", "该账号已存在,请重新输入", QMessageBox.Yes, QMessageBox.Yes)) print("该邮箱已被注册")
def delete_tuple(self): # 删除的时候需要获取信号源的行坐标 sender = self.sender() rowindex = sender.objectName() rowindex = int(rowindex) level = self.record[rowindex][0].text() model = modelFile.Model() model.connect2db() model.delete_edu_exp(self.currentID, level) # 删除所有控件! print("will delete", self.record[rowindex][0].text()) for row in range(len(self.record)): for col in range(7): self.record[row][col].deleteLater() self.fetchexp()
def bottomAdd(self): fri_email, ok = QInputDialog.getText(self, "搜索好友", "请输入好友的email", QLineEdit.Normal, "*****@*****.**") if not ok: return if fri_email == self.currentID: QMessageBox.information(self, "提醒", "你输入了自己的email...", QMessageBox.Yes) return model = modelFile.Model() model.connect2db() grp = model.findGrp(self.currentID, fri_email) if len(grp) != 0: QMessageBox.information(self, "提醒", "ta已经是你的好友啦", QMessageBox.Yes) return fri_info = model.usrinfo(fri_email) if len(fri_info) == 0: QMessageBox.information(self, "没有诶", "该用户还未注册哦", QMessageBox.Yes) return model.addFriend(self.currentID, fri_email) self.showfriends()
def deleteFri(self): model = modelFile.Model() model.connect2db() sender = self.sender() rowindex = sender.objectName() rowindex = int(rowindex) name = self.record[rowindex][0].text() fri_email = self.record[rowindex][1].text() reply = QMessageBox.warning(self, "取消关注", "确定取消关注{}吗?".format(name), QMessageBox.Yes | QMessageBox.No) if reply == 65536: return model.deleteFriend(self.currentID, fri_email) # 删除所有控件! for row in range(len(self.record)): for col in range(6): self.record[row][col].deleteLater() self.showfriends()
def bottomAdd(self): model = modelFile.Model() model.connect2db() self.t1 = QLineEdit() self.t2 = QLineEdit() self.t3 = QLineEdit() self.t4 = QLineEdit() self.t5 = QPushButton("添加") self.t5.setFixedWidth(150) self.t5.setFixedHeight(30) self.t5.setObjectName(str(self.rowindex)) self.t5.clicked.connect(self.add_exp_tuple) self.grid.addWidget(self.t1, self.rowindex + 3, 1) self.grid.addWidget(self.t2, self.rowindex + 3, 2) self.grid.addWidget(self.t3, self.rowindex + 3, 3) self.grid.addWidget(self.t4, self.rowindex + 3, 4) self.grid.addWidget(self.t5, self.rowindex + 3, 5) self.record.append([self.t1, self.t2, self.t3, self.t4, self.t5]) self.rowindex += 1
def delete_tuple(self): model = modelFile.Model() model.connect2db() sender = self.sender() rowindex = sender.objectName() rowindex = int(rowindex) workplace = self.record[rowindex][0].text() title = self.record[rowindex][1].text() print("chosen", workplace) model.delete_work_exp(self.currentID, workplace, title) # 删除所有控件! print("will delete", self.record[rowindex][0].text()) for row in range(len(self.record)): for col in range(6): self.record[row][col].deleteLater() self.fetchexp()
def modelsignin(self): email = self.emailLineEdit.text() passwd = self.passLineEdit.text() model = modelFile.Model() model.connect2db() loginstatus = model.signin(email, passwd) #print("Checking!") if loginstatus == 1: #账号不存在 print(QMessageBox.warning( self, "警告", "账号不存在!", QMessageBox.Yes, QMessageBox.Yes)) elif loginstatus == 2: #登陆成功 print(QMessageBox.information( self, "提醒", "登陆成功!", QMessageBox.Yes, QMessageBox.Yes)) return email elif loginstatus == 3: #密码错误 print(QMessageBox.warning( self, "警告", "密码错误!", QMessageBox.Yes, QMessageBox.Yes))
def add2db(self): sender = self.sender() rowindex = sender.objectName() rowindex = int(rowindex) level = self.record[rowindex][0].text() school = self.record[rowindex][1].text() degree = self.record[rowindex][2].text() startDate = self.record[rowindex][3].text() endDate = self.record[rowindex][4].text() model = modelFile.Model() model.connect2db() model.add_edu_work(self.currentID, level, school, degree, startDate, endDate) for row in range(len(self.record)-1): for col in range(7): print(row, col) self.record[row][col].deleteLater() for col in range(6): self.record[len(self.record)-1][col].deleteLater() self.fetchexp()
def add_exp_tuple(self): sender = self.sender() rowindex = sender.objectName() rowindex = int(rowindex) workplace = self.record[rowindex][0].text() title = self.record[rowindex][1].text() startdate = self.record[rowindex][2].text() enddate = self.record[rowindex][3].text() model = modelFile.Model() model.connect2db() model.add_work_exp(self.currentID, workplace, title, startdate, enddate) # 删除所有控件! for row in range(len(self.record) - 1): for col in range(6): print(row, col) self.record[row][col].deleteLater() for col in range(5): self.record[len(self.record) - 1][col].deleteLater() self.fetchexp()
def showfriends(self): model = modelFile.Model() model.connect2db() model.showfriends(self.currentID)
def __init__(self): self.model = modelFile.Model()