updataworker.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 人事管理
{
    public partial class updataworker : Form
    {
        data da = new data();
        public workermaneger workerm = new workermaneger();
        OpenFileDialog open;
        public updataworker()
        {
            InitializeComponent();
        }

        private void updataworker_Load(object sender, EventArgs e)
        {
            SqlCommand sqlcomm1 = new SqlCommand("select branchnumID,branchnumname from branchnum", da.link());
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlcomm1);
            DataSet ds = new DataSet();
            sqlda.Fill(ds, "branchnum");
            branchtxt.DataSource = ds.Tables["branchnum"].DefaultView;
            branchtxt.DisplayMember = "branchnumname";
        }
        //浏览照片
        private void updownphotobtn_Click(object sender, EventArgs e)
        {
            open = new OpenFileDialog();
            open.Filter = "bmp|*.bmp|jpg|*.jpg|gif|*.gif|ico|*.ico|所有文件|*.*";
            if (open.ShowDialog() == DialogResult.OK)
            {
                if (open.FileName != null)
                {
                    photobox.Image = Image.FromFile(open.FileName);
                    string path = Path.GetDirectoryName(Application.ExecutablePath) + "\\picture\\" + Path.GetFileName(open.FileName);
                    System.IO.File.Copy(open.FileName, path, true);
                }
            }
        }
        //修改
        private void updatabtn_Click(object sender, EventArgs e)
        {
            if (passwordtxt.Text != repasswordtxt.Text || passwordtxt.Text == "" || repasswordtxt.Text == "")
            {
                MessageBox.Show("请重新输入密码！");
                passwordtxt.Text = "";
                repasswordtxt.Text = "";
            }
            else if (workernametxt.Text == loginnametxt.Text)
            {
                MessageBox.Show("姓名与登录名不得相同！");
                workernametxt.Text = "";
                loginnametxt.Text = "";
            }
            else if (workernametxt.Text == "" || loginnametxt.Text == "" || emailtxt.Text == "")
            {
                MessageBox.Show("请将信息填写完整！");
            }
            else if (photobox.Image == null)
            {
                MessageBox.Show("请上传相片！");
            }
            else
            {
                SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
                SqlCommand sqlcomm = new SqlCommand("update Worker set WorkerName=@WorkerName,WorkerLogin=@WorkerLogin,WorkerPassword=@WorkerPassword,Birthday=@Birthday,WorkerEmail=@WorkerEmail,branchnumID=@branchnumID,WorkerCompensation=@WorkerCompensation,Wposition=@Wposition,Wphone=@Wphone,Wlevel=@Wlevel,Wphoto=@Wphoto where WorkerID=@WorkerID", da.link());
                sqlcomm.Parameters.AddWithValue("@WorkerName", workernametxt.Text);
                sqlcomm.Parameters.AddWithValue("@WorkerLogin", loginnametxt.Text);
                sqlcomm.Parameters.AddWithValue("@WorkerPassword", passwordtxt.Text);
                sqlcomm.Parameters.AddWithValue("@Birthday", birthdaytxt.Text);
                sqlcomm.Parameters.AddWithValue("@WorkerEmail", emailtxt.Text);
                sqlcomm.Parameters.AddWithValue("@branchnumID", Convert.ToInt32(branchtxt.SelectedIndex + 1));
                sqlcomm.Parameters.AddWithValue("@WorkerCompensation", moneytxt.Text);
                sqlcomm.Parameters.AddWithValue("@Wposition", positiontxt.Text);
                sqlcomm.Parameters.AddWithValue("@Wphone", phonetxt.Text);
                sqlcomm.Parameters.AddWithValue("@Wlevel", levelbox.Text);
                sqlcomm.Parameters.AddWithValue("@Wphoto", "./picture/" + Path.GetFileName(open.FileName));
                SqlParameter para = sqlcomm.Parameters.Add("@WorkerID", this.Tag.ToString());
                para.SourceVersion = DataRowVersion.Current;
                sqlda.UpdateCommand = sqlcomm;
                sqlda.UpdateCommand.ExecuteNonQuery();
                MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.Close();
            }
        }

        private void outbtn_Click(object sender, EventArgs e)
        {
            DialogResult sss = MessageBox.Show("请确认要退出!", "请确认要退出!", MessageBoxButtons.YesNo);
            if (sss == DialogResult.Yes)
            {
                this.Close();
            }
        }
    }
}