实训教学管理系统报告模板.doc

实训报告实训项目名称实训教学管理系统编号专业软件技术班级软件技术501学号2007010110姓名黎世保成绩指导教师刘英、洪秀金时间实训目的及要求1. 培养学生团队合作意识；2. 培养学生专业实践能力；3. 培养学生分析问题、解决问题能力；4. 培养学生严谨的工作态度和良好的工作习惯。实训内容描述针对我院软件实训教学需要，编写一个实训教学管理系统。完成实训教学工作安排、实训教学资料管理、实训考勤管理、实训成绩评定等功能。采用VS2010+SQL SERVER2005平台设计开发。实训方法与步骤一、 登录模块1、 教师用户；2、 管理员用户；3、 学生用户。二、 实训教学工作安排模块1、 实训学生管理；2、 实训教师管理；3、 实训班级管理；4、 实训场所管理；5、 实训教学安排。三、 实训教学资料管理模块1、 教师实训方案上传；2、 学生实训资料上传。四、 实训考勤管理1、 考勤参数设定；2、 学生考勤签到；3、 考勤情况查询。五、 实训成绩评定模块1、 实训成绩录入；2、 实训成绩查询。六、 扩展功能模块此处填写个人实训操作步骤如下是个人实训步骤 小组讨论安排个人任务教学安排（tr_teaching）备注字段名字段类型长度是否PK是否unll教学安排编号(递增)tea_IDint4PK否实训项目编号pro_IDint4FK否教室编号pla_IDint4FK否教师编号tch_IDvarchar10FK否班级编号cls_IDvarchar10FK否开始时间pla_Stimedatetime否结束时间pla_Ntimedatetime否附件（tr_attachment）备注字段名字段类型长度是否PK是否unll附件编号(递增)atta_IDint4PK否附近地址tach_Addressvarchar200否备注atta_Remarksvarchar100教师方案表（t_scheme）备注字段名字段类型长度是否PK是否unll方案编号(递增)sch_IDint4PK否实训项目编号pro_IDint4FK否教师编号tch_IDvarchar10FK否班级编号cls_IDvarchar10FK否附件编号adda_IDint4FK否上传时间sch_Time datetime否实训结果分析与结论此处填写实训结果（可用图或文字说明等表述）实现结果。如下（图2-1）数据库表（图2-1）1 创建数据库视图。如下（图2-2)视图（图2-2）个人收获及体会主要代码清单此处填写重要代码清单（附注释）如下视图表代码：-视图表-CREATE view v_specialty -专业视图 WITH SCHEMABINDING -指定这个AS SELECT a.spe_ID,a.spe_Name,b.dep_Name,a.spe_Remarks FROM dbo.t_specialty a, dbo.t_department b -必须指定架构. WHERE a.dep_ID = b.dep_ID;GOCREATE view v_class -班级视图 WITH SCHEMABINDING -指定这个AS SELECT a.cls_ID,a.cls_Name,b.dep_Name,c.spe_Name,a.cls_Grade,a.cls_Remarks FROM dbo.t_class a, dbo.t_department b, dbo.t_specialty c -必须指定架构. WHERE a.dep_ID = b.dep_ID and a.spe_ID = c.spe_ID;GOCREATE view v_teacher -教师视图 WITH SCHEMABINDING -指定这个AS SELECT a.tch_ID,a.tch_Name,a.tch_Pwd,a.tch_Sex,a.tch_Nation,a.tch_Xueli,b.dep_Name,a.tch_Teaching,a.tch_school,a.tch_BithPlace,a.tch_Photo,a.tch_Political,a.tch_No,a.tch_Speciaty,a.tch_Phone,a.tch_PronaTits,a.tch_Email,a.tch_QQ,a.tch_Address,a.tch_Remarks FROM dbo.t_teacher a, dbo.t_department b -必须指定架构. WHERE a.dep_ID = b.dep_IDGOCREATE view v_student -学生视图 WITH SCHEMABINDING -指定这个AS SELECT a.stu_ID,a.stu_Name,a.stu_Pwd,a.stu_Sex,a.stu_Nation,b.dep_Name,c.spe_Name,d.cls_Name,a.stu_Photo,a.stu_Time,a.stu_No,a.stu_System,e.stua_Type,a.stu_BithDay,a.stu_Rxsj,a.stu_BithPlace,a.stu_Political,a.stu_Phone,a.stu_Email,a.stu_QQ,a.stu_Postal,a.stu_Remarks FROM dbo.t_student a,dbo.t_department b,dbo.t_specialty c,dbo.t_class d,dbo.tr_stuation e -必须指定架构. WHERE a.dep_ID = b.dep_ID and a.spe_ID=c.spe_ID and a.cls_ID=d.cls_ID and a.stua_ID=e.stua_IDGOCREATE view v_project -实训项目视图 WITH SCHEMABINDING -指定这个ASSELECT _ID,_Name,_Type,_Cpe,b.tch_Name,_Stime,_NtimeFROM dbo.t_project a,dbo.t_teacher bWHERE a.tch_ID = b.tch_IDGOCREATE view v_achievement -学生成绩视图 WITH SCHEMABINDING -指定这个ASSELECT a.ach_ID,b.stu_Name,c.tch_Name,_Name,e.cls_Name,a.ach_Time,a.ach_Usually,a.ach_Training,a.ach_Grade,a.ach_EvaluationFROM dbo.t_achievement a,dbo.t_student b,dbo.t_teacher c,dbo.t_project d,dbo.t_class eWHERE a.stu_ID = b.stu_ID and a.tch_ID = c.tch_ID and _ID = _ID and a.cls_ID = e.cls_IDGOCREATE view v_teaching -教学安排视图 WITH SCHEMABINDING -指定这个ASSELECT a.tea_ID,_Name,e.pla_Number,e.pla_Name,c.tch_Name,b.cls_NameFROM dbo.tr_teaching a,dbo.t_class b,dbo.t_teacher c,dbo.t_project d,dbo.t_place eWHERE a.cls_ID = b.cls_ID and a.tch_ID = c.tch_ID and _ID = _ID and a.pla_ID = e.pla_IDGOCREATE view v_scheme -教师方案视图 WITH SCHEMABINDING -指定这个ASSELECT a.sch_ID,_Name,c.tch_Name,b.cls_Name,e.atta_Address,a.sch_Time FROM dbo.t_scheme a,dbo.t_class b,dbo.t_teacher c,dbo.t_project d,dbo.tr_attachment eWHERE a.cls_ID = b.cls_ID and a.tch_ID = c.tch_ID and _ID = _ID and a.atta_ID = e.atta_IDGOCREATE view v_share -学生共享资源视图 WITH SCHEMABINDING -指定这个ASSELECT a.sha_ID,b.stu_Name,c.atta_Address,a.sha_Time FROM dbo.tr_share a,dbo.t_student b,dbo.tr_attachment cWHERE a.stu_ID = b.stu_ID and a.atta_ID = c.atta_IDGOCREATE view v_studentatt -学生考勤视图 WITH SCHEMABINDING -指定这个ASSELECT a.stua_ID,b.cls_Name,d.stu_Name,c.tch_Name,_Name,a.stua_Late,a.stua_Gtw,a.stua_Gow,a.stua_LeaveFROM dbo.tr_studentatt a,dbo.t_class b,dbo.t_teacher c,dbo.t_student d,dbo.t_project eWHERE a.cls_ID = b.cls_ID and a.tch_ID = c.tch_ID and a.stu_ID = d.stu_ID and _ID = _IDGOCREATE view v_teacheratt -教师考勤视图 WITH SCHEMABINDING -指定这个ASSELECT a.tcat_ID,b.dep_Name,d.tch_Name,c.cls_Name,_Name,a.tcat_Late,a.tcat_Gtw,a.tcat_Gow,a.tcat_LeaveFROM dbo.tr_teacheratt a,dbo.t_department b,dbo.t_class c,dbo.t_teacher d,dbo.t_project eWHERE a.dep_ID = b.dep_ID and a.cls_ID = c.cls_ID and a.tch_ID = d.tch_ID and _ID = _IDGO/*-/ Copyright (C) 2011 07软件501 动感超人小组/ 版权所有。 / 文件名：t_Class.cs/ 文件功能描述：班级表实体类/ 创建标识：linyinli 20111109/-*/using System;using System.Collections.Generic;using System.Text;namespace Maticsoft.DM / / 班级类 / Serializablepublic class t_Class private string _cls_ID;/班级编号 private string _cls_Name;/班级名称 private string _dep_ID;/系部编号 private string _spe_ID;/专业编号 private DateTime _cls_Grade;/年级 private string _cls_Remarks;/备注 public string cls_ID get return _cls_ID; set _cls_ID = value; public string cls_Name get return _cls_Name; set _cls_Name = value; public string dep_ID get return _dep_ID; set _dep_ID = value; public string spe_ID get return _spe_ID; set _spe_ID = value; public DateTime cls_Grade get return _cls_Grade; set _cls_Grade = value; public string cls_Remarks get return _cls_Remarks; set _cls_Remarks = value; 如下教师安排表：/*-/ Copyright (C) 2011 07软件501 动感超人小组/ 版权所有。 / 文件名：tr_Teaching.cs/ 文件功能描述：用户表实体类/ 创建标识：linyinli 20111109/-*/using System;using System.Collections.Generic;using System.Text;namespace Maticsoft.DM / / 用户类 / Serializablepublic class tr_Teaching private int _tea_ID;/教学安排编号 private int _pro_ID;/实训项目编号 private string _pla_ID;/教室编号 private string _tch_ID;/教师编号 private string _cls_ID;/班级编号 private DateTime _pla_Stime;/开始时间 private DateTime _pla_Ntime;/结束时间 public int tea_ID get return _tea_ID; set _tea_ID = value; public int pro_ID get return _pro_ID; set _pro_ID = value; public string pla_ID get return _pla_ID; set _pla_ID = value; public string tch_ID get return _tch_ID; set _tch_ID = value; public string cls_ID get return _cls_ID; set _cls_ID = value; public DateTime pla_Stime get return _pla_Stime; set _pla_Stime = value; public DateTime pla_Ntime get return _pla_Ntime; set _pla_Ntime = value; 如下附件表:/*-/ Copyright (C) 2011 07软件501 动感超人小组/ 版权所有。 / 文件名：tr_Attachment.cs/ 文件功能描述：附件表实体类/ 创建标识：linyinli 20111109/-*/using System;using System.Collections.Generic;using System.Text;namespace Maticsoft.DM / / 附件类 / Serializablepublic class tr_Attachment private int _atta_ID;/附件编号 private string _atta_Address;/附近地址 private string _atta_Remarks;/备注 public int atta_ID get return _atta_ID; set _atta_ID = value; public string atta_Address get return _atta_Address; set _atta_Address = value; public string atta_Remarks get return _atta_Remarks; set _atta_Remarks = value; 如下教师方案表:/*-/ Copyright (C) 2011 07软件501 动感超人小组/ 版权所有。 / 文件名：t