employees.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;

namespace BlueHill_Win_
{
    public partial class Employees : Form
    {
        public Employees()
        {
            InitializeComponent();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            //this.Hide();
            //Main M = new Main();
            //M.Show();
            this.Close();
        }

        private void btnNewEmployee_Click(object sender, EventArgs e)
        {
            this.Hide();
            NewEmployee NE = new NewEmployee();
            NE.Show();
        }

        private void btnEditEmployee_Click(object sender, EventArgs e)
        {
            string ss = grdEmployee[grdEmployee.CurrentCell].ToString();
            DB.setA = ss;
            this.Hide();
            EditEmployee EE = new EditEmployee();
            EE.Show();
        }

        private void btnQueryEmployee_Click(object sender, EventArgs e)
        {
            //this.Hide();
            EmployeeSelect ES = new EmployeeSelect();
            ES.Show();
        }

        private void Employees_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“blueHillManagementDataSet10.员工表”中。您可以根据需要移动或移除它。
            this.员工表TableAdapter3.Fill(this.blueHillManagementDataSet10.员工表);
            // TODO: 这行代码将数据加载到表“blueHillManagementDataSet9.员工表”中。您可以根据需要移动或移除它。
            this.员工表TableAdapter2.Fill(this.blueHillManagementDataSet9.员工表);
            ////// TODO: 这行代码将数据加载到表“blueHillManagementDataSet6.员工表”中。您可以根据需要移动或移除它。
            ////this.员工表TableAdapter1.Fill(this.blueHillManagementDataSet6.员工表);
            ////// TODO: 这行代码将数据加载到表“blueHillManagementDataSet.员工表”中。您可以根据需要移动或移除它。
            ////this.员工表TableAdapter.Fill(this.blueHillManagementDataSet.员工表);
           
        }

        private void grdEmployee_Navigate(object sender, NavigateEventArgs ne)
        {

        }

        private void btnDeleteEmployee_Click(object sender, EventArgs e)
        {
            string ss = grdEmployee[grdEmployee.CurrentCell].ToString();
            SqlConnection con = DB.connection();
            con.Open();
            SqlCommand cmd = new SqlCommand("delete from 员工表 where 员工编号='" + ss + "'", con);
            int count = Convert.ToInt32(cmd.ExecuteNonQuery());
            if (count > 0)
            {
                DialogResult = MessageBox.Show("删除成功！", "提示");
                
                //grdEmployee.EditItemIndex = -1;
                this.Hide();
                Employees E = new Employees();
                E.Show();

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