高校学生宿舍信息管理系统

1、高校学生宿舍管理系统课程设计名：学 号：专 业：08级信息管理与信息系统2班指导教师：时 间： 2011年12月2日目录1课程设计目的2课程设计题目描述和要求3课程设计报告内容一、课程设计目的通过课程设计，使学生能够掌握C#语言的基本内容及程序设计的基本方 法与编程技巧，使学生具有应用计算机解决实际问题的基本能力，培养学生 掌握使用计算机处理问题的思维方法与途径，培养良好的程序设计风格，使 学生能够独立编制和调试各种结构的面向对象的C#语言程序。初步掌握软件 开发过程的问题分析、系统设计、程序编码、测试等基本方法和技能；提高 综合运用所学的理论知识和方法独立分析和解决问题的能力。完成所选设计题

2、目，上机调试通过该程序系统所有功能；编写设计说明 书，内容包括：课程设计的目的、意义；设计任务；总体设计方案；软件设 计（各功能模块的流程图及详细的文字说明）；软件系统的使用说明；收获、 体会等。二、课程设计题目描述和要求1、开发系统的功能介绍（1）系统管理窗体系统设置信息（2）资源管理窗体管理宿舍信息（3）学生管理窗体管理学生住宿信息。（4）报修管理窗体管理宿舍维修信息。（5）违规管理窗体管理违规学生信息三、课程设计报告内容操作流程用户一注册一登录一操作界面一 系统管理- 系统设置信息资源管理- 管理宿舍信息学生管理- 管理学生住宿信息报修管理一管理宿舍维修信息违规管理一管理违规学生信息管理

3、违规学生信息（四）系统功能结构根据高校学生宿舍信息管理系统的特点，可将其分为：系统登录、系统 注册用户，主界面、系统管理界面、资源管理界面、学生管理界面等。（五）系统预览为了初步了解家庭理财系统，下面分别给出系统中的四个界面。登录页面:注册页面:主窗体页面:学生信息登记界面:学生宿舍基本信息界面（六）构建开发环境：系统开发环境：Microsoft Visual Studio 2010集成开发环境。系统开发语言：C#系统数据库：Microsoft Sqlserver2008开发运行环境：Windows XP、Vista、7系统服务运行环境：M Framework 4.0.最佳效果：1024*76

4、8。（七）数据库设计本系统采用Sqlserver2008数据库，名称为VirgoDB_StuInfo表:WIN-41CENMJ2UAU.-列名数据类型允许Null值StLlNQchar(l|SstuMameviarchar(lO)nstuSexch aOstuTimedatetimeBstuDepartvarctiarlj8)SstuProwarchar(18)EstuElsetext国BDB_DormInfo 表：WIN-41CENMJ2UAU.dbo.&B_D?rmIiifo列名数据类型允许M圳值darnnldintSbuild Areavarchar(lO)SbuildNointOdor

5、niNointEbedNumirtdornnElsetexts（九）公共类设计在开发过程中，经常会用到一些公共的模块，如数据库的连接及操作的 类，字串的处理的类等，因此，在开发系统前，首先要设计这些公共模块， 下面将介绍高校学生宿舍信息管理系统中所需要的数据库操作类，数据库操 作类用来完成数据库的连接操作，以及数据库的查询，添加，删除修改操作， 现将这几种操作编写到一个公共类里，可以减少代码的编写工作，有利于代 码的维护。代码如下：using System;using System.Collections.Generic;using System.Linq;using System.Text;

6、using System.Data;using System.Data.SqlClient;using System.Windows.Forms;namespace VirgoMis/ /此类维护数据库连接字符串和Connection对象/ class DBHelperprivate static SqlCommand cmd = null;private static SqlDataReader dr = null;/数据库连接字符串/private static string connectionString =Server = HUAIHUAI-8B2819; Database = Vi

7、rgo; IntegratedSecurity = SSPI；private static string connectionString = 矿DataSource二.；AttachDbFilename=F:、学习 C#、网上下载、新建文件夹源程序代码VirgoMisVirgo.mdf;Integrated Security=True”;/数据库连接Connection对象public static SqlConnection connection = new SqlConnection(connectionString);public DBHelper() #region返回结果集publ

