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

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

        private void btnOK_Click(object sender, EventArgs e)
        {
            if (TxtDeptName.Text == "")
            {
                DialogResult = MessageBox.Show("请输入要添加的部门名！", "提示");
            }
            else
            {
                if(txtDeptDescription.Text == "")
                {
                    DialogResult = MessageBox.Show("请填写对该部门的描述！", "提示");
                }
                else
                {
                   if(TxtManagerID.Text == "")
                   {
                       DialogResult = MessageBox.Show("请指派该部门的经理！", "提示");
                   }
                   else
                   {
                       SqlConnection con = DB.connection();
                       con.Open();
                       try
                       {
                           SqlCommand cmd = new SqlCommand("insert into 部门表(部门名称,部门描述,部门经理编号) values ('"+ TxtDeptName.Text.ToString().Trim() 
                               +"','"+ txtDeptDescription.Text.ToString().Trim() +"','"+ TxtManagerID.Text.ToString().Trim() +"')",con);
                           int count = Convert.ToInt32(cmd.ExecuteNonQuery());
                           if (count > 0)
                           {
                               con.Close();
                               DialogResult = MessageBox.Show("添加成功！", "提示");
                               this.Close();
                           }
                           else
                           {
                               con.Close();
                               DialogResult = MessageBox.Show("操作失败！", "提示");
                           }
                       }
                       catch(Exception ev)
                       {
                           MessageBox.Show(ev.ToString());
                       }

                   }
                }
            }
            

        }

        private void pictureBox1_Click(object sender, EventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {

        }
    }
}