1、软件工程学习与程序设计课程设计报告( 2010 - 2011 年度第 2 学期)名 称: 软件设计与实践 题 目:人事管理系统的设计与实现院 系: 计算机系 班 级: 网络0702班 学 号: 200709030217 学生姓名: 孟岩 指导教师: 软件设计与实践教学组 设计周数: 2 成 绩: 日期: 2011 年 5 月 10 日一、课程设计的目的与要求1 目的:通过综合性实验的设计,使学生综合训练自己的需求分析、系统设计、编程、测试等各种能力,积累软件开发的经验,提高学生进行软件开发所需具备的专业素质以及团队协作能力。2 要求:完成一个人事管理系统的分析、设计、编程、测试工作。二、设计正
2、文1、系统分析(需求分析)1.需求分析:能够输入职工的综合情况的输入、修改以及删除;能够实现对职工信息的浏览;能够实现对职工进行查询; 能够实现职工考勤2.系统性能要求:系统安全、可靠;功能齐全;操作方便、界面友好;3.系统的功能分析:资料维护:系统维护包括对各种表记录的修改、删除、添加等操作。资料维护:对数据表中的信息进行浏览。系统查询:可以按职工编号、姓名等相关信息进行详细或模糊查询。报表统计:包括统计职工编号、职工姓名、职工性别、所在部门、职工年龄、基本工资、考勤字段。其它操作:系统封面、计时器控制。4.系统功能模块人事管理系统有:数据浏览、数据修改、考勤、报表显示和系统封面构成。5.功
3、能的实现:“数据浏览”模块: 数据浏览:可以对数据表中的数据实现,上一项、下一项、首相、尾项等操作。“数据修改”模块:(1)添加数据:增加一个新的记录 (2)修改数据:修改原有记录。“考勤”模块: 对员工考勤“报表显示”模块: 显示当前查找到的数据内容,以报表形式打印。“系统封面构成”模块:功能实现:进入主界面与退出系统。2.系统设计1、界面设计:管理员的界面普通员工添加个人信息解雇员工考勤查询报表生成2、功能设计通过主窗体调用其他窗体,具体实现可以参照系统分析相关内容。应用系统主控界面包括记录编辑和记录查询等功能模块。记录编辑功能完成职工记录编辑的记录增加、记录删除、记录刷新和记录查询等功能
4、。记录查询功能可以对数据集中的记录进行查询三、课程设计总结或结论本次实验利用C#窗体编程,使用了TextBox、label、Button、dataGridView、reportViewer等控件实现界面,人机数据交流的功能。使用SQLserver实现数据的存储功能。通过SQL与virual studio的连接完成了本系统的设计。本次实验完成的较为成功。四、参考文献 1 王海龙, 董智勇 C#. 电子工业出版社, 2006.9附录(设计流程图、程序、表格、数据等)流程图:程序:增加员工界面源代码: public partial class add : Form private int dep;
5、private int edu; private int sal; private int ex = 01; public add() InitializeComponent(); private void add_Load(object sender, EventArgs e) SqlConnection MyConnection = DB.creatCon(); MyConnection.Open(); SqlCommand com = new SqlCommand(select * from depInfo,MyConnection); SqlDataReader dr = com.Ex
6、ecuteReader(); while (dr.Read() this.listBox1.Items.Add(dr1.ToString(); dr.Close(); com = new SqlCommand(select * from eduInfo, MyConnection); dr=com.ExecuteReader(); while(dr.Read() this.listBox2.Items.Add(dr1.ToString(); dr.Close(); com = new SqlCommand(select * from salInfo, MyConnection); dr = c
7、om.ExecuteReader(); while (dr.Read() this.listBox3.Items.Add(dr1.ToString(); dr.Close(); private void button1_Click(object sender, EventArgs e) int ID = Convert.ToInt32(txtID.Text); string name = txtName.Text.ToString(); string sex = txtSex.Text.ToString(); string birth = txtBirth.Text.ToString(); S
8、qlConnection MyConnection = DB.creatCon(); MyConnection.Open(); SqlCommand cmd = new SqlCommand(insert into eInfo values(+ID+,+name+,+sex+,+birth+),MyConnection); cmd.ExecuteNonQuery(); /cmd.Close(); txtName.Text = ; txtBirth.Text = ; txtID.Text = ; txtSex.Text = ; MyConnection.Close(); SqlConnectio
9、n con = DB.creatCon(); con.Open(); SqlCommand cmd2 = new SqlCommand(insert into baseInfo values(+ID+,+dep+,+edu+,+sal+,+ex+),con); cmd2.ExecuteNonQuery(); con.Close(); System.Windows.Forms.MessageBox.Show(添加成功!); private void listBox2_SelectedIndexChanged(object sender, EventArgs e) if (listBox2.Sel
10、ectedItem.ToString() != null) SqlConnection con = DB.creatCon(); con.Open(); string str = listBox2.SelectedItem.ToString(); SqlCommand cmd = new SqlCommand(select eduID from eduInfo where edu = +str+,con); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read() edu = (int)sdreduID; con.Close(); t
11、extBox2.Text = edu.ToString(); private void button3_Click(object sender, EventArgs e) Application.Exit(); private void button2_Click(object sender, EventArgs e) txtName.Text = ; txtBirth.Text = ; txtID.Text = ; txtSex.Text = ; private void listBox1_SelectedIndexChanged(object sender, EventArgs e) if
12、 (listBox1.SelectedItem.ToString() != null) SqlConnection con = DB.creatCon(); con.Open(); string str = listBox1.SelectedItem.ToString(); SqlCommand cmd = new SqlCommand(select eDepID from depInfo where depName =+str+,con); SqlDataReader sdr = cmd.ExecuteReader(); while(sdr.Read() dep = (int)sdreDep
13、ID; con.Close(); textBox1.Text = dep.ToString(); private void listBox3_SelectedIndexChanged(object sender, EventArgs e) if (listBox3.SelectedItem.ToString() != null) SqlConnection con = DB.creatCon(); con.Open(); string str = listBox3.SelectedItem.ToString(); SqlCommand cmd = new SqlCommand(select e
14、SalID from salInfo where Sal = + str + , con); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read() sal=(int)sdreSalID; con.Close(); textBox3.Text = sal.ToString(); 修改信息源代码 public partial class modify : Form private int s; private int dep; private int sal; public modify() InitializeComponent()
15、; private void textBox1_TextChanged(object sender, EventArgs e) SqlConnection con = DB.creatCon(); con.Open(); s = Convert.ToInt32(txtID.Text); SqlCommand cmd = new SqlCommand(select depName from depInfo,baseInfo where depInfo.eDepID=baseInfo.eDepID and baseInfo.eID= + s + , con); SqlDataReader sdr
16、= cmd.ExecuteReader(); while (sdr.Read() textBox2.Text = sdrdepName.ToString(); sdr.Close(); con.Close(); con.Open(); cmd = new SqlCommand(select sal from baseInfo,salInfo where baseInfo.eSalID=salInfo.eSalID and baseInfo.eID= + s + , con); SqlDataReader sdr2 = cmd.ExecuteReader(); while (sdr2.Read(
17、) textBox3.Text = sdr2sal.ToString(); con.Close(); private void button1_Click(object sender, EventArgs e) SqlConnection con = DB.creatCon(); con.Open(); SqlCommand cmd = new SqlCommand(update baseInfo set baseInfo.eDepID=+dep+ where baseInfo.eID = +s+,con); cmd.ExecuteNonQuery(); con.Close(); System
18、.Windows.Forms.MessageBox.Show(修改成功!); private void button2_Click(object sender, EventArgs e) SqlConnection con = DB.creatCon(); con.Open(); SqlCommand cmd = new SqlCommand(update baseInfo set baseInfo.eSalID= + sal + where baseInfo.eID = + s + , con); cmd.ExecuteNonQuery(); con.Close(); System.Wind
19、ows.Forms.MessageBox.Show(修改成功!); private void listBox1_SelectedIndexChanged(object sender, EventArgs e) if (listBox1.SelectedItem.ToString() != null) SqlConnection con = DB.creatCon(); con.Open(); string str = listBox1.SelectedItem.ToString(); SqlCommand cmd = new SqlCommand(select eDepID from depI
20、nfo where depName = + str + , con); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read() dep = (int)sdreDepID; con.Close(); private void modify_Load(object sender, EventArgs e) SqlConnection MyConnection = DB.creatCon(); MyConnection.Open(); SqlCommand com = new SqlCommand(select * from depInf
21、o, MyConnection); SqlDataReader dr = com.ExecuteReader(); while (dr.Read() /this.listBox1.Items.Add(dr0.ToString(); this.listBox1.Items.Add(dr1.ToString(); dr.Close(); com = new SqlCommand(select * from salInfo, MyConnection); dr = com.ExecuteReader(); while (dr.Read() this.listBox2.Items.Add(dr1.To
22、String(); dr.Close(); private void listBox2_SelectedIndexChanged(object sender, EventArgs e) if (listBox2.SelectedItem.ToString() != null) SqlConnection con = DB.creatCon(); con.Open(); string str = listBox2.SelectedItem.ToString(); SqlCommand cmd = new SqlCommand(select eSalID from salInfo where Sa
23、l = + str + , con); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read() sal=(int)sdreSalID; con.Close(); 解雇源代码 private void button1_Click(object sender, EventArgs e) int eID = Convert.ToInt32(textBox1.Text); SqlConnection con = DB.creatCon(); con.Open(); SqlCommand cmd = new SqlCommand(delete from baseInfo where eID=+eID+, con); cmd.ExecuteNonQuery(); cmd = new SqlCommand(delete from eInfo where eID= + eID + , con); cmd.ExecuteNonQuery(); con.Close(); System.Windows.Forms.MessageBox.Show(解雇成功!);
copyright@ 2008-2023 冰点文库 网站版权所有
经营许可证编号:鄂ICP备19020893号-2