class GeneralRecordModule(QDialog, Ui_Dialog):
edited = pyqtSignal(int)
def __init__(self, autoid, parent=None):
super(GeneralRecordModule, self).__init__(parent)
self.setupUi(self)
if '50' not in user.powers:
self.close()
if user.powers['50'] == 0:
self.close()
self.power = '{:03b}'.format(user.powers['50'])
if self.power[1] == '0':
self.pushButton_accept.setVisible(False)
self.pushButton_cancel.setVisible(False)
self.ori_detail = dict()
self.autoid = autoid
self.EC = EquipmentController()
self.current_content = object
# 获取记录内容
self.get_general_record()
def get_general_record(self):
values_list = ('formname', 'format')
key_dict = {'autoid': self.autoid}
res = self.EC.get_data(5, False, *values_list, **key_dict)
if len(res):
self.label_formname.setText(res[0]['formname'])
ori_paper = res[0]['format']
self.current_content = XMLReadWrite(self)
self.current_content.openxml(ori_paper)
self.gridLayout_6.addWidget(self.current_content)
self.current_content.__setattr__('autoid', self.autoid)
@pyqtSlot()
def on_pushButton_accept_clicked(self):
condition = {'autoid': self.autoid}
kwargs = {'formcontent': self.current_content.get_content()}
res = self.EC.update_data(5, condition, **kwargs)
if res:
self.current_content.flat = 0
self.accept()
@pyqtSlot()
def on_pushButton_cancel_clicked(self):
self.current_content.flat = 0
self.close()
class EditEquipDetailModule(QDialog, Ui_Dialog):
def __init__(self, autoid=None, parent=None):
super(EditEquipDetailModule, self).__init__(parent)
self.setupUi(self)
if '45' not in user.powers:
self.close()
if user.powers['45'] == 0:
self.close()
self.power = '{:03b}'.format(user.powers['45'])
if self.power[1] == '0':
self.pushButton_accept.setVisible(False)
self.pushButton_cancel.setVisible(False)
self.autoid = autoid
self.EC = EquipmentController()
self.ori_detail = dict()
self.new_detail = dict()
self.lineEdit_dept.setup('Department', RETURN_ROW_DEPT,
CONDITION_KEY_DEPT, TREEHEADER_NAME_DEPT,
None, 350, 190)
self.lineEdit_maintainer.setup('Clerks', RETURN_ROW_MAINTAINER,
CONDITION_KEY_MAINTAINER,
TREEHEADER_NAME_MAINTAINER, None, 350,
190)
self.get_detail()
self.get_check_detail()
def get_detail(self):
if self.autoid is None:
return
key_dict = {'autoid': self.autoid}
res = self.EC.get_data(0, False, *VALUES_TUPLE_EQ, **key_dict)
if not len(res):
return
self.ori_detail = res[0]
self.lineEdit_id.setText(self.ori_detail['eqno'])
self.lineEdit_name.setText(self.ori_detail['eqname'])
self.lineEdit_NO.setText(self.ori_detail['serialno'])
self.lineEdit_spec.setText(self.ori_detail['spec'])
self.lineEdit_price.setText(self.ori_detail['price'])
self.lineEdit_producer.setText(self.ori_detail['manufacturer'])
self.lineEdit_makedate.setText(self.ori_detail['makedate'])
self.lineEdit_indate.setText(self.ori_detail['indate'])
self.comboBox_type.setCurrentIndex(self.ori_detail['eqtype'])
self.lineEdit_location.setText(self.ori_detail['instposition'])
self.lineEdit_parameter.setText(self.ori_detail['parameter'])
self.lineEdit_performance.setText(self.ori_detail['performance'])
self.lineEdit_dept.setText(self.ori_detail['deptid'] + ' ' +
self.ori_detail['deptname'])
self.lineEdit_maintainer.setText(
self.ori_detail['maintainerid'] + ' ' + \
self.ori_detail['maintainername']
)
self.lineEdit_remark.setText(self.ori_detail['remark'])
self.comboBox_status.setCurrentIndex(self.ori_detail['status'])
def get_check_detail(self):
self.treeWidget_checklist.clear()
# self.treeWidget_checklist.hideColumn(0)
if self.autoid is None:
return
key_dict = {'eqid': self.autoid}
res = self.EC.get_data(2, False, *VALUES_TUPLE_EQCHECK, **key_dict)
for item in res:
qtreeitem = QTreeWidgetItem(self.treeWidget_checklist)
qtreeitem.setText(0, str(item['autoid']))
qtreeitem.setText(1, STAUTS[item['status']])
qtreeitem.setText(2, str(item['checkdate']))
qtreeitem.setText(3, item['company'])
qtreeitem.setText(4, item['result'])
qtreeitem.setText(5,
item['registerid'] + ' ' + item['registername'])
for i in range(1, 6):
self.treeWidget_checklist.resizeColumnToContents(i)
@pyqtSlot(str)
def on_lineEdit_id_textChanged(self, p_str):
try:
if p_str != self.ori_detail['eqno']:
self.new_detail['eqno'] = p_str
else:
try:
del self.new_detail['eqno']
except KeyError:
pass
except KeyError:
self.new_detail['eqno'] = p_str
@pyqtSlot(str)
def on_lineEdit_name_textChanged(self, p_str):
try:
if p_str != self.ori_detail['eqname']:
self.new_detail['eqname'] = p_str
else:
try:
del self.new_detail['eqname']
except KeyError:
pass
except KeyError:
self.new_detail['eqname'] = p_str
@pyqtSlot(str)
def on_lineEdit_NO_textChanged(self, p_str):
try:
if p_str != self.ori_detail['serialno']:
self.new_detail['serialno'] = p_str
else:
try:
del self.new_detail['serialno']
except KeyError:
pass
except KeyError:
self.new_detail['serialno'] = p_str
@pyqtSlot(str)
def on_lineEdit_spec_textChanged(self, p_str):
try:
if p_str != self.ori_detail['spec']:
self.new_detail['spec'] = p_str
else:
try:
del self.new_detail['spec']
except KeyError:
pass
except KeyError:
self.new_detail['spec'] = p_str
@pyqtSlot(str)
def on_lineEdit_price_textChanged(self, p_str):
try:
if p_str != self.ori_detail['price']:
self.new_detail['price'] = p_str
else:
try:
del self.new_detail['price']
except KeyError:
pass
except KeyError:
self.new_detail['price'] = p_str
@pyqtSlot(str)
def on_lineEdit_producer_textChanged(self, p_str):
try:
if p_str != self.ori_detail['manufacturer']:
self.new_detail['manufacturer'] = p_str
else:
try:
del self.new_detail['manufacturer']
except KeyError:
pass
except KeyError:
self.new_detail['manufacturer'] = p_str
@pyqtSlot(str)
def on_lineEdit_makedate_textChanged(self, p_str):
try:
if p_str != self.ori_detail['makedate']:
self.new_detail['makedate'] = p_str
else:
try:
del self.new_detail['makedate']
except KeyError:
pass
except KeyError:
self.new_detail['makedate'] = p_str
@pyqtSlot(str)
def on_lineEdit_indate_textChanged(self, p_str):
try:
if p_str != self.ori_detail['indate']:
self.new_detail['indate'] = p_str
else:
try:
del self.new_detail['indate']
except KeyError:
pass
except KeyError:
self.new_detail['indate'] = p_str
@pyqtSlot(str)
def on_lineEdit_location_textChanged(self, p_str):
try:
if p_str != self.ori_detail['instposition']:
self.new_detail['instposition'] = p_str
else:
try:
del self.new_detail['instposition']
except KeyError:
pass
except KeyError:
self.new_detail['instposition'] = p_str
@pyqtSlot(str)
def on_lineEdit_parameter_textChanged(self, p_str):
try:
if p_str != self.ori_detail['parameter']:
self.new_detail['parameter'] = p_str
else:
try:
del self.new_detail['parameter']
except KeyError:
pass
except KeyError:
self.new_detail['parameter'] = p_str
@pyqtSlot(str)
def on_lineEdit_performance_textChanged(self, p_str):
try:
if p_str != self.ori_detail['performance']:
self.new_detail['performance'] = p_str
else:
try:
del self.new_detail['performance']
except KeyError:
pass
except KeyError:
self.new_detail['performance'] = p_str
@pyqtSlot(str)
def on_lineEdit_dept_textChanged(self, p_str):
if len(p_str.split(' ')) != 2 and p_str != '':
return
id, name = p_str.split(' ') if p_str != '' else ('', '')
try:
if id != self.ori_detail['deptid'] or name != self.ori_detail[
'deptname']:
self.new_detail['deptid'] = id
self.new_detail['deptname'] = name
else:
try:
del self.new_detail['deptid']
del self.new_detail['deptname']
except KeyError:
pass
except KeyError:
self.new_detail['deptid'] = id
self.new_detail['deptname'] = name
@pyqtSlot(str)
def on_lineEdit_maintainer_textChanged(self, p_str):
if len(p_str.split(' ')) != 2 and p_str != '':
return
id, name = p_str.split(' ') if p_str != '' else ('', '')
try:
if id != self.ori_detail['maintainerid'] or name != self.ori_detail[
'maintainername']:
self.new_detail['maintainerid'] = id
self.new_detail['maintainername'] = name
else:
try:
del self.new_detail['maintainerid']
del self.new_detail['maintainername']
except KeyError:
pass
except KeyError:
self.new_detail['maintainerid'] = id
self.new_detail['maintainername'] = name
@pyqtSlot(str)
def on_lineEdit_remark_textChanged(self, p_str):
try:
if p_str != self.ori_detail['remark']:
self.new_detail['remark'] = p_str
else:
try:
del self.new_detail['remark']
except KeyError:
pass
except KeyError:
self.new_detail['remark'] = p_str
@pyqtSlot(int)
def on_comboBox_type_currentIndexChanged(self, p_int):
try:
if p_int != self.ori_detail['eqtype']:
self.new_detail['eqtype'] = p_int
else:
try:
del self.new_detail['eqtype']
except KeyError:
pass
except KeyError:
self.new_detail['eqtype'] = p_int
@pyqtSlot(int)
def on_comboBox_status_currentIndexChanged(self, p_int):
try:
if p_int != self.ori_detail['status']:
self.new_detail['status'] = p_int
else:
try:
del self.new_detail['status']
except KeyError:
pass
except KeyError:
self.new_detail['status'] = p_int
@pyqtSlot()
def on_pushButton_accept_clicked(self):
if not self.autoid or 'eqno' in self.new_detail:
eqno = self.lineEdit_id.text()
key_dict = {'eqno': eqno}
res = self.EC.get_data(0, True, 'autoid', **key_dict)
if len(res):
msg = MessageBox(self, text="设备编号重复")
msg.show()
return
if len(self.new_detail):
if self.autoid:
condition = {'autoid': self.autoid}
self.EC.update_data(0, condition, **self.new_detail)
else:
self.EC.update_data(0, **self.new_detail)
self.accept()
@pyqtSlot()
def on_pushButton_cancel_clicked(self):
self.close()
@pyqtSlot(QPoint)
def on_treeWidget_checklist_customContextMenuRequested(self, pos):
if self.power[1] == '0':
return
sender_widget = self.sender()
current_item = sender_widget.currentItem()
menu = QMenu()
button1 = menu.addAction("增加校验记录")
button2 = menu.addAction("修改校验记录")
button3 = menu.addAction("删除校验记录")
menu.addSeparator()
button4 = menu.addAction("提交完成")
global_pos = sender_widget.mapToGlobal(pos)
action = menu.exec(global_pos)
if action == button1:
detail = EditEquCheckDetailModule(eqid=self.autoid, parent=self)
detail.accepted.connect(self.get_check_detail)
detail.show()
elif action == button2:
if current_item is None:
return
id = int(current_item.text(0))
status = current_item.text(1)
if status == "完成":
return
detail = EditEquCheckDetailModule(id, self.autoid, self)
detail.accepted.connect(self.get_check_detail)
detail.show()
elif action == button3:
if current_item is None:
return
id = int(current_item.text(0))
print(id)
condition = {'autoid': id}
self.EC.delete_data(2, condition)
self.get_check_detail()
elif action == button4:
if current_item is None:
return
id = int(current_item.text(0))
condition = {'autoid': id}
detail = {'status': 1}
self.EC.update_data(2, condition, **detail)
self.get_check_detail()
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_checklist_itemDoubleClicked(self, qtreeitem, p_int):
if self.power[1] == '0':
return
id = int(qtreeitem.text(0))
detail = EditEquCheckDetailModule(id, self.autoid, self)
detail.accepted.connect(self.get_check_detail)
detail.show()
class EqRunListModule(QWidget, Ui_Form):
def __init__(self, parent=None):
super(EqRunListModule, self).__init__(parent)
self.setupUi(self)
if '46' not in user.powers:
self.close()
if user.powers['46'] == 0:
self.close()
self.power = '{:03b}'.format(user.powers['46'])
self.EC = EquipmentController()
self.deptid = ''
self.eqtype = -1
self.eqno = ''
self.treeWidget_equuiplist.hideColumn(0)
self.treeWidget_deptlist.hideColumn(1)
self.treeWidget_recordslist.hideColumn(0)
self.get_dept_detail()
self.get_eq_detail()
def get_eq_detail(self):
self.treeWidget_equuiplist.clear()
key_dict = dict()
if self.deptid != '':
key_dict['deptid'] = self.deptid
if self.eqtype != -1:
key_dict['eqtype'] = self.eqtype
res = self.EC.get_data(0, False, *VALUES_TUPLE_EQ, **key_dict)
if not len(res):
return
for item in res:
qtreeitem = QTreeWidgetItem(self.treeWidget_equuiplist)
qtreeitem.setText(0, str(item['autoid']))
qtreeitem.setText(1, item['eqno'])
qtreeitem.setText(2, item['eqname'])
qtreeitem.setText(3, item['instposition'])
for i in range(1, 4):
self.treeWidget_equuiplist.resizeColumnToContents(i)
def get_dept_detail(self):
self.treeWidget_deptlist.clear()
all_dept = QTreeWidgetItem(self.treeWidget_deptlist)
all_dept.setText(0, "全部部门")
all_dept.setText(1, "")
self.treeWidget_deptlist.expandAll()
res = self.EC.get_data(0, False, *VALUES_TUPLE_DP).distinct()
if not len(res):
return
for item in res:
qtreeitem = QTreeWidgetItem(all_dept)
qtreeitem.setText(0, item['deptname'])
qtreeitem.setText(1, item['deptid'])
self.treeWidget_deptlist.resizeColumnToContents(0)
def get_run_note(self):
self.treeWidget_recordslist.clear()
index = self.tabWidget.currentIndex()
key_dict = {'eqno': self.eqno, 'status': index}
res = self.EC.get_data(1, False, *VALUES_TUPLE_RUN, **key_dict)
if not len(res):
return
for item in res:
qtreeitem = QTreeWidgetItem(self.treeWidget_recordslist)
qtreeitem.setText(0, str(item['autoid']))
qtreeitem.setText(
1,
str(item['runstarttime'])
if type(item['runstarttime']) is datetime.datetime else '')
qtreeitem.setText(2, str(item['runtime']))
qtreeitem.setText(3, item['fillerid'] + ' ' + item['fillername'])
qtreeitem.setText(4, item['dictid'] + ' ' + item['dictname'])
qtreeitem.setText(5, item['batchno'])
for i in range(1, 6):
self.treeWidget_recordslist.resizeColumnToContents(i)
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_equuiplist_itemDoubleClicked(self, qtreeitem, p_int):
self.eqno = qtreeitem.text(1)
self.get_run_note()
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_deptlist_itemDoubleClicked(self, qtreeitem, p_int):
self.deptid = qtreeitem.text(1)
self.get_eq_detail()
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_equiplist_itemDoubleClicked(self, qtreeitem, p_int):
self.eqid = qtreeitem.text(0)
self.get_run_note()
@pyqtSlot(int)
def on_toolBox_currentChanged(self, p_int):
current_tool = getattr(self, 'page_' + str(p_int))
current_tool.setLayout(self.gridLayout_3)
self.eqtype = p_int - 1
self.get_eq_detail()
@pyqtSlot(int)
def on_tabWidget_currentChanged(self, p_int):
current_tool = getattr(self, 'tab_' + str(p_int))
current_tool.setLayout(self.gridLayout_2)
self.get_run_note()
@pyqtSlot(QPoint)
def on_treeWidget_recordslist_customContextMenuRequested(self, pos):
if self.power[1] == '0':
return
sender_widget = self.sender()
current_item = sender_widget.currentItem()
index = self.tabWidget.currentIndex()
menu = QMenu()
button1 = menu.addAction("增加运行记录")
button2 = menu.addAction("修改运行记录")
button3 = menu.addAction("删除运行记录")
menu.addSeparator()
button4 = menu.addAction("提交完成")
global_pos = sender_widget.mapToGlobal(pos)
action = menu.exec(global_pos)
if action == button1:
if self.eqno != '':
detail = EqrunnoteModule(eqno=self.eqno,
edit=False,
parent=self)
detail.accepted.connect(self.get_run_note)
detail.show()
elif action == button2:
if current_item is not None and index == 0:
id = int(current_item.text(0))
detail = EqrunnoteModule(autoid=id, edit=False, parent=self)
detail.accepted.connect(self.get_run_note)
detail.show()
elif action == button3:
if current_item is not None:
id = int(current_item.text(0))
condition = {'autoid': id}
self.EC.delete_data(1, condition)
self.get_run_note()
elif action == button4:
if current_item is not None and index == 0:
id = int(current_item.text(0))
condition = {'autoid': id}
kwargs = {'status': 1}
self.EC.update_data(1, condition, **kwargs)
self.get_run_note()
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_recordslist_itemDoubleClicked(self, qtreeitem, p_int):
id = int(qtreeitem.text(0))
detail = EqrunnoteModule(autoid=id, edit=False, parent=self)
detail.accepted.connect(self.get_run_note)
detail.show()
class EqGeneralRecorsListModule(QWidget, Ui_Form):
def __init__(self, parent=None):
super(EqGeneralRecorsListModule, self).__init__(parent)
self.setupUi(self)
if '50' not in user.powers:
self.close()
if user.powers['50'] == 0:
self.close()
self.power = '{:03b}'.format(user.powers['50'])
self.EC = EquipmentController()
self.SC = SelfdefinedformatController()
self.deptid = ''
self.eqtype = -1
self.eqno = ''
self.treeWidget_equuiplist.hideColumn(0)
self.treeWidget_deptlist.hideColumn(1)
self.treeWidget_recordslist.hideColumn(0)
self.get_dept_detail()
self.get_eq_detail()
def get_eq_detail(self):
self.treeWidget_equuiplist.clear()
key_dict = dict()
if self.deptid != '':
key_dict['deptid'] = self.deptid
if self.eqtype != -1:
key_dict['eqtype'] = self.eqtype
res = self.EC.get_data(0, False, *VALUES_TUPLE_EQ, **key_dict)
if not len(res):
return
for item in res:
qtreeitem = QTreeWidgetItem(self.treeWidget_equuiplist)
qtreeitem.setText(0, str(item['autoid']))
qtreeitem.setText(1, item['eqno'])
qtreeitem.setText(2, item['eqname'])
qtreeitem.setText(3, item['instposition'])
for i in range(1, 4):
self.treeWidget_equuiplist.resizeColumnToContents(i)
def get_dept_detail(self):
self.treeWidget_deptlist.clear()
all_dept = QTreeWidgetItem(self.treeWidget_deptlist)
all_dept.setText(0, "全部部门")
all_dept.setText(1, "")
self.treeWidget_deptlist.expandAll()
res = self.EC.get_data(0, False, *VALUES_TUPLE_DP).distinct()
if not len(res):
return
for item in res:
qtreeitem = QTreeWidgetItem(all_dept)
qtreeitem.setText(0, item['deptname'])
qtreeitem.setText(1, item['deptid'])
self.treeWidget_deptlist.resizeColumnToContents(0)
def get_generalrecors_note(self):
self.treeWidget_recordslist.clear()
index = self.tabWidget.currentIndex()
key_dict = {
'eqno': self.eqno,
'status': index,
}
res = self.EC.get_data(5, False, *VALUES_TUPLE_RECORDS, **key_dict)
if not len(res):
return
for item in res:
qtreeitem = QTreeWidgetItem(self.treeWidget_recordslist)
qtreeitem.setText(0, str(item['autoid']))
qtreeitem.setText(1, item['formname'])
qtreeitem.setText(
2, item['createtime'].strftime('%Y-%m-%d %H:%M')
if type(item['createtime']) is datetime.datetime else '')
qtreeitem.setText(3, item['creatorid'] + ' ' + item['creatorname'])
for i in range(1, 4):
self.treeWidget_recordslist.resizeColumnToContents(i)
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_equuiplist_itemDoubleClicked(self, qtreeitem, p_int):
self.eqno = qtreeitem.text(1)
self.get_generalrecors_note()
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_deptlist_itemDoubleClicked(self, qtreeitem, p_int):
self.deptid = qtreeitem.text(1)
self.get_eq_detail()
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_equiplist_itemDoubleClicked(self, qtreeitem, p_int):
self.eqid = qtreeitem.text(0)
self.get_generalrecors_note()
@pyqtSlot(int)
def on_toolBox_currentChanged(self, p_int):
current_tool = getattr(self, 'page_' + str(p_int))
current_tool.setLayout(self.gridLayout_3)
self.eqtype = p_int - 1
self.get_eq_detail()
@pyqtSlot(int)
def on_tabWidget_currentChanged(self, p_int):
current_tool = getattr(self, 'tab_' + str(p_int))
current_tool.setLayout(self.gridLayout_2)
self.get_generalrecors_note()
@pyqtSlot(QPoint)
def on_treeWidget_recordslist_customContextMenuRequested(self, pos):
if self.power[1] == '0':
return
sender_widget = self.sender()
current_item = sender_widget.currentItem()
index = self.tabWidget.currentIndex()
menu = QMenu()
button1 = menu.addAction("增加一般记录")
button2 = menu.addAction("修改一般记录")
button3 = menu.addAction("删除一般记录")
menu.addSeparator()
button4 = menu.addAction("提交完成")
global_pos = sender_widget.mapToGlobal(pos)
action = menu.exec(global_pos)
if action == button1:
if self.eqno != '':
detail = SelectGeneralRecordsModule(self)
detail.accepted.connect(self.get_generalrecors_note)
detail.selected.connect(self.new_general_records)
detail.show()
elif action == button2:
if current_item is not None and index == 0:
id = int(current_item.text(0))
detail = GeneralRecordModule(id, self)
detail.accepted.connect(self.get_generalrecors_note)
detail.show()
elif action == button3:
if current_item is not None:
id = int(current_item.text(0))
condition = {'autoid': id}
self.EC.delete_data(5, condition)
self.get_generalrecors_note()
elif action == button4:
if current_item is not None and index == 0:
id = int(current_item.text(0))
condition = {'autoid': id}
kwargs = {'status': 1}
self.EC.update_data(5, condition, **kwargs)
self.get_generalrecors_note()
@pyqtSlot(QTreeWidgetItem, int)
def on_treeWidget_recordslist_itemDoubleClicked(self, qtreeitem, p_int):
id = int(qtreeitem.text(0))
detail = GeneralRecordModule(id, self)
detail.accepted.connect(self.get_generalrecors_note)
detail.show()
def new_general_records(self, id_tuple):
if len(id_tuple) == 0:
return
else:
key_dict = dict()
key_dict['autoid__in'] = id_tuple
res = self.SC.get_selfdefinedformat(False, *VALUES_TUPLE_SD,
**key_dict)
for item in res:
kwargs = {
'eqno': self.eqno,
'creatorid': user.user_id,
'creatorname': user.user_name,
'formname': item['formatname'],
'kind': item['kind'],
'subkind': item['subkind'],
'format': item['format'],
'createtime': user.now_time
}
self.EC.update_data(5, **kwargs)
class EditEquCheckDetailModule(QDialog, Ui_Dialog):
def __init__(self, autoid=None, eqid=0, parent=None):
super(EditEquCheckDetailModule, self).__init__(parent)
self.setupUi(self)
self.autoid = autoid
self.eqid = eqid
self.EC = EquipmentController()
self.ori_detail = dict()
self.new_detail = dict()
self.get_detail()
self.get_company_items()
def get_detail(self):
if self.autoid is None:
self.dateEdit_checkdate.setDate(user.now_date)
return
key_dict = {'autoid': self.autoid}
res = self.EC.get_data(2, False, *VALUES_TUPLE_EQCHECK, **key_dict)
if not len(res):
return
self.ori_detail = res[0]
self.dateEdit_checkdate.setDate(self.ori_detail['checkdate'])
self.lineEdit_result.setText(self.ori_detail['result'])
def get_company_items(self):
items = self.EC.get_data(2, True, *VALUES_TUPLE_COMPANY).distinct()
self.comboBox_company.addItems(items)
if len(self.ori_detail):
self.comboBox_company.setCurrentText(self.ori_detail['company'])
else:
self.comboBox_company.setCurrentText('')
@pyqtSlot(QDate)
def on_dateEdit_checkdate_dateChanged(self, q_date):
try:
if type(self.ori_detail['checkdate']) is str:
self.new_detail['checkdate'] = q_date.toPyDate()
return
if q_date != QDate(self.ori_detail['checkdate']):
self.new_detail['checkdate'] = q_date.toPyDate()
else:
try:
del self.new_detail['checkdate']
except KeyError:
pass
except KeyError:
self.new_detail['checkdate'] = q_date.toPyDate()
@pyqtSlot(str)
def on_comboBox_company_currentTextChanged(self, p_str):
try:
if p_str != self.ori_detail['company']:
self.new_detail['company'] = p_str
else:
try:
del self.new_detail['company']
except KeyError:
pass
except KeyError:
self.new_detail['company'] = p_str
@pyqtSlot(str)
def on_lineEdit_result_textChanged(self, p_str):
try:
if p_str != self.ori_detail['result']:
self.new_detail['result'] = p_str
else:
try:
del self.new_detail['result']
except KeyError:
pass
except KeyError:
self.new_detail['result'] = p_str
@pyqtSlot()
def on_pushButton_accept_clicked(self):
if len(self.new_detail):
self.new_detail['registerid'] = user.user_id
self.new_detail['registername'] = user.user_name
if self.autoid:
condition = {'autoid': self.autoid}
self.EC.update_data(2, condition, **self.new_detail)
else:
self.new_detail['eqid'] = self.eqid
self.EC.update_data(2, **self.new_detail)
self.accept()
@pyqtSlot()
def on_pushButton_cancel_clicked(self):
self.close()
@pyqtSlot()
def on_pushButton_apply_clicked(self):
self.new_detail['status'] = 1
self.new_detail['registerid'] = user.user_id
self.new_detail['registername'] = user.user_name
if self.autoid:
condition = {'autoid': self.autoid}
self.EC.update_data(2, condition, **self.new_detail)
else:
self.new_detail['eqid'] = self.eqid
self.EC.update_data(2, **self.new_detail)
self.accept()
class EqrunnoteModule(QDialog, Ui_Dialog):
def __init__(self,
autoid=None,
eqno='',
status=0,
starttime=user.currentdatetime,
endtime=user.currentdatetime,
edit=False,
parent=None):
super(EqrunnoteModule, self).__init__(parent)
self.setupUi(self)
if edit:
self.power = '111'
else:
if '46' in user.powers:
self.close()
if user.powers['46'] == 0:
self.close()
self.power = '{:03b}'.format(user.powers['46'])
if self.power[1] == '0':
self.pushButton_accept.setVisible(False)
self.pushButton_cancel.setVisible(False)
self.autoid = autoid
self.starttime = starttime
self.endtime = endtime
self.eqno = eqno
self.status = status
self.maintenance = bin(0)
self.ori_detail = object
self.new_detail = {}
self.EC = EquipmentController()
# 获取记录详细内容
self.get_eq_run_note_detail(autoid)
reg = QRegExp('^[0-9]+$')
self.lineEdit_runtime_day.setValidator(QRegExpValidator(reg))
self.lineEdit_runtime_hour.setValidator(QRegExpValidator(reg))
self.lineEdit_runtime_minute.setValidator(QRegExpValidator(reg))
# 获取详细运行记录
def get_eq_run_note_detail(self, autoid):
if self.autoid is None:
self.dateTimeEdit_runstarttime.setDateTime(QDateTime(user.time))
self.dateTimeEdit_runendtime.setDateTime(QDateTime(user.time))
return
key_dict = {'autoid': autoid}
res = self.EC.get_data(1, False, **key_dict).extra(
select={'eqname': 'equipments.eqname'},
tables=['equipments'],
where=['equipments.eqno=eqrunnotes.eqno'])
if len(res):
self.ori_detail = res[0]
self.label_equipment.setText(self.ori_detail.eqno + ' ' +
self.ori_detail.eqname)
self.lineEdit_product.setText(self.ori_detail.dictid + ' ' +
self.ori_detail.dictname)
self.lineEdit_batchno.setText(self.ori_detail.batchno)
if type(self.ori_detail.runstarttime) is datetime.datetime:
self.dateTimeEdit_runstarttime.setDateTime(
self.ori_detail.runstarttime)
else:
self.dateTimeEdit_runstarttime.setDateTime(self.starttime())
if type(self.ori_detail.runendtime) is datetime.datetime:
self.dateTimeEdit_runendtime.setDateTime(
self.ori_detail.runendtime)
else:
self.dateTimeEdit_runendtime.setDateTime(self.endtime())
self.set_runtime(self.ori_detail.runtime)
self.comboBox_runstatus.setCurrentIndex(
int(self.ori_detail.runstatus))
self.lineEdit_remark.setText(self.ori_detail.remark)
if self.ori_detail.fillerid and self.ori_detail.fillername:
self.pushButton_filler.setText(self.ori_detail.fillerid + ' ' +
self.ori_detail.fillername)
self.comboBox_startstatus.setCurrentIndex(
int(self.ori_detail.startstatus))
self.comboBox_stopstatus.setCurrentIndex(
int(self.ori_detail.stopstatus))
self.maintenance = self.ori_detail.maintenance
bin_list = bin(self.ori_detail.maintenance)[2:]
for i in range(1, len(bin(self.ori_detail.maintenance)[2:]) + 1):
try:
getattr(self,
"checkBox_" + str(i)).setChecked(int(bin_list[-i]))
except IndexError:
break
if self.ori_detail.status == 1:
self.pushButton_accept.setVisible(False)
self.pushButton_cancel.setVisible(False)
# 修改开始运行时间
@pyqtSlot(QDateTime)
def on_dateTimeEdit_runstarttime_dateTimeChanged(self, q_time):
if not q_time.isValid():
return
qdtime = q_time.toPyDateTime().strftime('%Y-%m-%d %H:%M')
try:
if qdtime != self.ori_detail.runstarttime.\
strftime('%Y-%m-%d %H:%M'):
self.new_detail['runstarttime'] = qdtime
#'yyyy-MM-dd hh:mm:ss')
else:
try:
del self.new_detail['runstarttime']
except KeyError:
pass
except AttributeError:
self.new_detail['runstarttime'] = qdtime
runtime = int(
(self.dateTimeEdit_runendtime.dateTime().toSecsSinceEpoch() -
q_time.toSecsSinceEpoch()) / 60)
self.set_runtime(runtime)
self.new_detail['runtime'] = runtime
# 修改结束运行时间
@pyqtSlot(QDateTime)
def on_dateTimeEdit_runendtime_dateTimeChanged(self, q_time):
if not q_time.isValid():
return
qdtime = q_time.toPyDateTime().strftime('%Y-%m-%d %H:%M')
try:
if qdtime != self.ori_detail.runendtime.strftime('%Y-%m-%d %H:%M'):
self.new_detail['runendtime'] = qdtime
else:
try:
del self.new_detail['runendtime']
except KeyError:
pass
except AttributeError:
self.new_detail['runendtime'] = qdtime
runtime = int(
(q_time.toSecsSinceEpoch() -
self.dateTimeEdit_runstarttime.dateTime().toSecsSinceEpoch()) /
60)
self.set_runtime(runtime)
self.new_detail['runtime'] = runtime
# 修改运行时长-day
@pyqtSlot(str)
def on_lineEdit_runtime_day_textEdited(self, p_str):
self.modify_runtime()
# 修改运行时长-hour
@pyqtSlot(str)
def on_lineEdit_runtime_hour_textEdited(self, p_str):
self.modify_runtime()
# 修改运行时长-minute
@pyqtSlot(str)
def on_lineEdit_runtime_minute_textEdited(self, p_str):
self.modify_runtime()
# 修改运行时长
def modify_runtime(self):
day = int(self.lineEdit_runtime_day.text()
) if self.lineEdit_runtime_day.text() else 0
hour = int(self.lineEdit_runtime_hour.text()
) if self.lineEdit_runtime_hour.text() else 0
minute = int(self.lineEdit_runtime_minute.text()
) if self.lineEdit_runtime_minute.text() else 0
try:
runtime = day * 86400 + hour * 3600 + minute * 60
if runtime != self.ori_detail.runtime:
self.new_detail['runtime'] = runtime
else:
try:
del self.new_detail['runtime']
except KeyError:
pass
self.dateTimeEdit_runendtime.setDateTime(
QDateTime.fromSecsSinceEpoch(self.dateTimeEdit_runstarttime.
dateTime().toSecsSinceEpoch() +
runtime))
except ValueError:
pass
except AttributeError:
self.new_detail['runtime'] = runtime
# 修改运行情况
@pyqtSlot(int)
def on_comboBox_runstatus_currentIndexChanged(self, p_int):
try:
if p_int != self.ori_detail.runstatus:
self.new_detail['runstatus'] = p_int
else:
try:
del self.new_detail['runstatus']
except KeyError:
pass
except ValueError:
pass
except AttributeError:
self.new_detail['runstatus'] = p_int
# 修改开机准备
@pyqtSlot(int)
def on_comboBox_startstatus_currentIndexChanged(self, p_int):
try:
if p_int != self.ori_detail.startstatus:
self.new_detail['startstatus'] = p_int
else:
try:
del self.new_detail['startstatus']
except KeyError:
pass
except ValueError:
pass
except AttributeError:
self.new_detail['startstatus'] = p_int
# 修改停机保养
@pyqtSlot(int)
def on_comboBox_stopstatus_currentIndexChanged(self, p_int):
try:
if p_int != self.ori_detail.stopstatus:
self.new_detail['stopstatus'] = p_int
else:
try:
del self.new_detail['stopstatus']
except KeyError:
pass
except ValueError:
pass
except AttributeError:
self.new_detail['stopstatus'] = p_int
# 修改备注
@pyqtSlot(str)
def on_lineEdit_remark_textEdited(self, p_str):
try:
if p_str != self.ori_detail.remark:
self.new_detail['remark'] = p_str
else:
try:
del self.new_detail['remark']
except KeyError:
pass
except ValueError:
pass
except AttributeError:
self.new_detail['remark'] = p_str
# 修改填写人
@pyqtSlot(bool, str)
def on_pushButton_filler_signChanged(self, p_bool, p_str):
try:
fillerid, fillername = p_str.split(' ') if p_bool else ('', '')
if fillerid != self.ori_detail.fillerid and fillername != self.ori_detail.fillername:
self.new_detail['fillerid'] = fillerid
self.new_detail['fillername'] = fillername
else:
try:
del self.new_detail['fillerid']
del self.new_detail['fillername']
except KeyError:
pass
except ValueError:
pass
except AttributeError:
self.new_detail['fillerid'] = fillerid
self.new_detail['fillername'] = fillername
@pyqtSlot(bool)
def on_checkBox_1_clicked(self, p_int):
self.set_maintenance(1, p_int)
@pyqtSlot(bool)
def on_checkBox_2_clicked(self, p_int):
self.set_maintenance(2, p_int)
@pyqtSlot(bool)
def on_checkBox_3_clicked(self, p_int):
self.set_maintenance(3, p_int)
@pyqtSlot(bool)
def on_checkBox_4_clicked(self, p_int):
self.set_maintenance(4, p_int)
@pyqtSlot(bool)
def on_checkBox_5_clicked(self, p_int):
self.set_maintenance(5, p_int)
@pyqtSlot(bool)
def on_checkBox_6_clicked(self, p_int):
self.set_maintenance(6, p_int)
@pyqtSlot(bool)
def on_checkBox_7_clicked(self, p_int):
self.set_maintenance(7, p_int)
@pyqtSlot(bool)
def on_checkBox_8_clicked(self, p_int):
self.set_maintenance(8, p_int)
@pyqtSlot(bool)
def on_checkBox_9_clicked(self, p_int):
self.set_maintenance(9, p_int)
@pyqtSlot(bool)
def on_checkBox_10_clicked(self, p_int):
self.set_maintenance(10, p_int)
# 设置设备状态
# pos:第几个位置
# status:该位置的值
def set_maintenance(self, pos, status):
values = 2**(pos - 1) * (1 if status else -1)
self.maintenance += values
try:
if self.maintenance != self.ori_detail.maintenance:
self.new_detail['maintenance'] = self.maintenance
else:
try:
del self.new_detail['maintenance']
except KeyError:
pass
except ValueError:
pass
except AttributeError:
self.new_detail['maintenance'] = self.maintenance
# 确认
@pyqtSlot()
def on_pushButton_accept_clicked(self):
print(self.new_detail)
if len(self.new_detail):
if self.autoid is None:
self.new_detail['eqno'] = self.eqno
self.new_detail['status'] = self.status
self.EC.update_data(1, **self.new_detail)
else:
condition = {'autoid': self.autoid}
self.EC.update_data(1, condition, **self.new_detail)
self.accept()
# 取消
@pyqtSlot()
def on_pushButton_cancel_clicked(self):
self.close()
# 把整数转为天-时-分
def set_runtime(self, p_int: int):
day = int(p_int / 1440)
hour = (p_int % 1440 // 60) if p_int > 0 else int(p_int % -1440 / 60)
minute = p_int % (60 if p_int > 0 else -60)
self.lineEdit_runtime_day.setText(str(day))
self.lineEdit_runtime_hour.setText(str(hour))
self.lineEdit_runtime_minute.setText(str(minute))
class AccidentModule(QDialog, Ui_Dialog):
def __init__(self, autoid=None, eqno=None, parent=None):
super(AccidentModule, self).__init__(parent)
self.setupUi(self)
if '49' not in user.powers:
self.close()
if user.powers['49'] == 0:
self.close()
self.power = '{:03b}'.format(user.powers['49'])
if self.power[1] == '0':
self.pushButton_accept.setVisible(False)
self.pushButton_cancel.setVisible(False)
self.autoid = autoid
self.eqno = eqno
self.ori_detail = dict()
self.new_detail = dict()
self.EC = EquipmentController()
self.get_detail()
def get_detail(self):
if self.autoid is None:
self.dateTimeEdit_occurdate.setDateTime(user.time)
self.dateEdit_filldate.setDate(user.now_date)
if self.eqno is not None:
key_dict = {'eqno': self.eqno}
res = self.EC.get_data(0, True, *VALUES_TUPLE_EQ, **key_dict)
if len(res):
self.label_eqno.setText(self.eqno)
self.label_eqname.setText(res[0])
return
key_dict = {'autoid': self.autoid}
res = self.EC.get_data(4, False, **key_dict).extra(
select={
'eqname': 'equipments.eqname'
},
tables=['equipments'],
where=['equipments.eqno=eqaccidentnotes.eqno'
]).values(*VALUES_TUPLE_NOTE)
if not len(res):
return
self.ori_detail = res[0]
self.label_eqno.setText(self.ori_detail['eqno'])
self.label_eqname.setText(self.ori_detail['eqname'])
self.lineEdit_place.setText(self.ori_detail['place'])
self.dateTimeEdit_occurdate.setDateTime(self.ori_detail['occurdate'])
self.lineEdit_factormen.setText(self.ori_detail['factormen'])
self.lineEdit_kind.setText(self.ori_detail['kind'])
self.lineEdit_injury.setText(self.ori_detail['injury'])
self.plainTextEdit_brief.setPlainText(self.ori_detail['brief'])
self.plainTextEdit_reason.setPlainText(self.ori_detail['reason'])
self.plainTextEdit_loss.setPlainText(self.ori_detail['loss'])
self.plainTextEdit_treatadvice.setPlainText(
self.ori_detail['treatadvice'])
self.plainTextEdit_chargeradvice.setPlainText(
self.ori_detail['chargeradvice'])
self.pushButton_filler.setSign(
True,
self.ori_detail['fillerid'] + ' ' + self.ori_detail['fillername'])
self.dateEdit_filldate.setDate(self.ori_detail['filldate'])
if self.ori_detail['status'] == 1:
self.pushButton_accept.setVisible(False)
self.pushButton_cancel.setVisible(False)
@pyqtSlot(str)
def on_lineEdit_place_textChanged(self, p_str):
try:
if p_str != self.ori_detail['place']:
self.new_detail['place'] = p_str
else:
try:
del self.new_detail['place']
except KeyError:
pass
except KeyError:
self.new_detail['place'] = p_str
@pyqtSlot(str)
def on_lineEdit_factormen_textChanged(self, p_str):
try:
if p_str != self.ori_detail['factormen']:
self.new_detail['factormen'] = p_str
else:
try:
del self.new_detail['factormen']
except KeyError:
pass
except KeyError:
self.new_detail['factormen'] = p_str
@pyqtSlot(str)
def on_lineEdit_kind_textChanged(self, p_str):
try:
if p_str != self.ori_detail['kind']:
self.new_detail['kind'] = p_str
else:
try:
del self.new_detail['kind']
except KeyError:
pass
except KeyError:
self.new_detail['kind'] = p_str
@pyqtSlot(str)
def on_lineEdit_injury_textChanged(self, p_str):
try:
if p_str != self.ori_detail['injury']:
self.new_detail['injury'] = p_str
else:
try:
del self.new_detail['injury']
except KeyError:
pass
except KeyError:
self.new_detail['injury'] = p_str
@pyqtSlot()
def on_plainTextEdit_brief_textChanged(self):
p_str = self.plainTextEdit_brief.toPlainText()
try:
if p_str != self.ori_detail['brief']:
self.new_detail['brief'] = p_str
else:
try:
del self.new_detail['brief']
except KeyError:
pass
except KeyError:
self.new_detail['brief'] = p_str
@pyqtSlot()
def on_plainTextEdit_reason_textChanged(self):
p_str = self.plainTextEdit_reason.toPlainText()
try:
if p_str != self.ori_detail['reason']:
self.new_detail['reason'] = p_str
else:
try:
del self.new_detail['reason']
except KeyError:
pass
except KeyError:
self.new_detail['reason'] = p_str
@pyqtSlot()
def on_plainTextEdit_loss_textChanged(self):
p_str = self.plainTextEdit_loss.toPlainText()
try:
if p_str != self.ori_detail['loss']:
self.new_detail['loss'] = p_str
else:
try:
del self.new_detail['loss']
except KeyError:
pass
except KeyError:
self.new_detail['loss'] = p_str
@pyqtSlot()
def on_plainTextEdit_treatadvice_textChanged(self):
p_str = self.plainTextEdit_loss.toPlainText()
try:
if p_str != self.ori_detail['treatadvice']:
self.new_detail['treatadvice'] = p_str
else:
try:
del self.new_detail['treatadvice']
except KeyError:
pass
except KeyError:
self.new_detail['treatadvice'] = p_str
@pyqtSlot()
def on_plainTextEdit_chargeradvice_textChanged(self):
p_str = self.plainTextEdit_loss.toPlainText()
try:
if p_str != self.ori_detail['chargeradvice']:
self.new_detail['chargeradvice'] = p_str
else:
try:
del self.new_detail['chargeradvice']
except KeyError:
pass
except KeyError:
self.new_detail['chargeradvice'] = p_str
@pyqtSlot(bool, str)
def on_pushButton_filler_signChanged(self, p_bool, p_str):
id, name = p_str.split(' ') if p_bool else ('', '')
try:
if id != self.ori_detail['fillerid'] or name != self.ori_detail[
'fillername']:
self.new_detail['fillerid'] = id
self.new_detail['fillername'] = name
else:
try:
del self.new_detail['fillerid']
del self.new_detail['fillername']
except KeyError:
pass
except KeyError:
self.new_detail['fillerid'] = id
self.new_detail['fillername'] = name
@pyqtSlot(QDate)
def on_dateEdit_filldate_dateChanged(self, q_date):
try:
if type(self.ori_detail['filldate']) is str:
self.new_detail['filldate'] = q_date.toPyDate()
return
if q_date != QDate(self.ori_detail['filldate']):
self.new_detail['filldate'] = q_date.toPyDate()
else:
try:
del self.new_detail['filldate']
except KeyError:
pass
except KeyError:
self.new_detail['filldate'] = q_date.toPyDate()
@pyqtSlot(QDateTime)
def on_dateTimeEdit_occurdate_dateTimeChanged(self, q_time):
if not q_time.isValid():
return
qdtime = q_time.toPyDateTime().strftime('%Y-%m-%d %H:%M')
try:
if qdtime != self.ori_detail['occurdate'].\
strftime('%Y-%m-%d %H:%M'):
self.new_detail['occurdate'] = qdtime
else:
try:
del self.new_detail['occurdate']
except KeyError:
pass
except KeyError:
self.new_detail['occurdate'] = qdtime
@pyqtSlot()
def on_pushButton_accept_clicked(self):
condition = dict()
if len(self.new_detail):
if self.autoid is None:
self.new_detail['eqno'] = self.eqno
else:
condition['autoid'] = self.autoid
self.EC.update_data(4, condition, **self.new_detail)
self.accept()
pyqtSlot()
def on_pushButton_cancel_clicked(self):
self.close()
class LabrecordsController(object):
def __init__(self):
self.SFC = SelfdefinedformatController()
self.EC = EquipmentController()
self.SC = StuffController()
self.PC = ProductController()
def get_labrecord(self, flag=False, *args, **kwargs):
return LabModel.get_labrecord(flag, *args, **kwargs)
def get_labitem(self, flag=False, *args, **kwargs):
return LabModel.get_labitem(flag, *args, **kwargs)
def get_labimages(self, flag=False, kind=2, scid=0):
values_list_rela = [
'autoid', 'title', 'imageid', 'creatorid', 'creatorname',
'createdate'
]
key_dict_rela = {'kind': kind, 'scid': scid}
res = ImagesModel.get_rela(flag, *values_list_rela, **key_dict_rela)
if not len(res):
return []
img_list = []
for item in res:
img_list.append(item['imageid'])
values_list_img = ['autoid', 'img', 'ext']
key_dict_img = {'autoid__in': img_list}
image_list = ImagesModel.get_img(flag, *values_list_img,
**key_dict_img)
for it in res:
for value in image_list:
if it['imageid'] == value['autoid']:
it.update({'image': value['img'], 'ext': value['ext']})
break
return res
def select_oricheckpaper(self, dictid, itemtype=0):
if not dictid:
return []
if itemtype in (0, 1, 2):
condition = {'stuffid': dictid}
res = self.SC.get_data(0, True, *VALUES_TUPLE_ID, **condition)
if not len(res):
return []
id = res[0]
elif itemtype in (3, 4, 5, 6):
condition = {'prodid': dictid}
res = self.PC.get_data(1, True, *VALUES_TUPLE_ID, **condition)
if not len(res):
return []
id = res[0]
else:
id = int(dictid)
key_dict = {'dictid': id, 'itemtype': itemtype}
sdfid_list = LabModel.get_oricheckpapersetting(True, *VALUES_TUPLE_SD,
**key_dict)
if len(sdfid_list):
values_list_sdf = ['autoid', 'kind', 'formatname']
key_dict_sdf = {'autoid__in': sdfid_list}
return self.SFC.get_selfdefinedformat(False, *values_list_sdf,
**key_dict_sdf)
else:
return []
def get_selfdefineformat(self, flag=False, *args, **kwargs):
return self.SFC.get_selfdefinedformat(False, *args, **kwargs)
def get_oricheckpaper(self, flag=False, *args, **kwargs):
return LabModel.get_oricheckpaper(flag, *args, **kwargs)
def get_paperno(self, lrid):
return LabModel.get_paperno(lrid)
def update_labrecord(self, autoid=0, *args, **kwargs):
return LabModel.update_labrecord(autoid, *args, **kwargs)
def delete_labrecord(self, autoid=0, *args, **kwargs):
return LabModel.delete_labrecord(autoid, *args, **kwargs)
def update_labitem(self, autoid=0, *args, **kwargs):
return LabModel.update_labitem(autoid, *args, **kwargs)
def delete_labitem(self, autoid=0, *args, **kwargs):
return LabModel.delete_labitem(autoid, *args, **kwargs)
def update_labimages(self, relakwargs, imgkwargs, relaid=0, imgid=0):
return ImagesModel.update_img(relakwargs, imgkwargs, relaid, imgid)
def create_oricheckpaper(self, opid, op_detail, sdfid, sdf_detail):
with transaction.atomic():
p1 = transaction.savepoint()
condition = {'autoid': sdfid}
res = self.SFC.get_data(0, False, *VALUES_TUPLE_SDF, **condition)
if not len(res):
transaction.savepoint_rollback(p1)
return False
sdf_data = {
'formname': res[0]['formatname'],
'formcontent': res[0]['format']
}
sdf_data.update(sdf_detail)
oripaper = self.update_data(2, **sdf_data)
condition_2 = {'opid_id': opid}
res_2 = self.get_data(8, False, **condition_2)
for item in res_2:
eqrun_data = {
'eqno': item.eqid.eqno,
'rtype': 1,
'pid': oripaper.autoid
}
eqrun_data.update(op_detail)
self.EC.update_data(1, **eqrun_data)
return oripaper
def delete_labimages(self, relaid, imgid):
return ImagesModel.delete_img(relaid, imgid)
def delete_oricheckpaper(self, id):
with transaction.atomic():
p1 = transaction.savepoint()
condition = {'autoid': id}
self.delete_data(2, **condition)
condition_eqrun = {'pid': id, 'rtype': 1}
self.EC.delete_data(1, **condition_eqrun)
return True
def get_data(self, table_num: int, display_flag=False, *args, **kwargs):
table_str = TABLE_SET[table_num][0]
err_msg = "查询" + TABLE_SET[table_num][1]
return LabModel.get_data(table_str, err_msg, display_flag, *args,
**kwargs)
def update_data(self, table_num: int, condition={}, *args, **kwargs):
table_str = TABLE_SET[table_num][0]
err_msg = "更新" + TABLE_SET[table_num][1]
return LabModel.update_data(table_str, err_msg, condition, *args,
**kwargs)
def delete_data(self, table_num: int, condition={}, *args, **kwargs):
table_str = TABLE_SET[table_num][0]
err_msg = "删除" + TABLE_SET[table_num][1]
return LabModel.delete_data(table_str, err_msg, condition, *args,
**kwargs)
def create_labrecord(self, checkitem_id, itemtype, date, *args, **kwargs):
with transaction.atomic():
p1 = transaction.savepoint()
new_labrecor = self.update_data(0, **kwargs)
lrid = new_labrecor.autoid
key_dict_checkitem = {
'stuffid': checkitem_id,
'itemtype': itemtype
}
checkitems = self.get_data(4, False, *VALUES_TUPLE_CHECKITEM,
**key_dict_checkitem)
for item in checkitems:
kwargs_checkitem = {
'lrid': lrid,
'seqid': item['seqid'],
'itemname': item['itemname'],
'kind': item['kind'],
'referencevalue': item['referencevalue'],
'labvalue': item['referencevalue'],
'putintype': item['putintype'],
'startdate': date,
'enddate': date,
'checked': 2
}
self.update_data(1, **kwargs_checkitem)
return lrid
def delete_labrecord_and_detail(self, lrid=0, *args, **kwargs):
with transaction.atomic():
p1 = transaction.savepoint()
if lrid != 0:
condition_lr = {'autoid': lrid}
condition_detail = {'autoid': lrid}
else:
condition_lr = {'autoid__in': args}
condition_detail = {'autoid__in': args}
self.delete_data(0, condition_lr)
self.delete_data(1, condition_detail)
self.delete_data(2, condition_detail)
def delete_sample_record(self, srid):
with transaction.atomic():
p1 = transaction.savepoint()
condition = {'srid_id': srid}
lrid_list = self.get_data(7, False, **condition).extra(
select={
'lrid': 'Labrecords.autoid'
},
tables=['Labrecords'],
where=[
'Labrecords.ciid=Observationrecords.autoid',
'Labrecords.labtype=6'
]).values_list(*VALUES_TUPLE_OB, flat=True)
if len(lrid_list):
self.delete_labrecord_and_detail(*lrid_list)
condition = {'autoid': srid}
self.delete_data(6, condition)
class RepairedModule(QDialog, Ui_Dialog):
def __init__(self, autoid=None, eqno=None, parent=None):
super(RepairedModule, self).__init__(parent)
self.setupUi(self)
if '48' not in user.powers:
self.close()
if user.powers['48'] == 0:
self.close()
self.power = '{:03b}'.format(user.powers['48'])
if self.power[1] == '0':
self.pushButton_accept.setVisible(False)
self.pushButton_cancel.setVisible(False)
self.autoid = autoid
self.eqno = eqno
self.ori_detail = dict()
self.new_detail = dict()
self.EC = EquipmentController()
self.get_detail()
def get_detail(self):
if self.autoid is None:
self.dateEdit_finishdate.setDate(user.now_date)
if self.eqno is not None:
key_dict = {'eqno': self.eqno}
res = self.EC.get_data(0, True, *VALUES_TUPLE_EQ, **key_dict)
if len(res):
self.label_eqno.setText(self.eqno)
self.label_eqname.setText(res[0])
return
key_dict = {'autoid': self.autoid, 'kind': 0}
res = self.EC.get_data(3, False, **key_dict).extra(
select={
'eqname': 'equipments.eqname'
},
tables=['equipments'],
where=['equipments.eqno=eqrepairnotes.eqno'
]).values(*VALUES_TUPLE_NOTE)
if not len(res):
return
self.ori_detail = res[0]
self.label_eqno.setText(self.ori_detail['eqno'])
self.label_eqname.setText(self.ori_detail['eqname'])
self.lineEdit_mainpoint.setText(self.ori_detail['mainpoint'])
self.plainTextEdit_repaired.setPlainText(
self.ori_detail['partrepairing'])
self.plainTextEdit_part.setPlainText(self.ori_detail['partreplacing'])
self.plainTextEdit_running.setPlainText(self.ori_detail['testrunning'])
self.pushButton_repairer.setSign(
True, self.ori_detail['repairerid'] + ' ' +
self.ori_detail['repairername'])
self.dateEdit_finishdate.setDate(self.ori_detail['finishdate'])
@pyqtSlot(str)
def on_lineEdit_mainpoint_textChanged(self, p_str):
try:
if p_str != self.ori_detail['mainpoint']:
self.new_detail['mainpoint'] = p_str
else:
try:
del self.new_detail['mainpoint']
except KeyError:
pass
except KeyError:
self.new_detail['mainpoint'] = p_str
@pyqtSlot()
def on_plainTextEdit_repaired_textChanged(self):
p_str = self.plainTextEdit_repaired.toPlainText()
try:
if p_str != self.ori_detail['partrepairing']:
self.new_detail['partrepairing'] = p_str
else:
try:
del self.new_detail['partrepairing']
except KeyError:
pass
except KeyError:
self.new_detail['partrepairing'] = p_str
@pyqtSlot()
def on_plainTextEdit_part_textChanged(self):
p_str = self.plainTextEdit_part.toPlainText()
try:
if p_str != self.ori_detail['partreplacing']:
self.new_detail['partreplacing'] = p_str
else:
try:
del self.new_detail['partreplacing']
except KeyError:
pass
except KeyError:
self.new_detail['partreplacing'] = p_str
@pyqtSlot()
def on_plainTextEdit_running_textChanged(self):
p_str = self.plainTextEdit_running.toPlainText()
try:
if p_str != self.ori_detail['testrunning']:
self.new_detail['testrunning'] = p_str
else:
try:
del self.new_detail['testrunning']
except KeyError:
pass
except KeyError:
self.new_detail['testrunning'] = p_str
@pyqtSlot(bool, str)
def on_pushButton_repairer_signChanged(self, p_bool, p_str):
id, name = p_str.split(' ') if p_bool else ('', '')
try:
if id != self.ori_detail['repairerid'] or name != self.ori_detail[
'repairername']:
self.new_detail['repairerid'] = id
self.new_detail['repairername'] = name
else:
try:
del self.new_detail['repairerid']
del self.new_detail['repairername']
except KeyError:
pass
except KeyError:
self.new_detail['repairerid'] = id
self.new_detail['repairername'] = name
@pyqtSlot(QDate)
def on_dateEdit_finishdate_dateChanged(self, q_date):
try:
if type(self.ori_detail['finishdate']) is str:
self.new_detail['finishdate'] = q_date.toPyDate()
return
if q_date != QDate(self.ori_detail['finishdate']):
self.new_detail['finishdate'] = q_date.toPyDate()
else:
try:
del self.new_detail['finishdate']
except KeyError:
pass
except KeyError:
self.new_detail['finishdate'] = q_date.toPyDate()
@pyqtSlot()
def on_pushButton_accept_clicked(self):
if len(self.new_detail):
if self.autoid is None:
self.new_detail['eqno'] = self.eqno
self.new_detail['kind'] = 0
self.EC.update_data(3, **self.new_detail)
self.accept()
pyqtSlot()
def on_pushButton_cancel_clicked(self):
self.close()