def StockSearch(self):
table = self.stockSearch.tableWidget
ID = self.stockSearch.WareID_LineEdit.text()
search_sql = """
SELECT * FROM WARE_DATA
WHERE WARE_ID = %s
"""
db = function.connect_database()
cursor = db.cursor()
while True:
try:
cursor.execute(search_sql, ID)
except Exception as e:
print(e)
db.rollback()
break
else:
data = cursor.fetchone()
if data == None:
self.stockSearch.WareID_LineEdit.clear()
break
else:
self.stockDia.show()
self.stockDia.WareName.setText(str(data[0]))
self.stockDia.WareID.setText(str(data[1]))
self.stockDia.Stock.setText(str(data[3]))
break
cursor.close()
db.close()
'''
def SaleRegister_Action(self):
sale_data = []
# 对从qt中收到的datetime数据进行转换，以适应数据库格式要求
datetime = self.saleRegister.dateEdit.text().split(' ')[0].replace(
'/', '')
sale_data.append(datetime)
sale_data.append(self.saleRegister.WareID_LineEdit.text())
sale_data.append(self.saleRegister.Quantity_SpinBox.text())
insert_sql = """
INSERT INTO sale_data
(date_time, ware_id, quantity)
VALUES(%s,%s,%s)
"""
db = function.connect_database()
cursor = db.cursor()
if function.ware_id_check(sale_data[1]) != 1:
self.errorDia.ErrorMessage.setText("商品代码不存在！请修改商品代码")
self.errorDia.show()
elif function.stock_update(sale_data[1], int(-1), int(
sale_data[2])) != 1:
self.errorDia.ErrorMessage.setText("采购后库存大于上限,请修改采购量!")
self.errorDia.show()
else:
try:
cursor.execute(insert_sql, sale_data)
except Exception as e:
self.errorDia.ErrorMessage.setText(str(e))
self.errorDia.show()
db.rollback()
else:
db.commit()
self.saleRegister.close()
def LoginCheck(self):
# 检查登录信息
user_name = self.login.Login_LineEdit_UserName.text()
password = self.login.Login_LineEdit_Password.text()
db = function.connect_database()
cursor = db.cursor()
check_sql = 'SELECT PASSWORD FROM ADMIN WHERE ID=%s'
row = cursor.execute(check_sql, user_name)
result = cursor.fetchone()
if row == 0:
self.errorDia.ErrorMessage.setText("账号不存在，请联系管理员")
self.errorDia.show()
elif str(result[0]) != str(password):
self.errorDia.ErrorMessage.setText("密码错误，重新输入")
self.errorDia.show()
else:
self.menu.show()
self.login.close()
def Register_Action(self):
ware_data = []
ware_data.append(self.wareRegister.Name_LineEdit.text())
ware_data.append(int(self.wareRegister.ID_LineEdit.text()))
ware_data.append(int(self.wareRegister.Format_LineEdit.text()))
ware_data.append(int(self.wareRegister.Quantity_SpinBox.text()))
ware_data.append(int(self.wareRegister.PurchasePrice_LineEdit.text()))
ware_data.append(int(self.wareRegister.SellPrice_LineEdit.text()))
ware_data.append(int(self.wareRegister.MaxStock_SpinBox.text()))
ware_data.append(int(self.wareRegister.MinStock_SpinBox.text()))
insert_sql = """
INSERT INTO ware_data
(name, ware_id, format, quantity, purchase_price, sell_price, max_stock, min_stock)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s)
"""
stock_sql = """
INSERT INTO stock_data
(ware_id, amount)
VALUES(%s,0)
"""
db = function.connect_database()
cursor = db.cursor()
while True:
try:
cursor.execute(insert_sql, ware_data)
cursor.execute(stock_sql, ware_data[1])
except Exception as e:
print(e)
db.rollback()
self.Register_DataClear()
# self.registerError.show()
break
else:
db.commit()
break
cursor.close()
db.close()
self.wareRegister.close()
'''
def SaleSearch(self):
table = self.saleSearch.tableWidget
startTime = self.saleSearch.StartTime_DateEdit.date().toString(
'yyyy-mm-dd')
endTime = self.saleSearch.EndTime_DateEdit.date().toString(
'yyyy-mm-dd')
db = function.connect_database()
cursor = db.cursor()
sql = '''
SELECT * FROM SALE_DATA
WHERE DATE_TIME > %s AND DATE_TIME < %s
'''
cursor.execute(sql, (startTime, endTime))
results = cursor.fetchall()
for i in results:
row = table.rowCount()
table.setRowCount(row + 1)
date = i[0].strftime("%Y-%m-%d")
table.setItem(row, 0, QTableWidgetItem(str(i[1])))
table.setItem(row, 1, QTableWidgetItem(date))
table.setItem(row, 2, QTableWidgetItem(str(i[2])))
table.setItem(row, 3, QTableWidgetItem(str(i[3])))