def show_joblog(ls): print(ls) #管理员登录 if ls[2]: p=LinkMysql().select_admin(ls[0]) pwd=(" ".join('%s' %id for id in p)) print(pwd) if ls[1]==pwd: landing.hide() myWin.get_user(ls[0]) myWin.show() else: landing.show_error() #员工登录 if ls[3]: p1=LinkMysql().select_staff(ls[0]) pwd1=(" ".join('%s' %id for id in p1)) print(pwd1) if ls[1]==pwd1: landing.hide() myWin.get_user(ls[0]) myWin.show() else: landing.show_error()
def add_to_database(self): self.value=[] self.value.append(self.t_id.toPlainText()) self.value.append(self.t_rank.toPlainText()) self.value.append(self.t_name.toPlainText()) self.value.append(self.t_sex.toPlainText()) self.value.append(self.t_marriage.toPlainText()) self.value.append(self.t_bir.toPlainText()) self.value.append(self.t_nation.toPlainText()) self.value.append(self.t_tel.toPlainText()) self.value.append(self.t_mail.toPlainText()) self.value.append(self.t_edu.toPlainText()) self.value.append(self.t_salary.toPlainText()) self.value.append(self.t_entry.toPlainText()) self.value.append(self.t_depid.toPlainText()) self.value.append(self.t_duty.toPlainText()) self.value.append(self.t_politics.toPlainText()) self.value.append(self.t_skills.toPlainText()) self.value.append(self.t_dep.toPlainText()) print(self.value) sql = "INSERT INTO staff values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)" if LinkMysql().commit_sql1(sql,self.value): QMessageBox.information(self,"温馨提示", "添加成功",QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示','有错误发生,请重试',QMessageBox.Retry) print('Something wrong')
def add_to_database(self): self.value = [] self.value.append(self.id_ln.text()) self.value.append(self.name_ln.text()) self.value.append(self.pw_ln.text()) self.value.append(self.tel_ln.text()) self.value.append(self.mail_ln.text()) self.value.append(self.dep_ln.text()) self.value.append(self.work_ln.text()) if not self.id_ln.text(): QMessageBox.warning(self, '温馨提示', '请输入管理员id', QMessageBox.Retry) print('Something wrong') else: id = int(self.id_ln.text()) print(self.value) sql = "INSERT INTO sys_admin values (%s,%s,%s,%s,%s,%s,%s)" if id < 1000: QMessageBox.warning(self, '温馨提示', '管理员id要大于1000', QMessageBox.Retry) print('Something wrong') elif LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry) print('Something wrong')
def __init__(self,parent = None): super(salary_staff_console,self).__init__(parent) #设置界面大小、名称、背景 self.resize(500,600) self.setWindowTitle('工资管理') #窗体属性 self.setWindowFlags(Qt.Widget) sql="SELECT staId,staName,origin_salary FROM salary order by staId" #数据列名 col_lst=['员工Id','姓名','底薪'] type=1 data=LinkMysql().select_single(sql,type) #数据的大小 row = len(data) vol = len(data[0]) #插入表格 self.MyTable = QtWidgets.QTableWidget(row,vol) self.MyTable.setColumnCount(vol) self.MyTable.setRowCount(row) self.MyTable.setEditTriggers(QtWidgets.QAbstractItemView.NoEditTriggers) self.MyTable.setSelectionBehavior(QtWidgets.QAbstractItemView.SelectRows) self.MyTable.setObjectName("MyTable") font = QtGui.QFont('微软雅黑',10) #设置字体、表头 self.MyTable.horizontalHeader().setFont(font) self.MyTable.setHorizontalHeaderLabels(col_lst) #设置竖直方向表头不可见 self.MyTable.verticalHeader().setVisible(False) self.MyTable.setFrameShape(QFrame.NoFrame) #构建表格插入数据 for i in range(row): for j in range(vol): temp_data = data[i][j] # 临时记录,不能直接插入表格 self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格 self.MyTable.setItem(i, j, self.data1) #编辑按钮 self.qle = QLineEdit() self.qle.setText('请输入员工id') self.qle.setFont(font) #垂直布局 layout = QVBoxLayout() layout.addWidget(self.qle) layout.addWidget(self.MyTable) self.setLayout(layout)
def del_data(self): #是否删除的对话框 tmp = '请输入部门id' tmp1 = self.qle.text() reply = QMessageBox.question(self, 'Message', 'Are you sure to delete it ?', QMessageBox.Yes | QMessageBox.No, QMessageBox.No) if reply == QMessageBox.Yes: #当前行 if tmp1 == tmp: row_2 = self.MyTable.currentRow() userid = self.MyTable.item(row_2, 0).text() else: userid = self.qle.text() ls = int(userid) print(ls) sql = "delete from department where dId= %s " if LinkMysql().commit_sql(sql, ls): #删除表格 QMessageBox.information(self, "温馨提示", "删除成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '无法删除,请检查该部门是否有员工', QMessageBox.Retry) print('Something wrong')
def del_data(self): #是否删除的对话框 tmp = '请输入员工id' tmp1 = self.qle.text() reply = QMessageBox.question(self, 'Message', 'Are you sure to delete it ?', QMessageBox.Yes | QMessageBox.No, QMessageBox.No) if reply == QMessageBox.Yes: if tmp1 == tmp: row_2 = self.MyTable.currentRow() userid = self.MyTable.item(row_2, 0).text() else: userid = self.qle.text() ls = int(userid) print(ls) sql = "update staff_bad set sta_remarks=NULL where staId= %s " if LinkMysql().commit_sql(sql, ls): #删除表格 QMessageBox.information(self, "温馨提示", "删除成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误产生', QMessageBox.Retry) print('Something wrong')
def __init__(self, user_id): super(salary_query_panel, self).__init__() self.setupUi(self) sql = 'select * from salary where staId=%s' self.data = LinkMysql().select_sql(sql, user_id) print(self.data) times = self.data[0][4] origin = self.data[0][2] award = self.data[0][3] realSalary = origin + award - (times * 100) self.sa_id.setText(str(self.data[0][0])) self.sa_name.setText(self.data[0][1]) self.sa_or.setText(str(self.data[0][2])) self.sa_aw.setText(str(self.data[0][3])) self.sa_times.setText(str(self.data[0][4])) self.real_sa.setText(str(realSalary)) self.sa_id.setReadOnly(True) self.sa_name.setReadOnly(True) self.sa_or.setReadOnly(True) self.sa_aw.setReadOnly(True) self.sa_times.setReadOnly(True) self.real_sa.setReadOnly(True)
def save_to_database(self): self.value=[] self.value.append(self.mon_id.text()) self.value.append(self.mon_name.text()) self.value.append(self.mon_date.text()) self.value.append(self.mon_awa.text()) self.value.append(self.mon_re.toPlainText()) print(self.value) sql0="delete from monthrecord where staId=%s" LinkMysql().commit_sql(sql0,self.user_id) sql = "INSERT INTO monthrecord values (%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql,self.value): QMessageBox.information(self,"温馨提示", "修改成功",QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示','有错误发生,请重试',QMessageBox.Retry) print('Something wrong') self.close()
def __init__(self, user_id): super(sys_secret_panel, self).__init__() self.setupUi(self) self.user_id = user_id sql = 'select * from sys_view where staId=%s' print(self.user_id) self.data = LinkMysql().select_sql(sql, user_id) print(self.data) self.id_ln.setText(str(self.data[0][0])) self.osec_ln.setText(self.data[0][1])
def save_to_database(self): self.value = [] self.value.append(self.sa_id.text()) self.value.append(self.sa_name.text()) self.value.append(self.sa_or.text()) self.value.append(self.sa_aw.text()) self.value.append(self.sa_times.text()) print(self.value) sql0 = "delete from salary where staId=%s" LinkMysql().commit_sql(sql0, self.user_id) sql = "INSERT INTO salary values (%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry) print('Something wrong') self.close()
def __init__(self, user_id): super(change_secret_panel, self).__init__() self.setupUi(self) self.user_id = user_id self.admit.clicked.connect(self.change) sql = 'select * from staff where stId=%s' sql1 = 'select staPwd from sys_staff where staId=%s' self.data = LinkMysql().select_sql(sql, user_id) self.data1 = LinkMysql().select_sql(sql1, user_id) self.pwd = (" ".join('%s' % id for id in self.data1)) self.id_ln.setText(str(user_id)) self.name_ln.setText(self.data[0][2]) self.osec_ln.setText(self.pwd) self.id_ln.setReadOnly(True) self.name_ln.setReadOnly(True) self.osec_ln.setReadOnly(True)
def save_to_database(self): self.value = [] self.value.append(self.id_ln.text()) self.value.append(self.name_ln.text()) self.value.append(self.pw_ln.text()) self.value.append(self.tel_ln.text()) self.value.append(self.mail_ln.text()) self.value.append(self.dep_ln.text()) self.value.append(self.work_ln.text()) print(self.value) sql0 = "delete from sys_admin where aId=%s" LinkMysql().commit_sql(sql0, self.user_id) sql = "INSERT INTO sys_admin values (%s,%s,%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry) print('Something wrong') self.close()
def save_to_database(self): da = self.ch_date.date().toString('yyyy-MM-dd') self.value = [] self.value.append(self.ch_id.text()) self.value.append(self.ch_name.text()) self.value.append(self.ch_dep.text()) self.value.append(self.ch_work.text()) self.value.append(da) print(self.value) sql0 = "delete from checking_in where staId=%s" LinkMysql().commit_sql(sql0, self.user_id) sql = "INSERT INTO checking_in values (%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry) print('Something wrong') self.close()
def __init__(self,user_id): super(act_modify_panel,self).__init__() self.setupUi(self) self.user_id=user_id sql='select * from activity where acId=%s' self.data=LinkMysql().select_sql(sql,user_id) print(self.data) self.time.setDate(QDate(self.data[0][2])) self.title_ln.setText(self.data[0][1]) self.con_ln.setText(self.data[0][3])
def save_to_database(self): self.value = [] self.value.append(self.did_ln.text()) self.value.append(self.ddirname_ln.text()) self.value.append(self.ddir_ln.text()) self.value.append(self.ddir_tel.text()) self.value.append(self.ddir_mail.text()) self.value.append(self.dintr_ln.toPlainText()) print(self.value) sql0 = "delete from department where dId=%s" LinkMysql().commit_sql(sql0, self.user_id) sql = "INSERT INTO department values (%s,%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '请检查该部门无员工后再进行更改', QMessageBox.Retry) print('Something wrong') self.close()
def save_to_database(self): dateTime= self.time.date().toString('yyyy-MM-dd') print(dateTime) self.value=[] self.value.append(self.title_ln.text()) self.value.append(dateTime) self.value.append(self.con_ln.toPlainText()) self.value.append(1) print(self.value) sql0="delete from activity where acId=%s" LinkMysql().commit_sql(sql0,self.user_id) sql = "INSERT INTO activity(acTitle,acTime,acContent,acbuilder) values (%s,%s,%s,%s)" if LinkMysql().commit_sql(sql,self.value): QMessageBox.information(self,"温馨提示", "修改成功",QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示','有错误发生,请重试',QMessageBox.Retry) print('Something wrong') self.close()
def change(self): new_sec = self.nsec_ln.text() sql = 'update sys_staff set staPwd=%s where staId=%s' ls = [] ls.append(new_sec) ls.append(self.user_id) if LinkMysql().commit_sql(sql, ls): QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '修改失败', QMessageBox.Retry) print('Something wrong')
def __init__(self, user_id): super(check_modify_panel, self).__init__() self.setupUi(self) self.user_id = user_id sql = 'select * from checking_in where staId=%s' self.data = LinkMysql().select_sql(sql, user_id) self.ch_id.setText(str(self.data[0][0])) self.ch_name.setText(self.data[0][1]) self.ch_dep.setText(self.data[0][2]) self.ch_work.setText(self.data[0][3]) self.ch_date.setDate(QDate(self.data[0][4]))
def __init__(self,user_id): super(mon_modify_panel,self).__init__() self.setupUi(self) self.user_id=user_id sql='select * from monthrecord where staId=%s' self.data=LinkMysql().select_sql(sql,user_id) self.mon_id.setText(str(self.data[0][0])) self.mon_name.setText(self.data[0][1]) self.mon_date.setText(str(self.data[0][2])) self.mon_awa.setText(str(self.data[0][3])) self.mon_re.setText(self.data[0][4])
def __init__(self, user_id): super(dep_modify_panel, self).__init__() self.setupUi(self) self.user_id = user_id sql = 'select * from department where dId=%s' self.data = LinkMysql().select_sql(sql, user_id) self.did_ln.setText(str(self.data[0][0])) self.ddirname_ln.setText(self.data[0][1]) self.ddir_ln.setText(self.data[0][2]) self.ddir_tel.setText(self.data[0][3]) self.ddir_mail.setText(self.data[0][4]) self.dintr_ln.setText(self.data[0][5])
def __init__(self, user_id): super(sys_admin_modify_panel, self).__init__() self.setupUi(self) self.user_id = user_id sql = 'select * from sys_admin where aId=%s' self.data = LinkMysql().select_sql(sql, user_id) self.id_ln.setText(str(self.data[0][0])) self.name_ln.setText(self.data[0][1]) self.pw_ln.setText(self.data[0][2]) self.tel_ln.setText(self.data[0][3]) self.mail_ln.setText(str(self.data[0][4])) self.dep_ln.setText(self.data[0][5]) self.work_ln.setText(self.data[0][6])
def save_to_database(self): self.value = [] self.value.append(self.nsec_ln.text()) self.value.append(self.user_id) print(self.value) sql = "call pupdate(%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry) print('Something wrong') self.close()
def add_to_database(self): self.value = [] self.value.append(self.mon_id.text()) self.value.append(self.mon_name.text()) self.value.append(self.mon_date.text()) self.value.append(self.mon_awa.text()) self.value.append(self.mon_re.toPlainText()) print(self.value) sql = "INSERT INTO monthrecord values (%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误发生', QMessageBox.Retry) print('Something wrong')
def order_data(self): sql = "SELECT stId,stName,stDepartment,stPositionalTitles,stSex,stNum FROM staff order by stNum" type = 1 data = LinkMysql().select_single(sql, type) #数据的大小 row = len(data) vol = len(data[0]) self.MyTable.setRowCount(row) #构建表格插入数据 for i in range(row): for j in range(vol): temp_data = data[i][j] # 临时记录,不能直接插入表格 self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格 self.MyTable.setItem(i, j, self.data1) print('This is order-area')
def add_to_database(self): da = self.ch_date.date().toString('yyyy-MM-dd') self.value = [] self.value.append(self.ch_id.text()) self.value.append(self.ch_name.text()) self.value.append(self.ch_dep.text()) self.value.append(self.ch_work.text()) self.value.append(da) print(self.value) sql = "INSERT INTO checking_in values (%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '有错误发生', QMessageBox.Retry) print('Something wrong')
def refresh_data(self): sql="SELECT staId,staPwd FROM sys_staff order by staId" data=LinkMysql().select_single(sql,type) #数据的大小 row = len(data) vol = len(data[0]) self.MyTable.setRowCount(row) #构建表格插入数据 for i in range(row): for j in range(vol): temp_data = data[i][j] # 临时记录,不能直接插入表格 self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格 self.MyTable.setItem(i, j, self.data1) print('This is refresh-area')
def add_to_database(self): self.value = [] self.value.append(self.did_ln.text()) self.value.append(self.ddirname_ln.text()) self.value.append(self.ddir_ln.text()) self.value.append(self.ddir_tel.text()) self.value.append(self.ddir_mail.text()) self.value.append(self.dintr_ln.toPlainText()) print(self.value) sql = "INSERT INTO department values (%s,%s,%s,%s,%s,%s)" if LinkMysql().commit_sql(sql, self.value): QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok) print('You succeed') else: QMessageBox.warning(self, '温馨提示', '请检查部门id是否重复', QMessageBox.Retry) print('Something wrong')
def __init__(self, user_id): super(staff_bad_panel, self).__init__() self.setupUi(self) sql = 'select * from staff_bad where staId=%s' self.data = LinkMysql().select_sql(sql, user_id) print(self.data) self.id.setText(str(self.data[0][0])) self.name.setText(self.data[0][1]) self.dep.setText(self.data[0][2]) self.work.setText(self.data[0][3]) self.remark.setText(self.data[0][4]) self.id.setReadOnly(True) self.name.setReadOnly(True) self.dep.setReadOnly(True) self.work.setReadOnly(True) self.remark.setReadOnly(True)
def refresh_data(self): sql = "SELECT dId,dName,dDirector FROM department order by dId" type = 1 data = LinkMysql().select_single(sql, type) #数据的大小 row = len(data) vol = len(data[0]) self.MyTable.setRowCount(row) #构建表格插入数据 for i in range(row): for j in range(vol): temp_data = data[i][j] # 临时记录,不能直接插入表格 self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格 self.MyTable.setItem(i, j, self.data1) print('This is refresh-area')
def refresh_data(self): sql = "SELECT staId,staName,staDep FROM checking_in order by Time desc" type = 1 data = LinkMysql().select_single(sql, type) #数据的大小 row = len(data) vol = 3 self.MyTable.setRowCount(row) #构建表格插入数据 for i in range(row): for j in range(vol): temp_data = data[i][j] # 临时记录,不能直接插入表格 self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格 self.MyTable.setItem(i, j, self.data1) print('This is refresh-area')