python实验报告_Python项目：实验报告发放台账信息管理系统

# laboratory_info.py

# 实验报告发放台账信息管理项目，要求带操作界面，并完成每项操作：

# ＋－－－－－－－－－－－－－－－－－－－－－－＋

# ｜　１）添加实验报告发放台账信息　　　　　　　　　　 ｜

# ｜　２）显示所有实验报告发放台账的信息　　　　　　　 ｜

# ｜　３）删除实验报告发放台账信息　　　　　　　　　　 ｜

# ｜　４）修改实验报告发放台账信息　　　　　　　　　　 ｜

# ｜ 5）保存实验报告发放台账信息到文件（laboratory.xls) ｜

# ｜ 6）从文件中读取实验报告发放台账信息（laboratory.xls)｜

# ｜ 退出：其他任意按键＜回车＞ ｜

# ＋－－－－－－－－－－－－－－－－－－－－－－＋

def menu():

menu_info = '''＋－－－－－－－－－－－－－－－－－－－－－－＋｜ １）添加实验报告发放台账信息 ｜｜ ２）显示所有实验报告发放台账的信息 ｜｜ ３）删除实验报告发放台账信息 ｜｜ ４）修改实验报告发放台账信息 ｜｜ ５）保存实验报告发放台账信息到文件（laboratory.xls)｜｜ ６）从文件中读取发放台账信息（laboratory.xls) ｜｜ 退出：其他任意按键＜回车＞ ｜＋－－－－－－－－－－－－－－－－－－－－－－＋'''

print(menu_info)

# １）添加实验报告发放台账信息

def add_laboratory_info():

L = []

while True:

Tn = input("请输入试验编号：")

if not Tn: # 试验编号为空　跳出循环

break

try:

on = int(input("请输入序号："))

tn = int(input("请输入试品编号："))

tpn = input("请输入试品名称：")

tt = input("请输入试品型号：")

rtd = input("请输入要求试验部门：")

c = input("请输入委托人：")

la = input("请输入实验员：")

rcd = int(input("请输入要求完成日期："))

acd = int(input("请输入实际完成日期："))

ec = input("请输入实验结论：")

doior = int(input("请输入报告发放日期："))

s = input("请输入接收人：")

r = input("请输入备注：")

except:

print("输入无效．．．．重新录入信息")

continue

info = {"Testnumber":Tn,"ordernumber":on,"testnumber":tn,"testproductname":tpn,"testtype":tt,"requiredtestdepartment":rtd,"client":c,"labassistant":la,"requestcompletiondate":rcd,"actualcompletiondate":acd,"experimentalconclusion":ec,"dateofissuanceofreport":doior,"sendee":s,"remark":r}

L.append(info)

print("实验报告发放台账信息录入完毕！！！")

return L

# ２）显示所有实验报告发放台账的信息

def show_laboratory_info(laboratory_info):

if not laboratory_info:

print("无数据信息．．．．．")

return

print("试验编号".center(8),"序号".center(8),"试品编号".center(8),"试品名称".center(8),"试品型号".center(8),"要求试验部门".center(8),"委托人".center(8),"实验员".center(8),"要求完成日期".center(8),"实际完成日期".center(8),"实验结论".center(8),"报告发放日期".center(8),"接收人".center(8),"备注".center(8))

for info in laboratory_info:

print(info.get("Testnumber").center(10),str(info.get("ordernumber")).center(10),str(info.get("testnumber")).center(10),str(info.get("testproductname")).center(10),str(info.get("testtype")).center(10),str(info.get("requiredtestdepartment")).center(10),str(info.get("client")).center(10),str(info.get("labassistant")).center(10),str(info.get("requestcompletiondate")).center(10),str(info.get("actualcompletiondate")).center(10),str(info.get("experimentalconclusion")).center(10),str(info.get("dateofissuanceofreport")).center(10),str(info.get("sendee")).center(10),str(info.get("remark")).center(10))

# ３）删除实验报告发放台账信息

def del_laboratory_info(laboratory_info,del_Testnumber = ''):

if not del_Testnumber:

del_Testnumber = input("请输入删除的试验编号：")

