editemployee.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 EditEmployee : Form
    {
        public EditEmployee()
        {
            InitializeComponent();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Hide();
            Employees E = new Employees();
            E.Show();
        }

        private void BtnUpdateEmployee_Click(object sender, EventArgs e)
        {
            byte[] images = Photo.image;
            if(textBox1.Text.Trim() =="")
            {
                DialogResult = MessageBox.Show("请输入姓名！", "提示");
                textBox1.Focus();
            }
            else if (textBox5.Text.Trim() == "")
            {
                DialogResult = MessageBox.Show("请输入电子邮件！", "提示");
                textBox5.Focus();
            }
            else
            {
                try
                {
                    SqlConnection con = DB.connection();
                    con.Open();
                    SqlCommand cmd = new SqlCommand("update 员工表 set 员工姓名=('" + textBox1.Text.ToString().Trim() + "'),员工密码=('" + textBox3.Text.ToString().Trim()
                        + "'),员工电子邮件=('" + textBox5.Text.ToString().Trim() + "'),员工所属部门编号=('" + comboBox1.Text.ToString().Trim() + "'),员工基本薪资=('" + textBox6.Text.ToString().Trim()
                        + "'),员工职位名称=('" + textBox7.Text.ToString().Trim()
                        + "'),员工电话=('" + textBox8.Text.ToString().Trim() + "'),照片=('"+ images + "'),级别=('" + numLevel.Value.ToString() + "') where 员工登录名=('" + textBox2.Text.ToString().Trim() + "')", con);
                    int count = Convert.ToInt32(cmd.ExecuteNonQuery());
                    if (count > 0)
                    {
                        con.Close();
                        DialogResult = MessageBox.Show("修改成功！", "提示");
                        this.Hide();
                        Employees E = new Employees();
                        E.Show();
                    }
                    else
                    {
                        con.Close();
                        DialogResult = MessageBox.Show("操作失败！", "提示");
                        //this.Hide();
                        //Employees E = new Employees();
                        //E.Show();
                    }
                }
                catch(Exception EV)
                {
                    DialogResult = MessageBox.Show(EV.ToString(), "异常提示");
                }
            }
        }

        private void EditEmployee_Load(object sender, EventArgs e)
        {
            SqlConnection con = DB.connection();
            con.Open();
            string cmdselect = "select * from 员工表 where 员工编号='"+ DB.getA +"'";
            SqlCommand cmdE = new SqlCommand(cmdselect,con);
            SqlDataReader sdr = cmdE.ExecuteReader();
            if (sdr.Read())
            {
                textBox1.Text = sdr["员工姓名"].ToString();
                textBox2.Text = sdr["员工登录名"].ToString();
                textBox3.Text = sdr["员工密码"].ToString();
                textBox5.Text = sdr["员工电子邮件"].ToString();
                textBox6.Text = sdr["员工基本薪资"].ToString();
                //numLevel.Value = sdr["级别"].ToString();
                textBox7.Text = sdr["员工职位名称"].ToString();
                textBox8.Text = sdr["员工电话"].ToString();
                comboBox1.Text = sdr["员工所属部门编号"].ToString();
                //pictureBox1.Image = sdr["照片"];
                sdr.Close();
            }
            con.Close();
        }

        private void buttonUploadPhoto_Click(object sender, EventArgs e)
        {
            Photo P = new Photo();
            P.Show();
        }

        private void pictureBox1_Move(object sender, EventArgs e)
        {

        }

        private void pictureBox1_ParentChanged(object sender, EventArgs e)
        {

        }

        private void pictureBox1_MouseMove(object sender, MouseEventArgs e)
        {
            string imageU = Photo.txt;
            pictureBox1.ImageLocation = imageU;
        }
    }
}