课程设计课程设计名称：数据库应用系统课程设计专业班级：学生姓名： xxxxx 学号：指导教师：计算机科学与技术专业课程设计任务书学生姓名专业班级学号题目报刊订阅管理系统课题性质其它课题来源自拟课题指导教师同组姓名无主要内容人们在部门单位中一直以来都是使用传统人工方式管理本单位的报刊订阅，这种管理方式存在着许多缺点，而且时间一长，将产生大量的文件和数据，难于归类整理，这对于查找、更新和维护都带来了不少的困难。

课题要求设计并实现一个报刊订阅管理系统，能够通过计算机和数据库对本单位的报刊订阅进行管理。

一个单位可指定一个或多个管理员，普通用户注册获得一个账号后就可以订阅报刊以及在自己的权限范围内进行相关的操作。

功能应包括：登录对角色的判断，管理员注册新用户，查看、更新报刊信息，查询、统计订阅信息，维护数据，管理用户，普通用户修改个人信息，查询、统计、增加订阅等模块。

界面设计相对友好，方便用户的操作。

任务要求综合运用所学的数据库基本知识，并能通过查阅相关文献材料，独立完成该课题的设计开发工作。

要求根据本课题设计出合理的数据结构，并实现报刊订阅管理系统中,登录对角色的判断，管理员注册新用户，管理员查看、更新报刊信息，查询、统计订阅信息，维护数据，管理用户，普通用户修改个人信息，查询、统计、增加订阅等功能模块。

参考文献【1】尹志宇、郭晴数据库原理与应用教程清华大学出版社2010.5【2】（美）厄尔曼数据库系统基础教程机械工业出版社2009.8 【3】郑阿奇sql server2005教程电子工业出版社2011.2【4】明日科技c#开发技术大全人民邮电出版社2011.11【5】（美）米凯利斯c#本质论人民邮电出版社2010.9审查意见指导教师签字：教研室主任签字：年月日报刊订阅管理系统1：概述人们在部门单位中一直以来都是使用传统人工方式管理本单位的报刊订阅，这种管理方式存在着许多缺点，譬如：效率低、保密性差，而且时间一长，将产生大量的文件和数据，难于归类整理，这对于查找、更新和维护都带来了不少的困难。

本学期学习了c#、数据库以及基于c#的windows应用程序开发以后，在本次课程设计中，便利用这些知识点，实现一个报刊订阅管理系统，能够通过计算机和数据库对本单位的报刊订阅进行管理，实现智能化管理，克服传统人工管理方式的缺点以及弊端。

在报刊订阅管理系统中，要实现：一个单位可指定一个或多个管理员，管理员可以注册新用户，查看、更新报刊信息，查询、统计订阅信息，系统维护，管理用户；普通用户通过注册获得一个账号后就可以订阅报刊以及在自己的权限范围内进行查询、统计订阅以及修改个人信息等相关的操作。

功能应包括：登录对角色的判断，管理员注册新用户，管理员查看、更新报刊信息，管理员查询、统计订阅信息，管理员维护数据、管理员管理用户、普通用户修改个人信息、普通用户查询、统计、增加订阅等功能模块。

界面设计要相对友好，方便用户的操作。

2：需求分析设计报刊订阅管理系统，要能够通过计算机和数据库对本单位的报刊订阅进行管理，实现智能化管理，克服传统人工管理方式的缺点以及弊端。

要实现：一个单位可指定一个或多个管理员，管理员可以注册新用户，查看、更新报刊信息，查询、统计订阅信息，系统维护，管理用户；普通用户通过注册获得一个账号后就可以订阅报刊以及在自己的权限范围内进行查询、统计订阅以及修改个人信息等相关的操作。

具体功能应包括：用户登录，管理员注册用户（包括普通用户、管理员），更新报刊（包括查看、录入、修改、删除），查询订阅（按用户、报刊、部门），统计订阅（按用户、报刊、部门），系统维护（备份、还原数据）、管理用户（查询、修改、删除），普通用户修改个人信息，增加、删除、修改、查询、统计订阅信息等功能模块。

界面设计要相对友好，方便用户的操作。

系统流程图如图1：图1：用户登录管理员普通用户注册用户更新报刊查询订阅统计订阅系统维护管理用户个人信息增加订阅查询订阅统计订阅查询、修改普用用户、管理员查看、录入、修改、删除按用户、报刊、部门按用户、报刊、部门备份、还原数据查询、修改、删除3：概念结构设计在报刊订阅管理系统中，共涉及到3个实体：报刊、部门、用户。

