workermaneger.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.Configuration;

namespace 人事管理
{
    public partial class workermaneger : Form
    {
        SqlDataAdapter sqlda;
        data da = new data();
        SqlParameter para;
        public workermaneger()
        {
            InitializeComponent();
   
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //string sql = "select * from WorkerCompensationManageView";
            //data da = new data();
            DataSet ds = new DataSet();
            sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
            sqlda.Fill(ds, "Worker");
            workerview.DataSource = ds.Tables["Worker"];
            da.link().Close();
        }
        //添加
        private void addworkerbtn_Click(object sender, EventArgs e)
        {
            addworker addw = new addworker();
            //workerview.DataSource = ds.Tables["Worker"];
            addw.ShowDialog();
            addw.workerm = this;
            DataSet ds = new DataSet();
            sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
            sqlda.Fill(ds, "Worker");
            workerview.DataSource = ds.Tables["Worker"];
        }
        //修改
        private void altworkerbtn_Click(object sender, EventArgs e)
        {
            if (workerview.DataSource != null && workerview.CurrentCell != null)
            {
               
                DataSet ds = new DataSet();
                SqlDataAdapter sqlda1 = new SqlDataAdapter("select * from WorkerCompensationManage1View", da.link());
                sqlda1.Fill(ds);
                updataworker update = new updataworker();
                update.Tag = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][0].ToString().Trim();
                update.workernametxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][1].ToString().Trim();
                update.loginnametxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][2].ToString().Trim();
                //update.passwordtxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][3].ToString().Trim();
                update.birthdaytxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][3].ToString().Trim();
                update.emailtxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][4].ToString().Trim();
                update.branchtxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][5].ToString().Trim();
                update.moneytxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][6].ToString().Trim();
                update.positiontxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][7].ToString().Trim();
                update.phonetxt.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][8].ToString().Trim();
                update.levelbox.Text = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][9].ToString().Trim(); 
                string a = "";
                a = ds.Tables[0].Rows[workerview.CurrentCell.RowIndex][10].ToString();
                if (a != "")
                {
                    a = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + "/" + a.Substring(1, a.Length - 1);
                    update.photobox.Image = Image.FromFile(a);
                }
                update.ShowDialog();
                da.link().Close();
                sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
                sqlda.Fill(ds, "Worker");
                workerview.DataSource = ds.Tables["Worker"];
            }
            else
                MessageBox.Show("没有指定的员工信息");
        }
        //删除
        private void deleteworkerbtn_Click(object sender, EventArgs e)
        {
            if (workerview.DataSource != null && workerview.CurrentCell != null)
            {
                SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
                SqlCommand sqlcomm = new SqlCommand("delete Worker where WorkerID=@WorkerID", da.link());
                para = sqlcomm.Parameters.Add("@WorkerID", SqlDbType.Int, 4, "WorkerID");
                para.SqlValue = workerview.SelectedCells[0].Value.ToString();
                para.SourceVersion = DataRowVersion.Current;
               sqlda.DeleteCommand = sqlcomm;
               sqlda.DeleteCommand.ExecuteNonQuery();
               da.link().Close();
               DataSet ds = new DataSet();
               sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
               sqlda.Fill(ds, "Worker");
               workerview.DataSource = ds.Tables["Worker"];
            }
            else
                MessageBox.Show("没有指定的员工信息");
        }
        //查询
        private void selectworkerbtn_Click(object sender, EventArgs e)
        {
            selectworker swo = new selectworker();
            swo.ShowDialog();
            if (selectworker.bj == true)
            {
                DataSet ds = new DataSet();
                string txtName = swo.workernametxt.Text;
                string Email = swo.emailtxt.Text;
                string Depart = swo.branchbox.Text;
                SqlCommand sqlcomm = new SqlCommand("SELECT_queryem", da.link());
                sqlcomm.CommandType = CommandType.StoredProcedure;
                sqlcomm.Parameters.AddWithValue("@WorkerName", txtName);
                sqlcomm.Parameters.AddWithValue("@WorkerEmail", Email);
                sqlcomm.Parameters.AddWithValue("@branchnumname", Depart);
                sqlcomm.ExecuteNonQuery();
                sqlda = new SqlDataAdapter(sqlcomm);
                sqlda.Fill(ds,"work");
                workerview.DataSource = ds.Tables["work"];
                if (ds.Tables["work"].Rows.Count  == 0)
                {
                    sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
                    sqlda.Fill(ds, "Worker");
                    workerview.DataSource = ds.Tables["Worker"];
                    MessageBox.Show("未查到符合条件的员工!");
                }
            }
            da.link().Close();
        }

        private void outbtn_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
            sqlda.Fill(ds, "Worker");
            workerview.DataSource = ds.Tables["Worker"];
            da.link().Close();
        }
    }
}