?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 人事管理
{
    public partial class createbranch : Form
    {
        data da = new data();
        public createbranch()
        {
            InitializeComponent();
        }

        private void label2_Click(object sender, EventArgs e)
        {

        }

        private void createbranch_Load(object sender, EventArgs e)
        {

        }
        //瀏覽員工
        private void positonbtn_Click(object sender, EventArgs e)
        {
            selectboss sebo = new selectboss();
            sebo.crbr = this;
            sebo.ShowDialog();
        }
        //確定
        private void yesbtn_Click(object sender, EventArgs e)
        {
            DataSet ds1 = new DataSet();
            SqlDataAdapter sqlda1 = new SqlDataAdapter("SELECT branchnumname from branchnum where branchnumname='" + branchnametxt.Text + "'", da.link());
            sqlda1.Fill(ds1, "branchnum1");
            if (ds1.Tables["branchnum1"].Rows.Count > 0)
            {
                MessageBox.Show("同名部門已存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                if (mangernametxt.Text.Trim() == "")
                {
                    MessageBox.Show("創建部門失敗!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    DataSet ds = new DataSet();
                    SqlDataAdapter sqlda = new SqlDataAdapter("SELECT dbo.Worker.WorkerID FROM dbo.branchnum iNNER JOIN dbo.Worker ON dbo.branchnum.branchnumID = dbo.Worker.branchnumID where Worker.WorkerName='" + mangernametxt.Text + "'", da.link());
                    sqlda.Fill(ds, "selectworkid");
                    //添加
                    SqlCommand sqlcomm = new SqlCommand("insert branchnum (branchnumname,branchnumdepict,branchnummanegerID) values(@branchnumname,@branchnumdepict," + ds.Tables["selectworkid"].Rows[0][0] + ")", da.link());
                    sqlcomm.Parameters.AddWithValue("@branchnumname", branchnametxt.Text);
                    sqlcomm.Parameters.AddWithValue("@branchnumdepict", miantxt.Text);
                    //sqlcomm.Parameters.AddWithValue("@branchnummanegerID",Convert.ToInt32(mangernametxt.Text));
                    sqlda.InsertCommand = sqlcomm;
                    sqlda.InsertCommand.ExecuteNonQuery();
                    this.Close();

                }
            }
        }
        //取消
        private void outbtn_Click(object sender, EventArgs e)
        {
            DialogResult sss = MessageBox.Show("請確認要退出!", "請確認要退出!", MessageBoxButtons.YesNo);
            if (sss == DialogResult.Yes)
            {
                this.Close();
            }
        }
        
    }
}