人事管理系统实验报告

1、重庆邮电大学理学院信息与计算科学专业集中实践报告 题 目： 人事管理系统 指导老师： 李永红 系 别： 数学系 专 业： 信息与计算科学 班 级： 学 号： 姓 名： 唐敬源 学 号： 姓 名： 徐思齐 成 绩： 20 17 年 6 月 28 日人事客户管理系统实验报告一 系统需求分析随着信息化时代的快速发展，企业人事管理变得十分繁杂，大量的客户资料信息的堆积让他公司的经营变得不畅，人事管理系统的出现让越来越多的企业享受到了福利，因为其方便快捷易于维护的特点，极大地提高了企业人事管理的办事效率，第一时间掌握人事信心，客户信息让公司的管理经营尽在掌控之中。二 系统模块设计关于软件 登录界面 退出

2、系统 更改密码用户管理系统添加客户添加投诉添加服务客户管理数据库设计模块：Data table： Manager customer addcompliant addserviceClient Addclient aboutmanager表：实验使用软件为： VS stdio 2010 c#语言 Microsoft SQL sever 2008 数据库语言 Windows7 XP环境三 实验内容及其结果1. 登录模块的设计 代码： namespace CRM_System public partial class Form1 : Form public Form1() InitializeCom

3、ponent(); private void Form1_Load(object sender, EventArgs e) private void btnExit_Click(object sender, EventArgs e) Application.Exit(); private void btnLogin_Click(object sender, EventArgs e) if (tbUser.Text.Trim().Length = 0)/判断是否输入用户名 MessageBox.Show(请输入用户名！); tbUser.Focus(); return; if (tbPwd.Te

4、xt.Trim().Length = 0) MessageBox.Show(请输入密码！); tbPwd.Focus(); return; /创建commom对象 common com= new common(); /创建database对象 database db = new database(); /统计所输入的用户名和密码在对应数据表中个数的查询语句 int t = 0; string sql = select count(*) from manager where username + tbUser.Text.Trim() + and Pwd= + com.md5(tbPwd.Text

5、.Trim() + ; /将对应表中数据条数放在变量t当中 t = db.runSqlInt(sql); if (t 0) this.Hide(); main fmain = new main(); fmain.User = tbUser.Text.Trim(); fmain.Show(); else MessageBox.Show(用户名或者密码错误!); 2.主登录模块代码为： namespace 管理系统_客户管理系统 public partial class main : Form public main() InitializeComponent(); private string

6、user; public string User get return user; set user = value; private void main_Load(object sender, EventArgs e) private void main_FormClosing(object sender, FormClosingEventArgs e) DialogResult result = MessageBox.Show(你确认退出系统, 退出m对话框, MessageBoxButtons.YesNo); if (result = DialogResult.Yes) this.Dis

7、pose(); else e.Cancel = true; private void lklblExit_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) DialogResult result = MessageBox.Show(你确认退出系统, 退出m对话框, MessageBoxButtons.YesNo); if (result = DialogResult.Yes) this.Dispose(); private void 退出系统ToolStripMenuItem_Click(object sender, Eve

8、ntArgs e) DialogResult result = MessageBox.Show(你确认退出系统, 退出m对话框, MessageBoxButtons.YesNo); if (result = DialogResult.Yes) this.Dispose(); private void lklblAddClient_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) AddClient ac = new AddClient(); ac.Show(); private void lklblComplaint_Lin

9、kClicked(object sender, LinkLabelLinkClickedEventArgs e) AddComplaint acom = new AddComplaint(); acom.Show(); private void lklblAddSevice_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) AddService aser = new AddService(); aser.Show(); private void 添加客户ToolStripMenuItem_Click(object sende

10、r, EventArgs e) AddClient ac = new AddClient(); ac.Show(); private void 客户管理ToolStripMenuItem1_Click(object sender, EventArgs e) Client cli = new Client(); cli.Show(); private void 添加服务ToolStripMenuItem_Click(object sender, EventArgs e) AddService aser = new AddService(); aser.Show(); private void 添

