def updateData(self, list, queryModel): """ 修改产出库信息 :param list: :return: """ self.outNO.setText(list[1]) self.productID.addItem(list[2]) # 获取所有的productID AddOutStorage.AddOutStorage.get_product_NO(self) self.outStorageNo.setText(list[3]) self.outTechState.setText(list[4]) self.isReturn.setItemText(0, list[5]) self.createTime.setDateTime(datetime.strptime(list[7], "%Y-%m-%d %H:%M:%S")) self.createTime.setDisplayFormat("yyyy-MM-dd hh:mm:ss") self.remark.setText(list[10]) global out_count out_count = int(list[11]) self.outCount.setRange(0, out_count) self.outCount.setValue(out_count) db = openDB() query = QSqlQuery() sql = "SELECT * FROM T_Out_Base where OutNO='%s'" % self.outNO.text() query.exec(sql) if query.next(): self.outDate.setDateTime(datetime.strptime(query.value(2), "%Y-%m-%d")) self.outDate.setDisplayFormat("yyyy-MM-dd") self.usedID.setText(str(query.value(3))) self.usedDepartmentNO.setText(str(query.value(4))) self.outRecorderPersonNO.setText(str(query.value(5))) self.outReason.setText(query.value(6)) db.close()
def setData(self, list): """ hsj 设置单个产品查询结果 :param list: 单个查询结果 :return: """ self.ID.setText(list[0]) self.outNO.setText(list[1]) self.productID.setText(list[2]) self.outStorageNo.setText(list[3]) self.outTechState.setText(list[4]) self.isReturn.setItemText(0, list[5]) self.createTime.setDateTime( datetime.strptime(list[7], "%Y-%m-%d %H:%M:%S")) self.createTime.setDisplayFormat("yyyy-MM-dd hh:mm:ss") self.updateID.setText(list[8]) self.updateTime.setDateTime( datetime.strptime(list[9], "%Y-%m-%d %H:%M:%S")) self.updateTime.setDisplayFormat("yyyy-MM-dd hh:mm:ss") self.remark.setText(list[10]) self.outCount.setRange(0, int(list[11])) self.outCount.setValue(int(list[11])) db = openDB() query = QSqlQuery() sql = "SELECT * FROM T_Out_Base where OutNO='%s'" % self.outNO.text() query.exec(sql) if query.next(): self.outDate.setDate(datetime.strptime(query.value(2), "%Y-%m-%d")) self.outDate.setDisplayFormat("yyyy-MM-dd") self.outReason.setText(query.value(6)) self.usedID.setText(str(query.value(3))) self.usedDepartmentNO.setText(str(query.value(4))) self.outRecorderPersonNO.setText(str(query.value(5))) db.close()
def addmwID(self): try: self.mwID.clear() # 给mwID加上项目 db = openDB() query = QSqlQuery() productID = self.productID.currentText() # print(productID) mwid_list = ["该产品暂无相应的维保方式"] if not self.mwID.hasFocus(): sql = "SELECT MaintenanceWayID From MaintenanceWay where ProductID = '%s'" % ( productID) # print(sql) query.exec(sql) while query.next(): mwid_list.append(query.value(0)) # print(mwid_list) if len(mwid_list) > 1: mwid_list[0] = "" for i in mwid_list: self.mwID.addItem(i) # for i in range(1,len(mwid_list)): # self.mwID.addItem(str(mwid_list[i])) else: for i in mwid_list: self.mwID.addItem(i) except Exception as e: print(e)
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 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 setData(self, list): self.ID.setText(list[0]) self.productID.setText(list[1]) self.inStorageNo.setText(list[2]) self.inTechState.setText(list[4]) self.isUsed.setItemText(0, list[5]) self.createTime.setDateTime( datetime.strptime(list[7], "%Y-%m-%d %H:%M:%S")) self.createTime.setDisplayFormat("yyyy-MM-dd hh:mm:ss") self.updateID.setText(list[8]) self.updateTime.setDateTime( datetime.strptime(list[9], "%Y-%m-%d %H:%M:%S")) self.updateTime.setDisplayFormat("yyyy-MM-dd hh:mm:ss") self.remark.setText(list[10]) self.inCount.setRange(0, int(list[12])) self.inCount.setValue(int(list[12])) db = openDB() query = QSqlQuery() sql = "SELECT * FROM T_In_Base where ID=%s" % self.ID.text() query.exec(sql) if query.next(): self.inNO.setText(query.value(1)) self.outNO.setText(query.value(2)) self.inDate.setDate(datetime.strptime(query.value(3), "%Y-%m-%d")) self.inDate.setDisplayFormat("yyyy-MM-dd") self.inRecorderPerson.setText(query.value(4)) db.close()
def searchTableD(self, sql): """ hsj 根据条件查询信息,并返回界面 :param select_condition: 列名 :param content: 具体查询条件 :return: """ list = [] db = openDB() query = QSqlQuery() q = QSqlQuery() sql2 = "SELECT distinct ProductNO From T_Product_New" query.exec(sql2) while query.next(): ProductNO = query.value(0) sql3 = "select sum(InitCount) FROM T_Product_New %s ProductNO='%s' ORDER BY %s" % ( sql, ProductNO, self.tableKey) sql1 = "SELECT %s,(%s)sum From %s %s ProductNO='%s' ORDER BY %s" % ( self.slt, sql3, self.table, sql, ProductNO, self.tableKey) q.exec(sql1) while q.next(): list.append([str(q.value(i)) for i in range(5)]) self.searchRefreshPage(list) self.update()
def updateData(self, list, queryModel): """ 修改入库信息 :param list: :return: """ self.productID.addItem(list[1]) # 获取所有的productID AddInStorage.get_product_NO(self) self.inStorageNo.setText(list[2]) self.inTechState.setText(list[4]) self.isUsed.setItemText(0, list[5]) self.updateID.setText(getCurrentUserId()) self.createTime.setDateTime( datetime.strptime(list[7], "%Y-%m-%d %H:%M:%S")) self.createTime.setDisplayFormat("yyyy-MM-dd hh:mm:ss") self.updateTime.setDateTime(QDateTime.currentDateTime()) self.updateTime.setDisplayFormat("yyyy-MM-dd hh:mm:ss") self.remark.setText(list[10]) self.inNO.setText(str(list[11])) global in_count in_count = int(list[12]) self.inCount.setRange(0, in_count) self.inCount.setValue(in_count) db = openDB() query = QSqlQuery() sql = "SELECT * FROM T_In_Base where InNO='%s'" % self.inNO.text() query.exec(sql) if query.next(): self.outNO.setText(query.value(2)) self.inDate.setDateTime( datetime.strptime(query.value(3), "%Y-%m-%d")) self.inDate.setDisplayFormat("yyyy-MM-dd") self.inRecorderPerson.setText(query.value(4)) db.close()
def get_product_NO(self): db = openDB() q = QSqlQuery() sql = "SELECT ProductID FROM T_Product_New" q.exec(sql) while q.next(): self.productID.addItem(str(q.value(0))) db.close()
def get_product_NO(self): db = openDB() q = QSqlQuery() sql = "SELECT ProductID FROM T_Out_Detail where IsReturn='否'" q.exec(sql) while q.next(): self.productID.addItem(str(q.value(0))) db.close()
def insert_info(userId): db = openDB() query = QSqlQuery() LoginTime = time.strftime("%Y-%m-%d %H:%M:%S") insert_sql = "INSERT INTO Login_info (id,userId,loginTime,isLogining) VALUES (NULL,'%s', '%s','%s')"% \ (userId, LoginTime, True) query.exec(insert_sql) db.commit() db.close()
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 getResolveMethod(self): db = openDB() query = QSqlQuery() sql = "SELECT Content FROM T_Knowladge_Base_Mangement WHERE Num = '%s' " % ( self.result_list[1]) query.exec(sql) if query.next(): self.result_list[1] = query.value(0) else: self.result_list[1] = "知识库ID对应的数据不存在"
def getData(self): """ 获取所有数据 :return: """ results = [] sql = "SELECT * FROM %s ORDER BY %s" % (self.table, self.tableKey) db = openDB() query = QSqlQuery() if self.table == "T_Product_New": sql = "SELECT ProductID, ProductName, ProductNO, BatchNO, Count, ReceiverDate, Receiver, ReceiverCompany, RegisterDate, Registerer, RegisterCompany FROM %s ORDER BY %s" % ( self.table, self.tableKey) # print(sql) elif self.table == "T_ProductComponent_New": sql = "SELECT ComponentID, ProductID, ComponentNO, ComponentName, FatherID, ComponentType, Count FROM %s ORDER BY %s" % ( self.table, self.tableKey) elif self.table == "T_Out_Detail": sql = "SELECT T_Out_Detail.OutNO,ProductID,OutStorageNO,OutDate," \ "OutCount,RecorderID,UsedID,UsedDepartmentID FROM T_Out_Detail,T_Out_Base " \ "WHERE T_Out_Base.ID=T_Out_Detail.ID ORDER BY T_Out_Detail.ID " elif self.table == "T_In_Detail": sql = "SELECT T_In_Detail.InNO,ProductID,InStorageNO,InDate,InCount," \ "InRecoder,OutNO FROM T_In_Detail,T_In_Base WHERE T_In_Detail.ID=T_In_Base.ID " \ "ORDER BY T_In_Detail.ID " elif self.table == "T_Diagnose": sql = "SELECT FaultID, FaultName, ProductName, AnswerCount, KnowledgeID FROM %s ORDER BY %s" % ( self.table, self.tableKey) elif self.table == 'MaintenanceRecord': sql = 'SELECT MrID,ProductID,ProductName,MwID, MwName, MrTime, MrPart, ' \ 'MrLead, MrResult, Remark FROM %s ORDER BY %s' % (self.table, self.tableKey) elif self.table == 'MaintenanceWay': sql = 'SELECT MaintenanceWayID,MaintenanceWayName, ProductID, ProductName,ProductNO,Interva,AlterRule,RecentTime FROM %s ORDER BY %s' % ( self.table, self.tableKey) elif self.table == 'T_Knowladge_Base_Mangement': sql = "SELECT Num,Title, Source, Publisher, Rtime, Etime, Readrange, Content FROM %s ORDER BY %s" % ( self.table, self.tableKey) # elif self.table == "T_Product_BatchDetail": # sql = "SELECT BatchNO, ProductNO, DeliverDate, DeliverCompanyName, Deliverer, ReceiveCompanyName, Receiver, Remark, Document FROM %s ORDER BY %s" % (self.table, self.tableKey) # # print(sql) # elif self.table == "T_Product": # sql = "SELECT ProductNO, Life, StartDate, DaysBefore, IsUsedCountLimit, MaxUsedCount, HaveUsedCount, Remark FROM %s ORDER BY %s" % (self.table, self.tableKey) # # print(sql) # elif self.table == "T_Product_Component": # sql = "SELECT ID, ProductNO, ComponentName, ComponentTypeID, ParentID, IsLifeRemind, Life, StartDate, DaysBefore, IsUsedCountLimit, MaxUsedCount, HaveUsedCount, Remark FROM %s ORDER BY %s" % (self.table, self.tableKey) # # self.tableLength = 8 # # print(sql) a = query.exec(sql) # print('a', a) while (query.next()): results.append([query.value(i) for i in range(self.tableLength)]) # print(results) return results
def getTreeData(productID, fatherID='无父组件'): db = openDB() query = QSqlQuery() sql = "Select ComponentID, ComponentName, ComponentType, Count From T_ProductComponent_New Where ProductID = '%s' and FatherID = '%s'" % ( productID, fatherID) # sql = "Select * From T_ProductComponent_New" # print(sql) query.exec(sql) list = [] while (query.next()): list.append([query.value(i) for i in range(4)]) return list
def getProductCount(productID): db = openDB() query = QSqlQuery() sql = "Select InitCount From T_Product_New Where ProductID = '%s'" % ( productID) # sql = "Select * From T_ProductComponent_New" # print(sql) query.exec(sql) result = 0 if query.next(): result = query.value(0) return result
def checkOn(self, productNO): """ 检查产品号是否合理 :return: """ self.db = openDB() self.query = QSqlQuery() sql = "SELECT * FROM T_Product WHERE ProductNO = '%s'" % productNO self.query.exec(sql) if self.query.next(): print(QMessageBox.information(QDialog(), "提示", "产品已存在,请更换后重试!", QMessageBox.Yes, QMessageBox.Yes)) return 0 return 1
def getCurrentUserId(): db = openDB() query = QSqlQuery() search_sql = "SELECT * FROM Login_info WHERE isLogining='%s'" % True query.exec_(search_sql) if (query.next()): userid = query.value(1) db.commit() db.close() else: userid = -1 return str(userid)
def update_currentLoginState(): db = openDB() query = QSqlQuery() search_sql = "SELECT * FROM Login_info WHERE isLogining ='%s'" % True query.exec_(search_sql) if (query.next()): thisId = query.value(0) update_sql = "UPDATE Login_info SET isLogining = '%s' WHERE id='%s'" % ( False, thisId) query.exec_(update_sql) db.commit() db.close()
def getMwID(self): max_no = '' db = openDB() q = QSqlQuery() date_str = QDate.currentDate().toString("yyyyMMdd") sql = "SELECT MaintenanceWayID FROM MaintenanceWay WHERE ID=(SELECT MAX(ID) FROM MaintenanceWay)" if q.exec(sql): while q.next(): max_no = q.value(0) db.close() if date_str > max_no[1:9]: return 'W' + date_str + '001' else: return 'W' + str(int(max_no[1:]) + 1)
def delelteExactID(self,id): """ 李振 :return: """ db = openDB() query = QSqlQuery() #print("这里执行了:") for i, isSelected in enumerate(self.checkList): if isSelected == "Checked": sql = "DELETE FROM MaintenanceWay WHERE ProductID = '%s'" % id query.exec(sql) db.commit() self.refreshPage()
def getOutNO(self): max_no = '' db = openDB() q = QSqlQuery() date_str = QDate.currentDate().toString("yyyyMMdd") sql = "SELECT OutNO FROM T_Out_Base WHERE ID=(SELECT MAX(ID) FROM T_Out_Base)" if q.exec(sql): while q.next(): max_no = q.value(0) db.close() if date_str > max_no[1:9]: return 'C' + date_str + '001' else: return 'C' + str(int(max_no[1:]) + 1)
def getComponentID(self): max_no = '' db = openDB() q = QSqlQuery() date_str = QDate.currentDate().toString("yyyyMMdd") sql = "SELECT ComponentID FROM T_ProductComponent_New WHERE ID=(SELECT MAX(ID) FROM T_ProductComponent_New)" if q.exec(sql): while q.next(): max_no = q.value(0) db.close() if date_str > max_no[1:9]: return 'Z' + date_str + '001' else: return 'Z' + str(int(max_no[1:]) + 1)
def checkOn(self, mrID): """ 检查产品号是否合理 :return: """ self.db = openDB() self.query = QSqlQuery() sql = "SELECT * FROM MaintenanceRecord WHERE mrID = '%s'" % mrID self.query.exec(sql) if self.query.next(): print( QMessageBox.information(QDialog(), "提示", "维保方式记录已存在,请更换后重试!", QMessageBox.Yes, QMessageBox.Yes)) return 0 return 1
def answerCountEvent(self): try: db = openDB() query = QSqlQuery() if self.answerCount.hasFocus(): sql = "SELECT Question, Answer From T_Diagnose WHERE AnswerCount = '%s' AND ProductName = '%s'" % (self.answerCount.text(), self.productName.text()) query.exec(sql) if query.next(): question = query.value(0) answer = query.value(1) # self.productName.setText(productname) self.question.setText(question) self.answer.setText(answer[:-1]) except Exception as e: print(e)
def get_count(self): global count db = openDB() q = QSqlQuery() sql = "SELECT Count FROM T_Product_New where productID='%s'" % self.productID.currentText( ) q.exec(sql) if q.next(): count = int(q.value(0)) self.outCount.setValue(count) self.outCount.setRange(0, count) else: QMessageBox.information(QDialog(), "错误", "产品编号输入错误,请重新输入", QMessageBox.Yes, QMessageBox.Yes) db.close()
def deleteMR(self): """ 李振 :return: """ db = openDB() query = QSqlQuery() print("这里执行了:") for i, isSelected in enumerate(self.checkList): if isSelected == "Checked": sql = "DELETE FROM MaintenanceRecord WHERE MrID = '%s'" % ( self.data_list[i][0]) query.exec(sql) db.commit() self.refreshPage()
def getOutNO(self): global out_no db = openDB() q = QSqlQuery() if self.productID.hasFocus(): product_no = self.productID.currentText() sql_code = "SELECT OutNO FROM T_Out_Detail WHERE ProductID='%s' AND IsReturn='否'" % product_no q.exec(sql_code) if q.next(): out_no = q.value(0) self.outNO.setText(out_no) else: QMessageBox.information(QDialog(), "错误", "产品编号输入错误,请重新输入", QMessageBox.Yes, QMessageBox.Yes) db.close()
def delOverOneMonthItem(): db = openDB() query = QSqlQuery() #获取前一个月的时间 struct_time = (time.localtime().tm_year, time.localtime().tm_mon - 1, time.localtime().tm_mday, time.localtime().tm_hour, time.localtime().tm_min, time.localtime().tm_sec, time.localtime().tm_wday, time.localtime().tm_yday, time.localtime().tm_isdst) OneMonthAgo = time.strftime("%Y-%m-%d %H:%M:%S", struct_time) delete_sql = "DELETE FROM Login_info WHERE loginTime < '%s'" % OneMonthAgo query.exec_(delete_sql) db.commit() db.close()