for info in laboratory_info:

if del_Testnumber == info.get("Testnumber"):

return info

raise IndexError("实验报告发放台账信息不匹配,没有找到%s" %del_Testnumber)

# ４）修改实验报告发放台账信息

def mod_laboratory_info(laboratory_info):

mod_Testnumber = input("请输入修改的试验编号：")

for info in laboratory_info:

if mod_Testnumber == info.get("Testnumber"):

Tn = input("请输入试验编号：")

on = int(input("请输入序号："))

tn = int(input("请输入试品编号："))

tpn = input("请输入试品名称：")

tt = input("请输入试品型号：")

rtd = input("请输入要求试验部门：")

c = input("请输入委托人：")

la = input("请输入实验员：")

rcd = int(input("请输入要求完成日期："))

acd = int(input("请输入实际完成日期："))

ec = input("请输入实验结论：")

doior = int(input("请输入报告发放日期："))

s = input("请输入接收人：")

r = input("请输入备注：")

info = {"Testnumber":Tn,"ordernumber":on,"testnumber":tn,"testproductname":tpn,"testtype":tt,"requiredtestdepartment":rtd,"client":c,"labassistant":la,"requestcompletiondate":rcd,"actualcompletiondate":acd,"experimentalconclusion":ec,"dateofissuanceofreport":doior,"sendee":s,"remark":r}

return info

raise IndexError("实验报告发放台账信息不匹配,没有找到%s" %mod_Testnumber)

# 5）保存实验报告发放台账信息到文件（laboratory.xls)

def save_info(laboratory_info):

try:

laboratory_xls = open("laboratory.xls","w") # 以写模式打开，并清空文件内容

except Exception as e:

laboratory_xls = open("laboratory.xls", "x") # 文件不存在，创建文件并打开

for info in laboratory_info:

laboratory_xls.write(str(info)+"\n") # 按行存储，添加换行符

laboratory_xls.close()

# 6）从文件中读取数据（laboratory.xls)

def read_info():

old_info = []

try:

laboratory_xls = open("laboratory.xls")

except:

print("暂未保存数据信息") # 打开失败，文件不存在说明没有数据保存

return

while True:

info = laboratory_xls.readline()

if not info:

break

# print(info)

info = info.rstrip() #　去掉换行符

# print(info)

info = info[1:-1] # 去掉｛｝

# print(info)

laboratory_dict = {} # 单个实验报告字典信息

for x in info.split(","): # 以，为间隔拆分

# print(x)

key_value = [] # 开辟空间，key_value[0]存key,key_value[0]存value

for k in x.split(":"): # 以：为间隔拆分

k = k.strip() #　去掉首尾空字符

# print(k)

if k[0] == k[-1] and len(k) > 2: # 判断是字符串还是整数

key_value.append(k[1:-1]) # 去掉　首尾的＇

else:

key_value.append(int(k))

# print(key_value)

laboratory_dict[key_value[0]] = key_value[1] # 实验报告发放台账信息添加

# print(laboratory_dict)

old_info.append(laboratory_dict) # 所有实验报告发放台账信息汇总

laboratory_xls.close()

return old_info

def main():

laboratory_info = []

while True:

# print(laboratory_info)

menu()

number = input("请输入选项：")

if number == '1':

laboratory_info = add_laboratory_info()

elif number == '2':

show_laboratory_info(laboratory_info)

elif number == '3':

try:

laboratory_info.remove(del_laboratory_info(laboratory_info))

except Exception as e:

# 试验编号不匹配

print(e)

elif number == '4':

try:

laboratory = mod_laboratory_info(laboratory_info)

except Exception as e:

# 试验编号不匹配

print(e)

else:

# 首先按照根据输入信息的试验编号，从列表中删除该实验报告发放台账信息，然后重新添加该实验报告发放台账最新信息

laboratory_info.remove(del_laboratory_info(laboratory_info,del_Testnumber = laboratory.get("Testnumber")))

laboratory_info.append(laboratory)

elif number == '5':

save_info(laboratory_info)

elif number == '6':

laboratory_info = read_info()

else:

break

input("回车显示菜单")

main()