formdepartmentmanagement.cs

人事管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

namespace HumanResourceManagement
{
    public partial class FormDepartmentManagement : Form
    {
        public FormDepartmentManagement()
        {
            InitializeComponent();
        }

        private const int CP_NOCLOSE_BUTTON = 0x200;
        protected override CreateParams CreateParams
        {
            get
            {
                CreateParams myCp = base.CreateParams;
                myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON;
                return myCp;
            }
        } 

        public static string Select_String;

        public void TreeView_Select(string Table_Name, string Date_Column_Name)
        {
            SqlConnection con = DB.connection();
            con.Open();
            SqlCommand cmd = new SqlCommand("select DeptName from tblDepartment", con);
            SqlDataAdapter sda = new SqlDataAdapter();
            DataTable sdt = new DataTable();

        }

        private void btnQuit_Click(object sender, EventArgs e)
        {
            this.Close();
            Main M = new Main();
            M.Show();

        }

        private void btnAddDept_Click(object sender, EventArgs e)
        {
            this.Hide();
            FormAddDepartment FAD = new FormAddDepartment();
            FAD.Show();
        }

        private void btnDeleteDept_Click(object sender, EventArgs e)
        {
            string DD = tvDept.SelectedNode.Text;
            MessageBox.Show(DD.ToString());
            SqlConnection con = DB.connection();
            con.Open();
            SqlCommand cmd = new SqlCommand("delete from tblDepartment where DeptName='" + DD + "'", con);
            int count = Convert.ToInt32(cmd.ExecuteNonQuery());
            if (count > 0)
            {
                DialogResult = MessageBox.Show("删除成功！", "提示");
                this.Hide();
                FormDepartmentManagement FDM = new FormDepartmentManagement();
                FDM.Show();

            }
            else
                DialogResult = MessageBox.Show("操作失败！", "提示");
            con.Close();
        }

        private void btnDeptDetinfo_Click(object sender, EventArgs e)
        {
            Select_String =tvDept.SelectedNode.Text;
            if (Select_String == "")
            {
                DialogResult = MessageBox.Show("请选择你要查看的部门！", "提示");
            }
            else

                this.Hide();
            FromDepartmentDetails FDP = new FromDepartmentDetails();
            FDP.Show();
        }

        private void DeptManagement_Load(object sender, EventArgs e)
        {
            SqlConnection con = DB.connection();
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from tblDepartment", con);
            SqlDataReader bm = cmd.ExecuteReader();
            while (bm.Read())
            {
                tvDept.Nodes.Add(bm["DeptName"].ToString());
            }
            con.Close();

        }
    }
}