用户包括普通用户、管理员，每个用户都唯一属于一个部门，每个部门可包括多个用户，它们是多对一的关系。

普通用户可以订阅多份报刊，一份报刊可被多个用户订阅，属于多对多的关系。

E-R图如图2。

图2：报刊编号。

分类名称部门编号部门名称4：逻辑结构设计设计数据库共有7个关系模式，分别为：用户 属于 用户账号 。

身份证号 用户账号 。

密码 用户账号报刊编号用户（用户账号，姓名，密码，用户类别）用户账号为主键，决定因素为主键自身或包含主键，满足BC范式。

普通用户1（用户账号，联系电话，联系地址，部门编号）用户账号为主键，部门编号为外键，决定因素为主键自身或包含主键，满足BC范式。

普通用户2（用户账号，身份证号）用户账号为主键，决定因素为主键自身或包含主键，满足BC范式。

部门（部门编号，部门名称）部门编号为主键，决定因素为主键自身或包含主键，满足BC范式。

报刊信息（报刊编号，报刊名称，出版报社，出版周期，季度报价，内容介绍，分类编号）报刊编号为主键，分类编号为外键，决定因素为主键自身或包含主键，满足BC范式。

报刊类别（分类编号，分类名称）分类编号为主键，决定因素为主键自身或包含主键，满足BC范式。

订单（用户编号，报刊编号，订阅份数，订阅月数）用户编号、报刊编号为主键，决定因素为主键自身或包含主键，满足BC范式。

