基于PysimpleGUI+pymysql建立的简单管理系统.zip

import pymysql import PySimpleGUI as sg import pandas as pd import os import time import threading import datetime conn = pymysql.connect(host="localhost", user="root", password="123456", db="user_information", charset="utf8") cursor = conn.cursor() sql ="select * from custome_information" cursor.execute(sql) result = cursor.fetchall() all = list(result) cursor.close() conn.close() layout = [[sg.Text("客户名 订单名 时间 材料 尺寸 数量 单价 金额")], [sg.Listbox(all, key='-TEXT-', select_mode='single',size=(80, 6))], [sg.Button('返回'),sg.Button('修改'),sg.Button('查找'),sg.Button('退出')]] window = sg.Window('修改客户账单', layout) while True: event, values = window.read() if event == sg.WINDOW_CLOSED or event == '退出': break if event == '返回': time.sleep(0.5) window.close() os.system('python menu.py') break if event == '修改': values = pd.DataFrame.from_dict(values,orient='index') str1 = str(values.iat[0,0]) custome_name = str1.split("\'")[1] order_name = str1.split("\'")[3] material = str1.split("\'")[5] size = str1.split("\'")[7] quantity = str1.split(",")[9] price = str1.split(",")[10] amount = str1.split(",")[11].strip(')') time.sleep(0.5) window.close() layout = [[sg.Text("请输入要修改的序号：")], [sg.Text("1.客户名 2.订单名 3.时间 4.材料 ")], [sg.Text("5.尺寸 6.数量 7.单价 8.金额 ")], [sg.Input(key='-INPUT-')], [sg.Button('确定'),sg.Button('返回')]] window = sg.Window('修改', layout) while True: event, values = window.read() if event == sg.WINDOW_CLOSED : break if event == '返回': time.sleep(0.5) window.close() os.system('python revise.py') break if event == '确定': values = pd.DataFrame([values]) if values.iat[0,0] == '': window.close() layout = [[sg.Text("填写为空！")], [sg.Button('返回')]] window = sg.Window('错误', layout) while True: event, values = window.read() if event == sg.WINDOW_CLOSED: break if event == '返回': time.sleep(0.5) window.close() os.system('python revise.py') break choice = int(values.iat[0,0]) time.sleep(0.5) window.close() if choice == 1: layout = [[sg.Text("请输入要修改的内容：")], [sg.Input(key='-INPUT-')], [sg.Button('确定'),sg.Button('返回')]] window = sg.Window('修改', layout) while True: event, values = window.read() if event == sg.WINDOW_CLOSED : break if event == '返回': time.sleep(0.5) window.close() os.system('python revise.py') break if event == '确定': values = pd.DataFrame([values]) content = str(values.iat[0,0]) cursor = conn.cursor() conn.ping(reconnect=True) thread_lock = threading.Lock() thread_lock.acquire() sql ="update custome_information set custome_name = '%s' where order_name = '%s' and material = '%s' and size = '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,order_name,material,size,quantity,price,amount) cursor.execute(sql) conn.commit() conn.close() thread_lock.release() time.sleep(0.5) window.close() os.system('python revise.py') break if choice == 2: layout = [[sg.Text("请输入要修改的内容：")], [sg.Input(key='-INPUT-')], [sg.Button('确定'),sg.Button('返回')]] window = sg.Window('修改', layout) while True: event, values = window.read() if event == sg.WINDOW_CLOSED : break if event == '返回': time.sleep(0.5) window.close() os.system('python revise.py') break if event == '确定': values = pd.DataFrame([values]) content = str(values.iat[0,0]) cursor = conn.cursor() conn.ping(reconnect=True) thread_lock = threading.Lock() thread_lock.acquire() sql ="update custome_information set order_name = '%s' where custome_name = '%s' and material = '%s' and size = '%s' and quantity = '%s' and price = '%s' and amount = '%s'" %(content,custome_name,material,size,quantity,price,amount) cursor.execute(sql) conn.commit() conn.close() thread_lock.release() time.sleep(0.5) window.close() os.system('python revise.py') break if choice == 3: layout = [[sg.Text("请输入要修改的内容：(年.月.日)")], [sg.Input(key='-INPUT-')], [sg.Button('确定'),sg.Button('返回')]] window = sg.Window('修改', layout) while True: event, values = window.read() if event == sg.WINDOW_CLOSED : break if event == '返回': time.sleep(0.5) window.close() os.system('python revise.py') break if event == '确定': values = pd.DataFrame([values]) content = str(values.iat[0,0]) format_str = '%Y.%m.%d' content = datetime.datetime.strptime(content, format_str) cursor = conn.cursor() conn.ping(reconnect=True) thread_lock = threading.Lock() thread_lock.acquire() sql ="update custome_information set time = '%s' where custome_name = '%s'and order_name = '%s' and material = '%s' and size = '%s' and quantity = '%s' and price