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

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

        private void btnNewEmployee_Click(object sender, EventArgs e)
        {
            byte[] images = Photo.image;
            //dateTimePicker1.CustomFormat = "yyyy-mm-dd  hh-mi";
            //dateTimePicker1.Format = DateTimePickerFormat.Custom;
            //DateTime DT=Convert.ToDateTime(dateTimePicker1.Text.ToString());
            if (textBox1.Text.Trim() == "")
            {
                DialogResult = MessageBox.Show("请输入姓名！", "提示");
                textBox1.Focus();
            }
            else
            {
                if (textBox2.Text.Trim() == "")
                {
                    DialogResult = MessageBox.Show("请输入登陆名！", "提示");
                    textBox2.Focus();
                }
                else
                {
                    if (textBox4.Text.Trim() == "")
                    {
                        DialogResult = MessageBox.Show("请输入电子邮件！", "提示");
                        textBox4.Focus();
                    }
                    else
                    {
                        SqlConnection con = DB.connection();
                        con.Open();
                       // try
                        //{
                            if (textBox3.Text.Trim() == "")
                            {
                                DialogResult = MessageBox.Show("你没有给此员工设置初始密码，系统将默认设置为“123456?” ", "南山人事管理系统提示你", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                                if (DialogResult == DialogResult.OK)
                                {
                                    SqlCommand cmd = new SqlCommand("insert into 员工表(员工姓名,员工登录名,员工密码,员工电子邮件,员工所属部门编号,员工基本薪资,员工职位名称,员工电话,员工报到日期,照片,级别) values('"
                                        + textBox1.Text.ToString().Trim() +"','"+ textBox2.Text.ToString().Trim() +"','"+ 123456 +"','"+textBox4.Text.ToString().Trim() + "','"+ comboBox1.Text.ToString().Trim()
                                        + "','" + textBox5.Text.ToString().Trim() + "','" + textBox6.Text.ToString().Trim() + "','" + textBox7.Text.ToString().Trim() + "','" + dateTimePicker1.Value.ToShortDateString() + "','" + images + "','" + numLevel.Value.ToString()
                                        + "')", con);
                                    int count = Convert.ToInt32(cmd.ExecuteNonQuery());
                                    if (count > 0)
                                    {
                                        DialogResult = MessageBox.Show("添加成功！", "提示");
                                    }
                                    else
                                    {
                                        DialogResult = MessageBox.Show("操作失败！", "提示");
                                    }
                                }
                                //else
                                //{
                                //}
                            }
                            else
                            {
                                if (textBox3.Text.Length < 6)
                                {
                                    DialogResult = MessageBox.Show("密码至少为6位！", "提示");
                                }
                                else
                                {
                                    SqlCommand cmd = new SqlCommand("insert into 员工表(员工姓名,员工登录名,员工密码,员工电子邮件,员工所属部门编号,员工基本薪资,员工职位名称,员工电话,员工报到日期,照片,级别) values('"
                                            + textBox1.Text.ToString().Trim() + "','" + textBox2.Text.ToString().Trim() + "','" + textBox3.Text.ToString().Trim() + "','" + textBox4.Text.ToString().Trim() + "','" + comboBox1.Text.ToString().Trim()
                                            + "','" + textBox5.Text.ToString().Trim() + "','" + textBox6.Text.ToString().Trim() + "','" + textBox7.Text.ToString().Trim() + "','" + dateTimePicker1.Value.ToShortDateString() + "','" + images + "','" + numLevel.Value.ToString()
                                            + "')", con);
                                    int count = Convert.ToInt32(cmd.ExecuteNonQuery());
                                if (count > 0)
                                {
                                    DialogResult = MessageBox.Show("添加成功！", "提示");
                                }
                                else
                                {
                                    DialogResult = MessageBox.Show("操作失败！", "提示");
                                }
                                }
                            }
                        //}
                        //catch (Exception EV)
                        //{

                        //    MessageBox.Show(EV.ToString(),"异常");

                        //}
                        //finally
                        //{
                        //    //DialogResult = MessageBox.Show("操作失败！", "提示");
                        //    textBox1.Text = "";
                        //    textBox2.Text = "";
                        //    textBox3.Text = "";
                        //    textBox4.Text = "";
                        //    textBox5.Text = "";
                        //    textBox6.Text = "";
                        //    textBox7.Text = "";

                        //}
                    }
                }
            }
            
            
            //DialogResult = MessageBox.Show(dateTimePicker1.Value.ToShortTimeString(), "提示");
        }

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

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