《c#实验报告(人事管理系统)》由会员分享,可在线阅读,更多相关《c#实验报告(人事管理系统)(30页珍藏版)》请在金锄头文库上搜索。
1、C#实验报告(人事管理系统)学 号 149074353姓 名 程裕博班 级 物 141指导教师 夏敏安徽工业大学计算机学院2016 年 12 月一程序步骤先设置一个登录界面(连接数据库) ,登录时进行判断,根据不同的错误信息进行报错,如密码错误。登陆成功后,进入主界面。主界面通过树和表格来显示数据。可以对人员,班组,部门进行增删改查操作,数据保存在数据库中。二程序源码1.数据库表结构2、登录界面using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using Sys
2、tem.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using CCWin;using System.Data.SqlClient;namespace 实验_人事管理系统public partial class Form_login : CCSkinMainpublic Form_login()InitializeComponent();string src = Data Source=(LocalDB)v11.0;AttachDbFile
3、name=c:users博博documentsvisual studio 2013Projects实验 人事管理系统实验 人事管理系统MyData.mdf;Integrated Security=True;private void Form1_Load(object sender, EventArgs e)private void button_login_Click(object sender, EventArgs e)string user = this.skinTextBox.Text;string password = this.skinTextBox2.Text;int sign1
4、= 0;int sign2 = 0;if (user = | password = )MessageBox.Show(您输入的数据不完整!);elsestring sql1 = string.Format(select USERNAME from Table_login where USERNAME=N0;, user);using (SqlConnection coon = new SqlConnection(src)SqlCommand cmd = new SqlCommand(sql1, coon); coon.Open();using (SqlDataReader dr = cmd.E
5、xecuteReader()while (dr.Read()sign1+;if (sign1 = 0)MessageBox.Show(未查询到您的用户信息!);if (sign1 != 0)string sql2 = string.Format(select PASSWORD from Table_login where USERNAME=N0;, user);using (SqlConnection coon = new SqlConnection(src)SqlCommand cmd = new SqlCommand(sql2, coon);coon.Open();using (SqlDa
6、taReader dr = cmd.ExecuteReader()while (dr.Read()if (password = drPASSWORD.ToString()sign2+;if (sign1 != 0 & sign2 = 0)MessageBox.Show(您的密码输入错误!);if (sign2 != 0) Form_show f1 = new Form_show(user, this); f1.Show();this.Visible = false;3、主界面using System;using System.Collections.Generic;using System.C
7、omponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Timers;using System.Data.SqlClient;using CCWin;namespace 实验_人事管理系统public partial class Form_show : Formpublic Form_show()InitializeComponent()
8、;public Form_show(string name1,Form_login f)login_name=name1;fl = f;InitializeComponent();string login_name=xx;Form_login fl =null ;TreeNode t = new TreeNode();int ID=-1;public List list = new List();string name;string birth;string sex;string education;string adminisitrator;string manegetime;/ strin
9、g category_name;string src = Data Source=(LocalDB)v11.0;AttachDbFilename=c:users博博documentsvisual studio 2013Projects实验 人事管理系统实验 人事管理系统MyData.mdf;Integrated Security=True; private void Form_show_Load(object sender, EventArgs e)toolStripStatusLabel_name.Text = 管理员: + this.login_name;toolStripStatusLa
10、bel_time.Text = 登录时间: + DateTime.Now.ToLongTimeString();Addparent();this.dataGridView1.ClearSelection();private void toolStripStatusLabel_name_Click(object sender, EventArgs e)private void Form_show_FormClosed(object sender, FormClosedEventArgs e)fl.Close();public void Addparent()string sql = select
11、 * from Table_tree where PR_NUMBER=-1;using (SqlConnection coon = new SqlConnection(src)SqlCommand cmd = new SqlCommand(sql, coon);coon.Open();using (SqlDataReader dr = cmd.ExecuteReader()while (dr.Read()string name = drNAME.ToString();string number = drNUMBER.ToString();/ string category=drCATEGORY
12、.ToString();TreeNode tn = new TreeNode();tn.Text = name;tn.Tag = number;tn.ImageIndex = 1;AddChild(number, tn);treeView_jiegou.Nodes.Add(tn);/ skinTreeView1.Nodes.Add(tn); private void AddChild(string pnumber, TreeNode pnode)if (Convert.ToInt32(pnode.Tag) = 0 | (pnode.Parent!=null & Convert.ToInt32(
13、pnode.Parent.Tag) = 0)string sql = select * from Table_tree where PR_NUMBER= + pnumber + order by NAME desc;using (SqlConnection conn = new SqlConnection(src)SqlCommand cmd = new SqlCommand(sql, conn);conn.Open();using (SqlDataReader dr = cmd.ExecuteReader()while (dr.Read()string name = drNAME.ToStr
14、ing();string number = drNUMBER.ToString();/ string category = drCATEGORY.ToString();TreeNode tn = new TreeNode();tn.Text = name;tn.Tag = number;tn.ImageIndex = 1;AddChild(number, tn);pnode.Nodes.Add(tn);elsestring sql = select * from Table_tree where PR_NUMBER= + pnumber + order by NAME desc;using (
15、SqlConnection conn = new SqlConnection(src)SqlCommand cmd = new SqlCommand(sql, conn);conn.Open();using (SqlDataReader dr = cmd.ExecuteReader()while (dr.Read()string name = drNAME.ToString(); string number = drNUMBER.ToString();/ string category = drCATEGORY.ToString();TreeNode tn = new TreeNode();tn.Text = name;tn.Tag = number;tn.ImageIndex = 0;AddChild(number, tn);pnode.Nodes.Add(tn);private void skinButton_add_Click(objec