yggl.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using GongZi.GongZiClass;
using System.Data.SqlClient;
namespace GongZi
{
    public partial class yggl : Form
    {
        public yggl()
        {
            InitializeComponent();
        }
        DBOperate operate = new DBOperate();//创建数据库操作对象
        private void frmEmployee_Load(object sender, EventArgs e)
        {
            string str = //创建查询字符串
                "select ID as '编号',employeeID as '员工编号',employeeName as '员工姓名',employeeSex as '员工性别',employeeDept as '所属部门',employeeBirthday as '员工生日',employeeNation as '民族',employeeMarriage as '婚姻状况',employeeDuty as '担任职务',employeePhone as '联系电话',employeeAccession as '就职日期' from tb_employee";
            operate.BindDataGridView(dgvEmployee,str);//将查询信息绑定到DataGridView控件
            dgvEmployee.Columns[0].Width = 40;//定义数据列宽度
            dgvEmployee.Columns[1].Width = 80;//定义数据列宽度
            treeView1.ImageList = imageList1;//设置控件的ImageList属性
            treeView1.ImageIndex = 0;//设置图像列表的索引
            treeView1.SelectedImageIndex =0;//设置选中节点时显示的图像列表索引
            string sql = "select count(*) from tb_employee";//定义SQL字符串
            toolStripStatusLabel2.Text=operate.HumanNum(sql).ToString()+"人";//显示员工人数
            TreeNode tn = treeView1.Nodes.Add("所有部门");//添加节点
            SqlConnection conn = DBConnection.MyConnection();//创建数据库连接对象
            conn.Open();//打开数据库连接
            SqlCommand cmd = new SqlCommand("select * from tb_department", conn);//创建命令对象
            SqlDataReader sdr = cmd.ExecuteReader();//创建数据读取器
            while (sdr.Read())//读取数据
            {
                tn.Nodes.Add(sdr["DepName"].ToString());//添加节点
            }
            sdr.Close();//关闭数据读取器
            conn.Close();//关闭数据库连接
            treeView1.ExpandAll();//展开所有节点
        }

        private void toolStripTextBox1_TextChanged(object sender, EventArgs e)
        {
            string str =//创建查询字符串
                "select ID as '编号',employeeID as '员工编号',employeeName as '员工姓名',employeeSex as '员工性别',employeeDept as '所属部门',employeeBirthday as '员工生日',employeeNation as '民族',employeeMarriage as '婚姻状况',employeeDuty as '担任职务',employeePhone as '联系电话',employeeAccession as '就职日期' from tb_employee where employeeName like '%"+toolStripTextBox1.Text.Trim()+"%'";
            operate.BindDataGridView(dgvEmployee, str);//将查询信息绑定到DataGridView控件
            dgvEmployee.Columns[0].Width = 40;//定义数据列宽度
            dgvEmployee.Columns[1].Width = 80;//定义数据列宽度
        }

        private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            string str = e.Node.Text;//得到选中节点的字符串
            if (str == "所有部门")
            {
                string SQLStr = //创建查询字符串
                     "select ID as '编号',employeeID as '员工编号',employeeName as '员工姓名',employeeSex as '员工性别',employeeDept as '所属部门',employeeBirthday as '员工生日',employeeNation as '民族',employeeMarriage as '婚姻状况',employeeDuty as '担任职务',employeePhone as '联系电话',employeeAccession as '就职日期' from tb_employee";