11、加投诉ToolStripMenuItem_Click(object sender, EventArgs e) AddComplaint acom = new AddComplaint(); acom.Show(); private void 更改密码ToolStripMenuItem_Click(object sender, EventArgs e) About ab = new About(); ab.Show(); 3. 客户管理修改数据：删除数据：添加数据： 代码为： namespace 管理系统_客户管理系统 public partial class Client : Form pub

12、lic Client() InitializeComponent(); private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e) if (e.ClickedItem.Name = tslblAdd) modclient(); if (e.ClickedItem.Name = tslblModify) modclient(); if (e.ClickedItem.Name = tslblDelete) DialogResult status = MessageBox.Show(你确定删除

13、所选的行吗？,确认对话框,MessageBoxButtons.YesNo); if (status = DialogResult.Yes) modclient(); common com = new common(); database db = new database(); private void showCustomer() com.bindDGV(dataGridView1, select * from customer order by id desc); private void Client_Load(object sender, EventArgs e) /显示客户的方法 s

14、howCustomer(); /添加客户 private void showForm(int t) AddClient ac = new AddClient(); ac.ID = t; DialogResult result = ac.ShowDialog(); if (result = DialogResult.OK) showCustomer(); /修改客户 private void modclient() if (dataGridView1.RowCount 0) if (dataGridView1.SelectedRows.Count = 1) string value = data

