基于C#的体育选课管理系统的设计与实现

基于C#的体育选课管理系统的设计与实现,DesignandImplementationofP.E.CurriculumElectiveManagementSystemBasedonC#,专业:计算机科学与技术,学号:051201065,姓名:左彪,导师:徐英杰工程师,1,2,3,4,课题研究背景与意义,开发环境与主要技术,主要工作,系统设计,自述内容,5,功能展示,6,结论,2020/6/12,左彪,1.1研究背景,1,传统的体育选课管理模式已无法满足当前体育教学管理实际需求,2020/6/12,左彪,1.2研究意义,1,实现对体育选课信息的统一有效管理,2020/6/12,左彪,2020/6/12,左彪,2开发环境与主要技术,Oracle数据库,Microsoftvisualstudio2005,C#语言,ADO.NET数据访问技术,三层架构设计模型,3主要工作,Client,BLL,DAL,窗体类FrmLoginFrmMainFrmAddScoreFrmApplyStatisticFrmApplyTimeSettingFrmAthletesAddScoreFrmAthletesManageFrmBranchDeptSettingFrmBrowseApplyResultFrmBrowseSchedulesFrmFranchiseApply,业务实体类AddAthletesLoginApplyResultYYDProjectsTermsStudentsPhyTasksPhySchedulePhyProjectsAddAthletesCouseBranch,数据库访问类OrancleDataBase,问题空间与解空间结构一致,三层架构设计模型,2020/6/12,左彪,4.1数据库设计,标准数据表,自建数据表,数据表,qhdb.ty_ksxm,qhdb.base_department,qhdb.ty_kcrw,qhdb.tyxk_student,qhdb.base_major,qhdb.base_class,Oracle数据库,2020/6/12,左彪,4.2功能模块设计,沈阳工业大学体育选课管理系统,开设项目管理,校区学院年级设置,查看体育排课情况,教学任务管理,选课时间设定,查看选课结果,选课结果统计,学生特权选课,查看未选课学生信息,成绩录入,按课程成绩查看,运动员类型查看,运动员管理,运动队管理,运动员加分管理,密码修改,登陆,课程管理,选课管理,成绩管理,运动员管理,按学院成绩查看,2020/6/12,左彪,5功能展示(1),课程任务管理窗体,自定义方法WorkStateStateswitch(value)caseWorkState.wsBrowse:dgvTasks.Enabled=true;tlStrip.Enabled=true;grpTaskInfo.Enabled=false;break;caseWorkState.wsAppend:caseWorkState.wsModify:dgvTasks.Enabled=false;tlStrip.Enabled=false;grpTaskInfo.Enabled=true;break;,stringtaskID=DAL.DataBase.ExecuteScaler(selectmax(KCRWNO)FROMQHDB.TY_KCRW).ToString();taskID=(int.Parse(taskID)+1).ToString();DAL.DataBase.ExecuteNonQuery(insertintoQHDB.TY_KCRW(KCRWNO,YEARTERMNAME,COUSENO,TIMENO,NUMMAX,BRANCHNO)+VALUES(+taskID+,+term+,+aProjectID+,+aSectionID+,+aThreshold+,+branchNO+);,2020/6/12,左彪,privatevoidFrmTaskManage_Load(objectsender,EventArgse)ListallTerms=BLL.Terms.GetAllTerms();foreach(stringitminallTerms)tlsCboTerm.Items.Add(itm);ListallBranches=BLL.Branches.GetAllBranches();foreach(stringitminallBranches)tlsCboBranches.Items.Add(itm);dgvTasks.AutoGenerateColumns=false;,5功能展示(1),课程任务管理窗体窗体类关键代码,2020/6/12,左彪,classTermsstaticpublicListGetAllTerms()tryListrstList=newList();DataTabledtTerms=DAL.DataBase.SelectDataTable(selectdistinctEARTERMNAMEfromQHDB.Base_YearTermorderbyYEARTERMNAMEdesc,false);foreach(DataRowrowindtTerms.Rows)rstList.Add(row0.ToString();dtTerms.Dispose();returnrstList;catchthrow;,5功能展示(1),课程任务管理窗体业务实体类关键代码,2020/6/12,左彪,5功能展示(1),课程任务管理窗体数据访问类关键代码,publicstaticDataTableSelectDataTable(stringSqlString,boolfillSchema)conn=GetConnection();conn.Open();DataTabledt=newDataTable();tryOracleDataAdapteradapter=newOracleDataAdapter(SqlString,conn);if(fillSchema)adapter.FillSchema(dt,SchemaType.Source);adapter.Fill(dt);conn.Close();catch(Exceptionex)conn.Close();throwex;returndt;,2020/6/12,左彪,5功能展示(2),查看未选课学生窗体,2020/6/12,左彪,privatevoidtlBtnLoadData_Click(objectsender,EventArgse)if(tlsCboTerm.Text=)MessageBox.Show(MyResource.noTerm,错误,MessageBoxButtons.OK,MessageBoxIcon.Error);return;dgvUnAplStudents.DataSource=BLL.Students.UnApplyStudents(tlsCboTerm.Text);stalblCount.Text=dgvUnAplStudents.RowCount.ToString()+人未选课;if(dgvUnAplStudents.RowCount=0)MessageBox.Show(MyResource.NoRecord,提示,MessageBoxButtons.OK,MessageBoxIcon.Information);,5功能展示(2),查看未选课学生窗体-窗体类关键代码,2020/6/12,左彪,staticclassStudentsstaticpublicDataTableUnApplyStudents(stringaTerm)DAL.DataBase.ExecuteSqlTransaction(newstring1deleteqhdb.ty_xkcjwhereSTUDENTNOisnull);returnDAL.DataBase.SelectDataTable(selectstudentno,studentname,classname,deptname,coursename,d.timenamefromqhdb.tyxk_studentc,qhdb.ty_timed+wherec.STUDENTNOnotin(selecta.STUDENTNOfromqhdb.tyxk_studenta,qhdb.ty_xkcjb+wherea.STUDENTNO=b.studentnoanda.YEARTERMNAME=b.yeartermname)+andc.timeno=d.timenoandc.yeartermname=+aTerm+orderbyc.STUDENTNO,false);,查看未选课学生窗体-业务实体类关键代码,5功能展示(2),2020/6/12,左彪,publicstaticvoidExecuteSqlTransaction(stringSqlStrings)conn=GetConnection();conn.Open();OracleCommandcommand=conn.CreateCommand();OracleTransactiontransaction=conn.BeginTransaction();command.Connection=conn;command.Transaction=transaction;tryfor(inti=0;iSqlStrings.Length;i+)command.CommandText=SqlStringsi;command.ExecuteNonQuery();transaction.Commit();catch(Exceptionex)transaction.Rollback();throwex;finallyconn.Close();,5功能展示(2),查看未选课学生窗体数据访问类关键代码,2020/6/12,左彪,5功能展示(3),选课报名结果统计窗体,2020/6/12,左彪,5功能展示(4),特权选课窗体,2020/6/12,左彪,5功能展示(5),报名时间设定窗体,2020/6/12,左彪,privateBLL.ApplyTimecurAppTime=newTYXK.BLL.ApplyTime();privatevoidFrmApplyTimeSetting_Load(objectsender,EventArgse)ListallTerms=BLL.Terms.GetAllTerms();foreach(stringitminallTerms)tlsCboTerm.Items.Add(itm);if(curAppTime.IsEmpty)tlsCboTerm.Text=;dtpBegin.Value=DateTime.Now;dtpEnd.Value=DateTime.Now;elsetlsCboTerm.Text=curAppTime.Term;dtpBegin.Value=Convert.ToDateTime(curAppTime.BeginTime);dtpEnd.Value=Convert.ToDateTime(curAppTime.EndTime);,5功能展示(5),报名时间设定窗体-窗体类关键代码,2020/6/12,左彪,publicboolReset(stringaTerm,stringaBegin,stringaEnd)stringcmds=newstring2;cmds0=deletefromQHDB.TY_XKCS;cmds1=insertintoQHDB.TY_XKCSvalues(+aTerm+,to_date(+aBegin+,yyyy-mm-ddhh24:mi:ss),to_date(+aEnd+,yyyy-mm-ddhh24:mi:ss);DAL.DataBase.ExecuteSqlTransaction(cmds);returntrue;,报名时间设定窗体业务实体类关键代码,5功能展示(5),2020/6/12,左彪,5功能展示(6),运动队管理窗体,2020/6/12,左彪,privatevoidbtnSave_Click(objectsender,EventArgse)if(ws=WorkState.wsAppend)if(prj.MyIsExisted(txtNo.Text)MessageBox.Show(MyResource.prjIDExisted,错误,MessageBoxButtons.OK,MessageBoxIcon.Error);return;elseprj.AddProject(txtNo.Text,txtMovementsName.Text,cobMovementType.Text);elseif(ws=WorkState.wsModify)prj.ModiProjectInfo(txtNo.Text,txtMovementsName.Text,cobMovementType.Text);State=WorkState.wsBrowse;dgvMovements.DataSource=prj.GetYYDProjects();State=WorkState.wsBrowse;,运动队管理窗体-窗体类关键代码,5功能展示(6),2020/6/12,左彪,publicboolMyIsExisted(objectprjNO)DataTabledt=DAL.DataBase.SelectDataTable(selectcount(*)fromQHDB.TY_YYDwhereyydno=+prjNO+,false);Stringtmp=;foreach(DataRowrowindt.Rows)tmp=row0.ToString();if(tmp.Equals(0)returnfalse;returntrue;publicboolAddProject(stringprjNO,stringprjName,stringprjDesc)tryDAL.DataBase.ExecuteNonQuery(insertintoqhdb.ty_yydvalues(+prjNO+,+prjName+,+prjDesc+);returntrue;catchthrow;,运动队管理窗体业务实体类关键代码,5功能展示(6),2020/6/12,左彪,publicstaticintExecuteNonQuery(stringSqlString)tryconn=GetConnection();conn.Open();OracleCommandCommand=conn.CreateCommand();Command.CommandText=SqlString;inti=Command.ExecuteNonQuery();conn.Close();returni;catch(Exceptionex)conn.Close();throwex;,5功能展示(6),运动队管理窗体数据访问类关键代码,2020/6/12,左彪,5功能展示(7),运动员管理窗体,2020/6/12,左彪,2020/6/12,左彪,5功能展示(8),运动员加分课程管理窗体,privatevoidtlsBtnAdd_Click(objectsender,EventArgse)if(curTasks=null)MessageBox.Show(MyResource.noDataLoaded,错误,MessageBoxButtons.OK,MessageBoxIcon.Error);return;for(inti=0;idgvClassStudents.CheckedItems.Count;i+)curTasks.addKC(tlsCboTerm.Text,dgvTasks.CurrentRow.Cells3.Value.ToString(),dgvClassStudents.CheckedItemsi.SubItems1.Text,dgvClassStudents.CheckedItemsi.SubItems2