information.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.Collections;

namespace renshiguanli
{
    public partial class Information : Form
    {
        public static Class_employee employee = new Class_employee();
        public static Class_sql sql = new Class_sql();
        public static int cell_selected=-1;
        public Information()
        {
            InitializeComponent();
        }

        private void set_gridview()
        {
            string strConnecton = "Server=NUAA\\SQLEXPRESS;Integrated Security=SSPI;DataBase=aaa";
            SqlConnection mycon = new SqlConnection(strConnecton);
            SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT * FROM tblEmployee", mycon);
            SqlCommandBuilder myBuilder = new SqlCommandBuilder(myAdapter);
            DataSet myDataset = new DataSet();
            mycon.Open();
            myAdapter.Fill(myDataset, "tblEmployee");
            dataGridView1.Rows.Clear();
            for (int k = 0; k < myDataset.Tables["tblEmployee"].Rows.Count; k++)
            {
                dataGridView1.Rows.Add();
                dataGridView1["EmployeeID", k].Value = (int)myDataset.Tables["tblEmployee"].Rows[k]["EmployeeID"];
                dataGridView1["name", k].Value = myDataset.Tables["tblEmployee"].Rows[k]["Name"];
                dataGridView1["LoginName", k].Value = myDataset.Tables["tblEmployee"].Rows[k]["LoginName"];
                dataGridView1["Email", k].Value = myDataset.Tables["tblEmployee"].Rows[k]["Email"];
                dataGridView1["Department", k].Value = sql.convert_dept((int)myDataset.Tables["tblEmployee"].Rows[k]["DeptID"]);
                dataGridView1["BasicSalary", k].Value = (int)myDataset.Tables["tblEmployee"].Rows[k]["BasicSalary"];
                dataGridView1["Title", k].Value = myDataset.Tables["tblEmployee"].Rows[k]["Title"];
                dataGridView1["Telephone", k].Value = myDataset.Tables["tblEmployee"].Rows[k]["Telephone"];
                dataGridView1["OnboardDate", k].Value = myDataset.Tables["tblEmployee"].Rows[k]["OnboardDate"];
                dataGridView1["Level", k].Value = myDataset.Tables["tblEmployee"].Rows[k]["EmployeeLevel"];
            }
            mycon.Close();
        }

        private void btn_add_Click(object sender, EventArgs e)
        {
            Add ad = new Add();
            if (ad.ShowDialog() == DialogResult.OK)
            {
                sql.add_employee(employee);
//                MessageBox.Show(employee.DeptID.ToString());
                set_gridview();
            }
        }

        private void btn_modify_Click(object sender, EventArgs e)
        {
            if (cell_selected==-1 )
            {
                MessageBox.Show("请选择员工");
            }
            else 
            {
                Modify mod = new Modify();
                if (mod.ShowDialog() == DialogResult.OK)
                {
                    sql.modify_employee(employee);
                    set_gridview();
                    cell_selected = -1;
                }
            }

 //           mod.Show();
        }

        private void btn_showall_Click(object sender, EventArgs e)
        {
            set_gridview();
        }

        private void btn_search_Click(object sender, EventArgs e)
        {
            Search sch = new Search();
            if (sch.ShowDialog()== DialogResult.OK)
            {
                ArrayList found_employee=sql.search_employee(Search.name_search, Search.email_search, Search.deptid_search);
               if (found_employee.Count == 0)
               {
                   MessageBox.Show("查无此人");
               }
               else
               {
                   SqlConnection mycon = new SqlConnection("Server=NUAA\\SQLEXPRESS;Integrated Security=SSPI;DataBase=aaa");
                   mycon.Open();
                   SqlDataAdapter myAdapter = new SqlDataAdapter("select * from tblEmployee", mycon);
                   SqlCommandBuilder myBuilder = new SqlCommandBuilder(myAdapter);
                   DataSet myDataset = new DataSet();
                   myAdapter.Fill(myDataset, "tblEmployee");
                   dataGridView1.Rows.Clear();
                   for (int k = 0; k < found_employee.Count; k++)
                   {
                       dataGridView1.Rows.Add();
                       dataGridView1["EmployeeID", k].Value = (int)myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["EmployeeID"];
                       dataGridView1["name", k].Value = myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["Name"];
                       dataGridView1["LoginName", k].Value = myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["LoginName"];
                       dataGridView1["Email", k].Value = myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["Email"];
                       dataGridView1["Department", k].Value = sql.convert_dept((int)myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["DeptID"]);
                       dataGridView1["BasicSalary", k].Value = (int)myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["BasicSalary"];
                       dataGridView1["Title", k].Value = myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["Title"];
                       dataGridView1["Telephone", k].Value = myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["Telephone"];
                       dataGridView1["OnboardDate", k].Value = myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["OnboardDate"];
                       dataGridView1["Level", k].Value = myDataset.Tables["tblEmployee"].Rows[(int)found_employee[k]]["EmployeeLevel"];
                   }
                   mycon.Close();
               }
            }
//            sch.Show();
        }

        private void btn_delete_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("确认删除该员工？", "确认删除", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                string strConnecton = "Server=NUAA\\SQLEXPRESS;Integrated Security=SSPI;DataBase=aaa";
                SqlConnection mycon = new SqlConnection(strConnecton);
                mycon.Open();
                SqlDataAdapter myAdapter = new SqlDataAdapter("select * from tblEmployee", mycon);
                SqlCommandBuilder myBuilder = new SqlCommandBuilder(myAdapter);
                DataSet myDataset = new DataSet();
                myAdapter.Fill(myDataset, "tblEmployee");
                for (int k = 0; k < myDataset.Tables["tblemployee"].Rows.Count; k++)
                {
                    if ((int)myDataset.Tables["tblemployee"].Rows[k]["employeeid"] == Information.cell_selected)
                    {
                        myDataset.Tables["tblemployee"].Rows[k].Delete();
                        myAdapter.Update(myDataset, "tblemployee");
                        break;
                    }
                }
                mycon.Close();
                set_gridview();
            }
  //          pic pic_change = new pic();
    //        pic_change.Show();
        }

        private void Information_Load(object sender, EventArgs e)
        {
            set_gridview();
        }

        private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.RowIndex != -1)
            {
                cell_selected = (int)dataGridView1["employeeid", e.RowIndex].Value;
                sql.selected_employee(cell_selected);
            }
        }
    }
}