.net课程设计实验报告

实验目的通过软件开发的实践训练，进一步了解软件工程的方法和技术，提高软件开发的实际能力，培养工程设计能力和综合分析、解决问题的能力。具体如下：学习和实践面向对象的系统分析与设计，编码和测试方面的知识；熟悉自动化的软件开发工具SQLServer2008，VisualStudio2012,并将其运用于软件开发的全过程；进一步加强和提高软件工程文档的编写能力。实验内容:概述1.课题题目：招生收费系统2.功能：专业管理、收费管理。3.软件开发工具：SQLServer2008、VisualStudio2012。4.操作系统：Win7。系统需求分析本软件访问、修改、删除数据库中的数据。对专业信息的查询增删改，对学生专业的确认以及修改，对学生进行收费管理。功能描述主要功能在客户端浏览器体现。客户端完成数据查询、输入、修改、删除等简单功能，大部分工作要有服务器承担，包括对数据的保存。1.专业管理：通过对招生季节和招生年度查询专业信息，且还可以对其进行添加、删除、修改。2.收费管理：通过招生季节、招生年度及准考证号查询学生信息和学费信息；选择专业可以查看报该专业的学费信息。系统功能模块图:设计(一)数据库设计专业信息表：收费信息表：学生信息表：(二)实验界面1）专业信息管理界面招生专业管理界面招生收费管理界面（三）实验主要代码1）专业信息管理代码：intk;///<summary>///运用了实体框架，声明上下文///</summary>WebEntities_context=newWebEntities();protectedvoidPage_Load(objectsender,EventArgse){btnDelete.Attributes.Add("onclick","returnconfirm('确实要删除吗？');");gvTable.DataSource=_context.majors.ToList();gvTable.DataBind();}///<summary>///删除按钮///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnDelete_Click(objectsender,EventArgse){for(inti=0;i<this.gvTable.Rows.Count;i++){k=0;stringid=this.gvTable.Rows[i].Cells[4].Text;CheckBoxcb=this.gvTable.Rows[i].FindControl("CheckBox1")asCheckBox;if(cb.Checked){Delete(id);k++;}}if(k==0){Response.Write("<scripttype='text/javascript'>alert('请选择要删除的记录！')</script>");}elseResponse.Write("<scripttype='text/javascript'>alert('删除成功！')</script>");}///<summary>///刷新///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnRefresh_Click(objectsender,EventArgse){Response.Write("<scripttype='text/javascript'>alert('刷新成功！')</script>");Response.Redirect("WebForm1.aspx");}///<summary>///删除函数///</summary>///<paramname="id"></param>publicvoidDelete(stringid){stringConString="DataSource=ACER-PC\\SQLEXPRESS;InitialCatalog=Web;IntegratedSecurity=True";SqlConnectionconn=newSqlConnection(ConString);conn.Open();SqlCommandcmd=newSqlCommand("deletefrom专业信息where专业代码="+id,conn);cmd.ExecuteNonQuery();conn.Close();}///<summary>///添加按钮///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnAdd_Click(objectsender,EventArgse){Response.Redirect("WebForm2.aspx");Response.Write("<scripttype='text/javascript'>alert('添加成功！')</script>");}}新增专业信息代码段：///<summary>///运用了实体框架，声明上下文///</summary>WebEntities_context=newWebEntities();protectedvoidPage_Load(objectsender,EventArgse){}///<summary>///添加按钮///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnAdd_Click(objectsender,EventArgse){string专业代码=TextBox15.Text.Trim().ToString();string招生年度=TextBox1.Text.Trim().ToString();string招生季节=TextBox2.Text.Trim().ToString();stringId=TextBox14.Text.Trim().ToString();string专业名=TextBox3.Text.Trim().ToString();string学制=TextBox4.Text.Trim().ToString();string学院=TextBox16.Text.Trim().ToString();string国际专业代码=TextBox17.Text.Trim().ToString();string学费=TextBox18.Text.Trim().ToString();string住宿费=TextBox19.Text.Trim().ToString();string书本费=TextBox20.Text.Trim().ToString();string代收费=TextBox21.Text.Trim().ToString();majorMajor=newmajor(){MajorCode=专业代码,EnrolYear=招生年度,EnrolSeason=招生季节,MajorID=Id,MajorName=专业名,EduLength=学制,SchoolName=学院,NationalMajorNo=国际专业代码,Tuition=学费,RoomMoney=住宿费,TextBookMoney=书本费,AgencyMoney=代收费,};_context.majors.Add(Major);_context.SaveChanges();Response.Write("<scripttype='text/javascript'>alert('添加成功！')</script>");Response.Redirect("WebForm1.aspx");}///<summary>///重置按钮///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnRe_Click(objectsender,EventArgse){TextBox15.Text="";TextBox1.Text="";TextBox2.Text="";TextBox14.Text="";TextBox3.Text="";TextBox4.Text="";TextBox16.Text="";TextBox17.Text="";TextBox18.Text="";TextBox19.Text="";TextBox20.Text="";TextBox21.Text="";Response.Write("<scripttype='text/javascript'>alert('重置成功！')</script>");}}2）招生专业管理代码：///<summary>///采用实体框架，声明上下文///</summary>WebEntities_context=newWebEntities();protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){ddlSchoolName.DataSource=_context.major.Select(m=>m.SchoolName).Distinct().ToList();ddlSchoolName.DataBind();}}protectedvoidddlSchoolName_SelectedIndexChanged(objectsender,EventArgse){stringSchoolName=ddlSchoolName.SelectedValue.ToString();ddlMajorName.DataSource=_context.major.Where(m=>m.SchoolName==SchoolName).ToList();ddlMajorName.DataBind();}///<summary>///考生查询///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnQuery_Click(objectsender,EventArgse){try{stringID=txtID.Text.ToString();txtName.Text=_context.message.Where(m=>m.ID==ID).Single().Name.ToString();txtSex.Text=_context.message.Where(m=>m.ID==ID).Single().Sex.ToString();txtWantMajor.Text=_context.message.Where(m=>m.ID==ID).Single().WantMajor.ToString();txtMajor.Text="";}catch(Exceptionex){Response.Write("<scripttype='text/javascript'>alert('不存在该考生！')</script>");}}protectedvoidddlMajorName_SelectedIndexChanged(objectsender,EventArgse){stringmajorId=ddlMajorName.SelectedValue.ToString();txtMajorCode.Text=_context.major.Where(m=>m.MajorID==majorId).Single().MajorCode.ToString();txtEdulength.Text=_context.major.Where(m=>m.MajorID==majorId).Single().EduLength.ToString();}protectedvoidDDLSchoolName_DataBound(objectsender,EventArgse){stringSchoolName=ddlSchoolName.SelectedValue.ToString();ddlMajorName.DataSource=_context.major.Where(m=>m.SchoolName==SchoolName).ToList();ddlMajorName.DataBind();}protectedvoidddlMajorName_DataBound(objectsender,EventArgse){stringmajorId=ddlMajorName.SelectedValue.ToString();txtMajorCode.Text=_context.major.Where(m=>m.MajorID==majorId).Single().MajorCode.ToString();txtEdulength.Text=_context.major.Where(m=>m.MajorID==majorId).Single().EduLength.ToString();}///<summary>///确认专业///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnSure_Click(objectsender,EventArgse){stringmajorId=ddlMajorName.SelectedValue.ToString();txtMajor.Text=_context.major.Where(m=>m.MajorID==majorId).Single().MajorName.ToString();messagestudent=newmessage(){ID=txtID.Text.ToString(),Name=txtName.Text.ToString(),Sex=txtSex.Text.ToString(),WantMajor=txtWantMajor.Text.ToString(),MajorName=txtMajor.Text.ToString()};_context.message.Attach(student);_context.Entry<message>(student).State=System.Data.EntityState.Modified;_context.SaveChanges();Response.Write("<scripttype='text/javascript'>alert('确认专业成功！')</script>");}///<summary>///收费管理///</summary>///<paramname="sender"></param>///<paramname="e"></param>protectedvoidbtnCharge_Click(objectsender,EventArgse){stringID=txtID.Text.ToString();messagestudent=newmessage();student=_context.message.FirstOrDefault(m=>m.ID==ID);if(student.MajorName==null){Response.Write("<scripttype='text/javascript'>alert('未确定专业')</script>");}else{Response.Write("<scripttype='text/javascript'>window.open('WebForm2.aspx')</script>");}Session["message"]=student;}}3）招生收费管理代码：///<summary>///采用实体框架，声明上下文///</summary>WebEntities_context=newWebEntities();protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){messagestudent=(message)Session["message"];txtID.Text=student.ID;txtName.Text=student.Name.ToString();txtSex.Text=student.Sex.ToString();txtMajorName.Text=student.MajorName.ToString();majorMajor=newmajor();txtxf.Text=_context.major.Where(m=>m.MajorName==student.MajorName).Single().Tuition.ToString();txtzsf.Text=_context.major.Where(m=>m.MajorName==student.MajorName).Single().RoomMoney.ToString();txtjcf.Text=_context.major.Where(m=>m.MajorName==student.MajorName).Single().TextBookMoney.ToString();txtdsf.Text=_context.major.Where(m=>m.MajorName==student.MajorName).Single().AgencyMoney.ToString();txtcost.Text=(Convert.ToInt32(txtxf.Text)+Convert.ToInt32(txtzsf.Text)+Convert.ToInt32(txtjcf.Text)+Convert.ToInt32(txtdsf.Text)).ToString();}}//转换成大写#region转换成大写publicstaticstringConvertToCn(decimalnum){stringstr1="零壹贰叁肆伍陆柒捌玖";//0-9所对应的汉字stringstr2="万仟佰拾亿仟佰拾万仟佰拾元角分";//数字位所对应的汉字stringstr3="";//从原num值中取出的值stringstr4="";//数字的字符串形式stringstr5="";//人民币大写金额形式inti;//循环变量intj;//num的值乘以100的字符串长度stringch1="";//数字的汉语读法stringch2="";//数字位的汉字读法intnzero=0;//用来计算连续的零值是几个inttemp;//从原num值中取出的值num=Math.Round(Math.Abs(num),2);//将num取绝对值并四舍五入取2位小数str4=((long)(num*100)).ToString();//将num乘100并转换成字符串形式j=str4.Length;//找出最高位if(j>15){return"溢出";}str2=str2.Substring(15-j);//取出对应位数的str2的值。如：200.55,j为5所以str2=佰拾元角分//循环取出每一位需要转换的值for(i=0;i<j;i++){str3=str4.Substring(i,1);//取出需转换的某一位的值temp=Convert.ToInt32(str3);//转换为数字if(i!=(j-3)&&i!=(j-7)&&i!=(j-11)&&i!=(j-15)){//当所取位数不为元、万、亿、万亿上的数字时if(str3=="0"){ch1="";ch2="";nzero=nzero+1;}else{if(str3!="0"&&nzero!=0){ch1="零"+str1.Substring(temp*1,1);ch2=str2.Substring(i,1);nzero=0;}else{ch1=str1.Substring(temp*1,1);ch2=str2.Substring(i,1);nzero=0;}}}else{//该位是万亿，亿，万，元位等关键位if(str3!="0"&&nzero!=0){ch1="零"+str1.Substring(temp*1,1);ch2=str2.Substring(i,1);nzero=0;}else{if(str3!="0"&&nzero==0){ch1=str1.Substring(temp*1,1);ch2=str2.Substring(i,1);nzero=0;}else{if(str3=="0"&&nzero>=3){ch1="";ch2="";nzero=nzero+1;}else{if(j>=11){ch1="";nzero=nzero+1;}else{ch1="";ch2=str2.Substring(i,1);nzero=nzero+1;}}}}}if(i==(j-11)||i==(j-3)){//如果该位是亿位或元位，则必须写上ch2=str2.Substring(i,1);}str5=str5+ch1+ch2;if(i==j-1&&str3=="0"){//最后一位（分）为0时，加上“整”str5=str5+"整";}}if(num==0){str5="零元整";}returnstr5;}//publicstaticstringConvertToCn(stringnumstr)//{//decimalnum=0;//if(decimal.TryParse(numstr,outnum))//{//returnConvertToCn(num);//}//else//{//return"非数字形式！";//}//}