5：源代码及系统截图源代码：（1）登录界面的逻辑实现using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.IO;using System.Data.SqlClient;namespace newspaperorder{public partial class login : Form{private int childFormNumber = 0;public login(){InitializeComponent();}private void ShowNewForm(object sender, EventArgs e){Form childForm = new Form();childForm.MdiParent = this;childForm.Text = "Window " + childFormNumber++;childForm.Show();}private void OpenFile(object sender, EventArgs e){OpenFileDialog openFileDialog = new OpenFileDialog();openFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);openFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*";if (openFileDialog.ShowDialog(this) == DialogResult.OK){string FileName = openFileDialog.FileName;}}private void SaveAsToolStripMenuItem_Click(object sender, EventArgs e){SaveFileDialog saveFileDialog = new SaveFileDialog();saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);saveFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*";if (saveFileDialog.ShowDialog(this) == DialogResult.OK){string FileName = saveFileDialog.FileName;}}private void ExitToolsStripMenuItem_Click(object sender, EventArgs e){this.Close();}private void CascadeToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.Cascade);}private void TileVerticalToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.TileVertical);}private void TileHorizontalToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.TileHorizontal);}private void ArrangeIconsToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.ArrangeIcons);}private void CloseAllToolStripMenuItem_Click(object sender, EventArgs e){foreach (Form childForm in MdiChildren){childForm.Close();}}private void button2_Click(object sender, EventArgs e){this.textBox1.Clear();this.textBox2.Clear();}private void notifyicon1_click(object sender, System.Windows.Forms.MouseEventArgs e) {if (e.Button == System.Windows.Forms.MouseButtons.Right){if (this != null && this.contextMenuStrip1 != null){this.contextMenuStrip1.Show();}}}private void button1_Click(object sender, EventArgs e){string usernum = null;usernum=this.textBox1.Text.ToString();string userpass = null;userpass=this.textBox2.Text.ToString();if (usernum.Equals("") || userpass.Equals("")){MessageBox.Show("请?输?入?账?号?和í密ü码?");}else{string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"select * from 用?户§ where 用?户§账?号?=" + usernum + " and 密ü码?=" + userpass + " ";SqlCommand MyCommand = new SqlCommand(sql, MyCon);SqlDataReader mydatareader = MyCommand.ExecuteReader();if (mydatareader.HasRows){mydatareader.Read();string power = mydatareader.GetString(3);if (power.StartsWith("管ü理え员±")){this.Hide();this.admin = new adminform(usernum);}if (power.StartsWith("普?通 用?户§")){this.Hide();mon = new commonform(usernum);}}else{MessageBox.Show("账?号?或ò密ü码?不?正y确ā?");}MyCon.Close();}catch (Exception e1) { MessageBox.Show(e1.Message); }}}private void toolStripMenuItem1_Click(object sender, EventArgs e){this.Dispose();}}}（2）管理员主界面的逻辑实现using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace newspaperorder{public partial class adminform : Form{private int childFormNumber = 0;public adminform(string usernum){this.Visible = true;ernum = usernum;InitializeComponent();}private void ShowNewForm(object sender, EventArgs e){Form childForm = new Form();childForm.MdiParent = this;childForm.Text = "Window " + childFormNumber++;childForm.Show();}private void OpenFile(object sender, EventArgs e){OpenFileDialog openFileDialog = new OpenFileDialog();openFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);openFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*";if (openFileDialog.ShowDialog(this) == DialogResult.OK){string FileName = openFileDialog.FileName;}}private void SaveAsToolStripMenuItem_Click(object sender, EventArgs e){SaveFileDialog saveFileDialog = new SaveFileDialog();saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);saveFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*";if (saveFileDialog.ShowDialog(this) == DialogResult.OK){string FileName = saveFileDialog.FileName;}}private void ExitToolsStripMenuItem_Click(object sender, EventArgs e){this.Close();}private void CascadeToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.Cascade);}private void TileVerticalToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.TileVertical);}private void TileHorizontalToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.TileHorizontal);}private void ArrangeIconsToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.ArrangeIcons);}private void CloseAllToolStripMenuItem_Click(object sender, EventArgs e){foreach (Form childForm in MdiChildren)childForm.Close();}}private void toolStripMenuItem5_Click(object sender, EventArgs e){if (erselect1 == null){erselect1 = new userselect();erselect1.TopMost = true;}else{if (erselect1.WindowState == FormWindowState.Minimized){erselect1.WindowState = FormWindowState.Normal;}erselect1.display();erselect1.TopMost = true;erselect1.Show();}}private void 管ü理え员±ToolStripMenuItem_Click(object sender, EventArgs e){if (this.add1 == null){this.add1 = new addadmin();this.add1.TopMost = true;}else{this.add1.Show();this.add1.TopMost = true;}}private void 普?通 用?户§ToolStripMenuItem_Click(object sender, EventArgs e) {if (this.add2 == null){this.add2 = new addcommon();this.add2.TopMost = true;}{this.add2.Show();this.add2.TopMost = true;}}private void toolStripMenuItem3_Click(object sender, EventArgs e){if (this.addnewspaper1 == null){this.addnewspaper1 = new addnewspaper();this.addnewspaper1.TopMost = true;}else{this.addnewspaper1.Show();this.addnewspaper1.TopMost = true;}}private void toolStripMenuItem6_Click(object sender, EventArgs e){if (this.newspaperselect1 == null){this.newspaperselect1 = new newspaperselect();this.newspaperselect1.TopMost = true;}else{if (this.newspaperselect1.WindowState == FormWindowState.Minimized) {this.newspaperselect1.WindowState = FormWindowState.Normal;}this.newspaperselect1.display();this.newspaperselect1.Show();this.newspaperselect1.TopMost = true;}}private void toolStripMenuItem7_Click(object sender, EventArgs e){if (this.departselect1 == null){this.departselect1 = new departselect();this.departselect1.TopMost = true;}else{if (this.departselect1.WindowState == FormWindowState.Minimized){this.departselect1.WindowState = FormWindowState.Normal;}this.departselect1.display();this.departselect1.Show();this.departselect1.TopMost = true;}}private void 按恪用?户§ToolStripMenuItem_Click(object sender, EventArgs e) {if (this.countuser1 == null){this.countuser1 = new countuser();this.countuser1.TopMost = true;}else{this.countuser1.display();this.countuser1.Show();this.countuser1.TopMost = true;}}private void 按恪报馈刊ˉToolStripMenuItem_Click(object sender, EventArgs e) {if (this.countnewspaper1 == null){this.countnewspaper1 = new countnewspaper();this.countnewspaper1.TopMost = true;}else{this.countnewspaper1.display();this.countnewspaper1.Show();this.countnewspaper1.TopMost = true;}}private void 按恪部?门?ToolStripMenuItem_Click(object sender, EventArgs e){if (this.countdepart1 == null){this.countdepart1 = new countdepart();this.countdepart1.TopMost = true;}else{this.countdepart1.display();this.countdepart1.Show();this.countdepart1.TopMost = true;}}private void ToolStripMenuItem_Click(object sender, EventArgs e){string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"backup database newspaperorder to disk='G:\databasedata2\newspaperbackup.Bak' with init";SqlCommand MyCommand = new SqlCommand(sql, MyCon);MyCommand.ExecuteNonQuery();MyCon.Close();MessageBox.Show("已?成é功|备?份 数簓据Y库a!");}catch (Exception e1) { MessageBox.Show(e1.Message); }}private void 数簓据Y恢?复′ToolStripMenuItem_Click(object sender, EventArgs e){string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"use master restore database newspaperorder from disk='G:\databasedata2\newspaperbackup.Bak' with replace";SqlCommand MyCommand = new SqlCommand(sql, MyCon);MyCommand.ExecuteNonQuery();MyCon.Close();MessageBox.Show("已?成é功|恢?复′数簓据Y库a!");}catch (Exception e1) { MessageBox.Show(e1.Message); }}private void toolStripMenuItem9_Click(object sender, EventArgs e) {if (this.adminalter1== null){this.adminalter1 = new adminalter(ernum);this.adminalter1.TopMost = true;}else{this.adminalter1.Show();this.adminalter1.TopMost = true;}}private void toolStripMenuItem11_Click(object sender, EventArgs e) {if (this.adminscannewspaper1 == null){this.adminscannewspaper1 = new adminscannewspaper();this.adminscannewspaper1.TopMost = true;}else{this.adminscannewspaper1.display();this.adminscannewspaper1.Show();this.adminscannewspaper1.TopMost = true;}}private void toolStripMenuItem12_Click(object sender, EventArgs e) {if (this.admindelnewspaper1 == null){this.admindelnewspaper1 = new admindelnewspaper();this.admindelnewspaper1.TopMost = true;}else{this.admindelnewspaper1.Show();this.admindelnewspaper1.TopMost = true;}}}}（3）普通用户界面的逻辑实现using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace newspaperorder{public partial class commonform : Form{private int childFormNumber = 0;public commonform(string usernum){ernum = usernum;this.Visible = true;InitializeComponent();}private void ShowNewForm(object sender, EventArgs e){Form childForm = new Form();childForm.MdiParent = this;childForm.Text = "Window " + childFormNumber++;childForm.Show();}private void OpenFile(object sender, EventArgs e){OpenFileDialog openFileDialog = new OpenFileDialog();openFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);openFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*";if (openFileDialog.ShowDialog(this) == DialogResult.OK){string FileName = openFileDialog.FileName;}}private void SaveAsToolStripMenuItem_Click(object sender, EventArgs e){SaveFileDialog saveFileDialog = new SaveFileDialog();saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);saveFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*";if (saveFileDialog.ShowDialog(this) == DialogResult.OK){string FileName = saveFileDialog.FileName;}}private void ExitToolsStripMenuItem_Click(object sender, EventArgs e){this.Close();}private void CascadeToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.Cascade);}private void TileVerticalToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.TileVertical);}private void TileHorizontalToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.TileHorizontal);}private void ArrangeIconsToolStripMenuItem_Click(object sender, EventArgs e){LayoutMdi(MdiLayout.ArrangeIcons);}private void CloseAllToolStripMenuItem_Click(object sender, EventArgs e){foreach (Form childForm in MdiChildren){childForm.Close();}}private void toolStripMenuItem3_Click(object sender, EventArgs e) {if (this.alter1 == null){this.alter1 = new commonalter(ernum);this.alter1.TopMost = true;}else{this.alter1.Show();this.alter1.TopMost = true;}}private void toolStripMenuItem5_Click(object sender, EventArgs e) {if (this.addnewspaper1 == null){this.addnewspaper1 = new commonaddnewspaper(ernum); this.addnewspaper1.TopMost = true;}else{this.addnewspaper1.display();this.addnewspaper1.Show();this.addnewspaper1.TopMost = true;}}private void toolStripMenuItem7_Click(object sender, EventArgs e) {if (monselect1 == null){monselect1 = new commonselect(ernum);monselect1.TopMost = true;}else{monselect1.Show();monselect1.TopMost = true;}}private void toolStripMenuItem9_Click(object sender, EventArgs e){string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"select count(*) as 种?类え?sum(订?阅?份 数簓) as 份 数簓 from 订?单蹋?where 用?户§编括号?='" +ernum+ "'";SqlCommand MyCommand = new SqlCommand(sql, MyCon);SqlDataReader myreader = MyCommand.ExecuteReader();myreader.Read();if (!myreader.IsDBNull(1)){string count1 = myreader.GetInt32(0).ToString();string count2 = myreader.GetInt32(1).ToString();MessageBox.Show("您ú订?阅?了?：阰" + count1 + "种?报馈刊ˉ共2" + count2 + "份 ");}else{MessageBox.Show("您ú没?有瓺订?阅?!");}MyCon.Close();}catch (Exception e1) { MessageBox.Show(e1.Message); }}}}（4）管理员注册用户（管理员）private void button1_Click(object sender, EventArgs e){string usernum = this.textBox1.Text.ToString();string username = this.textBox2.Text.ToString();string userpass = this.textBox3.Text.ToString();string usertype = this.textBox4.Text.ToString();if (usernum.Equals("") || userpass.Equals("")||username.Equals("")){MessageBox.Show("请?输?入?账?号?信?息￠！?");}else{string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql =@"insert into 用?户§(用?户§账?号?,姓?名?,密ü码?,用?户§类え别纄) values('" + usernum + "','" + username + "','" + userpass + "','" + usertype + "') "; SqlCommand MyCommand = new SqlCommand(sql, MyCon);MyCommand.ExecuteNonQuery();MessageBox.Show("已?正y确ā注痢册á管ü理え员±信?息￠！?");}catch (Exception e1) { MessageBox.Show(e1.Message); }}}（5）管理员注册用户（普通用户）private void button1_Click(object sender, EventArgs e){string usernum = this.textBox1.Text.ToString();string userid = this.textBox2.Text.ToString();string userphone = this.textBox3.Text.ToString();string useraddress = this.textBox4.Text.ToString();string userdepartnum = this.textBox5.Text.ToString();string userpass = this.textBox6.Text.ToString();string username = this.textBox7.Text.ToString();string usertype="普?通 用?户§";if (usernum.Equals("") || userid.Equals("") || userphone.Equals("") || useraddress.Equals("") || userdepartnum.Equals("")){MessageBox.Show("请?输?入?账?号?信?息￠！?");}else{string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql1 = @"insert into 用?户§ values('" + usernum + "','" +username+ "','" + userpass+ "','"+usertype+"') ";string sql2 =@"insert into 普?通 用?户§1 values('" + usernum + "','" + userphone + "','" + useraddress + "','"+userdepartnum+"') ";string sql3 = @"insert into 普?通 用?户§2 values('" + usernum + "','" + userid + "')";SqlCommand MyCommand1 = new SqlCommand(sql1, MyCon);SqlCommand MyCommand2 = new SqlCommand(sql2, MyCon);SqlCommand MyCommand3 = new SqlCommand(sql3, MyCon);MyCommand1.ExecuteNonQuery(); MyCommand2.ExecuteNonQuery(); MyCommand3.ExecuteNonQuery();MessageBox.Show("已?正y确ā注痢册á普?通 用?户§信?息￠！?");}catch (Exception e1) { MessageBox.Show(e1.Message); }}}（6）管理员录入报刊private void button1_Click(object sender, EventArgs e){string newspapernum = this.textBox1.Text.ToString();string newspapername = this.textBox2.Text.ToString();string newspaperpublish= this.textBox3.Text.ToString();string newspapertime= this.textBox4.Text.ToString();int newspaperprice=int.Parse(this.textBox5.Text.ToString());string newspaperintro= this.textBox6.Text.ToString();string newspapertypenum= this.textBox7.Text.ToString();if (newspapernum.Equals("") || newspapername.Equals("") || newspaperpublish.Equals("") || newspapertime.Equals("") || newspaperprice.Equals("") || newspaperintro.Equals("") || newspapertypenum.Equals("")){MessageBox.Show("请?输?入?报馈刊ˉ信?息￠！?");}else{string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql =@"insert into 报馈刊ˉ信?息￠ values('" + newspapernum + "','" + newspapername + "','" + newspaperpublish + "','"+newspapertime+"'," + newspaperprice + ",'"+newspaperintro+ "','" + newspapertypenum+ "') ";SqlCommand MyCommand = new SqlCommand(sql, MyCon);MyCommand.ExecuteNonQuery();MessageBox.Show("已?正y确ā录?入?报馈刊ˉ信?息￠！?");MyCon.Close();}catch (Exception e1) { MessageBox.Show(e1.Message); }}}（7）管理员删除报刊private void button1_Click(object sender, EventArgs e){string newspapernum = this.textBox1.Text.ToString();string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"delete 报馈刊ˉ信?息￠where 报馈刊ˉ编括号?='" + newspapernum + "'";SqlCommand MyCommand = new SqlCommand(sql, MyCon);MyCommand.ExecuteNonQuery();MessageBox.Show("删?除y报馈刊ˉ信?息￠成é功|!");MyCon.Close();}catch (Exception e1) { MessageBox.Show(e1.Message); }}（8）管理员查询订阅（按用户）private void button1_Click(object sender, EventArgs e){string newspapernum = this.textBox1.Text.ToString();string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"delete 报馈刊ˉ信?息￠where 报馈刊ˉ编括号?='" + newspapernum + "'";SqlCommand MyCommand = new SqlCommand(sql, MyCon);MyCommand.ExecuteNonQuery();MessageBox.Show("删?除y报馈刊ˉ信?息￠成é功|!");MyCon.Close();}catch (Exception e1) { MessageBox.Show(e1.Message); }}（9）管理员查询订阅（按报刊）public void setempty(){int emptycount = (this.dataGridView1.Height - this.dataGridView1.ColumnHeadersHeight - this.dataGridView1.RowTemplate.Height * this.dataGridView1.Rows.Count) / this.dataGridView1.RowTemplate.Height;for (int i = 0; i < emptycount; i++){this.dataGridView1.Rows.Add();}}public void display(){string newspapernum = this.textBox1.Text.ToString();string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"select * from 订?单蹋?where 报馈刊ˉ编括号?='" + newspapernum + "'";SqlCommand MyCommand = new SqlCommand(sql, MyCon);SqlDataReader myreader = MyCommand.ExecuteReader();if (myreader.HasRows){this.dataGridView1.RowCount = 0;while (myreader.Read()){string ordernum = myreader.GetString(0); string usernum = myreader.GetString(1);string ordercount = myreader.GetInt32(3).ToString(); string ordermonth = myreader.GetInt32(4).ToString();string[] row = new string[] { ordernum, usernum, newspapernum, ordercount, ordermonth };this.dataGridView1.Rows.Add(row);}this.setempty();}else{this.dataGridView1.RowCount = 0;MessageBox.Show("订?阅?记?录?为a空?!");}MyCon.Close();}catch (Exception e1) { MessageBox.Show(e1.Message); }}private void button1_Click(object sender, EventArgs e){this.display();}private void sizechange(object sender, EventArgs e){this.setempty();}（10）管理员查询订阅（按部门）public void setempty(){int emptycount = (this.dataGridView1.Height - this.dataGridView1.ColumnHeadersHeight - this.dataGridView1.RowTemplate.Height * this.dataGridView1.Rows.Count) / this.dataGridView1.RowTemplate.Height;for (int i = 0; i < emptycount; i++){this.dataGridView1.Rows.Add();}}public void display(){string departnum = this.textBox1.Text.ToString();string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"select * from 订?单蹋?where exists (select * from 普?通 用?户§1 where 部?门?编括号?='" + departnum + "' and 用?户§账?号?=订?单蹋?用?户§编括号?)"; SqlCommand MyCommand = new SqlCommand(sql, MyCon);SqlDataReader myreader = MyCommand.ExecuteReader();if (myreader.HasRows){this.dataGridView1.RowCount = 0;while (myreader.Read()){string ordernum = myreader.GetString(0); string usernum = myreader.GetString(1); string newspapernum = myreader.GetString(2);string ordercount = myreader.GetInt32(3).ToString(); string ordermonth = myreader.GetInt32(4).ToString();string[] row = new string[] { ordernum, usernum, newspapernum, ordercount, ordermonth };this.dataGridView1.Rows.Add(row);}this.setempty();}else{this.dataGridView1.RowCount = 0;MessageBox.Show("订?阅?记?录?为a空?!");}MyCon.Close();}catch (Exception e1) { MessageBox.Show(e1.Message); }}private void button1_Click(object sender, EventArgs e){this.display();}private void sizechange(object sender, EventArgs e){this.setempty();}(11)管理员修改个人信息private void button1_Click(object sender, EventArgs e){string username = this.textBox1.Text.ToString(); string userpass = this.textBox2.Text.ToString();string strCon = @"server=(local);Integrated Security=true;database=newspaperorder;uid=sa;pwd=111111";SqlConnection MyCon = new SqlConnection(strCon);try{MyCon.Open();string sql = @"update 用?户§ set 姓?名?='" + username + "',密ü码?='" + userpass + "' where 用?户§账?号?='" + ernum + "' ";SqlCommand MyCommand = new SqlCommand(sql, MyCon);MyCommand.ExecuteNonQuery();。