2022年 11月 7日

python实现商品进销存管理系统

python实现商品进销存管理系统，基于python，MySQL，tkinter

  1.  
  2. import pymysql #导入数据库模块
  3. import tkinter #导入相关的窗体模块
  4. import os #利用os模块可以方便定义完整路径
  5. import  tkinter.messagebox#实现提示框的组件
  6. import  tkinter.simpledialog#简单对话框
  7. from wordcloud import WordCloud
  8. import matplotlib.pyplot as plt
  9. import threading
  10. import pandas as pd  #对数据进行访问
  11. import  sys  #与操作系统交互
  12. def get_resources_path(relative_path):#利用此函数实现资源路径的定位
  13.     if getattr(sys,"frozen",False):
  14.         base_path=sys._MEIPASS #获取临时资源
  15.     else:
  16.         base_path=os.path.abspath(".") #获取当前路径
  17.     return os.path.join(base_path,relative_path)  #获得绝对路径
  18. LOGO_PATH=get_resources_path(os.path.join("resources",'shop_logo.ico'))  #'resources'+os.sep + 'shop_logo.ico'#logo文件路径
  19. IMAGES_PATH=get_resources_path(os.path.join("resources",'background.png'))#'resources' +os.sep+ 'background.png'#图像文件路径
  20. Warehouse_PATH=get_resources_path(os.path.join("resources",'店铺.png'))#'resources' +os.sep+ '店铺.png'#图像文件路径
  21. COMMODITY_DELETE_PATH=get_resources_path(os.path.join("resources",'店铺修改背景图.png'))#'resources' +os.sep+ '店铺修改背景图.png'#图像文件路径
  22. WORDCLOUD_PATH='词云图.png'
  23. EXCEL_COMMODITY=get_resources_path(os.path.join("resources",'商品数据.xlsx'))#'resources'+ os.sep + '商品数据.xlsx'#商品数据的路径
  24. EXCEL_STORE=get_resources_path(os.path.join("resources",'店铺.xlsx'))#'resources'+ os.sep + '店铺.xlsx'#店铺数据的路径
  25. EXCEL_WAREHOUSE=get_resources_path(os.path.join("resources",'库房.xlsx'))#'resources'+ os.sep + '库房.xlsx'#库房数据的路径
  26. EXCEL_CUSTOMER=get_resources_path(os.path.join("resources",'顾客数据.xlsx'))#'resources'+ os.sep + '顾客数据.xlsx'#顾客数据的路径
  27. class MainForm: #定义窗体类,父类
  28.     def __init__(self):#构造窗体
  29.         self.root=tkinter.Tk()#创建一个窗体
  30.         self.root.title("露露小卖店")#设置标题
  31.         self.root.iconbitmap(LOGO_PATH)#设置logo资源
  32.         self.root.geometry('680x500+150+50')#初始化窗口大小
  33.         self.root.resizable(False,False) #固定窗口大小
  34.     def worcloud_s(self,text):    #生产词云图片
  35.         wc= WordCloud(
  36.             collocations=False,
  37.             font_path=r"C:/Windows/Fonts/simfang.ttf",
  38.             background_color="black",
  39.             width=600,
  40.             height=300,
  41.             max_words=50).generate(text)
  42.         wc.to_image()
  43.         wc.to_file("词云图.png")
  44. class The_login(MainForm):  #登录窗口
  45.     def __init__(self):
  46.         super().__init__()
  47.         photo = tkinter.PhotoImage(file=IMAGES_PATH)  # 设置图像资源
  48.         tkinter.Label(self.root, image=photo,width=680,height=500).place(x=0,y=0)
  49.         tkinter.Label(self.root, text="用户名", font=("黑体", 20)).place(x=150,y=200)
  50.         self.entry1 = tkinter.Entry(self.root,font=("黑体", 20))
  51.         self.entry1.place(x=300,y=200)
  52.         tkinter.Label(self.root, text="密码", font=("黑体", 20)).place(x=150,y=250)
  53.         self.entry2 = tkinter.Entry(self.root,font=("黑体", 20),show="*")
  54.         self.entry2.place(x=300,y=250)
  55.         tkinter.Button(self.root, text="店铺登录",command=self.bidui, width=15, font=("微软雅黑", 10)).place(x=150,y=300)
  56.         tkinter.Button(self.root, text="退出", command=self.root.quit, width=15, font=("微软雅黑", 10)).place(x=450, y=300)
  57.         tkinter.Button(self.root, text="导入店铺信息", command=self.store_in, width=10, font=("微软雅黑", 10)).place(x=550, y=450)
  58.         tkinter.Button(self.root, text="店铺注册", command=self.Registered, width=10, font=("微软雅黑", 10)).place(x=0, y=450)
  59.         self.root1=self.root.mainloop()
  60.       #对用户账号，密码进行查询，比对
  61.     def bidui(self):
  62.         global global_id
  63.         def find_store():#查找店铺账号和密码数据
  64.             cursor=conn.cursor()
  65.             sql='select * from store where store_id="%s" and store_password="%s"'%(self.entry1.get(),self.entry2.get())
  66.             cursor.execute(sql)
  67.             conn.commit()
  68.             cursor.close()
  69.             return cursor.fetchone()
  70.         try :
  71.             if bool(find_store())==1:
  72.                 print("登录成功")
  73.                 global_id=self.entry1.get()
  74.                 self.root.destroy()
  75.                 The_store()
  76.             else:
  77.                 labell = tkinter.Label(self.root, text='登陆失败！', font=("黑体", 10))  ##
  78.                 labell.place(x=300, y=0)
  79.         except:
  80.             pass
  81.     def store_in(self):
  82.         def remove_store_all():  # 清除店铺中的数据表数据
  83.             cursor = conn.cursor()  # 创建游标
  84.             cursor.execute('delete from store')
  85.             conn.commit()  # 提交
  86.             cursor.close()  # 关闭游标
  87.         def store_Add():  # 向店铺的表中导入数据
  88.             cursor = conn.cursor()  # 创建游标
  89.             for co in range(len(df["店铺账号"])-1):
  90.                 print(co)
  91.                 try:
  92.                     sql = 'insert into store values (%s,%s,%s,%s,%s,%s,%s);'  # 添加数据
  93.                     cursor.execute(sql,(
  94.                         df["店铺账号"][co],
  95.                         df["店铺密码"][co],
  96.                         df["店铺名称"][co],
  97.                         df["店铺地址"][co],
  98.                         df["店铺电话"][co],
  99.                         df["店主"][co],
  100.                         df["盈亏"][co]))  # 执行添加数据
  101.                     conn.commit()  # 提交
  102.                 except:
  103.                     print(df["店铺名称"][co])
  104.             cursor.close()  # 关闭游
  105.         df = pd.read_excel(EXCEL_STORE)
  106.         remove_store_all()
  107.         store_Add()
  108.         #——————————————————————-——————————店铺注册------------------------------
  109.     def Registered(self):  #店铺注册信息
  110.         def remove_prompt():  # 清空提示信息
  111.             Entry_prompt.delete(0.0, tkinter.END)
  112.             Entry_prompt.update()
  113.             Entry_prompt.insert(tkinter.INSERT,"———————————店铺注册——————————")
  114.         def store_add():#添加店铺信息
  115.             if Entry_user.get()=='':  #用户名不能为空
  116.                 remove_prompt()
  117.                 Entry_prompt.insert(tkinter.INSERT, "用户名输入为空\n")
  118.             elif Entry_password.get()=='': #密码不能为空
  119.                 remove_prompt()
  120.                 Entry_prompt.insert(tkinter.INSERT, "密码输入为空\n")
  121.             elif Entry_name.get() == '':  # 名称不能为空
  122.                 remove_prompt()
  123.                 Entry_prompt.insert(tkinter.INSERT, "店铺名称输入为空\n")
  124.             elif Entry_address.get() == '':  # 地址不能为空
  125.                 remove_prompt()
  126.                 Entry_prompt.insert(tkinter.INSERT, "店铺地址输入为空\n")
  127.             elif Entry_phon.get() == '':  # 电话不能为空
  128.                 remove_prompt()
  129.                 Entry_prompt.insert(tkinter.INSERT, "店铺电话输入为空\n")
  130.             elif Entry_master.get() == '':  # 店主不能为空
  131.                 remove_prompt()
  132.                 Entry_prompt.insert(tkinter.INSERT, "店主输入为空\n")
  133.             else:
  134.                 remove_prompt()
  135.                 cursor = conn.cursor()  # 创建游标
  136.                 try:
  137.                     sql = 'insert into store values (%s,%s,%s,%s,%s,%s,%s);'  # 添加数据
  138.                     cursor.execute(sql, (
  139.                         Entry_user.get(),  #账号
  140.                         Entry_password.get(),#密码
  141.                         Entry_name.get(),#名称
  142.                         Entry_address.get(),#地址
  143.                         Entry_phon.get(),#电话
  144.                         Entry_master.get(),#店主
  145.                         0       )#盈亏
  146.                                    )  # 执行添加数据
  147.                     conn.commit()  # 提交
  148.                     cursor.execute('select * from store where store_id="%s";'%(Entry_user.get()))
  149.                     conn.commit()
  150.                     Entry_prompt.insert(tkinter.INSERT, "店铺注册成功\n")
  151.                     Entry_prompt.insert(tkinter.INSERT, cursor.fetchall())
  152.                 except:
  153.                     Entry_prompt.insert(tkinter.INSERT, "店铺账号已存在，请从新输入：\n")
  154.                 cursor.close()  # 关闭游
  155.         root=tkinter.Toplevel()   #创建一个附属窗口
  156.         root.title("露露小卖店")   #标题
  157.         root.iconbitmap(LOGO_PATH)  # 设置logo资源
  158.         root.geometry('380x400+150+50')  # 初始化窗口大小
  159.         root.resizable(False, False)  # 固定窗口大小
  160.         tkinter.Button(root,text="确认添加",command=store_add,font=("微软雅黑", 10)).place(x=30,y=360)
  161.         tkinter.Button(root, text="退出", command=root.destroy, font=("微软雅黑", 10)).place(x=320, y=360)
  162.        #店铺账号	店铺密码	店铺名称	店铺地址	店铺电话	店主
  163.         tkinter.Label(root,text="店铺账号",font=("微软雅黑", 10)).place(x=60,y=120)
  164.         tkinter.Label(root, text="店铺密码", font=("微软雅黑", 10)).place(x=60, y=160)
  165.         tkinter.Label(root, text="店铺名称", font=("微软雅黑", 10)).place(x=60, y=200)
  166.         tkinter.Label(root, text="店铺地址", font=("微软雅黑", 10)).place(x=60, y=240)
  167.         tkinter.Label(root, text="店铺电话", font=("微软雅黑", 10)).place(x=60, y=280)
  168.         tkinter.Label(root, text="店    主", font=("微软雅黑", 10)).place(x=60, y=320)
  169.         Entry_prompt = tkinter.Text(root, width=44,height=5,font=("微软雅黑", 10))
  170.         Entry_prompt.place(x=12, y=10)
  171.         Entry_user=tkinter.Entry(root,font=("微软雅黑", 10))
  172.         Entry_user.place(x=120,y=120)
  173.         Entry_password = tkinter.Entry(root, font=("微软雅黑", 10))
  174.         Entry_password.place(x=120, y=160)
  175.         Entry_name = tkinter.Entry(root, font=("微软雅黑", 10))
  176.         Entry_name.place(x=120, y=200)
  177.         Entry_address = tkinter.Entry(root, font=("微软雅黑", 10))
  178.         Entry_address.place(x=120, y=240)
  179.         Entry_phon = tkinter.Entry(root, font=("微软雅黑", 10))
  180.         Entry_phon.place(x=120, y=280)
  181.         Entry_master = tkinter.Entry(root, font=("微软雅黑", 10))
  182.         Entry_master.place(x=120, y=320)
  183.         remove_prompt()
  184. class The_store(MainForm):#主页面设置
  185.     def __init__(self):
  186.         super().__init__()
  187.         self.Label=tkinter.Label(self.root,text="欢迎光临露露小卖店",bg='#233233',width=32,height=10,
  188.                                      fg='#ffffff',font=("黑体",30))
  189.         self.Label.place(x=20,y=0)
  190.         self.button1 = tkinter.Button(self.root, text="初始化", command=self.Ininia, height=3, width=10).place(x=0,y=430)
  191.         self.button2 = tkinter.Button(self.root, text="商品", command=self.Commodity_switch, height=3, width=10).place(x=150,y=430)
  192.         self.button3 = tkinter.Button(self.root, text="店铺", command=self.Shop_switch, height=3, width=10).place(x=300,y=430)
  193.         self.button4 = tkinter.Button(self.root, text="库房", command=self.Warehouse_switch, height=3, width=10).place(x=450,y=430)
  194.         self.button1 = tkinter.Button(self.root, text="退出", command=quit, height=3, width=10).place(x=600,y=430)
  195.         self.root.mainloop()
  196.     def  Commodity_switch(self):  #商品
  197.         self.root.destroy()  #关闭主界面
  198.         Commodity_From()   #进入商品界面
  199.     def Shop_switch(self):   #店铺
  200.         self.root.destroy()  # 关闭主界面
  201.         Shop_From()
  202.     def Warehouse_switch(self):  #库房
  203.         self.root.destroy()  # 关闭主界面
  204.         Warehouse()
  205.     def Ininia(self):   #具体初始化
  206.         self.Label.place_forget()
  207.         text=tkinter.Text(self.root,width=80,height=20,font=('微软雅黑', 10))
  208.         scroll = tkinter.Scrollbar()
  209.         scroll.pack(side=tkinter.RIGHT, fill=tkinter.Y)
  210.         text.place(x=20, y=20)
  211.         scroll.config(command=text.yview)
  212.         text.config(yscrollcommand=scroll.set)
  213.         text.insert(tkinter.INSERT,"----------数据加载开始---------\n")
  214.         INn=Initialize()
  215.         def After_xx():
  216.             for i in INn.Accord():
  217.                text.insert(tkinter.INSERT,i)
  218.                text.insert(tkinter.INSERT, '\n')
  219.             text.insert(tkinter.END,"数据加载完毕")
  220.         self.root.after(100,After_xx())
  221. class Initialize:  #对数据库进行初始化
  222.     def __init__(self):
  223.         self.df_commodity=pd.read_excel(EXCEL_COMMODITY)
  224.         self.df_warehouse = pd.read_excel(EXCEL_WAREHOUSE)
  225.         self.df_customer = pd.read_excel(EXCEL_CUSTOMER)
  226.         self.remove_all()
  227.         self.all_refresh()
  228.     def remove_all(self):  #清除数据表数据
  229.         cursor = conn.cursor()   #创建游标
  230.         cursor.execute('delete from commodity;')   #清除商品数据
  231.         cursor.execute('delete from warehouse;')       #清除库房信息
  232.         cursor.execute('delete from customer') #清除顾客信息
  233.         conn.commit()    #提交
  234.         cursor.close()  #关闭游标
  235.     def all_refresh(self):
  236.         def commodity_Add():#向商品commodity的表中导入数据'DW-1201090311','其它蔬菜',4,2,20210101,'2年',1,8
  237.             global global_id
  238.             cursor = conn.cursor()   #创建游标
  239.             for co in range(len(self.df_commodity["商品编码"])):
  240.                 try:
  241.                     sql = 'insert into commodity values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);'#添加数据
  242.                     cursor.execute(sql, (
  243.                     self.df_commodity["商品编码"][co],
  244.                     self.df_commodity["商品名称"][co],
  245.                     self.df_commodity["商品售价"][co],
  246.                     self.df_commodity["商品进价"][co],
  247.                     self.df_commodity["生产日期"][co],
  248.                     self.df_commodity["保质期"][co],
  249.                     self.df_commodity["商品规格"][co],
  250.                     self.df_commodity["销售数量"][co],
  251.                     global_id,
  252.                     self.df_commodity["库房编号"][co],
  253.                     None)
  254.                                    )  # 执行添加数据
  255.                 except:
  256.                     print(self.df_commodity["商品编码"][co])
  257.             conn.commit()  # 提交
  258.             cursor.close()  # 关闭游标
  259.         def warehouse_Add():#向库房的表中导入数据'DW-1201090311','其它蔬菜',4,2,20210101,'2年',1,8
  260.             global global_id
  261.             cursor = conn.cursor()   #创建游标
  262.             for co in range(len(self.df_warehouse["库房编号"])):
  263.                 try:
  264.                     sql = 'insert into warehouse values (%s,%s,%s,%s,%s,%s,%s);'#添加数据
  265.                     cursor.execute(sql, (
  266.                     self.df_warehouse["库房编号"][co],
  267.                     self.df_warehouse["库房密码"][co],
  268.                     self.df_warehouse["库房名称"][co],
  269.                     self.df_warehouse["库房地址"][co],
  270.                     self.df_warehouse["库房电话"][co],
  271.                     self.df_warehouse["库房管理人"][co],
  272.                     global_id     )
  273.                                    )  # 执行添加数据
  274.                 except:
  275.                     print(self.df_warehouse["库房编号"][co])
  276.             conn.commit()  # 提交
  277.             cursor.close()  # 关闭游标
  278.         def customer_Add():#向顾客的表中导入数据
  279.             global global_id
  280.             def go_shopping():  #查看购物情况
  281.                 sql=' select sum(commodity_amount) from commodity GROUP BY customer_id;'
  282.                 cursor.execute(sql)
  283.                 conn.commit()
  284.                 return  cursor.fetchall()
  285.             cursor = conn.cursor()  # 创建游标
  286.             for co in range(len(self.df_customer["用户账号"])):
  287.                 try:
  288.                     sql = 'insert into customer values (%s,%s,%s,%s,%s,%s);'#添加数据
  289.                     cursor.execute(sql, (
  290.                     self.df_customer["用户账号"][co],
  291.                     self.df_customer["密码"][co],
  292.                     self.df_customer["用户名"][co],
  293.                     self.df_customer["电话"][co],
  294.                     go_shopping(),
  295.                     global_id  )
  296.                                    )  # 执行添加数据
  297.                 except:
  298.                     print(self.df_customer["用户账号"][co])
  299.             conn.commit()  # 提交
  300.             cursor.close()  # 关闭游标
  301.         commodity_Add()
  302.         warehouse_Add()
  303.         customer_Add()
  304.     def Accord(self):
  305.         cursor = conn.cursor()  #创建游标
  306.         a=[]
  307.         for co1 in range(len(self.df_commodity["商品编码"])):
  308.             try:
  309.                 sql='select * from commodity where commodity_id="%s"'%(self.df_commodity["商品编码"][co1])
  310.                 cursor.execute(sql)
  311.                 a.append(cursor.fetchall())   #结果导出
  312.             except:
  313.                 continue
  314.         for co2 in range(len(self.df_warehouse["库房编号"])):
  315.             try:
  316.                 sql='select * from warehouse where warehouse_id="%s"'%(self.df_warehouse["库房编号"][co2])
  317.                 cursor.execute(sql)
  318.                 a.append(cursor.fetchall())   #结果导出
  319.             except:
  320.                 continue
  321.         for co in range(len(self.df_customer["用户账号"])):
  322.             try:
  323.                 sql='select * from customer where customer_id="%s"'%(self.df_customer["用户账号"][co])
  324.                 cursor.execute(sql)
  325.                 a.append(cursor.fetchall())   #结果导出
  326.             except:
  327.                 continue
  328.         conn.commit()        #提交
  329.         cursor.close()    #关闭游标
  330.         return a
  331. class Commodity_From(MainForm):  #商品界面设置
  332.     def __init__(self):
  333.         super().__init__()
  334.         self.Commodity_select_photo()
  335.         photo_word = tkinter.PhotoImage(file=WORDCLOUD_PATH)
  336.         tkinter.Label(self.root, image=photo_word, width=600, height=400).place(x=30, y=0)
  337.         tkinter.Label(self.root,text="------------你的年度销量---------",font=("微软雅黑", 20)).place(x=100,y=0)
  338.         self.button1 = tkinter.Button(self.root, text="增加", command=self.Commodity_add_s, height=3, width=10).place(x=0, y=430)
  339.         self.button2 = tkinter.Button(self.root, text="删除", command=self.Commodity_drop_s, height=3, width=10).place(x=150, y=430)
  340.         self.button3 = tkinter.Button(self.root, text="修改", command=self.Commodity_delente_s, height=3, width=10).place(x=300, y=430)
  341.         self.button4 = tkinter.Button(self.root, text="查询", command=self.Commodity_select_s, height=3, width=10).place(x=450, y=430)
  342.         self.button1 = tkinter.Button(self.root, text="返回", command=self.The_store_power, height=3, width=10).place(x=600, y=430)
  343.         self.root.mainloop()
  344.     def Commodity_add_s(self):#  进入增加界面
  345.         self.root.destroy()  # 关闭商品界面
  346.         Commodity_add()    #进入增加界面
  347.     def Commodity_drop_s(self):#进入删除界面
  348.         self.root.destroy()
  349.         Commodity_drop()
  350.     def Commodity_delente_s(self): #进去修改界面
  351.         self.root.destroy()
  352.         Commodity_delente()
  353.     def Commodity_select_s(self): #进入查询界面
  354.         self.root.destroy()
  355.         Commodity_select()
  356.     def The_store_power(self): #进入主界面
  357.         self.root.destroy()
  358.         The_store()
  359.     def Commodity_select_photo(self):#查询所有的商品信息commodity_name
  360.         global global_id
  361.         a=[]
  362.         cursor=conn.cursor()
  363.         sql='select commodity_name from commodity where store_id="%s"'%(global_id)
  364.         cursor.execute(sql)
  365.         conn.commit()
  366.         cursor.close()
  367.         for i in cursor.fetchall():
  368.             a.append(i[0])
  369.         self.worcloud_s(str(a))   #生成图片
  370. class Commodity_add(MainForm):# 商品类，，增删除，改，查
  371.     def __init__(self):
  372.         super().__init__()
  373.         tkinter.Label(self.root,text="增加商品信息",font=("微软雅黑", 20)).place(x=260,y=0)
  374.         tkinter.Label(self.root, text="商品编码", font=("微软雅黑", 10)).place(x=0,y=200)
  375.         self.entryss1 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  376.         self.entryss1.place(x=60,y=200)
  377.         tkinter.Label(self.root, text="商品名称", font=("微软雅黑", 10)).place(x=200,y=200)
  378.         self.entryss2 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  379.         self.entryss2.place(x=260,y=200)
  380.         self.Text_1 = tkinter.Text(self.root, height=6, width=80,font=("微软雅黑", 10))   #输出标注框
  381.         self.Text_1.place(x=20,y=50)
  382.         tkinter.Label(self.root, text="商品售价", font=("微软雅黑", 10)).place(x=0,y=270)
  383.         self.entryss3 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  384.         self.entryss3.place(x=60,y=270)
  385.         tkinter.Label(self.root, text="商品进价", font=("微软雅黑", 10)).place(x=0,y=350)
  386.         self.entryss4 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  387.         self.entryss4.place(x=60,y=350)
  388.         tkinter.Label(self.root, text="生产日期", font=("微软雅黑", 10)).place(x=200,y=270)
  389.         self.entryss5 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  390.         self.entryss5.place(x=260,y=270)
  391.         tkinter.Label(self.root, text="保质期", font=("微软雅黑", 10)).place(x=200,y=350)
  392.         self.entryss6 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  393.         self.entryss6.place(x=260,y=350)
  394.         tkinter.Label(self.root, text="商品规格", font=("微软雅黑", 10)).place(x=400,y=270)
  395.         self.entryss7 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  396.         self.entryss7.place(x=460,y=270)
  397.         tkinter.Label(self.root, text="销售数量", font=("微软雅黑", 10)).place(x=400,y=350)
  398.         self.entryss8 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  399.         self.entryss8.place(x=460,y=350)
  400.         tkinter.Label(self.root, text="仓库编号", font=("微软雅黑", 10)).place(x=400, y=200)
  401.         self.entryss9 = tkinter.Entry(self.root, font=("微软雅黑", 10))
  402.         self.entryss9.place(x=460, y=200)
  403.         tkinter.Button(self.root,text="确认添加",command=self.add_s,font=("微软雅黑", 15)).place(x=200,y=420)
  404.         tkinter.Button(self.root, text="取消   ", command=self.add_Cancel, font=("微软雅黑",15)).place(x=400,y=420)
  405.         tkinter.Button(self.root, text="返回主菜单", command=self.The_store_1, font=("微软雅黑", 15)).place(x=0, y=450)
  406.         tkinter.Button(self.root, text="返回     ", command=self.Commodity_From_1, font=("微软雅黑", 15)).place(x=600, y=450)
  407.         self.root.mainloop()
  408.     def The_store_1(self):#返回主菜单
  409.         self.root.destroy()
  410.         The_store()
  411.     def Commodity_From_1(self):    #返回商品菜单
  412.         self.root.destroy()
  413.         Commodity_From()
  414.     def drop_Text_1(self):#清除显示信息
  415.         self.Text_1.delete(0.0, tkinter.END)
  416.         self.Text_1.update()
  417.     def add_s(self):  #处理增加
  418.         global global_id
  419.         cursor = conn.cursor()  # 创建sql游标
  420.         if self.entryss1.get() =='':
  421.             self.drop_Text_1()
  422.             self.Text_1.insert(tkinter.INSERT,"你的商品编码输入为空")
  423.         elif self.entryss2.get() =='':
  424.             self.drop_Text_1()
  425.             self.Text_1.insert(tkinter.INSERT,"你的商品名称输入为空")
  426.         elif self.entryss3.get() == '':
  427.             self.drop_Text_1()
  428.             self.Text_1.insert(tkinter.INSERT, "你的商品售价输入为空")
  429.         elif self.entryss4.get() == '':
  430.             self.drop_Text_1()
  431.             self.Text_1.insert(tkinter.INSERT, "你的商品进价输入为空")
  432.         elif self.entryss5.get() == '':
  433.             self.drop_Text_1()
  434.             self.Text_1.insert(tkinter.INSERT, "你的生产日期输入为空")
  435.         elif self.entryss6.get() == '':
  436.             self.drop_Text_1()
  437.             self.Text_1.insert(tkinter.INSERT, "你的保质期输入为空")
  438.         elif self.entryss7.get() == '':
  439.             self.drop_Text_1()
  440.             self.Text_1.insert(tkinter.INSERT, "你的商品规格输入为空")
  441.         elif self.entryss8.get() == '':
  442.             self.drop_Text_1()
  443.             self.Text_1.insert(tkinter.INSERT, "你的销售数量输入为空")
  444.         elif self.entryss9.get() == '':
  445.             self.drop_Text_1()
  446.             self.Text_1.insert(tkinter.INSERT, "你的仓库编号输入为空")
  447.         else:
  448.             try:
  449.                 sql = "insert into commodity values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"  # 添加数据
  450.                 cursor.execute(sql,(
  451.                         self.entryss1.get(),  #商品编号
  452.                         self.entryss2.get(),  #商品名称
  453.                         self.entryss3.get(),  #商品售价
  454.                         self.entryss4.get(),  #商品进价
  455.                         self.entryss5.get(), #生产日期
  456.                         self.entryss6.get(),  #保质期
  457.                         self.entryss7.get(),  #商品规格
  458.                         self.entryss8.get(),  #销售数量
  459.                         global_id,           #店铺编号
  460.                         self.entryss9.get(),  #库房编号
  461.                         None                        #顾客编号为空
  462.                                             ))
  463.                 conn.commit()   #提交
  464.                 cursor.execute('select * from commodity where commodity_id="%s"' % (self.entryss1.get()))
  465.                 conn.commit()
  466.                 cursor.close()  #关闭游标
  467.                 self.drop_Text_1()
  468.                 self.Text_1.insert(tkinter.INSERT, "数据添加成功")
  469.                 self.Text_1.insert(tkinter.INSERT,cursor.fetchall())
  470.  
  471.             except:
  472.                 try:
  473.                     sql = 'select * from commodity where commodity_id="%s"' % (self.entryss1.get())
  474.                     cursor.execute(sql)
  475.                     conn.commit()
  476.                     self.drop_Text_1()
  477.                     self.Text_1.insert(tkinter.INSERT, "数据存在:")
  478.                     self.Text_1.insert(tkinter.INSERT, cursor.fetchall())
  479.                     cursor.close()
  480.                 except:
  481.                     self.drop_Text_1()
  482.                     self.Text_1.insert(tkinter.INSERT, "商品数据不符合类型，从新添加：")
  483.     def add_Cancel(self):   #取消输入的信息
  484.         self.entryss1.delete(0, tkinter.END)
  485.         self.entryss2.delete(0, tkinter.END)
  486.         self.entryss3.delete(0, tkinter.END)
  487.         self.entryss4.delete(0, tkinter.END)
  488.         self.entryss5.delete(0, tkinter.END)
  489.         self.entryss6.delete(0, tkinter.END)
  490.         self.entryss7.delete(0, tkinter.END)
  491.         self.entryss8.delete(0, tkinter.END)
  492.         self.entryss9.delete(0, tkinter.END)
  493.         self.Text_1.delete(0.0, tkinter.END)
  494.         self.entryss1.update()
  495.         self.entryss2.update()
  496.         self.entryss3.update()
  497.         self.entryss4.update()
  498.         self.entryss5.update()
  499.         self.entryss6.update()
  500.         self.entryss7.update()
  501.         self.entryss8.update()
  502.         self.entryss9.update()
  503.         self.Text_1.update()
  504.         self.Text_1.insert(tkinter.INSERT,"请选择其他")
  505.         #————————————————————————————店铺————————————————————————————————，
  506. class Commodity_drop(MainForm):  #删除界面
  507.     def __init__(self):
  508.         super().__init__()
  509.         self.Textw = tkinter.Text(self.root, height=18, width=80, font=("微软雅黑", 10))
  510.         self.Textw.place(x=15, y=0)
  511.         tkinter.Label(self.root,text="输入需要删除的商品编号或商品名称",font=("微软雅黑", 20)).place(x=100,y=350)
  512.         self.Entry_1=tkinter.Entry(self.root,font=("微软雅黑", 20))
  513.         self.Entry_1.place(x=20,y=400)
  514.         tkinter.Button(self.root,text="查询",command=self.commodity_select_drop,font=("微软雅黑", 10)).place(x=380,y=400)
  515.         tkinter.Button(self.root, text="返回", command=self.commodity_return, font=("微软雅黑", 10)).place(x=600, y=450)
  516.         tkinter.Button(self.root, text="确定清除", command=self.commodity_confirm, font=("微软雅黑", 10)).place(x=450, y=400)
  517.         tkinter.Button(self.root, text="取消清除", command=self.commodity_confirm, font=("微软雅黑", 10)).place(x=550, y=400)
  518.         self.commodity_refersh()   #显示提示页面
  519.         self.commodity_select()  #显示所有的商品信息
  520.         self.root.mainloop()
  521.     def commodity_return(self): #返回商品菜单
  522.         self.root.destroy()
  523.         Commodity_From()
  524.     def commodity_confirm(self):  #提示确认查询
  525.         self.commodity_refersh()
  526.         self.Textw.insert(tkinter.INSERT,"请先查询\n")
  527.         self.commodity_select()
  528.     def commodity_refersh(self):  #刷新界面
  529.         self.Textw.delete(0.0,tkinter.END)
  530.         self.Textw.update()
  531.         self.Textw.insert(tkinter.INSERT,
  532.                           "----------------------------------请输入你要删除的商品编号，或商品名称----------------------------------\n")
  533.     def commodity_select(self):  #查询所有的商品
  534.         cursor = conn.cursor()  # 创建sql游标
  535.         sql = 'select * from commodity '   # 查询所有商品的信息
  536.         cursor.execute(sql)
  537.         self.Textw.insert(tkinter.INSERT, "你的商品信息为：\n")
  538.         for fetchone in cursor.fetchall():
  539.             self.Textw.insert(tkinter.INSERT, fetchone)
  540.             self.Textw.insert(tkinter.INSERT, '\n')
  541.     #——————————————————————————————————————————————————————删除页面————————————————————————————————————————————————————
  542.     def commodity_select_drop(self):  #查询需要删除的商品信息
  543.         if self.Entry_1.get() == '':
  544.             self.commodity_refersh()
  545.             self.Textw.insert(tkinter.INSERT, "你的输入为空：\n")
  546.             self.commodity_select()
  547.         else:
  548.             try:
  549.                 def selecte_id_look():
  550.                     cursor = conn.cursor()  # 创建sql游标
  551.                     sql1 = 'select * from commodity where commodity_id="%s"' % (self.Entry_1.get())  # 查询需要删除的信息
  552.                     cursor.execute(sql1)
  553.                     conn.commit()  # 提交
  554.                     cursor.close()  # 关闭游标
  555.                     self.commodity_refersh()
  556.                     self.Textw.insert(tkinter.INSERT, "你输入的的商品编号查询的信息为：\n")
  557.                     return cursor.fetchall()
  558.                 def selecte_name_look():
  559.                     cursor = conn.cursor()  # 创建sql游标
  560.                     sql2 = 'select * from commodity where commodity_name="%s"' % (self.Entry_1.get())  # 查询需要删除的信息
  561.                     cursor.execute(sql2)
  562.                     conn.commit()  # 提交
  563.                     cursor.close()  # 关闭游标
  564.                     self.commodity_refersh()
  565.                     self.Textw.insert(tkinter.INSERT, "你输入的的商品名称查询的信息为：\n")
  566.                     return cursor.fetchall()
  567.                 def button_id():
  568.                     tkinter.Button(self.root, text="确定清除", command=delete_id,
  569.                                    font=("微软雅黑", 10)).place(x=450, y=400)
  570.                     tkinter.Button(self.root, text="取消清除", command=self.commodity_select, font=("微软雅黑", 10)).place(
  571.                         x=550, y=400)
  572.                 def button_name():
  573.                     tkinter.Button(self.root, text="确定清除", command=delete_name,
  574.                                    font=("微软雅黑", 10)).place(x=450, y=400)
  575.                     tkinter.Button(self.root, text="取消清除", command=self.commodity_select, font=("微软雅黑", 10)).place(
  576.                         x=550, y=400)
  577.                 def delete_id():
  578.                     cursor = conn.cursor()  # 创建sql游标
  579.                     sql = 'delete from commodity where commodity_id="%s"' % (self.Entry_1.get())
  580.                     cursor.execute(sql)
  581.                     conn.commit()  # 提交
  582.                     cursor.close()  # 关闭游标
  583.                     self.Textw.insert(tkinter.INSERT, "数据删除成功\n")
  584.                 def delete_name():
  585.                     cursor = conn.cursor()  # 创建sql游标
  586.                     sql = 'delete from commodity where commodity_name="%s"' % (self.Entry_1.get())
  587.                     cursor.execute(sql)
  588.                     conn.commit()  # 提交
  589.                     cursor.close()  # 关闭游标
  590.                     self.Textw.insert(tkinter.INSERT, "数据删除成功\n")
  591.                 if bool(selecte_id_look())==True:
  592.                     for fetchone in selecte_id_look():
  593.                         self.Textw.insert(tkinter.INSERT, fetchone)
  594.                         self.Textw.insert(tkinter.INSERT, '\n')
  595.                     button_id()
  596.                 elif bool(selecte_name_look())==True:
  597.                     for fetchone in selecte_name_look():
  598.                         self.Textw.insert(tkinter.INSERT, fetchone)
  599.                         self.Textw.insert(tkinter.INSERT, '\n')
  600.                     button_name()
  601.                 else:
  602.                     self.commodity_refersh()
  603.                     self.Textw.insert(tkinter.INSERT, "你输入的的商品信息错误或没有此商品：\n")
  604.             except:
  605.                 self.Textw.insert(tkinter.INSERT, "程序运行故障：\n")
  606.         #_____________________________________修改页面————————————————————————————————————————————————————————————
  607. class Commodity_delente(MainForm): #修改
  608.     def __init__(self):
  609.         super().__init__()
  610.         photo=tkinter.PhotoImage(file=COMMODITY_DELETE_PATH)
  611.         tkinter.Label(self.root, image=photo, width=680, height=500).place(x=0, y=0)
  612.         tkinter.Label(self.root,text="修改商品信息",font=("黑体",20)).place(x=250,y=0)
  613.         tkinter.Label(self.root, text="所有商品信息", font=("微软雅黑", 10)).place(x=110, y=30)
  614.         self.Text_select=tkinter.Text(self.root,width=40,height=13,font=("微软雅黑", 10))  #显示所有商品信息
  615.         self.Text_select.place(x=10,y=50)
  616.         tkinter.Label(self.root, text="修改商品信息", font=("微软雅黑", 10)).place(x=110, y=300)  #显示查询和修改的商品信息
  617.         self.Text_delete = tkinter.Text(self.root, width=40, height=8,font=("微软雅黑", 10))
  618.         self.Text_delete.place(x=10, y=320)
  619.         tkinter.Label(self.root, text="查询商品信息", font=("微软雅黑", 10)).place(x=500, y=30)
  620.         tkinter.Label(self.root, text="输入商品编号:", font=("微软雅黑", 10)).place(x=350, y=50)
  621.         self.Entry_id = tkinter.Entry(self.root,font=("微软雅黑", 10))   #输入商品编号
  622.         self.Entry_id.place(x=450, y=50)
  623.         tkinter.Button(self.root, text="查询",command=self.select_id_commodity, font=("微软雅黑", 7)).place(x=630, y=50)
  624.         tkinter.Label(self.root, text="修改商品内容:", font=("微软雅黑", 10)).place(x=350, y=100)
  625.         self.Entry_update = tkinter.Entry(self.root, font=("微软雅黑", 10))  #输入修改的商品信息
  626.         self.Entry_update.place(x=450, y=100)
  627.         tkinter.Button(self.root,text="商品名称",command=self.update_name,font=("微软雅黑",10)).place(x=450,y=150)
  628.         tkinter.Button(self.root, text="商品售价", command=self.update_price, font=("微软雅黑", 10)).place(x=550, y=150)
  629.         tkinter.Button(self.root, text="商品进价", command=self.update_pur_price, font=("微软雅黑", 10)).place(x=450, y=200)
  630.         tkinter.Button(self.root, text="生产日期", command=self.update_production, font=("微软雅黑", 10)).place(x=550, y=200)
  631.         tkinter.Button(self.root, text="保质期", command=self.update_life, font=("微软雅黑", 10)).place(x=450, y=250)
  632.         tkinter.Button(self.root, text="商品规格", command=self.update_speci, font=("微软雅黑", 10)).place(x=550, y=250)
  633.         tkinter.Button(self.root,text="库房编号",command=self.warehouse_id,font=("微软雅黑",10)).place(x=450,y=300)
  634.         tkinter.Button(self.root, text="返回", command=self.commodity_return, font=("微软雅黑", 10)).place(x=600, y=450)
  635.         self.selecte_Text_query()   #跟新并查询商品信息
  636.         self.root.mainloop()
  637.     def commodity_return(self):  #返回商品菜单
  638.         self.root.destroy()
  639.         Commodity_From()
  640.     def selecte_Text_query(self):  # 更新并查询商品信息
  641.         self.Text_select.delete(0.0, tkinter.END)
  642.         self.Text_select.update()
  643.         try:
  644.             cursor=conn.cursor()
  645.             sql='select * from commodity '
  646.             cursor.execute(sql)
  647.             conn.commit()
  648.             cursor.close()
  649.             for i in cursor.fetchall():
  650.                 self.Text_select.insert(tkinter.INSERT,i)
  651.                 self.Text_select.insert(tkinter.INSERT,'\n')
  652.         except:
  653.             pass
  654.     def delete_Text_query(self): #跟新输出显示框的信息
  655.         self.Text_delete.delete(0.0,tkinter.END)
  656.         self.Text_delete.update()
  657.         self.Text_delete.insert(tkinter.INSERT,"你查询到的商品为:\n")
  658.     def select_id_commodity(self):   #根据id查询信息
  659.         def commodity_select_id():  #查询商品信息
  660.             def select_id():
  661.                 cursor = conn.cursor()  # 创建sql游标
  662.                 sql = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  663.                 cursor.execute(sql)
  664.                 conn.commit()  # 提交
  665.                 cursor.close()  # 关闭游标
  666.                 return cursor.fetchall()
  667.             if bool(select_id())==True:
  668.                 for i in select_id():
  669.                     self.Text_delete.insert(tkinter.INSERT, i)
  670.                     self.Text_delete.insert(tkinter.INSERT,'\n')
  671.             else:
  672.                 self.Text_delete.insert(tkinter.INSERT,"没有该商品信息：\n")
  673.         if self.Entry_id.get()=='':
  674.             self.delete_Text_query()
  675.             self.Text_delete.insert(tkinter.INSERT,"你的输入为空：\n请从新输入;\n")
  676.         else:
  677.             commodity_select_id()
  678.     def update_name(self):
  679.         self.delete_Text_query()
  680.         try:
  681.             cursor=conn.cursor()
  682.             sql='update commodity set commodity_name="%s" where commodity_id="%s"'%(self.Entry_update.get(),self.Entry_id.get())
  683.             cursor.execute(sql)
  684.             conn.commit()
  685.             sql2 = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  686.             cursor.execute(sql2)
  687.             conn.commit()
  688.             self.Text_delete.insert(tkinter.INSERT,cursor.fetchall())
  689.             cursor.close()
  690.             self.Text_delete.insert(tkinter.INSERT, "\n你的商品名称修改成功;\n")
  691.         except:
  692.             pass
  693.     def update_price(self):
  694.         self.delete_Text_query()
  695.         try:
  696.             cursor=conn.cursor()
  697.             sql='update commodity set commodity_price="%s" where commodity_id="%s"'%(self.Entry_update.get(),self.Entry_id.get())
  698.             cursor.execute(sql)
  699.             conn.commit()
  700.             sql2 = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  701.             cursor.execute(sql2)
  702.             conn.commit()
  703.             self.Text_delete.insert(tkinter.INSERT,cursor.fetchall())
  704.             cursor.close()
  705.             self.Text_delete.insert(tkinter.INSERT, "\n你的商品售价修改成功;\n")
  706.         except:
  707.             pass
  708.     def update_pur_price(self):
  709.         self.delete_Text_query()
  710.         try:
  711.             cursor=conn.cursor()
  712.             sql='update commodity set commodity_pur_price="%s" where commodity_id="%s"'%(self.Entry_update.get(),self.Entry_id.get())
  713.             cursor.execute(sql)
  714.             conn.commit()
  715.             sql2 = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  716.             cursor.execute(sql2)
  717.             conn.commit()
  718.             self.Text_delete.insert(tkinter.INSERT,cursor.fetchall())
  719.             cursor.close()
  720.             self.Text_delete.insert(tkinter.INSERT, "\n你的商品进价修改成功;\n")
  721.         except:
  722.             pass
  723.     def update_production(self):
  724.         self.delete_Text_query()
  725.         try:
  726.             cursor=conn.cursor()
  727.             sql='update commodity set commodity_production="%s" where commodity_id="%s"'%(self.Entry_update.get(),self.Entry_id.get())
  728.             cursor.execute(sql)
  729.             conn.commit()
  730.             sql2 = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  731.             cursor.execute(sql2)
  732.             conn.commit()
  733.             self.Text_delete.insert(tkinter.INSERT,cursor.fetchall())
  734.             cursor.close()
  735.             self.Text_delete.insert(tkinter.INSERT, "\n你的生产日期修改成功;\n")
  736.         except:
  737.             pass
  738.     def update_life(self):
  739.         self.delete_Text_query()
  740.         try:
  741.             cursor=conn.cursor()
  742.             sql='update commodity set commodity_life="%s" where commodity_id="%s"'%(self.Entry_update.get(),self.Entry_id.get())
  743.             cursor.execute(sql)
  744.             conn.commit()
  745.             sql2 = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  746.             cursor.execute(sql2)
  747.             conn.commit()
  748.             self.Text_delete.insert(tkinter.INSERT,cursor.fetchall())
  749.             cursor.close()
  750.             self.Text_delete.insert(tkinter.INSERT, "\n你的保质期修改成功;\n")
  751.         except:
  752.             pass
  753.     def update_speci(self):
  754.         self.delete_Text_query()
  755.         try:
  756.             cursor=conn.cursor()
  757.             sql='update commodity set commodity_speci="%s" where commodity_id="%s"'%(self.Entry_update.get(),self.Entry_id.get())
  758.             cursor.execute(sql)
  759.             conn.commit()
  760.             sql2 = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  761.             cursor.execute(sql2)
  762.             conn.commit()
  763.             self.Text_delete.insert(tkinter.INSERT,cursor.fetchall())
  764.             cursor.close()
  765.             self.Text_delete.insert(tkinter.INSERT, "\n你的商品规格修改成功;\n")
  766.         except:
  767.             pass
  768.     def warehouse_id(self):
  769.         self.delete_Text_query()
  770.         try:
  771.             cursor=conn.cursor()
  772.             sql='update commodity set warehouse_id="%s" where commodity_id="%s"'%(self.Entry_update.get(),self.Entry_id.get())
  773.             cursor.execute(sql)
  774.             conn.commit()
  775.             sql2 = 'select * from commodity where commodity_id="%s"' % (self.Entry_id.get())
  776.             cursor.execute(sql2)
  777.             conn.commit()
  778.             self.Text_delete.insert(tkinter.INSERT,cursor.fetchall())
  779.             cursor.close()
  780.             self.Text_delete.insert(tkinter.INSERT, "\n你的库房修改成功;\n")
  781.         except:
  782.             pass
  783. class Commodity_select(MainForm) :  #查询
  784.     def __init__(self):
  785.         super().__init__()
  786.         tkinter.Label(self.root, text="查询商品信息", font=("黑体", 20)).place(x=250, y=0)
  787.         tkinter.Label(self.root, text="所有商品信息", font=("微软雅黑", 10)).place(x=110, y=30)
  788.         self.Text_select = tkinter.Text(self.root, width=40, height=13, font=("微软雅黑", 10))  # 显示所有商品信息
  789.         self.Text_select.place(x=10, y=50)
  790.         tkinter.Label(self.root, text="查询商品信息", font=("微软雅黑", 10)).place(x=500, y=30)
  791.         #商品编号
  792.         tkinter.Label(self.root, text="输入商品编号查询:", font=("微软雅黑", 10)).place(x=350, y=50)
  793.         self.Entry_id = tkinter.Entry(self.root, font=("微软雅黑", 10))  # 输入商品编号
  794.         self.Entry_id.place(x=450, y=50)
  795.         tkinter.Button(self.root, text="查询",command=self.selecte_id_commodity ,font=("微软雅黑", 7)).place(x=630, y=50)
  796.         tkinter.Label(self.root, text="所有商品编号信息", font=("微软雅黑", 10)).place(x=100, y=300)  # 显示查询和修改的商品信息
  797.         self.Text_id = tkinter.Text(self.root, width=30, height=8, font=("微软雅黑", 10))
  798.         self.Text_id.place(x=10, y=320)
  799.         # 商品名称
  800.         tkinter.Label(self.root, text="输入商品名称查询:", font=("微软雅黑", 10)).place(x=350, y=100)
  801.         self.Entry_name = tkinter.Entry(self.root, font=("微软雅黑", 10))  # 输入修改的商品信息
  802.         self.Entry_name.place(x=450, y=100)
  803.         tkinter.Button(self.root, text="查询",command=self.selecte_name_commodity, font=("微软雅黑", 7)).place(x=630, y=100)
  804.         tkinter.Label(self.root, text="所有商品名称信息", font=("微软雅黑", 10)).place(x=300, y=300)  # 显示查询和修改的商品信息
  805.         self.Text_name = tkinter.Text(self.root, width=30, height=8, font=("微软雅黑", 10))
  806.         self.Text_name.place(x=210, y=320)
  807.         #商品库房名称
  808.         tkinter.Label(self.root, text="输入库房名称查询:", font=("微软雅黑", 10)).place(x=350, y=150)
  809.         self.Entry_warehouse = tkinter.Entry(self.root, font=("微软雅黑", 10))  # 输入修改的商品信息
  810.         self.Entry_warehouse.place(x=450, y=150)
  811.         tkinter.Button(self.root, text="查询",command=self.selecte_warehouse_commodity, font=("微软雅黑", 7)).place(x=630, y=150)
  812.         tkinter.Label(self.root, text="库房所有商品信息", font=("微软雅黑", 10)).place(x=500, y=300)  # 显示查询和修改的商品信息
  813.         self.Text_warehouse = tkinter.Text(self.root, width=30, height=8, font=("微软雅黑", 10))
  814.         self.Text_warehouse.place(x=410, y=320)
  815.         tkinter.Button(self.root, text="返回", command=self.commodity_return, font=("微软雅黑", 10)).place(x=600, y=450)
  816.         self.selecte_Text_query()  # 跟新并查询商品信息
  817.         self.root.mainloop()
  818.     def commodity_return(self): #返回商品界面
  819.         self.root.destroy()
  820.         Commodity_From()
  821.     def selecte_Text_query(self):  # 更新并查询商品信息
  822.         self.Text_select.delete(0.0, tkinter.END)
  823.         self.Text_select.update()
  824.         try:
  825.             cursor = conn.cursor()
  826.             sql = 'select * from commodity '
  827.             cursor.execute(sql)
  828.             conn.commit()
  829.             cursor.close()
  830.             for i in cursor.fetchall():
  831.                 self.Text_select.insert(tkinter.INSERT, i)
  832.                 self.Text_select.insert(tkinter.INSERT, '\n')
  833.         except:
  834.             pass
  835.     def selecte_id_commodity(self): #根据商品id查询商品信息
  836.         def text_id_query():  #清空text里面的信息
  837.             self.Text_id.delete(0.0,tkinter.END)
  838.             self.Text_id.update()
  839.         if self.Entry_warehouse.get()=='':
  840.             text_id_query()
  841.             self.Text_id.insert(tkinter.INSERT,"你输入的库房账号为空\n")
  842.         else:
  843.             text_id_query()
  844.             def select_id():
  845.                 cursor=conn.cursor()
  846.                 sql='select * from commodity where warehouse_id="%s"'%(self.Entry_warehouse.get())
  847.                 cursor.execute(sql)
  848.                 conn.commit()
  849.                 cursor.close()
  850.                 return cursor.fetchall()
  851.             if bool(select_id())==True:
  852.                 for i in select_id():
  853.                     self.Text_id.insert(tkinter.INSERT,i)
  854.                     self.Text_id.insert(tkinter.INSERT,'\n')
  855.             else:
  856.                 self.Text_id.insert(tkinter.INSERT,"你输入的商品不在店铺\n")
  857.     def selecte_name_commodity(self): #根据商品name查询商品信息
  858.         def text_name_query():  #清空text里面的信息
  859.             self.Text_name.delete(0.0,tkinter.END)
  860.             self.Text_name.update()
  861.         if self.Entry_name.get()=='':
  862.             text_name_query()
  863.             self.Text_name.insert(tkinter.INSERT,"你输入的商品名称为空\n")
  864.         else:
  865.             text_name_query()
  866.             def select_name():
  867.                 cursor=conn.cursor()
  868.                 sql='select * from commodity where commodity_name="%s"'%(self.Entry_name.get())
  869.                 cursor.execute(sql)
  870.                 conn.commit()
  871.                 cursor.close()
  872.                 return cursor.fetchall()
  873.             if bool(select_name())==True:
  874.                 for i in select_name():
  875.                     self.Text_name.insert(tkinter.INSERT,i)
  876.                     self.Text_name.insert(tkinter.INSERT,'\n')
  877.             else:
  878.                 self.Text_name.insert(tkinter.INSERT,"你输入的商品名称查询不在店铺\n")
  879.     def selecte_warehouse_commodity(self): #根据商品id查询商品信息
  880.         def text_warehouse_query():  #清空text里面的信息
  881.             self.Text_warehouse.delete(0.0,tkinter.END)
  882.             self.Text_warehouse.update()
  883.         if self.Entry_warehouse.get()=='':
  884.             text_warehouse_query()
  885.             self.Text_warehouse.insert(tkinter.INSERT,"你输入的库房为空\n")
  886.         else:
  887.             text_warehouse_query()
  888.             def select_warehouse():
  889.                 cursor=conn.cursor()
  890.                 sql='select * from commodity where commodity_id="%s"'%(self.Entry_id.get())
  891.                 cursor.execute(sql)
  892.                 conn.commit()
  893.                 cursor.close()
  894.                 return cursor.fetchall()
  895.             if bool(select_warehouse())==True:
  896.                 for i in select_warehouse():
  897.                     self.Text_warehouse.insert(tkinter.INSERT,i)
  898.                     self.Text_warehouse.insert(tkinter.INSERT,'\n')
  899.             else:
  900.                 self.Text_warehouse.insert(tkinter.INSERT,"你输入的库房查询不在店铺\n")
  901. class Shop_From(MainForm):  #店铺界面设置,店铺可以查询，修改，导出仓库信息全部商品
  902.     def __init__(self):
  903.         super().__init__()
  904.         self.button1 = tkinter.Button(self.root, text="顾客", command=self.Customer, height=3, width=10).place(x=0, y=430)
  905.         self.button2 = tkinter.Button(self.root, text="商品", command=self.Commodiyt_from_1, height=3, width=10).place(x=150, y=430)
  906.         self.button3 = tkinter.Button(self.root, text="库房", command=self.Warehouse_1, height=3, width=10).place(x=300, y=430)
  907.         self.button4 = tkinter.Button(self.root, text="导入导出", command=self.export_1, height=3, width=10).place(x=450, y=430)
  908.         self.button1 = tkinter.Button(self.root, text="返回", command=self.The_store_1, height=3, width=10).place(x=600, y=430)
  909.         self.root.mainloop()
  910.     def Commodiyt_from_1(self):#进入商品界面
  911.         self.root.destroy()
  912.         Commodity_From()
  913.     def The_store_1(self):#进入主界面
  914.         self.root.destroy()
  915.         The_store()
  916.     def Warehouse_1(self):  # 进入库房界面
  917.         self.root.destroy()
  918.         Warehouse()
  919.     def export_1(self):#进入导出界面
  920.         self.root.destroy()
  921.         Shop_export()
  922.     def Customer(self):#  顾客管理
  923.         def remove_Text_purint():  #清空Customer_Text_purint数据
  924.             Customer_Text_purint.delete(0.0, tkinter.END)
  925.             Customer_Text_purint.update()
  926.         def import_user():  #导出所有用户信息到Customer_Text中
  927.             cursor = conn.cursor()
  928.             sql = 'select * from customer'
  929.             cursor.execute(sql)
  930.             Customer_Text.delete(0.0, tkinter.END)
  931.             Customer_Text.update()
  932.             Customer_Text.insert(tkinter.INSERT, '你的所有商品信息\n')
  933.             for x in cursor.fetchall():
  934.                 Customer_Text.insert(tkinter.INSERT,x)
  935.                 Customer_Text.insert(tkinter.INSERT, '\n')
  936.             conn.commit()
  937.             cursor.close()
  938.         def query_user():# 查询用户信息
  939.             cursor=conn.cursor()
  940.             sql='select * from customer where customer_id="%s" and customer_password="%s"'%(Customer_Entry_user.get(),Customer_Entry_password.get())
  941.             cursor.execute(sql)
  942.             conn.commit()
  943.             cursor.close()
  944.             return cursor.fetchall()
  945.         #....................修改用户名.........................
  946.         def delete_user():#  修改用户信息
  947.             def delete_user_od() : #修改
  948.                 cursor = conn.cursor()
  949.                 sql='update customer set customer_name="%s" where customer_id="%s"'%(Customer_Entry_name.get(),Customer_Entry_user.get())
  950.                 cursor.execute(sql)
  951.                 conn.commit()
  952.                 cursor.close()
  953.             if Customer_Entry_user.get()=='':
  954.                 remove_Text_purint()
  955.                 Customer_Text_purint.insert(tkinter.INSERT, "用户名输入为空\n")
  956.             elif Customer_Entry_password.get()=='':
  957.                 remove_Text_purint()
  958.                 Customer_Text_purint.insert(tkinter.INSERT, "密码输入为空\n")
  959.             else:
  960.                 try:
  961.                     remove_Text_purint()   #清空
  962.                     Customer_Text_purint.insert(tkinter.INSERT,'你原用户信息\n')  # 提示信息
  963.                     Customer_Text_purint.insert(tkinter.INSERT, query_user())  #查询
  964.                     Customer_Text_purint.insert(tkinter.INSERT, "\n你修改后用户信息\n")  # 查询
  965.                     delete_user_od()  #进行修改
  966.                     Customer_Text_purint.insert(tkinter.INSERT, query_user())  # 在查询
  967.                 except:
  968.                     remove_Text_purint()
  969.                     Customer_Text_purint.insert(tkinter.INSERT, "用户修改失败\n")
  970.         # ....................修改密码.........................
  971.         def delete_password():#修改密码
  972.             def delete_user_od() : #对密码修改
  973.                 cursor = conn.cursor()
  974.                 sql='update customer set customer_password="%s" where customer_id="%s"'%(Customer_Entry_password.get(),Customer_Entry_user.get())
  975.                 cursor.execute(sql)
  976.                 conn.commit()
  977.                 cursor.close()
  978.             def query_user():  # 查询用户信息
  979.                 cursor = conn.cursor()
  980.                 sql = 'select * from customer where customer_id="%s"'% (
  981.                 Customer_Entry_user.get())
  982.                 cursor.execute(sql)
  983.                 conn.commit()
  984.                 cursor.close()
  985.                 return cursor.fetchall()
  986.             if Customer_Entry_user.get()=='':
  987.                 remove_Text_purint()
  988.                 Customer_Text_purint.insert(tkinter.INSERT, "用户名输入为空\n")
  989.             elif Customer_Entry_password.get()=='':
  990.                 remove_Text_purint()
  991.                 Customer_Text_purint.insert(tkinter.INSERT, "密码输入为空\n")
  992.             else:
  993.                 try:
  994.                     remove_Text_purint()   #清空
  995.                     Customer_Text_purint.insert(tkinter.INSERT,'你原用户信息\n')  # 提示信息
  996.                     Customer_Text_purint.insert(tkinter.INSERT, query_user())  #查询
  997.                     Customer_Text_purint.insert(tkinter.INSERT, "\n你修改后的用户信息\n")  # 查询
  998.                     delete_user_od()  #进行修改
  999.                     Customer_Text_purint.insert(tkinter.INSERT, query_user())  # 在查询
  1000.                 except:
  1001.                     remove_Text_purint()
  1002.                     Customer_Text_purint.insert(tkinter.INSERT, "用户修改失败\n")
  1003.             # ....................增加用户.........................
  1004.         def add_user():  #增加用户
  1005.             def delete_user_add() : #增加修改
  1006.                 cursor = conn.cursor()
  1007.                 sql='insert into customer values(%s,%s,%s,0)'%(Customer_Entry_user.get(),Customer_Entry_name.get(),Customer_Entry_password.get())
  1008.                 cursor.execute(sql)
  1009.                 conn.commit()
  1010.                 cursor.close()
  1011.             def query_user():  # 查询用户信息
  1012.                 cursor = conn.cursor()
  1013.                 sql = 'select * from customer where customer_id="%s"'% (
  1014.                 Customer_Entry_user.get())
  1015.                 cursor.execute(sql)
  1016.                 conn.commit()
  1017.                 cursor.close()
  1018.                 return cursor.fetchall()
  1019.             if Customer_Entry_user.get()=='':
  1020.                 remove_Text_purint()
  1021.                 Customer_Text_purint.insert(tkinter.INSERT, "用户名输入为空\n")
  1022.             elif Customer_Entry_password.get()=='':
  1023.                 remove_Text_purint()
  1024.                 Customer_Text_purint.insert(tkinter.INSERT, "密码输入为空\n")
  1025.             else:
  1026.                 try:
  1027.                     remove_Text_purint()   #清空
  1028.                     Customer_Text_purint.insert(tkinter.INSERT, "你增加的用户信息\n")  # 查询
  1029.                     delete_user_add()  #进行修改
  1030.                     Customer_Text_purint.insert(tkinter.INSERT, query_user())  # 在查询
  1031.                 except:
  1032.                     remove_Text_purint()
  1033.                     Customer_Text_purint.insert(tkinter.INSERT, "用户已存在，用户添加失败\n")
  1034.                     Customer_Text_purint.insert(tkinter.INSERT, query_user())  # 在查询
  1035.             # ....................删除用户.........................
  1036.         def drop_user():  #删除用户
  1037.             def delete_user_drop() : #删除修改
  1038.                 cursor = conn.cursor()
  1039.                 sql='delete from customer where customer_id="%s" and customer_password="%s"'%(Customer_Entry_user.get(),Customer_Entry_password.get())
  1040.                 cursor.execute(sql)
  1041.                 conn.commit()
  1042.                 cursor.close()
  1043.             def query_user():  # 查询用户信息
  1044.                 cursor = conn.cursor()
  1045.                 sql = 'select * from customer where customer_id="%s"'% (
  1046.                 Customer_Entry_user.get())
  1047.                 cursor.execute(sql)
  1048.                 conn.commit()
  1049.                 cursor.close()
  1050.                 return cursor.fetchall()
  1051.             if Customer_Entry_user.get()=='':
  1052.                 remove_Text_purint()
  1053.                 Customer_Text_purint.insert(tkinter.INSERT, "用户名输入为空\n")
  1054.             elif Customer_Entry_password.get()=='':
  1055.                 remove_Text_purint()
  1056.                 Customer_Text_purint.insert(tkinter.INSERT, "密码输入为空\n")
  1057.             else:
  1058.                 try:
  1059.                     remove_Text_purint()   #清空
  1060.                     Customer_Text_purint.insert(tkinter.INSERT, "你删除的用户信息\n")  # 查询
  1061.                     delete_user_drop()  #删除
  1062.                     Customer_Text_purint.insert(tkinter.INSERT, query_user())  # 在查询
  1063.                 except:
  1064.                     remove_Text_purint()
  1065.                     Customer_Text_purint.insert(tkinter.INSERT, "用户输入不对，用户删除失败\n")
  1066.         tkinter.Label(self.root, text="顾客信息", font=("黑体", 20)).place(x=260, y=0)
  1067.         Customer_Text=tkinter.Text(self.root,width=50,height=20,font=("微软雅黑",10))
  1068.         Customer_Text.place(x=0,y=30)
  1069.         import_user()
  1070.         tkinter.Label(self.root, text="用户信息修改", font=("黑体", 10)).place(x=500, y=10)
  1071.         tkinter.Label(self.root, text="用户账号", font=("黑体", 10)).place(x=420, y=50)
  1072.         tkinter.Label(self.root, text="密    码", font=("黑体", 10)).place(x=420, y=100)
  1073.         tkinter.Label(self.root, text="用 户 名", font=("黑体", 10)).place(x=420, y=150)
  1074.         tkinter.Label(self.root, text="电    话", font=("黑体", 10)).place(x=420, y=200)
  1075.         Customer_Entry_user = tkinter.Entry(self.root, font=("微软雅黑", 10))  # 显示框
  1076.         Customer_Entry_user.place(x=500,y=50)
  1077.         Customer_Entry_password = tkinter.Entry(self.root, font=("微软雅黑", 10),show='*')  # 显示框
  1078.         Customer_Entry_password.place(x=500,y=100)
  1079.         Customer_Entry_name = tkinter.Entry(self.root, font=("微软雅黑", 10))  # 显示框
  1080.         Customer_Entry_name.place(x=500, y=150)
  1081.         Customer_Entry_phon = tkinter.Entry(self.root, font=("微软雅黑", 10))  # 显示框
  1082.         Customer_Entry_phon.place(x=500, y=200)
  1083.         tkinter.Button(self.root,text="修改用户信息",command=delete_user,font=('微软雅黑',10)).place(x=420,y=250)
  1084.         tkinter.Button(self.root, text="修改密码", command=delete_password, font=('微软雅黑', 10)).place(x=420, y=300)
  1085.         tkinter.Button(self.root, text="添加用户", command=add_user, font=('微软雅黑', 10)).place(x=560, y=250)
  1086.         tkinter.Button(self.root, text="删除用户", command='1111', font=('微软雅黑', 10)).place(x=560, y=300)
  1087.         Customer_Text_purint=tkinter.Text(self.root,width=30,height=3,font=("微软雅黑",10))
  1088.         Customer_Text_purint.place(x=420, y=350)
  1089.         Customer_Text_purint.insert(tkinter.INSERT,"输入正确的账号密码可以修改用户名\n输入正确的账号可以修改密码\n"
  1090.                                                    "输入没有的账号，用户名，密码可以添加账号\n输入正确的账号，密码可以删除账号")
  1091. class Shop_export(MainForm):#导入导出
  1092.     def __init__(self):
  1093.         super().__init__()
  1094.         tkinter.Label(self.root, text="导入导出顾客商品信息", font=("黑体", 20)).place(x=200, y=0)
  1095.         self.prompt=tkinter.Text(self.root,width=55,height=5,font=("微软雅黑",15))
  1096.         self.prompt.place(x=10,y=50)
  1097.         #————————————————导入————————————————————————
  1098.         tkinter.Label(self.root,text="输入导入的绝对地址：",font=("微软雅黑",15)).place(x=70,y=200)
  1099.         self.leading_in=tkinter.Entry(self.root,font=("黑体",15))
  1100.         self.leading_in.place(x=50,y=250)
  1101.         tkinter.Button(self.root, text="导入顾客", command=self.leading_in_customer,font=("微软雅黑",15)).place(x=100, y=300)
  1102.         tkinter.Button(self.root, text="导入商品", command=self.leading_in_commodity, font=("微软雅黑",15)).place(
  1103.             x=100, y=350)
  1104.         #————————————————导出————————————————
  1105.         tkinter.Label(self.root, text="输入导出的绝对地址：", font=("微软雅黑", 15)).place(x=420, y=200)
  1106.         self.leading_out = tkinter.Entry(self.root, font=("黑体", 15))
  1107.         self.leading_out.place(x=400, y=250)
  1108.         tkinter.Button(self.root, text="导出顾客", command=self.leading_out_customer, font=("微软雅黑",15)).place(x=450, y=300)
  1109.         tkinter.Button(self.root, text="导出商品", command=self.leading_out_commodity,font=("微软雅黑",15)).place(
  1110.             x=450, y=350)
  1111.         tkinter.Button(self.root, text="查看顾客", command=self.look_customer, font=("微软雅黑", 15)).place(x=0, y=430)
  1112.         tkinter.Button(self.root, text="查看商品", command=self.look_commodity, font=("微软雅黑", 15)).place(x=300, y=430)
  1113.         tkinter.Button(self.root, text="返回商品", command=self.The_store_1,font=("微软雅黑",15)).place(x=600,y=430)
  1114.         self.root.mainloop()
  1115.     def The_store_1(self): #返回商品
  1116.         self.root.destroy()
  1117.         The_store()
  1118.     def clean_prompt(self):  #清除提示框
  1119.         self.prompt.delete(0.0,tkinter.END)
  1120.         self.prompt.update()
  1121.     def look_customer(self): #查看顾客
  1122.         cursor=conn.cursor()
  1123.         cursor.execute("select * from customer")
  1124.         conn.commit()
  1125.         cursor.close()
  1126.         self.clean_prompt()
  1127.         for i in cursor.fetchall():
  1128.             self.prompt.insert(tkinter.INSERT,i)
  1129.     def look_commodity(self): #查看商品
  1130.         cursor=conn.cursor()
  1131.         cursor.execute("select * from commodity")
  1132.         conn.commit()
  1133.         cursor.close()
  1134.         self.clean_prompt()
  1135.         for i in cursor.fetchall():
  1136.             self.prompt.insert(tkinter.INSERT,i)
  1137.     def leading_in_customer(self):  #导入顾客信息
  1138.         global global_id
  1139.         self.clean_prompt()
  1140.         address=self.leading_in.get()
  1141.         df_customer=pd.read_excel(address)
  1142.         def go_shopping():  # 查看购物情况
  1143.             sql = ' select sum(commodity_amount) from commodity GROUP BY customer_id;'
  1144.             cursor.execute(sql)
  1145.             conn.commit()
  1146.             return cursor.fetchone()
  1147.         cursor = conn.cursor()  # 创建游标
  1148.         try:
  1149.             for co in range(len(df_customer["用户账号"])):
  1150.                 try:
  1151.                     sql = 'insert into customer values (%s,%s,%s,%s,%s,%s);'  # 添加数据
  1152.                     cursor.execute(sql, (
  1153.                         df_customer["用户账号"][co],
  1154.                         df_customer["密码"][co],
  1155.                         df_customer["用户名"][co],
  1156.                         df_customer["电话"][co],
  1157.                         go_shopping(),
  1158.                         global_id)
  1159.                                    )  # 执行添加数据
  1160.                     conn.commit()  # 提交
  1161.                 except:
  1162.                     self.prompt.insert(tkinter.INSERT,"你的用户账号已导入\n")
  1163.                     self.prompt.insert(tkinter.INSERT,df_customer["用户账号"][co])
  1164.                     self.prompt.insert(tkinter.INSERT, "\n")
  1165.         except:
  1166.             self.prompt.insert(tkinter.INSERT, "错误：你导入的信息不符合导入格式\n")
  1167.         cursor.close()  # 关闭游标
  1168.     def leading_in_commodity(self):  #导入顾客信息
  1169.         global global_id
  1170.         self.clean_prompt()
  1171.         address = self.leading_in.get()
  1172.         df_commodity = pd.read_excel(address)
  1173.         cursor = conn.cursor()  # 创建游标
  1174.         try:
  1175.             for co in range(len(df_commodity["商品编码"])):
  1176.                 try:
  1177.                     sql = 'insert into commodity values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);'  # 添加数据
  1178.                     cursor.execute(sql, (
  1179.                         df_commodity["商品编码"][co],
  1180.                         df_commodity["商品名称"][co],
  1181.                         df_commodity["商品售价"][co],
  1182.                         df_commodity["商品进价"][co],
  1183.                         df_commodity["生产日期"][co],
  1184.                         df_commodity["保质期"][co],
  1185.                         df_commodity["商品规格"][co],
  1186.                         df_commodity["销售数量"][co],
  1187.                         global_id,
  1188.                         df_commodity["库房编号"][co],
  1189.                         df_commodity["顾客编号"][co])
  1190.                                    )  # 执行添加数据
  1191.                     conn.commit()  # 提交
  1192.                 except:
  1193.                     self.prompt.insert(tkinter.INSERT, "你的商品账号已导入\n")
  1194.                     self.prompt.insert(tkinter.INSERT, df_commodity["商品编码"][co])
  1195.                     self.prompt.insert(tkinter.INSERT, "\n")
  1196.         except:
  1197.             self.prompt.insert(tkinter.INSERT, "错误：你导入的信息不符合导入格式\n")
  1198.         cursor.close()  # 关闭游标
  1199.     def leading_out_customer(self): #导出顾客
  1200.         def select_():
  1201.             cursor = conn.cursor()
  1202.             cursor.execute("select * from customer")
  1203.             conn.commit()
  1204.             cursor.close()
  1205.             return cursor.fetchall()
  1206.         b=['顾客帐号','顾客密码','顾客名称','顾客电话','消费情况','店铺帐号']
  1207.         c=self.leading_out.get()
  1208.         df=pd.DataFrame(select_(),columns=b)
  1209.         try:
  1210.             df.to_excel(c,index=0)
  1211.         except:
  1212.             self.prompt.insert(tkinter.INSERT,"地址格式错误：")
  1213.     def leading_out_commodity(self): #导出顾客
  1214.         def select_commoidty():
  1215.             cursor = conn.cursor()
  1216.             cursor.execute("select * from commodity")
  1217.             conn.commit()
  1218.             cursor.close()
  1219.             return cursor.fetchall()
  1220.         b=['商品编号','商品名称','商品售价','商品进价','生产日期','保质期','商品规格','销售数量','店铺编号','库房编号','顾客编号']
  1221.         c=self.leading_out.get()
  1222.         df=pd.DataFrame(select_commoidty(),columns=b)
  1223.         try:
  1224.             df.to_excel(c,index=0)
  1225.         except:
  1226.             self.prompt.insert(tkinter.INSERT,"地址格式错误：")
  1227. class Warehouse(MainForm):#库房
  1228.     def __init__(self):
  1229.         super().__init__()
  1230.         tkinter.Label(self.root, text="库房", font=("黑体", 20)).place(x=300, y=0)
  1231.         #库房统计查询
  1232.         tkinter.Button(self.root, text="库存情况", command=self.Warehouse_situation, height=3, width=10).place(x=0, y=430)
  1233.         tkinter.Button(self.root, text="库存导出", command=self.leading_out_warehouse, height=3, width=10).place(x=300, y=430)
  1234.         tkinter.Button(self.root, text="返回菜单", command=self.The_store_1, height=3, width=10).place(x=600, y=430)
  1235.         self.root.mainloop()
  1236.     def The_store_1(self):  #返回菜单
  1237.         self.root.destroy()
  1238.         The_store()
  1239.     def Warehouse_situation(self):  #库存情况
  1240.         tkinter.Label(self.root, text="店铺帐号：", font=("微软雅黑", 15)).place(x=100,y=200)
  1241.         self.entry_warehouse = tkinter.Entry(self.root, font=("微软雅黑", 15))
  1242.         self.entry_warehouse.place(x=250, y=200)
  1243.         tkinter.Label(self.root, text="店铺密码：", font=("微软雅黑", 15)).place(x=100, y=250)
  1244.         self.entry_password = tkinter.Entry(self.root, font=("微软雅黑", 15))
  1245.         self.entry_password.place(x=250, y=250)
  1246.         tkinter.Button(self.root, text="查询", command=self.Warehouse_confirm,font=("微软雅黑", 10)).place(x=600, y=200)
  1247.         self.Text_warehouse=tkinter.Text(self.root,width=80,height=7,font=("微软雅黑", 10))
  1248.         self.Text_warehouse.place(x=12,y=30)
  1249.         tkinter.Label(self.root, text="导出地址：", font=("微软雅黑", 15)).place(x=100, y=300)
  1250.         self.leading_warehouse_Entry = tkinter.Entry(self.root, font=("微软雅黑", 15))
  1251.         self.leading_warehouse_Entry.place(x=250, y=300)
  1252.     def remove_Text_warehouse(self):
  1253.         self.Text_warehouse.delete(0.0,tkinter.END)
  1254.         self.Text_warehouse.update()
  1255.     def Warehouse_confirm(self):  #执行查询结果
  1256.         self.remove_Text_warehouse()
  1257.         def selecte_warehouse():
  1258.             try:
  1259.                 cursor = conn.cursor()
  1260.                 sql=' select commodity_name,count(*),warehouse_id from commodity GROUP BY commodity_name having ' \
  1261.                     'warehouse_id=(select warehouse_id from warehouse where warehouse_id="%s"' \
  1262.                     ' and warehouse_password="%s")'%(self.entry_warehouse.get(),self.entry_password.get())
  1263.                 cursor.execute(sql)
  1264.                 conn.commit()
  1265.                 cursor.close()
  1266.                 self.remove_Text_warehouse()
  1267.                 return cursor.fetchall()
  1268.             except:
  1269.                 pass
  1270.         if bool(selecte_warehouse())==True:
  1271.             self.Text_warehouse.insert(tkinter.INSERT, "商品名称，库存，库房号：\n")
  1272.             for i in selecte_warehouse():
  1273.                 self.Text_warehouse.insert(tkinter.INSERT,i)
  1274.                 self.Text_warehouse.insert(tkinter.INSERT,'\n')
  1275.         else:
  1276.             self.Text_warehouse.insert(tkinter.INSERT,"库房账号，或密码输入不对\n")
  1277.     def leading_out_warehouse(self):  #导出库存
  1278.         self.remove_Text_warehouse()
  1279.         try:
  1280.             def selecte_warehouse():
  1281.                 cursor = conn.cursor()
  1282.                 sql = 'select commodity_name,count(*),warehouse_id from commodity group by commodity_name having warehouse_id="%s"'%(self.entry_warehouse.get())
  1283.                 cursor.execute(sql)
  1284.                 conn.commit()
  1285.                 cursor.close()
  1286.                 return cursor.fetchall()
  1287.             if bool(selecte_warehouse())==True:
  1288.                 df=pd.DataFrame(selecte_warehouse(),columns=["商品名称","剩余数量","库房名称"])
  1289.                 df.to_excel(self.leading_warehouse_Entry.get(),index=0)
  1290.                 self.Text_warehouse.insert(tkinter.INSERT, "库存导出成功\n")
  1291.             else:self.Text_warehouse.insert(tkinter.INSERT,"请先查库存\n")
  1292.         except:
  1293.             self.Text_warehouse.insert(tkinter.INSERT,"程序运行错误：\n")
  1294. if __name__=="__main__":
  1295.     conn=pymysql.connect(   #连接MySQL
  1296.         host='localhost',   #本地服务器
  1297.         port=3306, #服务器端口
  1298.         user='root', #用户名
  1299.         password='123456',
  1300.         db='cpsim',
  1301.         charset='utf8'
  1302.         )
  1303.     global_id = 0
  1304.     The_login()
  1305.     conn.close()
  1306.  
  1307.  
  1308.  
  1309.  
  1310.  
  1311.  
  1312.  
  1313.