?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 addworkmanege : Form
    {
        data da = new data();
        int bb;
        public addworkmanege()
        {
            InitializeComponent();
        }

        private void addworkmanege_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerOvertimeView", da.link());
            sqlda.Fill(ds, "WorkerOvertime");
            addworkview.DataSource = ds.Tables["WorkerOvertime"];
            da.link().Close();
        }
        //部門匯總
        private void branchbtn_Click(object sender, EventArgs e)
        {
            if (addworkview.DataSource != null && addworkview.CurrentCell != null)
            {
                人事管理.HolidayManage.Branchcollect branchcollect = new 人事管理.HolidayManage.Branchcollect();
                branchcollect.ShowDialog();
                DataSet ds = new DataSet();
                SqlCommand sqlcomm = new SqlCommand("select WorkerID from Worker inner join branchnum on branchnum.branchnumID=Worker.branchnumID where branchnumname='" + branchcollect.comboBox1.Text + "'", da.link());
                //sqlda.Fill(ds, "Worker");
                SqlDataReader sqldr = sqlcomm.ExecuteReader();
                sqldr.Read();
                try
                {
                    bb = Convert.ToInt32(sqldr.GetValue(0).ToString());
                }
                catch
                {
                    MessageBox.Show("無相關部門的信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }

                if (bb != 0)
                {
                    SqlDataAdapter sqlda1 = new SqlDataAdapter("select * from WorkerOvertimeView where 員工編號='" + bb + "'", da.link());
                    sqlda1.Fill(ds, "WorkerOvertime");
                    addworkview.DataSource = ds.Tables["WorkerOvertime"];
                    da.link().Close();
                }
            }
            else
            {
                MessageBox.Show("無相關部門的信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
        //員工查詢
        private void selectworkerbtn_Click(object sender, EventArgs e)
        {
            if (addworkview.DataSource != null && addworkview.CurrentCell != null)
            {
                selectworker selewo = new selectworker();
                selewo.ShowDialog();
                if (selectworker.bj == true)
                {
                    DataSet ds = new DataSet();
                    string txtName = selewo.workernametxt.Text;
                    string Email = selewo.emailtxt.Text;
                    string Depart = selewo.branchbox.Text;
                    //SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerOvertimeView", da.link());
                    SqlCommand sqlcomm = new SqlCommand("SELECT_addwork", da.link());
                    sqlcomm.CommandType = CommandType.StoredProcedure;
                    sqlcomm.Parameters.AddWithValue("@WorkerName", txtName);
                    sqlcomm.Parameters.AddWithValue("@WorkerEmail", Email);
                    sqlcomm.Parameters.AddWithValue("@branchnumname", Depart);
                    sqlcomm.ExecuteNonQuery();
                    SqlDataAdapter sqlda1 = new SqlDataAdapter(sqlcomm);
                    sqlda1.Fill(ds, "work");
                    addworkview.DataSource = ds.Tables["work"];
                    if (ds.Tables["work"].Rows.Count == 0)
                    {
                        SqlDataAdapter sqlda2 = new SqlDataAdapter("select * from WorkerOvertimeView", da.link());
                        sqlda2.Fill(ds, "WorkerOvertime");
                        addworkview.DataSource = ds.Tables["WorkerOvertime"];
                        MessageBox.Show("未查到符合條件的員工!");
                    }
                }
                da.link().Close();
            }
            else
            {
                MessageBox.Show("無相關員工的信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
        //確定
        private void yesbtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //
        private void button1_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerOvertimeView", da.link());
            sqlda.Fill(ds, "WorkerOvertime");
            addworkview.DataSource = ds.Tables["WorkerOvertime"];
            da.link().Close();
        }
    }
}