8、ic static SqlDataReader GetResult(string sql)trycmd = new SqlCommand();cmd.CommandText = sql;cmd.Connection = connection;cmd.Connection.Open();dr = cmd.ExecuteReader();return dr;catch (Exception ex)MessageBox.Show(ex.Message);return null;finally/dr.Close();/cmd.Connection.Close();#endregion#region对S

9、elect语句，返回int型结果集 public static int GetSqlResult(string sql) trycmd = new SqlCommand();cmd.CommandText = sql;cmd.Connection = connection;cmd.Connection.Open();int a = (int)cmd.ExecuteScalar(); return a;catch (Exception ex)MessageBox.Show(ex.Message);return -1;finallycmd.Connection.Close();#endregion

10、#region对Update,Insert和Delete语句，返回该命令所影响的行数public static int GetDsqlResult(string sql)trycmd = new SqlCommand();cmd.CommandText = sql;cmd.Connection = connection;cmd.Connection.Open();cmd.ExecuteNonQuery();return 1;catch (Exception ex)MessageBox.Show(ex.Message);return -1;finallycmd.Connection.Close(

11、);#endregion(十)各界面代码及功能实现(1)登录界面：功能：登陆登陆界面代码：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace VirgoMis(public partial class Login : For

12、m(public Login()(InitializeComponent();#region验证用户的输入，成功返回true,失败返回falseprivate bool IsValidataInput()(if (txtLoginNo.Text.Trim()=)(MessageBox.Show(请输入账号！，登陆提示，MessageBoxButtons.OK,MessageBoxIcon.Information);txtLoginNo.Focus();return false;else if (txtLoginPwd.Text =)(MessageBox.Show(请输入密码！,登陆提示，Me

13、ssageBoxButtons.OK,MessageBoxIcon.Information);txtLoginPwd.Focus();return false;else if (cboLoginType.Text =)(MessageBox.Show(请选择登陆类型！，登陆提示 ，MessageBoxButtons.OK,MessageBoxIcon.Information);cboLoginType.Focus();return false;return true;#endregion#region验证用户是否合法传递用户账号、密码、登陆类型，合法返回true,不合法返回 false/mes

14、sage参数用来记录验证失败的原因private bool IsValidataUser(string loginNo, string loginPwd, string loginType, ref string message)(string sql = String.Format(select count(*) from DB_ManageInfo where loginNo =0 and loginPwd =1 and loginType =2,loginNo,loginPwd,loginType);int a = DBHelper.GetSqlResult(sql);if (a 1)m

15、essage = 该用户名或密码不存在！;return false;elsereturn true;#endregion登陆事件 private void btnLogin_Click(object sender, EventArgs e) (/标识是否为合法用户bool isValidUser = false; string message ;if (IsValidataInput() (验证用户是否为合法用户 isValidUserIsValidataUser(txtLoginNo.Text.Trim(),txtLoginPwd.Text,cboLoginTy pe.Text,ref me

16、ssage); if (isValidUser) (/记录登陆用户名和用户类型UserHelper.loginNametxtLoginNo.Text.Trim(); UserHelper.loginType cboLoginType.Text;登陆类型是楼管会 if (cboLoginType.Text 楼管会) ( 登陆类型是维修部 else if (cboLoginType.Text 维修部) ( 登陆类型是总务处 else if (cboLoginType.Text 总务处) ( WFMain sfm new WFMain();sfm.Show();this.Hide();else(Me

17、ssageBox.Show(message,登 陆 提 示 ，MessageBoxButtons.OK,MessageBoxIcon.Asterisk);private void btnCanel_Click(object sender, EventArgs e) (DialogResult result = MessageBox.Show(您确定要退 出吗？ , 操 作提示 , MessageBoxButtons.OKCancel, MessageBoxIcon.Question);if (result = DialogResult.OK)(Application.Exit();privat

18、e void Login_Shown(object sender, EventArgs e)(光标焦点默认在输入账号上 txtLoginNo.Focus();private void Login_Load(object sender, EventArgs e)(privatevoidLogin_FormClosed(object sender,FormClosedEventArgs e)(Application.Exit();(2)注册界面：功能：注册。代码如下：using System;using System.Collections.Generic;using System.Compone

19、ntModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace VirgoMis(public partial class MRegister : Form(public MRegister()(InitializeComponent();private void WFRegison_Load(object sender, EventArgs e)(txtLogin

20、No.Focus();#region判断是否为有效输入private bool IsValidataInput()(if (txtLoginNo.Text.Trim()=)(MessageBox.Show(请输入账号！, 注册提示 MessageBoxButtons.OK, MessageBoxIcon.Information);txtLoginNo.Focus();return false;else if (txtLoginPwd.Text =)(MessageBox.Show(请输入密码！,注册提示， MessageBoxButtons.OK, MessageBoxIcon.Informa

21、tion);txtLoginPwd.Focus();return false;else if (DtxtLoginPwd.Text =)(MessageBox.Show(请再次确认输入密码！,注册 提示, MessageBoxButtons.OK, MessageBoxIcon.Information);DtxtLoginPwd.Focus();return false;(!txtLL_)if(MessageBox.Show(两次输入的密码不一致，请重新输入！，注册提示， MessageBoxButtons.OK, MessageBoxIcon.Information);DtxtLoginPw

22、d.Clear();txtLoginPwd.Clear();txtLoginPwd.Focus();return false;else if (cboLoginType.Text =)(MessageBox.Show(请选择登陆类型！,注册提示 , MessageBoxButtons.OK, MessageBoxIcon.Information);cboLoginType.Focus();return false;return true;#endregionprivate bool IsValidataUser(string loginNo, string loginPwd, string l

23、oginType, ref string message) (string sql = String.Format(select count(*) from DB_ManageInfo where loginNo = 0 and loginType =1, loginNo, loginType);int count = DBHelper.GetSqlResult(sql);if (count = 1)message =该账号已经存在，请重新注册！;return false;else( return true; private void btnEnter_Click(object sender,

24、 EventArgs e) (bool isValidUser = false; string message ;if (IsValidataInput() (验证用户是否为合法用户 isValidUser=IsValidataUser(txtLoginNo.Text.Trim(),txtLoginPwd.Text,cboLoginType.Text, ref message); if (isValidUser) (string sql String.Format(insert intoDB_ManageInfo(loginNo,loginPwd,loginType)values(0,1,2)

25、，txtLoginNo.Text.Trim(),txtLoginPwd.Text,cboL oginType.Text); int result DBHelper.GetDsqlResult(sql); if (result = 1) (MessageBox.Show(注册成功！, 注册提 示，MessageBoxButtons.OK, MessageBoxIcon.Asterisk); else (MessageBox.Show(注册失败！, 注册提 示，MessageBoxButtons.OK, MessageBoxIcon.Asterisk);else(MessageBox.Show(m

26、essage,注 册 提 示 ”,MessageBoxButtons.OK,MessageBoxIcon.Asterisk);txtLoginNo.Clear();txtLoginPwd.Clear();DtxtLoginPwd.Clear();cboLoginType.SelectedIndex = -1;txtLoginNo.Focus();private void btnExit_Click(object sender, EventArgs e)(this.Close();private void btnCanel_Click(object sender, EventArgs e)(th

27、is.Close();(3)主界面：功能：数据的显示，操作，各窗口跳转。代码如下：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace VirgoMis(public partial class WFMain : Form(public WFMain()(InitializeCom

28、ponent();private T OpenUniqueMDIChildWindow(Form mdiParent)where T : Form, new()(foreach (Form subForm in mdiParent.MdiChildren)(if (!subForm.GetType().Equals(typeof(T)(subForm.Close();else(subForm.Activate();return subForm as T;T newForm = new T();newForm.MdiParent = mdiParent;/newForm.FormBorderSt

29、yle = FormBorderStyle.None;/newForm.WindowState=FormWindowState.Maximized;/newForm.MaximizeBox=false;/newForm.MinimizeBox=false;newForm.StartPosition=FormStartPosition.CenterScreen;newForm.Show();return newForm;private void WFManage_Load(object sender, EventArgs e) (tsslState.Text = String.Format(0

30、: 1 登陆中 ，UserHelper.loginType,UserHelper.loginName);private void etsmiAppExit_Click(object sender, EventArgs e)DialogResult result = MessageBox.Show(您确定要退 出 该 系 统 吗？ , 操 作 提 示 ，MessageBoxButtons.OKCancel,MessageBoxIcon.Question);if (result = DialogResult.OK)Application.Exit();private void ztsmiDormR

31、egister_Click(object sender,EventArgs e)(OpenUniqueMDIChildWindow(this);/*foreach (Form form in this.MdiChildren)(if(!form.GetType().Equals(typeof(DormRegister)(form.Close();else(form.Activate();return;DormRegister WFdr = new DormRegister();WFdr.MdiParent = this;WFdr.Location = new Point(0,0);WFdr.S

32、how();*/private void btsmiBuildInfo_Click(object sender, EventArgs e)(OpenUniqueMDIChildWindow(this);private void dtsmiDormInfo_Click(object sender,EventArgs e)(OpenUniqueMDIChildWindow(this);private void etsmiStuInfoRegister_Click(object sender, EventArgs e)(OpenUniqueMDIChildWindow(this);private v

33、oid otsmiDormRepair_Click(object sender, EventArgs e)(OpenUniqueMDIChildWindow(this);private void ctsmiRepairFeedback_Click(object sender, EventArgs e) (OpenUniqueMDIChildWindow(this);private void dtsmiDormFouls_Click(object sender, EventArgs e)(OpenUniqueMDIChildWindow(this);private void ytsmiFouls

34、Feedback_Click(object sender, EventArgs e)(OpenUniqueMDIChildWindow(this);private void rtsmiMRegister_Click(object sender,EventArgs e)(OpenUniqueMDIChildWindow(this);private void utsmiMUpdate_Click(object sender, EventArgs e)(OpenUniqueMDIChildWindow(this);private void atsmiAbout_Click(object sender

35、, EventArgs e)(/*About about = new About();*about.MdiParent = this;*about.StartPosition=FormStartPosition.CenterScreen;*about.Show();*/OpenUniqueMDIChildWindow(this);private void tsbStuInfoSearch_Click(object sender, EventArgs e)(OpenUniqueMDIChildWindow(this);private void tsbRepairRecord_Click(obje

36、ct sender, EventArgs e)OpenUniqueMDIChildWindow(this);private void tsbFoulsRecord_Click(object sender,EventArgs e)(OpenUniqueMDIChildWindow(this);private void WFMain_FormClosed(object sender,FormClosedEventArgs e)(Application.Exit();(4)宿舍信息管理界面代码如下：using System;using System.Collections.Generic;using

37、 System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace VirgoMis(public partial class DormInfo : Form(public DormInfo()(InitializeComponent();SqlDataReader dataReader;private void DormInfo_Load

38、(object sender, EventArgs e)(cboBuildNo.Enabled = false;dCboBuildNo.Enabled = false;/初始化各控件cboBuildArea.Items.Clear();dCboBuildArea.Items.Clear();txtDormNo.Clear();cboBedNum.SelectedIndex = -1;txtDormElse.Clear();string sql = select * from DB_DormInfo;try(SqlCommand command = new SqlCommand(sql, DBH

39、elper.connection);DBHelper.connection.Open();dataReader = command.ExecuteReader();while (dataReader.Read()(ListViewItem lviDormInfo = new ListViewItem();lviDormInfo.SubItems.Clear();lviDormInfo.SubItems0.Text =dataReaderdormId.ToString();lviDormInfo.SubItems.Add(dataReaderbuildArea.ToString();lviDor

40、mInfo.SubItems.Add(dataReaderbuildNo.ToString();lviDormInfo.SubItems.Add(dataReaderdormNo.ToString();lviDormInfo.SubItems.Add(dataReaderbedNum.ToString();lviDormInfo.SubItems.Add(dataReaderdormElse.ToString();lvDormInfo.Items.Add(lviDormInfo);dataReader.Close();sql = select distinct buildArea from D

41、B_BuildInfo;command.CommandText = sql;dataReader = command.ExecuteReader();while (dataReader.Read()(cboBuildArea.Items.Add(dataReaderbuildArea.ToString();dCboBuildArea.Items.Add(dataReaderbuildArea.ToString();dataReader.Close();catch (Exception ex)(MessageBox.Show(ex.Message);finally(DBHelper.connec

42、tion.Close();private void cboBuildArea_SelectedIndexChanged(object sender, EventArgs e)(cboBuildNo.Items.Clear();string sql = String.Format(select buildNo from DB_BuildInfo where buildArea = 0order by buildNo, cboBuildArea.Text);try(SqlCommand command = new SqlCommand(sql, DBHelper.connection);DBHel

43、per.connection.Open();dataReader = command.ExecuteReader();while (dataReader.Read()(cboBuildNo.Items.Add(dataReaderbuildNo.ToString();dataReader.Close();cboBuildNo.Enabled = true;catch (Exception ex)(MessageBox.Show(ex.Message);finally(DBHelper.connection.Close();/验证是否是有效信息输入private bool IsValidataI

44、nput()(if (cboBuildArea.Text =)(MessageBox.Show(请选择宿舍的地理区域！，操作提示 ”,MessageBoxButtons.OK,MessageBoxIcon.Asterisk);return false;else if (cboBuildNo.Text =)(MessageBox.Show(请选择宿舍楼号！，操作提示 ，MessageBoxButtons.OK,MessageBoxIcon.Asterisk);return false;else if (txtDormNo.Text.Trim()=)(MessageBox.Show(请确定宿舍号！

45、，操作提示 ，MessageBoxButtons.OK,MessageBoxIcon.Asterisk);return false;else if (cboBedNum.Text =)(MessageBox.Show(请确定宿舍床位数！，操作提示 ，MessageBoxButtons.OK,MessageBoxIcon.Asterisk);return false;return true;验证是否是有效信息数据private bool IsValidata(string buildArea, int buildNo, int dormNo, ref string message)(string

46、 sql = String.Format(select count(*) from DB_DormInfo where buildArea = 0 and buildNo = 1 and dormNo = 2”,buildArea,buildNo,dormNo);trySqlCommand command = new SqlCommand(sql, DBHelper.connection);DBHelper.connection.Open();int count = (int)command.ExecuteScalar();if (count = 1)message = 该宿舍号已经存在，请重

47、新输入！； return false;elsereturn true;catch (Exception ex)(MessageBox.Show(ex.Message);return false;finally(DBHelper.connection.Close();验证是否是有效查询条件private bool IsSearchConditions()(if (dCboBuildArea.Text =)(MessageBox.Show(请选择查询的地理区域！ ，操作提示 ，MessageBoxButtons.OK,MessageBoxIcon.Asterisk);return false;el

48、se if (dCboBuildNo.Text =)(MessageBox.Show(请选择查询的宿舍楼号！，操作提示 ，MessageBoxButtons.OK,MessageBoxIcon.Asterisk);return false;return true;private void btnEnter_Click(object sender, EventArgs e)(bool isValidata = false; string message ;if (IsValidataInput() (isValidata = IsValidata(cboBuildArea.Text,Conver

49、t.ToInt32(cboBuildNo.Text),Convert.ToInt32(txtDormNo.Text),ref message);if (isValidata)(string sql String.Format(矿insert into DB_DormInfo(buildArea, buildNo, dormNo, bedNum, dormElse) values(0,1,2,3,4), cboBuildArea.Text,Convert.ToInt32(cboBuildNo.Text),Convert.ToInt32(txtDormNo.Text.Trim(),Convert.

50、ToInt32(cboBedNum.Text), txtDormElse.Text.Trim();try(SqlCommand command = new SqlCommand(sql, DBHelper.connection);DBHelper.connection.Open();int result = command.ExecuteNonQuery();if (result = 1)(MessageBox.Show(录入信息成功！，操作提 示，MessageBoxButtons.OK, MessageBoxIcon.Asterisk);else(MessageBox.Show(录入信息失

51、败！，操作提 示,MessageBoxButtons.OK, MessageBoxIcon.Asterisk);catch (Exception ex)(MessageBox.Show(ex.Message);finally(DBHelper.connection.Close();if (dCboBuildArea.Text = cboBuildArea.Text)(FormRefresh();else(btnRefresh.PerformClick();txtDormNo.Clear();txtDormElse.Clear();else(一MessageBox.Show(message，操作

52、提示，MessageBoxButtons.OK,MessageBoxIcon.Asterisk);private void btnExit_Click(object sender, EventArgs e)(this.Close();private void btnRefresh_Click(object sender, EventArgs e)(lvDormInfo.Items.Clear();初始化窗体DormInfo_Load(sender,e);/根据地理区域，宿舍楼号更新信息private void FormRefresh()(lvDormInfo.Items.Clear();执行

53、btnQuery_ClickbtnQuery.PerformClick();private void dCboBuildArea_SelectedIndexChanged(object sender, EventArgs e)(dCboBuildNo.Items.Clear();string sql = String.Format(select buildNo from DB_BuildInfo where buildArea = 0order by buildNo, dCboBuildArea.Text);try(SqlCommand command = new SqlCommand(sql

54、, DBHelper.connection);DBHelper.connection.Open();dataReader = command.ExecuteReader();while (dataReader.Read()(dCboBuildNo.Items.Add(dataReaderbuildNo.ToString();dataReader.Close();dCboBuildNo.Enabled = true;catch (Exception ex)(MessageBox.Show(ex.Message);finally(DBHelper.connection.Close(); priva

55、te void btnQuery_Click(object sender, EventArgs e) (if (IsSearchConditions()(lvDormInfo.Items.Clear();string sql = String.Format(select * from DB_DormInfo where buildArea = 0 and buildNo = 1”,dCboBuildArea.Text,Convert.ToInt32(dCboBuildNo.Text);测试数据库连接trySqlCommand command = new SqlCommand(sql, DBHe

56、lper.connection);打开数据库连接DBHelper.connection.Open();dataReader = command.ExecuteReader();while (dataReader.Read()ListViewItem lviDormInfo = new ListViewItem(); lviDormInfo.SubItems.Clear(); lviDormInfo.SubItems0.Text = dataReaderdormId.ToString();lviDormInfo.SubItems.Add(dataReaderbuildArea.ToString(

57、); lviDormInfo.SubItems.Add(dataReaderbuildNo.ToString(); lviDormInfo.SubItems.Add(dataReaderdormNo.ToString();lviDormInfo.SubItems.Add(dataReaderbedNum.ToString(); lviDormInfo.SubItems.Add(dataReaderdormElse.ToString(); lvDormInfo.Items.Add(lviDormInfo);dataReader.Close();catch (Exception ex)Messag

58、eBox.Show(ex.Message);finallyDBHelper.connection.Close();private void lvDormInfo_ItemSelectionChanged(object sender,ListViewItemSelectionChangedEventArgs e)(if (e.IsSelected)(uLblDormId.Text = e.Item.SubItems0.Text;uLblBuildArea.Text = e.Item.SubItems1.Text;uLblBuildNo.Text = e.Item.SubItems2.Text;u

59、LblDormNo.Text = e.Item.SubItems3.Text;uCboBedNum.Text = e.Item.SubItems4.Text;dTxtDormElse.Text = e.Item.SubItems5.Text;private void btnDel_Click(object sender, EventArgs e)(if (lvDormInfo.SelectedItems.Count = 0)(MessageBox.Show(请选择要删除的记录！，操作提示， MessageBoxButtons.OK, MessageBoxIcon.Asterisk);return;else(DialogResult result = MessageBox.Show(您确定要删除该 条记录吗？，操作提示，MessageBoxButtons.OKCancel, MessageBoxIcon.Question);if (result = DialogResult.OK)(string sql = String.Format(delete from DB_DormInfo where dormId = 0, Convert.ToInt32(uLblDormId.Text);trySqlCommand command = new SqlCommand(sql, D