15、GridView1.SelectedRows0.Cells0.Value.ToString(); if (value != null & value != string.Empty) showForm(int.Parse(value); else MessageBox.Show(所选择行不存在数据); else MessageBox.Show( 请选择一行要修改的数据); else MessageBox.Show(目前没有任何数据); 添加客户管理： 代码： namespace 管理系统_客户管理系统 public partial class AddClient : Form public A

16、ddClient() InitializeComponent(); common com = new common(); database db = new database(); private void AddClient_Load(object sender, EventArgs e) try com.bindComboBox(cbbnation, Select id,nation from nation order by id esc); /绑定名族 if (ID != 0) cbbgender.SelectedIndex = 0; cbbsource.SelectedIndex =

17、0; cbbcon.SelectedIndex = 0; cbbculture.SelectedIndex = 0; cbbcon.SelectedIndex = 0; cbbearing.SelectedIndex = 0; cbbmarriage.SelectedIndex = 0; Level.SelectedIndex = 0; Text = 客户修改资料; btnAdd.Text = 修改; showClient(ID); catch (Exception ex) MessageBox.Show(ex.Message.ToString(); private void showClie

18、nt(int t) SqlDataReader dr; db.runSql(select * from customer where id + t, out dr); if (dr.Read() tbname.Text = drusername.ToString(); com.CbbIndexByText(cbbnation, drnation.ToString(); dtpBirthday.Value = DateTime.Parse(drBirthday.ToString(); com.CbbIndexByText(cbbgender, drgender.ToString(); tbIdc

19、ard.Text = drIdcard.ToString(); tbaddress.Text = draddress.ToString(); tbEmail.Text = drEmail.ToString(); tbhobby.Text = drhobby.ToString(); tbmobile.Text = drmobile.ToString(); tbQQ.Text = drQQ.ToString(); tbTel.Text = drTel.ToString(); com.CbbIndexByText(cbbcity, drcity.ToString(); com.CbbIndexByT

20、ext(cbbprovince, drprovince.ToString(); com.CbbIndexByText(cbbcon, drcon.ToString(); com.CbbIndexByText(cbbculture, drculture.ToString(); com.CbbIndexByText(cbbearing, drearing.ToString(); com.CbbIndexByText(cbbmarriage, drmarriage.ToString(); com.CbbIndexByText(Level, drLevel.ToString(); else Messa

21、geBox.Show(你所修改的项不存在，将关闭窗体); Close(); private int _id; public int ID get return _id; set _id = value; private void btnAdd_Click(object sender, EventArgs e) if (tbname.Text.Trim().Length = 0) MessageBox.Show(请输入用户名); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (tbaddress.Text.

22、Trim().Length = 0) MessageBox.Show(请输入地址); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (tbIdcard.Text.Trim().Length = 0) MessageBox.Show(请输入身份证号码); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (tbEmail.Text.Trim().Length = 0) MessageBox.Show(请输入邮箱号码); t

23、bname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (tbhobby.Text.Trim().Length = 0) MessageBox.Show(请输入爱好); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (tbhobby.Text.Trim().Length = 0) MessageBox.Show(请输入爱好); tbname.Focus(); btnAdd.DialogResult = DialogResult.

24、None; return; if (tbmobile.Text.Trim().Length = 0) MessageBox.Show(请输入电话号码); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (tbQQ.Text.Trim().Length = 0) MessageBox.Show(请输入QQ); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (tbTel.Text.Trim().Length = 0) Me

25、ssageBox.Show(请输入电话号码); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (cbbgender.Text.Trim().Length = 0) MessageBox.Show(请选择性别); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (cbbcity.Text.Trim().Length = 0) MessageBox.Show(请选择城市); tbname.Focus(); btnAdd.D

26、ialogResult = DialogResult.None; return; if (cbbcon.Text.Trim().Length = 0) MessageBox.Show(请选择重要程度); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (cbbculture.Text.Trim().Length = 0) MessageBox.Show(请选择宗教信仰); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if

27、(cbbnation.Text.Trim().Length = 0) MessageBox.Show(请选择名族); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (cbbprovince.Text.Trim().Length = 0) MessageBox.Show(请选择省份); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (cbbsource.Text.Trim().Length = 0) MessageBo

28、x.Show(请添加省份); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (cbbmarriage.Text.Trim().Length = 0) MessageBox.Show(请添加婚姻状况); tbname.Focus(); btnAdd.DialogResult = DialogResult.None; return; if (Level.Text.Trim().Length = 0) MessageBox.Show(请选择客户重要级别); tbname.Focus(); btnAdd.Dial

29、ogResult = DialogResult.None; return; string sql = ; string Rstatus = 添加; if (ID = 0) sql = insert into customer(username,nation,brithday,gender,IDcard,hobby,marriage ,source,levels,earning,concement,mobile,tel,QQ,culture,Email,province,city,address) values + ( + tbname.Text.Trim() + , + cbbnation.T

30、ext + , + dtpBirthday.Value + , + cbbgender.Text + , + tbaIdcard.Text.Trim() + , + tbhobby.Text.Trim() + , + cbbmarriage.Text.Trim() + , + cbbsource.Text + , + Level.Text + , + cbbearing.Text + , + cbbcon.Text + , + tbmobile.Text.Trim() + , + tbTel.Text.Trim() + , + tbQQ.Text.Trim() + , + cbbculture

31、.Text + ， + tbEmail.Text.Trim() + , + cbbprovince.Text + , + cbbcity.Text + ， + tbaddress.Text.Trim() + ); else Rstatus = 修改; sql = updata customer set username + tbname.Text.Trim() + nation + cbbnation.Text + birthday + dtpBirthday.Value + gender + cbbgender.Text + IDcard + tbaIdcard.Text.Trim() +

32、hobby + tbhobby.Text.Trim() + marriage + comboBox1.Text + source + cbbSource.Text + levels + comboBox2.Text + earing + cbbearing.Text + concement + cbbcon.Text + mobile + tbmobile.Text.Trim() + tel + tbTel.Text.Trim() + QQ + tbQQ.Text.Trim() + culture + cbbculture.Text + Email + tbEmail.Text.Trim()

33、+ province + cbbprovince.Text + city + cbbcity.Text + address + tbaddress.Text.Trim() + where id= + _id; db.runSql(sql); MessageBox.Show(Rstatus + 成功！); 投诉模块设计： 代码为： namespace CRM_System public partial class AddComplaint : Form public AddComplaint() InitializeComponent(); private void textBox1_TextChanged(object sender, EventArgs e) private void btClose_Click(object sender, EventArgs e) Close(); database db = new database(); private void btnscelect_Click(object sender, EventArgs e) SelectClient sc = new SelectClient(); DialogResult result=sc.ShowDialog(); if (result = DialogResult.OK)