def updateButtonEvent(self, Widget): """ hsj 修改产品批次信息 :param Widget: 要显示的窗体 :return: """ logger = logToFile() UserId = getCurrentUserId() tableName = self.queryModel.table result = self.queryModel.selectSingleTable() logger.info("用户:" + str(UserId) + " 点击了更新按钮,试图更新 " + " 产品入库 " + "表中的原数据:" + str(result)) # 判断复选框是否只选中一个 a = self.isCorrect() if a == 0: return result = self.queryModel.selectSingleTable() batchDialog = Widget form = QDialog() batchDialog.setupUi(form) batchDialog.updateData(result, self.queryModel) form.show() a = form.exec() # 如果对话框关闭,则对查询数据进行更行 if a == 0: self.queryModel.refreshPage() self.queryModel.update()
def deleteProduct(self): """ hsj 删除选中的产品,并且关联删除 :return: """ UserId = getCurrentUserId() logger = logToFile() db = openDB() query = QSqlQuery() for i, isSelected in enumerate(self.checkList): if isSelected == "Checked": sql = "DELETE FROM T_Product_New WHERE ProductID = '%s'" % ( self.data_list[i][0]) logger.info("用户:" + str(UserId) + " 删除了 T_Product_New 表(产品信息表)中的产品ID为:" + str(self.data_list[i][0]) + "的数据项") #print(sql) query.exec(sql) sql = "DELETE FROM T_ProductComponent_New WHERE ProductID = '%s'" % ( self.data_list[i][0]) logger.info("用户:" + str(UserId) + " 删除 T_ProductComponent_New 表(产品组件表)中的产品ID为:" + str(self.data_list[i][0]) + "的数据项") print(sql) sql = "DELETE FROM MaintenanceWay WHERE ProductID = '%s'" % ( self.data_list[i][0]) logger.info("用户:" + str(UserId) + " 删除 MaintenanceWay 表(维保方式表)中的产品ID为:" + str(self.data_list[i][0]) + "的数据项") query.exec(sql) db.commit() self.refreshPage()
def deleteCompoment(self): """ hsj 删除选中的组件及关联删除 :return: """ UserId = getCurrentUserId() logger = logToFile() self.db = openDB() self.query = QSqlQuery() for i, isSelected in enumerate(self.checkList): if isSelected == "Checked": sql = "DELETE FROM %s WHERE %s = '%s'" % ( self.table, self.tableKey, self.data_list[i][0]) self.query.exec(sql) logger.info("用户:" + str(UserId) + " 删除了 " + str(self.table) + " 表中的主键 " + str(self.tableKey) + " = " + str(self.data_list[i][0]) + "的组件,及其全部子组件") # sql = "DELETE FROM T_Product WHERE ProductNO = '%s'" % (self.data_list[i][2]) # query.exec(sql) # sql = "DELETE FROM %s WHERE FatherID = '%s' AND ProductID = '%s'" % (self.table, self.data_list[i][0], self.data_list[i][1]) self.deleteComponent_Sub(self.data_list[i][0]) # print(sql) self.query.exec(sql) # sql = "DELETE FROM T_Product_Component WHERE ProductID = '%s'" % (self.data_list[i][2]) # query.exec(sql) self.db.commit() self.refreshPage()
def deleteButtonEvent(self): """ hsj 删除按钮绑定事件 :return: """ # print(self.queryModel.checkList.count("Checked")) # 如果没有选中数据,则提示无数据 logger = logToFile() UserId = getCurrentUserId() data = self.queryModel.getAllCheckedData() tableName = self.queryModel.table logger.info("用户:" + str(UserId) + " 点击了删除按钮,试图删除 " + str(tableName) + " 表中的数据:" + str(data)) if self.queryModel.checkList.count("Checked") == 0: logger.info("用户:" + str(UserId) + " 删除失败(没有选择要删除的数据)") QMessageBox.warning(QDialog(), "警告", "没有数据被选中,请选中后重试!", QMessageBox.Yes, QMessageBox.Yes) return a = QMessageBox.information(QDialog(), "提示", "是否确认删除?", QMessageBox.Yes, QMessageBox.No) if a == QMessageBox.No: logger.info("用户:" + str(UserId) + " 取消了删除") return self.queryModel.deleteOut() self.queryModel.update() self.updateBottomWidget()
def updateButtonEvent(self, queryModel): """ 更新界面按钮事件 :param queryModel: :return: """ UserId = getCurrentUserId() logger = logToFile() # print(self.pre_list) ComponentID = self.pre_list[1] productID = self.productID.currentText() componentNO = self.componentNO.text() componentName = self.componentName.text() fatherID = self.fatherID.currentText() componentType = self.componentType.currentText() count = self.count.text() liftType = self.lifeType.currentText() lifeTime = self.lifeTime.text() tolifeDays = self.toLifeDays.text() firstMaintainTime = self.firstMaintainTime.text() maintainInterval = self.maintainInterval.text() toMaintainDays = self.toMaintainDays.text() componentID = self.getComponentID() if fatherID == "0": fatherID = "无父组件" # 如果必要的信息都不为空 if productID == "" or componentNO == "": print( QMessageBox.information(QDialog(), "提示", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return self.db = openDB() self.query = QSqlQuery() sql = "UPDATE T_ProductComponent_New SET (productID, componentNO, componentName, fatherID, componentType, count, lifeType,lifeTime, tolifeDays, firstMaintainTime, maintainInterval, toMaintainDays) = ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s') WHERE ComponentID = '%s'"\ % (productID, componentNO, componentName, fatherID, componentType, count, liftType, lifeTime, tolifeDays, firstMaintainTime, maintainInterval, toMaintainDays, ComponentID) # print(sql) # update_sql = "UPDATE T_Product_New SET (ProductNO, ProductName, BatchNO, Receiver, ReceiverDate, ReceiverCompany, Registerer, RegisterDate, RegisterCompany, InitCount, Count, StorePlace, LifeType, LifeTime, ToLifeDays, FirstMaintainTime, ToMaintainDays, MaintainInterval, Document) = " \ # "('%s', '%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s', '%s','%s','%s','%s','%s','%s') WHERE ProductID = '%s'" % \ # (productNO, productName, batchNO, receiver, receiverDate, receiverCompany, registerer, registerDate, registerCompany, initCount, count, storePlace, lifeType, lifeTime, toliftDays, firstMaintainTime, toMaintainDays, maintainInterval, document, productID) self.query.exec(sql) self.db.commit() logger.info("用户:" + str(UserId) + " 修改了 T_ProductComponent_New 表的数据,新数据为:[" + str(componentID) + "," + str(productID) + "," + str(componentNO) + "," + str(componentName) + "," + str(fatherID) + "," + str(componentType) + "," + str(count) + "," + str(liftType) + "," + str(lifeTime) + "," + str(tolifeDays) + "," + str(firstMaintainTime) + "," + str(maintainInterval) + "," + str(toMaintainDays) + "]") confirm = QMessageBox.information(QDialog(), "提示", "产品更改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close()
def updateButtonEvent(self, queryModel): """ 更新界面按钮事件 :param queryModel: :return: """ logger = logToFile() UserId = getCurrentUserId() # print(self.pre_list) productID = self.pre_list[1] productNO = self.productNO.text() productName = self.productName.text() batchNO = self.batchNO.text() receiver = self.receiver.text() receiverDate = self.receiverDate.text() receiverCompany = self.receiverCompany.text() registerer = self.registerer.text() registerDate = self.registerDate.text() registerCompany = self.registerCompany.text() count = self.count.text() initCount = int(self.pre_list[11]) + int(count) - int( self.pre_list[12]) storePlace = self.storePlace.currentText() lifeType = self.lifeType.currentText() lifeTime = self.lifeTime.text() toliftDays = self.toLifeDays.text() firstMaintainTime = self.firstMaintainTime.text() maintainInterval = self.maintainInterval.text() toMaintainDays = self.toMaintainDays.text() document = self.document.text() self.db = openDB() self.query = QSqlQuery() update_sql = "UPDATE T_Product_New SET (ProductNO, ProductName, BatchNO, Receiver, ReceiverDate, ReceiverCompany, Registerer, RegisterDate, RegisterCompany, InitCount, Count, StorePlace, LifeType, LifeTime, ToLifeDays, FirstMaintainTime, ToMaintainDays, MaintainInterval, Document) = " \ "('%s', '%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s', '%s','%s','%s','%s','%s','%s') WHERE ProductID = '%s'" % \ (productNO, productName, batchNO, receiver, receiverDate, receiverCompany, registerer, registerDate, registerCompany, initCount, count, storePlace, lifeType, lifeTime, toliftDays, firstMaintainTime, toMaintainDays, maintainInterval, document, productID) logger.info("用户: " + str(UserId) + " 更新了一条T_Product_New表数据,新数据为:[" + str(productID) + "," + str(productNO) + "," + str(productName) + "," + str(batchNO) + "," + str(receiver) + "," + str(receiverDate) + "," + str(receiverCompany) + "," + str(registerer) + "," + str(receiverDate) + "," + str(receiverCompany) + "," + str(count) + "," + str(count) + "," + str(storePlace) + "," + str(lifeType) + "," + str(lifeTime) + "," + str(toliftDays) + "," + str(firstMaintainTime) + "," + str(toMaintainDays) + "," + str(maintainInterval) + "," + str(document) + "]") # print(update_sql) self.query.exec(update_sql) self.db.commit() confirm = QMessageBox.information(QDialog(), "提示", "产品更改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close()
def conserveButtonEvent(self, Dialog): """ hsj 新建产品组件界面的保存按钮事件 :return: """ logger = logToFile() UserId = getCurrentUserId() productID = self.productID.currentText() componentNO = self.componentNO.text() componentName = self.componentName.text() fatherID = self.fatherID.currentText() componentType = self.componentType.currentText() count = self.count.text() liftType = self.lifeType.currentText() lifeTime = self.lifeTime.text() tolifeDays = self.toLifeDays.text() firstMaintainTime = self.firstMaintainTime.text() maintainInterval = self.maintainInterval.text() toMaintainDays = self.toMaintainDays.text() componentID = self.getComponentID() if fatherID == "0": fatherID = "无父组件" # 如果必要的信息都不为空 if productID == "" or componentNO == "": print( QMessageBox.information(QDialog(), "提示", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return else: num = self.checkOn(productID, fatherID) if num == 0: return insert_sql = "INSERT INTO T_ProductComponent_New VALUES (null, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" \ % (componentID, productID, componentNO, componentName, fatherID, componentType, count, liftType, lifeTime, tolifeDays, firstMaintainTime, maintainInterval, toMaintainDays) self.query.exec(insert_sql) self.db.commit() logger.info("用户:" + str(UserId) + " 新建了一个 T_ProductComponent_New 表的数据,新数据为:[" + str(componentID) + "," + str(productID) + "," + str(componentNO) + "," + str(componentName) + "," + str(fatherID) + "," + str(componentType) + "," + str(count) + "," + str(liftType) + "," + str(lifeTime) + "," + str(tolifeDays) + "," + str(firstMaintainTime) + "," + str(maintainInterval) + "," + str(toMaintainDays) + "]") confirm = QMessageBox.information(QDialog(), "提示", "组件新建成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: Dialog.close()
def conserveButtonEvent(self, Form): """ hsj 新建产品组件界面的保存按钮事件 :return: """ Num = self.Num.text() Title = self.Title.text() Source = self.Source.text() Publisher = getCurrentUserId() Rtime = self.Rtime.text() Etime = self.Etime.text() Readrange = self.Readrange.text() Content = self.Content.toPlainText() logger = logToFile() UserId = getCurrentUserId() # remark = self.remark.toPlainText() # 如果必要的信息都不为空 if Title == "" or Source == "" or Publisher == "" or Readrange == "" or Content == "" or Etime == "": logger.info("用户:" + str(UserId) + " 新建知识库数据失败(必要信息为空)") print( QMessageBox.information(QDialog(), "提示", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return else: num = self.checkOn(Num) if num == 0: logger.info("用户:" + str(UserId) + " 新建知识库数据失败(添加信息未通过检测)") revert_sql = "INSERT INTO T_Knowladge_Base_Mangement VALUES (null, '%s', '%s'," \ " '%s', '%s', '%s', " \ "'%s', '%s')" \ % (Title, Source, Publisher, Rtime, Etime, Readrange, Content) self.query.exec(revert_sql) self.db.commit() return insert_sql = "INSERT INTO T_Knowladge_Base_Mangement VALUES (null, '%s', '%s'," \ " '%s', '%s', '%s', " \ "'%s', '%s')" \ % (Title, Source, Publisher, Rtime, Etime, Readrange, Content) self.query.exec(insert_sql) self.db.commit() logger.info("用户:" + str(UserId) + " 新建知识库数据成功!数据为:[" + str(Title) + "," + str(Source) + "," + str(Publisher) + "," + str(Rtime) + "," + str(Etime) + "," + str(Readrange) + "," + str(Content) + "]") confirm = QMessageBox.information(QDialog(), "提示", "新建成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: Form.close()
def updateButtonEvent(self, queryModel): """ 更新界面按钮事件 :param queryModel: :return: """ #print(('shank')) Num = self.Num.text() Title = self.Title.text() Source = self.Source.text() Publisher = getCurrentUserId() Rtime = self.Rtime.text() Etime = self.Etime.text() Readrange = self.Readrange.text() Content = self.Content.toPlainText() # remark = self.remark.toPlainText() queryModel.delete() logger = logToFile() UserId = getCurrentUserId() # 如果必要的信息都不为空 if Title == "" or Source == "" or Publisher == "" or Readrange == "" or Content == "" or Etime == "": print( QMessageBox.information(QDialog(), "提示", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return else: num = self.checkOn(Num) if num == 0: return insert_sql = "INSERT INTO T_Knowladge_Base_Mangement VALUES ('%s', '%s', '%s'," \ " '%s', '%s', '%s', " \ "'%s', '%s')" \ % (Num,Title, Source, Publisher, Rtime, Etime, Readrange, Content) self.query.exec(insert_sql) self.db.commit() logger.info("用户:" + str(UserId) + " 修改知识库数据成功!数据为:[" + str(Title) + "," + str(Source) + "," + str(Publisher) + "," + str(Rtime) + "," + str(Etime) + "," + str(Readrange) + "," + str(Content) + "]") confirm = QMessageBox.information(QDialog(), "提示", "更改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.form.close()
def addButtonEvent(self, Widget): logger = logToFile() UserId = getCurrentUserId() tableName = self.queryModel.table logger.info("用户:" + str(UserId) + " 点击了添加按钮,试图在 " + str(tableName) + " 表中添加数据项") form = QDialog() w = Widget w.setupUi(form) form.show() a = form.exec_() # 如果对话框关闭,则对查询数据进行更行 if a == 0: self.queryModel.refreshPage() self.queryModel.update() self.updateUI()
def conserveButtonEvent(self, Dialog): """ hsj 新建产品界面的保存按钮事件 :return: """ logger = logToFile() UserId = getCurrentUserId() faultID = self.faultID.text() faultName = self.faultName.text() productName = self.productName.text() question_str = self.question.toPlainText() question = question_str.replace("?", "?").replace(",", ",") answer_str = self.answer.text() if answer_str.endswith(";") or answer_str.endswith(";"): answer_str = answer_str[:-1] answer = answer_str.replace(";", ";") answers = answer.split(";") answerCount = len(answers) if self.answerCount.text() != str(answerCount): QMessageBox.information(QDialog(), "提示", "输入的问题答案和决策树深度不匹配!", QMessageBox.Yes, QMessageBox.Yes) return knowledgeID = self.knowledgeID.currentText() # 如果必要的信息都不为空 if productName == "" or faultName == "": logger.info("用户:" + str(UserId) + " 新建故障树分支失败(必要信息为空)") print(QMessageBox.warning(QDialog(), "警告", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return else: self.db = openDB() self.query = QSqlQuery() insert_sql = "INSERT INTO T_Diagnose VALUES (null, '%s', '%s', '%s', '%s', '%s', '%s', '%s')" %\ (faultID, faultName, productName, question, answer, answerCount, knowledgeID) print(insert_sql) self.query.exec_(insert_sql) self.db.commit() logger.info("用户:" + str(UserId) + " 新建故障树分支成功!数据为:[" + str(faultID) + "," + str(faultName) + "," + str(productName) + "," + str(question) + "," + str(answer) + "," + str(answerCount) + "," + str(knowledgeID) + "]") confirm = QMessageBox.information(QDialog(), "提示", "故障树分支新建成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: Dialog.close()
def updateButtonEvent(self, queryModel): """ 更新界面按钮事件 :param queryModel: :return: """ faultID = self.faultID.text() faultName = self.faultName.text() productName = self.productName.text() question_str = self.question.toPlainText() question = question_str.replace("?", "?") answer_str = self.answer.text() if answer_str.endswith(";") or answer_str.endswith(";"): answer_str = answer_str[:-1] answer = answer_str.replace(";", ";") answers = answer.split(";") answerCount = len(answers) logger = logToFile() UserId = getCurrentUserId() if self.answerCount.text() != str(answerCount): QMessageBox.information(QDialog(), "提示", "输入的问题答案和决策树深度不匹配!", QMessageBox.Yes, QMessageBox.Yes) return knowledgeID = self.knowledgeID.currentText() self.db = openDB() self.query = QSqlQuery() update_sql = "UPDATE T_Diagnose SET (FaultName, ProductName, Question, Answer, Answercount, KnowledgeID) = " \ "('%s', '%s','%s','%s','%s','%s') WHERE FaultID = '%s'" % \ (faultName, productName, question, answer, answerCount, knowledgeID, faultID) print(update_sql) self.query.exec(update_sql) self.db.commit() logger.info("用户:" + str(UserId) + " 修改故障树分支成功!数据为:[" + str(faultID) + "," + str(faultName) + "," + str(productName) + "," + str(question) + "," + str(answer) + "," + str(answerCount) + "," + str(knowledgeID) + "]") confirm = QMessageBox.information(QDialog(), "提示", "故障分支更改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close()
def deleteButtonEvent(self): """ hsj 删除批次按钮绑定事件 :return: """ # print(self.queryModel.checkList.count("Checked")) # 如果没有选中数据,则提示无数据 UserId = getCurrentUserId() logger = logToFile() logger.info("用户:" + str(UserId) + " 点击了删除按钮,试图删除:" + str(self.queryModel.getData())) if self.queryModel.checkList.count("Checked") == 0: QMessageBox.warning(QDialog(), "警告", "没有数据被选中,请选中后重试!", QMessageBox.Yes, QMessageBox.Yes) return a = QMessageBox.information(QDialog(), "提示", "是否确认删除?", QMessageBox.Yes, QMessageBox.No) if a == QMessageBox.No: return self.queryModel.deleteCompoment() self.queryModel.update()
def deleteOut(self): """ 许帅 删除选中的出库信息,并且关联删除 :return: """ logger = logToFile() UserId = getCurrentUserId() db = openDB() query = QSqlQuery() for i, isSelected in enumerate(self.checkList): if isSelected == "Checked": global count global no sql = "SELECT ProductID,OutCount FROM T_Out_Detail WHERE OutNO = '%s'" % ( self.data_list[i][0]) query.exec(sql) if query.next(): no = query.value(0) count = query.value(1) sql = "UPDATE T_Product_New SET Count=Count+'%s' WHERE ProductID='%s'" % \ (int(count), no) query.exec(sql) sql = "DELETE FROM T_Out_Detail WHERE OutNO = '%s'" % ( self.data_list[i][0]) query.exec(sql) logger.info("用户:" + str(UserId) + " 删除了 T_Out_Detail 表中出库编号为 " + self.data_list[i][0] + " 的数据 " + str(self.data_list[i])) sql = "DELETE FROM T_Out_Base WHERE OutNO = '%s'" % ( self.data_list[i][0]) query.exec(sql) logger.info("用户:" + str(UserId) + " 删除了 T_Out_Base 表中出库编号为 " + self.data_list[i][0] + " 的数据 " + str(self.data_list[i])) db.commit() self.refreshPage()
def ok_fun(self): logger = logToFile() UserId = getCurrentUserId() if all([ self.outNO.text(), self.outDate.text(), self.usedID.text(), self.usedDepartmentNO.text(), self.outRecorderPersonNO.text(), self.outReason.text(), self.createTime.text(), self.remark.toPlainText(), self.productID.currentText(), self.outStorageNo.text(), self.outTechState.text(), self.isReturn.currentText(), self.createTime.text(), self.remark.toPlainText(), self.outCount.value() ]): db = openDB() q = QSqlQuery() insert_sql = "INSERT INTO T_Out_Base(outno, outdate, usedid, useddepartmentid, recorderid, outreason, " \ "createid, createtime, updateid, updatetime, remark) VALUES ('%s','%s','%s','%s','%s','%s'," \ "'%s','%s','%s','%s','%s')" % \ (self.outNO.text(), self.outDate.text(), self.usedID.text(), self.usedDepartmentNO.text(), self.outRecorderPersonNO.text(), self.outReason.text(), 1, self.createTime.text(), 0, self.createTime.text(), self.remark.toPlainText()) q.exec(insert_sql) db.commit() insert_sql = "INSERT INTO T_Out_Detail(outno, ProductID, outstorageno, outtechstate, isreturn, createid, " \ "createtime, updateid, updatetime, remark,OutCount)VALUES ('%s','%s','%s','%s','%s','%s'," \ "'%s','%s','%s','%s','%s')" % \ (self.outNO.text(), self.productID.currentText(), self.outStorageNo.text(), self.outTechState.text(), self.isReturn.currentText(), 1, self.createTime.text(), 0, self.createTime.text(), self.remark.toPlainText(), str(self.outCount.value())) q.exec(insert_sql) db.commit() logger.info("用户:" + str(UserId) + " 新建了一条产品出库基础信息" + "新数据为:[" + self.outNO.text() + " ," + self.outDate.text() + " ," + self.usedID.text() + " ," + self.usedDepartmentNO.text() + " ," + self.outRecorderPersonNO.text() + " ," + self.outReason.text() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + self.remark.toPlainText() + "]") update_sql = "UPDATE T_Product_New SET Count='%s' WHERE productID='%s'" % ( count - int(self.outCount.value()), self.productID.currentText()) q.exec(update_sql) db.commit() logger.info("用户:" + str(UserId) + " 新建了一条产品出库详细信息" + "新数据为:[" + self.outNO.text() + " ," + self.productID.currentText() + " ," + self.outStorageNo.text() + " ," + self.outTechState.text() + " ," + self.isReturn.currentText() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + self.remark.toPlainText() + " ," + str(self.outCount.value()) + "]") db.close() confirm = QMessageBox.information(QDialog(), "提示", "出库信息新建成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close() else: logger.info("用户:" + str(UserId) + " 出库信息新建失败(重要数据输入值为空)") QMessageBox.information(QDialog(), "错误", "输入值不能为0或为空,请重新检查输入!", QMessageBox.Yes, QMessageBox.Yes)
def deleteImage(): logger = logToFile() UserId = getCurrentUserId()
def conserveButtonEvent(self, Dialog): """ hsj 新建产品界面的保存按钮事件 :return: """ mrID = self.mrID.text() productID = self.productID.currentText() productName = self.productName.text() productNO = self.productNO.text() mwID = self.mwID.currentText() mwName = self.mwName.text() mrTime = self.mrTime.text() mrPart = self.mrPart.text() mrLead = self.mrLead.text() mrResult = self.mrResult.text() creator = getCurrentUserId() createTime = self.createTime.text() updateName = self.updateName.text() updateTime = self.updateTime.text() documentPath = self.documentPathButton.text() remark = self.remark.toPlainText() logger = logToFile() UserId = getCurrentUserId() # 如果必要的信息都不为空 if mrID == "" or mwID == "" or mwID == "该产品暂无相应的维保方式": print( QMessageBox.warning(QDialog(), "警告", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) logger.info("用户:" + str(UserId) + " 新建维保信息失败(必要信息为空)") return else: num = self.checkOn(mrID) if num == 0: logger.info("用户:" + str(UserId) + " 新建维保记录失败(新建数据未通过检验)") return createTime = time.strftime("%Y-%m-%d %H:%M:%S") conn = sqlite3.connect("./db/ProductManagement_new.db") cursor = conn.cursor() sql = "insert into MaintenanceRecord (MrID, ProductID, ProductName, ProductNO, MwID, " \ "MwName, MrTime, MrPart, MrLead, MrResult, " \ "Creator, CreateTime, UpdateName,UpdateTime,DocumentPath,Remark) " \ "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" try: cursor.execute( sql, (mrID, productID, productName, productNO, mwID, mwName, mrTime, mrPart, mrLead, mrResult, creator, createTime, updateName, updateTime, documentPath, remark)) conn.commit() logger.info("用户:" + str(UserId) + " 新建了一条维保记录,新数据为:[" + str(mrID) + " ," + str(mwID) + " ," + str(mwName) + " ," + str(mrTime) + " ," + str(mrPart) + " ," + str(mrLead) + " ," + str(mrResult) + " ," + str(creator) + " ," + str(createTime) + " ," + str(updateName) + str(updateTime) + " ," + str(documentPath) + " ," + str(remark) + " ]") # print("成功!!") confirm = QMessageBox.information(QDialog(), "提示", "维保记录创建完成!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: Dialog.close() except Exception as e: print(e) self.errorMessage.setText("抱歉,您的输入有误:" + str(e)) conn.rollback() # 获取RecentTime sql = 'SELECT RecentTime FROM MaintenanceWay where MaintenanceWayID=?' try: cursor.execute(sql, (mwID, )) list = cursor.fetchone() if list[0]: ss_recentTime = time.mktime( time.strptime(list[0], "%Y-%m-%d")) ss_mrTime = time.mktime(time.strptime(mrTime, "%Y-%m-%d")) # print(ss_mrTime) # print(ss_recentTime) diff = int(ss_mrTime) - int(ss_recentTime) # print('diff',diff) if diff: sql = 'UPDATE MaintenanceWay set RecentTime=? where MaintenanceWayID=?' cursor.execute(sql, (mrTime, mwID)) conn.commit() conn.close() # print('修改成功') else: sql = 'UPDATE MaintenanceWay set RecentTime=? where MaintenanceWayID=?' cursor.execute(sql, (mrTime, mwID)) conn.commit() # print('修改成功') conn.close() except Exception as e: print(e) conn.close()
def updateButtonEvent(self, queryModel): print('updateButtonEvent执行了') """ 更新界面按钮事件 :param queryModel: :return: """ # print('updateButtonEvent执行了') maintenanceWayID = self.maintenanceWayID.text() maintenanceWayName = self.maintenanceWayName.text() productID = self.productID.currentText() productName = self.productName.text() productNO = self.productNO.text() firstTime = self.firstTime.text() recentTime = self.recentTime.text() interva = self.interval.text() alterRule = self.alterRule.text() creator = self.creator.text() createTime = self.createTime.text() updateName = getCurrentUserId() updateTime = self.updateTime.text() operation = self.operation.toPlainText() remark = self.remark.text() logger = logToFile() UserId = updateName # 如果必要的信息都不为空 if maintenanceWayID == "" or productID == "": logger.info("用户:" + str(UserId) + " 更新维保方式失败(必要信息为空)") print( QMessageBox.warning(QDialog(), "警告", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return else: # num = self.checkOn(maintenanceWayID) # if num == 0: # logger.info("用户:" + str(UserId) + " 更新维保方式失败(未通过数据检测)") # return updateTime = time.strftime("%Y-%m-%d %H:%M:%S") conn = sqlite3.connect("./db/ProductManagement_new.db") cursor = conn.cursor() sql = "update MaintenanceWay set (MaintenanceWayName, ProductID, ProductName, ProductNO, FirstTime," \ " RecentTime, Interva, AlterRule, Creator, CreateTime, " \ "UpdateName,UpdateTime,Operation, Remark) " \ "= ('%s', '%s', '%s', '%s', '%s', " \ "'%s', '%s', '%s', '%s', '%s' ," \ "'%s', '%s', '%s', '%s') where MaintenanceWayID = ('%s')" %( maintenanceWayName, productID, productName, productNO,firstTime, recentTime, interva, alterRule, creator, createTime, updateName, updateTime, operation, remark,maintenanceWayID) try: cursor.execute(sql) conn.commit() logger.info("用户:" + str(UserId) + " 更新维保方式成功!经过更新的部分数据为:[" + str(maintenanceWayID) + " ," + str(productID) + " ," + str(maintenanceWayName) + " ," + str(firstTime) + " ," + str(recentTime) + " ," + str(interva) + " ," + str(alterRule) + " ," + str(creator) + " ," + str(createTime) + " ," + str(updateName) + " ," + str(updateTime) + " ," + str(operation) + " ," + str(remark) + "]") confirm = QMessageBox.information(QDialog(), "提示", "维保方式修改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close() except Exception as e: print(e) # self.errorMessage.setText("抱歉,您的输入有误:" + str(e)) conn.rollback()
def ok_fun(self): logger = logToFile() UserId = getCurrentUserId() verify_values = [ self.inNO.text(), self.outNO.text(), self.inDate.text(), self.inRecorderPerson.text(), self.remark.toPlainText(), self.productID.currentText(), self.inStorageNo.text(), self.inTechState.text(), self.isUsed.currentText(), self.createTime.text(), self.updateTime.text(), self.updateID.text(), str(self.inCount.value()) ] flag = True for value in verify_values: if value == ' ' or value == '0' or value == '': flag = False if flag: db = openDB() q = QSqlQuery() sql = "UPDATE T_In_Base SET OutNO='%s', InRecoder='%s', CreateTime='%s', " \ "UpdateID='%s', UpdateTime='%s', Remark='%s'WHERE OutNO='%s'" \ % (self.outNO.text(), self.inRecorderPerson.text(), self.createTime.text(), self.updateID.text(), self.updateTime.text(), self.remark.toPlainText(), self.inNO.text()) q.exec(sql) db.commit() logger.info("用户:" + str(UserId) + " 更新了产品入库基本信息表的数据,更新的数据为:[" + self.outNO.text() + "," + self.inRecorderPerson.text() + "," + self.createTime.text() + "," + self.updateID.text() + "," + self.updateTime.text() + "," + self.outNO.text() + "]") sql = "UPDATE T_In_Detail SET ProductID='%s', InStorageNO='%s', InTechState='%s', " \ "IsUsed='%s', createtime='%s', UpdateID='%s', updatetime='%s', remark='%s',InCount='%s'" \ "WHERE InNO='%s'" \ % (self.productID.currentText(), self.inStorageNo.text(), self.inTechState.text(), self.isUsed.currentText(), self.createTime.text(), self.updateID.text(), self.updateTime.text(), self.remark.toPlainText(), str(self.inCount.value()), self.inNO.text()) q.exec(sql) db.commit() logger.info("用户:" + str(UserId) + " 更新了产品入库详细信息表的数据,更新后的数据为:[" + self.productID.currentText() + "," + self.inStorageNo.text() + "," + self.inTechState.text() + "," + self.isUsed.currentText() + "," + self.createTime.text() + "," + self.updateID.text() + "," + self.updateTime.text() + "," + self.remark.toPlainText() + "," + str(self.inCount.value()) + "]") sql = "UPDATE T_Product_New SET Count=Count+'%s' WHERE productID='%s'" % \ (int(self.inCount.value()) - in_count, self.productID.currentText()) q.exec(sql) db.commit() db.close() confirm = QMessageBox.information(QDialog(), "提示", "入库信息修改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close() else: logger.info("用户:" + str(UserId) + " 入库信息更新失败(重要数据输入值不符合规范)") QMessageBox.information(QDialog(), "错误", "输入值不能为0或为空,请重新检查输入!", QMessageBox.Yes, QMessageBox.Yes)
def updateButtonEvent(self, queryModel): """ 更新界面按钮事件 :param queryModel: :return: """ mrID = self.mrID.text() productID = self.productID.currentText() productName = self.productName.text() productNO = self.productNO.text() mwID = self.mwID.currentText() mwName = self.mwName.text() mrTime = self.mrTime.text() mrPart = self.mrPart.text() mrLead = self.mrLead.text() mrResult = self.mrResult.text() creator = self.creator.text() createTime = self.createTime.text() updateName = self.updateName.text() updateTime = getCurrentUserId() documentPath = self.documentPathButton.text() remark = self.remark.toPlainText() logger = logToFile() UserId = updateName if mrID == "" or mwID == "": logger.info("用户:" + str(UserId) + " 更新维保记录失败(重要字段信息为空)") print( QMessageBox.information(QDialog(), "提示", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return else: # num = self.checkOn(mrID) # if num == 0: # logger.info("用户:" + str(UserId) + " 更新维保记录失败(未通过数据检测)") # return updateTime = time.strftime("%Y-%m-%d %H:%M:%S") conn = sqlite3.connect("./db/ProductManagement_new.db") # print("success") cursor = conn.cursor() sql = "update MaintenanceRecord set (ProductID, ProductName, ProductNO, MwID, MwName, " \ "MrTime, MrPart, MrLead, MrResult, Creator, " \ "CreateTime, UpdateName,UpdateTime,DocumentPath,Remark) = " \ "('%s', '%s', '%s', '%s', '%s', " \ "'%s', '%s', '%s', '%s', '%s', " \ "'%s', '%s', '%s', '%s', '%s')" \ "where MrID = ('%s')" %( productID, productName, productNO, mwID, mwName, mrTime, mrPart, mrLead, mrResult, creator, createTime, updateName, updateTime, documentPath, remark, mrID ) try: cursor.execute(sql) conn.commit() logger.info("用户:" + str(UserId) + " 更新维保记录成功,经过更新的部分数据为:[" + str(mrID) + " ," + str(mwID) + " ," + str(mwName) + " ," + str(mrTime) + " ," + str(mrPart) + " ," + str(mrLead) + " ," + str(mrResult) + " ," + str(creator) + " ," + str(createTime) + " ," + str(updateName) + str(updateTime) + " ," + str(documentPath) + " ," + str(remark) + " ]") confirm = QMessageBox.information(QDialog(), "提示", "维保记录修改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close() except Exception as e: print(e) self.errorMessage.setText("抱歉,您的输入有误:" + str(e)) conn.rollback() # 获取RecentTime sql = 'SELECT RecentTime FROM MaintenanceWay where MaintenanceWayID=?' try: cursor.execute(sql, (mwID, )) list = cursor.fetchone() if list[0]: ss_recentTime = time.mktime( time.strptime(list[0], "%Y-%m-%d")) ss_mrTime = time.mktime(time.strptime(mrTime, "%Y-%m-%d")) # print(ss_mrTime) # print(ss_recentTime) diff = int(ss_mrTime) - int(ss_recentTime) # print('diff', diff) if diff: sql = 'UPDATE MaintenanceWay set RecentTime=? where MaintenanceWayID=?' cursor.execute(sql, (mrTime, mwID)) conn.commit() conn.close() # print('修改成功') else: sql = 'UPDATE MaintenanceWay set RecentTime=? where MaintenanceWayID=?' cursor.execute(sql, (mrTime, mwID)) conn.commit() conn.close() # print('修改成功') except Exception as e: print(e) conn.close()
def conserveButtonEvent(self, Dialog): """ hsj 新建产品界面的保存按钮事件 :return: """ logger = logToFile() UserId = getCurrentUserId() productNO = self.productNO.text() productName = self.productName.text() batchNO = self.batchNO.text() receiver = self.receiver.text() receiverDate = self.receiverDate.text() receiverCompany = self.receiverCompany.text() registerer = self.registerer.text() registerDate = self.registerDate.text() registerCompany = self.registerCompany.text() count = self.count.text() storePlace = self.storePlace.currentText() lifeType = self.lifeType.currentText() lifeTime = self.lifeTime.text() toliftDays = self.toLifeDays.text() firstMaintainTime = self.firstMaintainTime.text() maintainInterval = self.maintainInterval.text() toMaintainDays = self.toMaintainDays.text() document = self.document.text() productID = self.getProductID() maintenanceWayID = self.getMwID() # 如果必要的信息都不为空 if productNO == "" or productName == "": print( QMessageBox.warning(QDialog(), "警告", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) return else: # import time # createTime = time.strftime("%Y-%m-%d %H:%M:%S") self.db = openDB() self.query = QSqlQuery() insert_sql = "INSERT INTO T_Product_New VALUES (null, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" %\ (productID, productNO, productName, batchNO, receiver, receiverDate, receiverCompany, registerer, registerDate, registerCompany, count, count, storePlace, lifeType, lifeTime , toliftDays, firstMaintainTime, toMaintainDays, maintainInterval, document) # print(insert_sql) self.query.exec_(insert_sql) maintenanceWayName = "默认维保方式" createTime = time.strftime("%Y-%m-%d %H:%M:%S") sql = "insert into MaintenanceWay (MaintenanceWayID, MaintenanceWayName, ProductID, ProductName, ProductNO, " \ "FirstTime, RecentTime, Interva, AlterRule, Creator, CreateTime," \ " UpdateName,UpdateTime,Operation, Remark) " \ "values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '--', '%s','详情见技术文档', '无')" % (maintenanceWayID, maintenanceWayName, productID, productName, productNO, firstMaintainTime, firstMaintainTime, maintainInterval, toMaintainDays, registerer, createTime, createTime) self.query.exec_(sql) self.db.commit() confirm = QMessageBox.information(QDialog(), "提示", "产品新建成功!", QMessageBox.Yes, QMessageBox.Yes) logger.info("用户: " + str(UserId) + " 新建了一条T_Product_New表数据,新数据为:[" + str(productID) + "," + str(productNO) + "," + str(productName) + "," + str(batchNO) + "," + str(receiver) + "," + str(receiverDate) + "," + str(receiverCompany) + "," + str(registerer) + "," + str(receiverDate) + "," + str(receiverCompany) + "," + str(count) + "," + str(count) + "," + str(storePlace) + "," + str(lifeType) + "," + str(lifeTime) + "," + str(toliftDays) + "," + str(firstMaintainTime) + "," + str(toMaintainDays) + "," + str(maintainInterval) + "," + str(document) + "]") if confirm == QMessageBox.Yes: Dialog.close()
def conserveButtonEvent(self, Dialog): """ hsj 新建产品界面的保存按钮事件 :return: """ maintenanceWayID = self.maintenanceWayID.text() maintenanceWayName = self.maintenanceWayName.text() productID = self.productID.currentText() productName = self.productName.text() productNO = self.productNO.text() firstTime = self.firstTime.text() recentTime = self.recentTime.text() interval = self.interval.text() alterRule = self.alterRule.text() creator = getCurrentUserId() # createTime是默认创建的,下面由系统自动生成 createTime = self.createTime.text() updateName = self.updateName.text() updateTime = self.updateTime.text() operation = self.operation.toPlainText() remark = self.remark.text() logger = logToFile() UserId = getCurrentUserId() # 如果必要的信息都不为空 if maintenanceWayID == "" or productID == "": print( QMessageBox.warning(QDialog(), "警告", "有字段为空,添加失败!", QMessageBox.Yes, QMessageBox.Yes)) logger.info("用户:" + str(UserId) + " 新建维保方式失败(必要信息为空)") return else: num = self.checkOn(maintenanceWayID) if num == 0: logger.info("用户:" + str(UserId) + " 新建维保方式失败(新建数据未通过检验)") return # createTime = time.strftime("%Y-%m-%d %H:%M:%S") # insert_sql = "INSERT INTO MaintenanceWay VALUES ('%s', '%s', '%s', '%s', '%s'" \ # ", '%s', '%s','%s', '%s', '%s',%s)" % \ # (maintenanceWayID, productID, maintenanceWayName, firstTime, interval, # alterRule, creator, createTime, updateName, updateTime,remark) # self.query.exec(insert_sql) # self.db.commit() # confirm = QMessageBox.information(QDialog(), "提示", "维保方式新建成功!", QMessageBox.Yes, QMessageBox.Yes) # if confirm == QMessageBox.Yes: # Dialog.close() createTime = time.strftime("%Y-%m-%d %H:%M:%S") conn = sqlite3.connect("./db/ProductManagement_new.db") # print('打卡db成功') cursor = conn.cursor() sql = "insert into MaintenanceWay (MaintenanceWayID, MaintenanceWayName, ProductID, ProductName, ProductNO, " \ "FirstTime, RecentTime, Interva, AlterRule, Creator, CreateTime," \ " UpdateName,UpdateTime,Operation, Remark) " \ "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" try: cursor.execute( sql, (maintenanceWayID, maintenanceWayName, productID, productName, productNO, firstTime, recentTime, interval, alterRule, creator, createTime, updateName, updateTime, operation, remark)) conn.commit() logger.info("用户:" + str(UserId) + " 新建了一条维保方式,新数据为:[" + str(maintenanceWayID) + " ," + str(productID) + " ," + str(maintenanceWayName) + " ," + str(firstTime) + " ," + str(interval) + " ," + str(alterRule) + " ," + str(creator) + " ," + str(createTime) + " ," + str(updateName) + " ," + str(updateTime) + " ," + str(operation) + " ," + str(remark) + " ]") confirm = QMessageBox.information(QDialog(), "提示", "维保方式新建成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: Dialog.close() except Exception as e: print(e) # self.errorMessage.setText("抱歉,您的输入有误:" + str(e)) conn.rollback()
def ChangePasswordButtonClicked(self): currentUserId = getCurrentUserId() UserId = self.UserIdEdit.text() oldPassword = self.oldPasswordEdit.text() password = self.passwordEdit.text() confirmPassword = self.confirmPasswordEdit.text() logger = logToFile() if (UserId == "" or oldPassword == "" or password == "" or confirmPassword == ""): print( QMessageBox.warning(self, "警告", "输入不可为空,请重新输入", QMessageBox.Yes, QMessageBox.Yes)) logger.info("用户: " + str(currentUserId) + " 输入为空修改密码失败") return db = openDB() query = QSqlQuery() sql = "SELECT * FROM User WHERE UserId='%s'" % UserId query.exec_(sql) # 如果用户不存在 if (not query.next()): print( QMessageBox.warning(self, "警告", "该用户不存在,请重新输入", QMessageBox.Yes, QMessageBox.Yes)) self.UserIdEdit.clear() logger.info("用户: " + str(currentUserId) + " 试图修改" + UserId + "但用户不存在") return # 如果密码错误 hl = hashlib.md5() hl.update(oldPassword.encode(encoding='utf-8')) md5password = hl.hexdigest() sql = "SELECT * FROM User WHERE Password='******' AND UserId='%s'" % ( md5password, UserId) query.exec_(sql) if (not query.next()): print( QMessageBox.warning(self, "警告", "原密码不正确,请重新输入", QMessageBox.Yes, QMessageBox.Yes)) logger.info("用户: " + str(currentUserId) + " 原密码错误,修改失败") self.oldPasswordEdit.clear() return # 密码与确认密码不同 if (password != confirmPassword): print( QMessageBox.warning(self, "警告", "两次输入密码不同,请确认输入", QMessageBox.Yes, QMessageBox.Yes)) logger.info("用户: " + str(currentUserId) + " 两次输入密码不同,修改失败") self.passwordEdit.clear() self.confirmPasswordEdit.clear() return # 修改密码 hl = hashlib.md5() hl.update(password.encode(encoding='utf-8')) md5password = hl.hexdigest() sql = "UPDATE User SET Password='******' WHERE UserId='%s'" % (md5password, UserId) query.exec_(sql) db.commit() logger.info("用户: " + str(currentUserId) + " 对用户:" + UserId + " 的密码修改成功") QMessageBox.information(self, "提醒", "修改密码成功,请登录系统!", QMessageBox.Yes, QMessageBox.Yes) self.close() return
def ok_fun(self): logger = logToFile() UserId = getCurrentUserId() verify_values = [self.outNO.text(), self.outDate.text(), self.usedID.text(), self.usedDepartmentNO.text(), self.outRecorderPersonNO.text(), self.outReason.text(), self.createTime.text(), self.remark.toPlainText(), self.productID.currentText(), self.outStorageNo.text(), self.outTechState.text(), self.isReturn.currentText(), self.createTime.text(), self.remark.toPlainText(), str(self.outCount.value())] flag = True for value in verify_values: if value == ' ' or value == '0' or value == '': flag = False if flag: db = openDB() q = QSqlQuery() sql = "UPDATE T_Out_Base SET outdate='%s', usedid='%s', useddepartmentid='%s', recorderid='%s', " \ "outreason='%s', " \ "createid='%s', createtime='%s', updateid='%s', updatetime='%s', remark='%s' WHERE OutNO='%s'" \ % (self.outDate.text(), self.usedID.text(), self.usedDepartmentNO.text(), self.outRecorderPersonNO.text(), self.outReason.text(), 1, self.createTime.text(), self.updateID.text(), self.updateTime.text(), self.remark.toPlainText(), self.outNO.text()) q.exec(sql) db.commit() logger.info("用户:" + str(UserId) + " 更新了一条产品出库基础信息" + "更新数据为:[" + self.outNO.text() + " ," + self.outDate.text() + " ," + self.usedID.text() + " ," + self.usedDepartmentNO.text() + " ," + self.outRecorderPersonNO.text() + " ," + self.outReason.text() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + self.remark.toPlainText() + "]") sql = "UPDATE T_Out_Detail SET ProductID='%s', OutStorageNO='%s', OutTechState='%s', IsReturn='%s', " \ "CreateID='%s', createtime='%s', UpdateID='%s',updatetime='%s', remark='%s',OutCount='%s' WHERE " \ "OutNO='%s'" \ % (self.productID.currentText(), self.outStorageNo.text(), self.outTechState.text(), self.isReturn.currentText(), 1, self.createTime.text(), self.updateID.text(), self.updateTime.text(), self.remark.toPlainText(), str(self.outCount.value()), self.outNO.text()) q.exec(sql) db.commit() logger.info("用户:" + str(UserId) + " 更新了一条产品出库详细信息" + "更新数据为:[" + self.outNO.text() + " ," + self.productID.currentText() + " ," + self.outStorageNo.text() + " ," + self.outTechState.text() + " ," + self.isReturn.currentText() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + str(UserId) + " ," + self.updateTime.text() + " ," + self.remark.toPlainText() + " ," + str(self.outCount.value()) + "]") sql = "UPDATE T_Product_New SET Count=Count+'%s' WHERE productID='%s'" % \ (out_count - int(self.outCount.value()), self.productID.currentText()) q.exec(sql) db.commit() db.close() confirm = QMessageBox.information(QDialog(), "提示", "出库信息修改成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close() else: QMessageBox.information(QDialog(), "错误", "输入值不能为0或为空,请重新检查输入!", QMessageBox.Yes, QMessageBox.Yes)
def ok_fun(self): logger = logToFile() UserId = getCurrentUserId() db = openDB() q = QSqlQuery() inNO = self.inNO.text() outNO = self.outNO.text() inDate = self.inDate.text() inRecorderPerson = self.inRecorderPerson.text() createTime = self.createTime.text() remark = self.remark.toPlainText() productID = self.productID.currentText() inStorageNo = self.inStorageNo.text() inTechState = self.inTechState.text() isUsed = self.isUsed.currentText() createTime = self.createTime.text() inCount = self.inCount.value() # 判断所有值均不为空 if all([ self.inNO.text(), self.outNO.text(), self.inDate.text(), self.inRecorderPerson.text(), self.createTime.text(), self.remark.toPlainText(), self.productID.currentText(), self.inStorageNo.text(), self.inTechState.text(), self.isUsed.currentText(), self.createTime.text(), self.inCount.value() ]): insert_sql = "INSERT INTO T_In_Base(InNO, OUTNO, INDATE, INRECODER, CREATEID, CREATETIME, UPDATEID, " \ "UPDATETIME, REMARK) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s')" % \ (inNO, outNO, inDate, inRecorderPerson, UserId, createTime, UserId, createTime, remark) # print(insert_sql) q.exec(insert_sql) # print(1111) db.commit() logger.info("用户:" + str(UserId) + " 新建了一条产品入库基础信息" + "新数据为:[" + self.inNO.text() + " ," + self.outNO.text() + " ," + self.inDate.text() + " ," + self.inRecorderPerson.text() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + str(UserId) + " ," + self.createTime.text() + " ," + self.remark.toPlainText() + "]") insert_sql = "INSERT INTO T_In_Detail(InNO,ProductID, InStorageNO, InTechState, IsUsed, " \ "CreateID,CreateTime, UpdateID, UpdateTime, Remark,InCount)VALUES ('%s','%s','%s','%s','%s'," \ "'%s','%s','%s','%s','%s','%s')" % \ (inNO, productID, inStorageNo, inTechState, isUsed, UserId, createTime, UserId, createTime, remark, inCount) q.exec(insert_sql) db.commit() # print("ok2") logger.info("用户:" + str(UserId) + " 与此同时!新建了一条产品入库详细信息" + "新数据为:[" + inNO + " ," + productID + " ," + inStorageNo + " ," + inTechState + " ," + isUsed + " ," + str(UserId) + " ," + createTime + " ," + str(UserId) + " ," + createTime + " ," + remark + " ," + str(inCount) + "]") # print("ok") update_sql = "UPDATE T_Product_New SET Count=Count+'%s' WHERE productID='%s'" \ % (int(inCount), productID) logger.info("用户:" + str(UserId) + " 与此同时!新增了与产品入库相关的产品库存信息(位置在产品表)" + "修改的库存产品编号为:" + self.productID.currentText() + ",增加了" + self.inCount.text() + "的库存") q.exec(update_sql) db.commit() if int(out_count) == int(self.inCount.value()): update_sql = "UPDATE T_Out_Detail SET IsReturn='是'where OutNO='%s'" % out_no q.exec(update_sql) db.commit() db.close() confirm = QMessageBox.information(QDialog(), "提示", "入库信息新建成功!", QMessageBox.Yes, QMessageBox.Yes) if confirm == QMessageBox.Yes: self.dialog.close() else: QMessageBox.information(QDialog(), "错误", "输入值不能为0或为空,请重新检查输入!", QMessageBox.Yes, QMessageBox.Yes)