实验目的通过软件开发的实践训练，进一步了解软件工程的方法和技术，提高软件开发的实际能力，培养工程设计能力和综合分析、解决问题的能力。
具体如下：1.学习和实践面向对象的系统分析与设计，编码和测试方面的知识；2.熟悉自动化的软件开发工具SQLServer2008，Visual Studio2012,并将其运用于软件开发的全过程；3.进一步加强和提高软件工程文档的编写能力。
实验内容:概述1.课题题目：招生收费系统2.功能：专业管理、收费管理。
3.软件开发工具：SQLServer2008、Visual Studio 2012。
4.操作系统：Win7。
系统需求分析本软件访问、修改、删除数据库中的数据。
对专业信息的查询增删改，对学生专业的确认以及修改，对学生进行收费管理。
功能描述主要功能在客户端浏览器体现。
客户端完成数据查询、输入、修改、删除等简单功能，大部分工作要有服务器承担，包括对数据的保存。
1.专业管理：通过对招生季节和招生年度查询专业信息，且还可以对其进行添加、删除、修改。
2.收费管理：通过招生季节、招生年度及准考证号查询学生信息和学费信息；选择专业可以查看报该专业的学费信息。
系统功能模块图:设计(一)数据库设计专业信息表：收费信息表：学生信息表：(二)实验界面1）专业信息管理界面2）招生专业管理界面3）招生收费管理界面（三）实验主要代码1）专业信息管理代码：int k;///<summary>///运用了实体框架，声明上下文///</summary>WebEntities _context = new WebEntities();protected void Page_Load(object sender, EventArgs e){btnDelete.Attributes.Add("onclick", "return confirm('确实要删除吗？');"); gvTable.DataSource = _context.majors.ToList();gvTable.DataBind();}///删除按钮///</summary>///<param name="sender"></param>///<param name="e"></param>protected void btnDelete_Click(object sender, EventArgs e){for (int i = 0; i < this.gvTable.Rows.Count; i++){k = 0;string id = this.gvTable.Rows[i].Cells[4].Text;CheckBox cb = this.gvTable.Rows[i].FindControl("CheckBox1") as CheckBox;if (cb.Checked){Delete(id);k++;}}if (k == 0){Response.Write("<script type='text/javascript'>alert('请选择要删除的记录！')</script>");}elseResponse.Write("<script type='text/javascript'>alert('删除成功！')</script>");}///<summary>///刷新///</summary>///<param name="sender"></param>///<param name="e"></param>protected void btnRefresh_Click(object sender, EventArgs e){Response.Write("<script type='text/javascript'>alert('刷新成功！')</script>");Response.Redirect("WebForm1.aspx");}///删除函数///</summary>///<param name="id"></param>public void Delete(string id){string ConString = "Data Source=ACER-PC\\SQLEXPRESS;InitialCatalog=Web;Integrated Security=True";SqlConnection conn = new SqlConnection(ConString);conn.Open();SqlCommand cmd = new SqlCommand("delete from 专业信息 where 专业代码=" + id, conn);cmd.ExecuteNonQuery();conn.Close();}///<summary>///添加按钮///</summary>///<param name="sender"></param>///<param name="e"></param>protected void btnAdd_Click(object sender, EventArgs e){Response.Redirect("WebForm2.aspx");Response.Write("<script type='text/javascript'>alert('添加成功！')</script>");}}新增专业信息代码段：///<summary>///运用了实体框架，声明上下文///</summary>WebEntities _context = new WebEntities();protected void Page_Load(object sender, EventArgs e){}///添加按钮///</summary>///<param name="sender"></param>///<param name="e"></param>protected void btnAdd_Click(object sender, EventArgs e){string专业代码 = TextBox15.Text.Trim().ToString();string招生年度 = TextBox1.Text.Trim().ToString();string招生季节 = TextBox2.Text.Trim().ToString();string Id = 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();major Major = new major(){MajorCode = 专业代码,EnrolYear = 招生年度,EnrolSeason = 招生季节,MajorID = Id,MajorName = 专业名,EduLength = 学制,SchoolName = 学院,NationalMajorNo = 国际专业代码,Tuition = 学费,RoomMoney = 住宿费,TextBookMoney = 书本费,AgencyMoney = 代收费,};_context.majors.Add(Major);_context.SaveChanges();Response.Write("<script type='text/javascript'>alert('添加成功！')</script>");Response.Redirect("WebForm1.aspx");}///<summary>///重置按钮///</summary>///<param name="sender"></param>///<param name="e"></param>protected void btnRe_Click(object sender, EventArgs e){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("<script type='text/javascript'>alert('重置成功！')</script>");}}2）招生专业管理代码：///<summary>///采用实体框架，声明上下文///</summary>WebEntities _context = new WebEntities();protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){ddlSchoolName.DataSource =_context.major.Select(m=>m.SchoolName).Distinct().ToList();ddlSchoolName.DataBind();}}protected void ddlSchoolName_SelectedIndexChanged(object sender, EventArgs e) {string SchoolName = ddlSchoolName.SelectedValue.ToString();ddlMajorName.DataSource =_context.major.Where(m=>m.SchoolName==SchoolName).ToList();ddlMajorName.DataBind();}///<summary>///考生查询///</summary>///<param name="sender"></param>///<param name="e"></param>protected void btnQuery_Click(object sender, EventArgs e){try{string ID = 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(Exception ex){Response.Write("<script type='text/javascript'>alert('不存在该考生！')</script>");}}protected void ddlMajorName_SelectedIndexChanged(object sender, EventArgs e) {string majorId = 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();}protected void DDLSchoolName_DataBound(object sender, EventArgs e){string SchoolName = ddlSchoolName.SelectedValue.ToString();ddlMajorName.DataSource = _context.major.Where(m => m.SchoolName == SchoolName).ToList();ddlMajorName.DataBind();}protected void ddlMajorName_DataBound(object sender, EventArgs e){string majorId = 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>///<param name="sender"></param>///<param name="e"></param>protected void btnSure_Click(object sender, EventArgs e){string majorId = ddlMajorName.SelectedValue.ToString();txtMajor.Text = _context.major.Where(m => m.MajorID ==majorId).Single().MajorName.ToString();message student = new message(){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("<script type='text/javascript'>alert('确认专业成功！')</script>");}///<summary>///收费管理///</summary>///<param name="sender"></param>///<param name="e"></param>protected void btnCharge_Click(object sender, EventArgs e){string ID = txtID.Text.ToString();message student = new message();student = _context.message.FirstOrDefault(m => m.ID ==ID);if (student.MajorName == null){Response.Write("<script type='text/javascript'>alert('未确定专业')</script>");}else{Response.Write("<scripttype='text/javascript'>window.open('WebForm2.aspx')</script>");}Session["message"] = student;}}3）招生收费管理代码：///<summary>///采用实体框架，声明上下文///</summary>WebEntities _context = new WebEntities();protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){message student = (message)Session["message"];txtID.Text= student.ID;txtName.Text = .ToString();txtSex.Text = student.Sex.ToString();txtMajorName.Text = student.MajorName.ToString();major Major = new major();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转换成大写public static string ConvertToCn(decimal num){string str1 = "零壹贰叁肆伍陆柒捌玖"; //0-9所对应的汉字string str2 = "万仟佰拾亿仟佰拾万仟佰拾元角分"; //数字位所对应的汉字string str3 = ""; //从原num值中取出的值string str4 = ""; //数字的字符串形式string str5 = ""; //人民币大写金额形式int i; //循环变量int j; //num的值乘以100的字符串长度string ch1 = ""; //数字的汉语读法string ch2 = ""; //数字位的汉字读法int nzero = 0; //用来计算连续的零值是几个int temp; //从原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的值。
