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()
