addworker.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 addworker : Form
    {
        public workermaneger workerm = new workermaneger();
        data da = new data();
        OpenFileDialog open;
        public addworker()
        {
            InitializeComponent();
        } 

        private void addworker_Load(object sender, EventArgs e)
        {
            SqlCommand sqlcomm = new SqlCommand("select branchnumID,branchnumname from branchnum", da.link());
            SqlDataAdapter sqlda = new SqlDataAdapter(sqlcomm);
            DataSet ds = new DataSet();
            sqlda.Fill(ds);
            branchtxt.DataSource = ds.Tables[0].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 yesbtn_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
            {
                DataSet ds = new DataSet();
                SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerCompensationManageView", da.link());
                //添加
                SqlCommand sqlcomm = new SqlCommand("insert Worker (WorkerName,WorkerLogin,WorkerPassword,Birthday,WorkerEmail,branchnumID,WorkerCompensation,Wposition,Wphone,Wlevel,Wphoto) values(@WorkerName,@WorkerLogin,@WorkerPassword,@Birthday,@WorkerEmail,@branchnumID,@WorkerCompensation,@Wposition,@Wphone,@Wlevel,@Wphoto)", 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));
                sqlda.InsertCommand = sqlcomm;
                sqlda.InsertCommand.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();
            }
        }

      
    }
}