import winsound
import xlwt
import pymssql
import tkinter as tk
window = tk.Tk()
window.title('my window')
window.geometry('300x300')
e = tk.Entry(window, show=None)
e.pack()
def set_style(name, height, bold=False):
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = name
font.bold = bold
font.color_index = 4
font.height = height
style.font = font
return style
def write_excel(d):
f = xlwt.Workbook()
sheet1 = f.add_sheet('学生',cell_overwrite_ok=True)
row0 = ["id","username","age"]
#写第一行
for i in range(0,len(row0)):
sheet1.write(0,i,row0[i],set_style('Times New Roman',220,True))
#从第二行开始写从数据库里面捞出来的数据
for i in range(0,len(d)):
for m in range(0, len(d[i])):
sheet1.write(i + 1, m, d[i][m], set_style('Times New Roman', 220, True))
f.save('D:/'+tt+'.xls',)
global Mes1
Mes1 = None
def insert_point():
conn = pymssql.connect('host="11223";user="ddd";password=r"ddd!"";database=r"NS"')
cur = conn.cursor()
if cur:
print(1)
global tt
tt=e.get()
if e.get()=='':
show_eff(False)
else:
cur.execute("select 'OptoLux Lower Console Assembly', c.value,SUBSTRING(b.PartNumber,charindex('08',b.PartNumber),17)aa,a.ChildSerialNumber,b.Description ,a.InsertedTime,e.EnterTime from ffUnitComponent a inner join ffPart b on a.ChildPartID =b.id inner join ffSerialNumber c on a.unitid=c.UnitID inner join ffSerialNumber d on a.ChildUnitID=d.UnitID inner join ffHistory e on a.UnitID=e.UnitID where c.Value=%s and( b.PartNumber like 'KSIH-08888-1325-000-__'or b.PartNumber like 'KSIH-PCBA-08895-4019-000-__'or b.PartNumber like 'KSIH-08888-1230-000-%' or b.PartNumber like 'KSIH-08888-1010-000-%' or b.PartNumber like 'KSIH-PCBA-08895-4000-000-%'or b.PartNumber like 'KSIH-PCBA-08895-4214-000-%'or b.PartNumber like 'KSIH-PCBA-08895-4032-000-%'or b.PartNumber like 'KSIH-PCBA-08895-4305-A00-%'or b.PartNumber like 'KSIH-PCBA-08895-4166-000-%'or b.PartNumber like 'KSIH-PCBA-08895-4002-000-%'or b.PartNumber like 'KSIH-PCBA-08991-4214-000-%'or b.PartNumber like 'KSIH-PCBA-08895-4020-000-%'or b.PartNumber like 'KSIH-PCBA-08890-4272-000-%'or b.PartNumber like 'KSIH-PCBA-08890-4168-000-%'or b.PartNumber like 'KSIH-08891-1326-000-%')and e. UnitStateID=23 order by b.PartNumber desc", (e.get()))
data = cur.fetchall()
if len(data) !=0:
t = []
d = []
for i in range(len(data)):
t.append(data[i][0])
t.append(data[i][1].rstrip())
t.append(data[i][2])
d.append(t)
t = []
write_excel(d)
cur.close()
show_eff(True)
else:
show_eff(False)
def show_eff(e):
global Mes1
if Mes1 is None:
Mes1 = tk.Message(text = 'OK' if e else 'Fail', width = 60)
Mes1.pack()
else:
Mes1.pack_forget()
Mes1 = tk.Message(text = 'OK' if e else 'Fail', width = 60)
Mes1.pack()
if e==False:
winsound.Beep(900, 1000)
def windowset():
b1 = tk.Button(window, text='insert point', width=15,
height=2, command=insert_point)
b1.pack()
window.mainloop()
windowset()
