第1页 / 共27页
第2页 / 共27页
第3页 / 共27页
第4页 / 共27页
第5页 / 共27页
第6页 / 共27页
第7页 / 共27页
第8页 / 共27页
c#人事管理系统.docx
C#程序设计实验报告
------人事管理系统
一．程序步骤
先设置一个登录界面（连接数据库），登录时进行判断，根据不同的错误信息进行报错，如密码错误。登陆成
功后，进入主界面。主界面通过树和表格来显示数据。可以对人员，班组，部门进行增删改查操作，数据保存在数
据库中。
二．程序源码
1.数据库表结构
2、登录界面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
1 / 27
using System.Threading.Tasks;
using System.Windows.Forms;
using CCWin;
using System.Data.SqlClient;
namespace 实验__人事管理系统
{
public partial class Form_login : CCSkinMain
{
public Form_login()
{
InitializeComponent();
}
string src = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\博博
\documents\visual studio 2013\Projects\实验——人事管理系统\实验——人事管理系统
\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 = 0;
int sign2 = 0;
if (user == "" || password == "")
MessageBox.Show("您输入的数据不完整！");
else
{
USERNAME=N'{0}';", user);
string sql1 = string.Format("select USERNAME from [Table_login] where
using (SqlConnection coon = new SqlConnection(src))
{
SqlCommand cmd = new SqlCommand(sql1, coon);
coon.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
sign1++;
}
}
2 / 27
}
if (sign1 == 0)
MessageBox.Show("未查询到您的用户信息！");
if (sign1 != 0)
{
USERNAME=N'{0}';", user);
string sql2 = string.Format("select PASSWORD from [Table_login] where
using (SqlConnection coon = new SqlConnection(src))
{
SqlCommand cmd = new SqlCommand(sql2, coon);
coon.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (password == dr["PASSWORD"].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.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
3 / 27
using System.Timers;
using System.Data.SqlClient;
using CCWin;
namespace 实验__人事管理系统
{
public partial class Form_show : Form
{
public Form_show()
{
InitializeComponent();
}
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;
// string category_name;
string src = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\博博
\documents\visual studio 2013\Projects\实验——人事管理系统\实验——人事管理系统
\MyData.mdf;Integrated Security=True";
private void Form_show_Load(object sender, EventArgs e)
{
toolStripStatusLabel_name.Text = "管理员：" + this.login_name;
toolStripStatusLabel_time.Text = "登录时间：" +
DateTime.Now.ToLongTimeString();
this.dataGridView1.ClearSelection();
Addparent();
}
private void toolStripStatusLabel_name_Click(object sender, EventArgs e)
{
}
private void Form_show_FormClosed(object sender, FormClosedEventArgs e)
4 / 27
{
fl.Close();
}
public void Addparent()
{
string sql = "select * 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 = dr["NAME"].ToString();
string number = dr["NUMBER"].ToString();
// string category=dr["CATEGORY"].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(pnode.Parent.Tag) == 0))
{
"order by NAME desc;";
string sql = "select * from [Table_tree]
where PR_NUMBER=" + pnumber +
using (SqlConnection conn = new SqlConnection(src))
{
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
string name = dr["NAME"].ToString();
5 / 27
string number = dr["NUMBER"].ToString();
// string category = dr["CATEGORY"].ToString();
TreeNode tn = new TreeNode();
tn.Text = name;
tn.Tag = number;
tn.ImageIndex = 1;
AddChild(number, tn);
pnode.Nodes.Add(tn);
}
}
}
}
else
{
"order by NAME desc;";
string sql = "select * from [Table_tree]
where PR_NUMBER=" + pnumber +
using (SqlConnection conn = new SqlConnection(src))
{
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
string name = dr["NAME"].ToString();
string number = dr["NUMBER"].ToString();
// string category = dr["CATEGORY"].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(object sender, EventArgs e)//无用的按钮
{
}
6 / 27
private void skinButton_add_Click_1(object sender, EventArgs e)
{
//MessageBox.Show("添加！");
if (t.Parent.Parent!=null && t.Parent!=null)
{
Form_Addperson fp = new Form_Addperson(t, toolStripStatusLabel_name.Text,
DateTime.Now.ToString());
fp.Owner = this;
fp.Show();
list.Clear();
}
else
MessageBox.Show("请到班组添加人员！");
// reshow();
}
private void treeView_jiegou_AfterSelect(object sender, TreeViewEventArgs e)
{
string sql = "select * from Table_person where CATEGORY_NUMBER=" + e.Node.Tag;
List list = new List();
using (SqlConnection conn = new SqlConnection(src))
{
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
person p = new person();
p.Person_name = dr["PERSON_NAME"].ToString();
p.Category_name = dr["CATEGORY_NAME"].ToString();
p.Sex = dr["SEX"].ToString();
string []dt=dr["BIRTH"].ToString().Split(' ');
p.Birth = dt[0];
= dr["EDUCATION"].ToString();
p.Education
p.Adminisitrator = dr["ADMINISITRATOR"].ToString();
p.Manegetime=dr["MANEGETIME"].ToString();
list.Add(p);
}
}
this.dataGridView1.ClearSelection();
this.dataGridView1.DataSource = list;
ID = -1;
7 / 27
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
