Q&A
できる範囲で不要なところを削ってみました
もう一度ご確認いただけないでしょうか
SQLSERVERよりSQLにて情報を取り出しております
import tkinter as tk
from tkinter import ttk
from tkcalendar import DateEntry
import pyodbc
import datetime, jpholiday
import tkinter.filedialog
DRIVER = '{SQL Server}'
SQL_SERVER = 'SV03'
PORT = 3306
DB_NAME = 'Test'
TABLE_NAME = '[Test].[dbo].[Tr_Slip_table]'
USER = ''
PASSWORD = ''
TRUSTED_CONNECTION = 'yes'
def login():
global cursor
cmd = f'DRIVER={DRIVER};SERVER={SQL_SERVER};DATABASE={DB_NAME};PORT={PORT};'
print("cmd")
if USER:
cmd += f'USER={USER};'
if PASSWORD:
cmd += f'PASSWORD={PASSWORD};'
if TRUSTED_CONNECTION:
cmd += f'Trusted_Connection={TRUSTED_CONNECTION};'
try:
connect = pyodbc.connect(cmd, charset='utf8')
except pyodbc.Error:
return False
cursor = connect.cursor()
return True
def open_tree():
global tree
global Name
global dst
global ded
global open_form_window
sql = f"SELECT [Id],FORMAT([希望納期],'yyyy/MM/dd') FROM [Test].[dbo].[Tr_Slip_table]; "
open_form_window = tk.Toplevel()
open_form_window.title('納期一覧')
open_form_window.configure(bg='khaki')
open_form_window.overrideredirect(True)
root_x, root_y = root.winfo_x(), root.winfo_y()
open_form_window.geometry(f'450x240+{root_x - 0}+{root_y - 240}')
print(root.__dict__)
form = ttk.Frame(open_form_window)
new_frame1 = tk.Frame(open_form_window, bg='khaki', pady=2)
new_frame1.pack(fill='both', expand=True)
form.pack()
open_form_window.attributes("-topmost", True)
tree = ttk.Treeview(open_form_window)
tree["columns"] = (1, 2)
tree["show"] = "headings"
tree["displaycolumns"] = [1, 2]
tree.column(1, width=40, anchor=tk.CENTER)
tree.column(2, width=50, anchor=tk.E)
tree.heading(1, text="製番")
tree.heading(2, text="希望納期")
tree.pack(padx=(5,5), pady=(5,5), fill='both', expand=True)
# TreeViewのデータをクリア
for item in tree.get_children():
tree.delete(item)
for row in cursor.execute(sql):
row = list(row)
tree.insert("", "end", values=row)
tree.bind('<Double-1>', getVule)
def getVule(event):
selected_items = tree.selection()
if not selected_items:
return
values = tree.item(selected_items[0], 'values')
with open('log.txt', 'a') as f:
print(values, file=f)
global open_form_window2
global nouki1
global label12
global entry31
if open_form_window2: open_form_window2.destroy()
open_form_window2 = tk.Toplevel()
open_form_window2.title('納期変更')
open_form_window2.configure(bg='khaki')
open_form_window2.overrideredirect(True)
root_x, root_y = root.winfo_x(), root.winfo_y()
open_form_window2.geometry(f'450x80+{root_x - 0}+{root_y - 325}')
print(root.__dict__)
form = ttk.Frame(open_form_window2)
new_frame2 = tk.Frame(open_form_window2, bg='khaki', pady=2)
label11 = tk.Label(new_frame2, text="製番", font=("", 9), fg='black', bg="antique white", height=1, width=8)
label12 = tk.Label(new_frame2, text=values[0], font=("", 10), fg='black', bg="antique white", height=1, width=8)
button2 = tk.Button(new_frame2, text="上書き", font=("", 10), width=8, bg="#e6e6fa", command=update_nouki)
label11.pack(side=tk.LEFT, padx=2)
label12.pack(side=tk.LEFT, padx=2)
button2.pack(side=tk.RIGHT, expand=None, padx=5)
new_frame2.pack(fill='both', expand=None)
new_frame3 = tk.Frame(open_form_window2, bg='khaki', pady=5)
label21 = tk.Label(new_frame3, text="希望納期", font=("", 9), fg='black', bg="antique white", height=1, width=11)
label21.pack(side=tk.LEFT, padx=15)
new_frame3.pack(fill='both', expand=None)
# カレンダーのスタイル
style = ttk.Style()
style.theme_use('clam')
style.configure('my.DateEntry',
fieldbackground='light green',
background='dark green',
foreground='black',
arrowcolor='white')
root.data_entry_date = DateEntry(style='my.DateEntry', showweeknumbers=False)
root.data_entry_date.place(x=250, y=230)
root.calender_date = DateEntry(showweeknumbers=False)
root.calender_date.place(x=500, y=230)
root.calender_date.pack()
new_frame4 = tk.Frame(open_form_window2, bg='khaki', pady=0)
entry31 = DateEntry(new_frame4, style='my.DateEntry', showweeknumbers=False, locale='ja_JP.UTF-8', width=11)
entry31.pack(side=tk.LEFT, padx=15)
new_frame4.pack(fill='both', expand=None)
form.pack()
open_form_window2.attributes("-topmost", True)
entry31.delete(0, "end")
if uwagaki == 0:
entry31.insert(0, values[1])
else:
entry31.insert(0, nouki1)
def update_nouki():
global nouki1
global uwagaki
idno = label12.cget("text")
if entry31 is None:
entry31.delete()
else:
dl1 = entry31.get_date()
sql = f"UPDATE [Test].[dbo].[Tr_Slip_table] SET [希望納期] = '{dl1}' WHERE [Id]={idno};"
res = tkinter.messagebox.askyesnocancel(title="上書き確認", message="表示の内容で更新します。納期情報を残しておきますか？")
print(res)
if res == True:
cursor.execute(sql)
cursor.commit()
nouki1 = entry31.get_date()
uwagaki = 1
open_tree()
elif res == False:
cursor.execute(sql)
cursor.commit()
nouki1 = ""
uwagaki = 0
open_tree()
else: tkinter.messagebox.showinfo(title="取り消し", message="処理を取り消しました")
def is_holiday_or_weekend(date):
return date.weekday() == 6 or date.weekday() == 5 or jpholiday.is_holiday(date)
def close_tree():
global open_form_window
if open_form_window: open_form_window.destroy()
open_form_window = None
open_form_window2 = None
root = tk.Tk()
root.title("納期変更アプリ")
root.geometry("450x40")
root.geometry('+1300+900')
root.configure(bg='khaki1')
root.overrideredirect(True)
frame1 = tk.Frame(root, pady=5, padx=5, relief=tk.RAISED, bd=2, bg='khaki')
label1 = tk.Label(frame1, text="納期変更ｱﾌﾟﾘ", font=("", 10), fg='black', bg="antique white", height=1, width=12)
button1 = tk.Button(frame1, text="読込", font=("", 10), width=8, bg="#e6e6fa", command=open_tree)
button3 = tk.Button(frame1, text="×", font=("", 8, "bold"), width=1, fg='white', bg='red', command=root.destroy)
label1.pack(side=tk.LEFT)
button1.pack(side=tk.LEFT, expand=True)
button3.pack(side=tk.RIGHT)
frame1.pack(fill=tk.BOTH, expand=True)
nouki1 = ""
uwagaki = 0
if login():
root.attributes("-topmost", True)
else:
root.title("納期変更アプリ(接続エラー)")
button1['state'] = 'disabled'
button2['state'] = 'disabled'
root.mainloop()
ベストアンサー
