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

        private void mainbranch_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda = new SqlDataAdapter("select WorkerName from branchnum inner join Worker on Worker.branchnumID=branchnum.branchnumID where branchnumname='" + branchnamelab.Text + "'", da.link());
            sqlda.Fill(ds, "branchnum");
            branchview.DataSource = ds.Tables["branchnum"];
            numworkerlab.Text = ds.Tables["branchnum"].Rows.Count.ToString();//員工數(shù)
           
        }

        private void branchview_Click(object sender, EventArgs e)
        {
            workernametxt.DataBindings.Clear();
            loginnametxt.DataBindings.Clear();
            emailtxt.DataBindings.Clear();
            DataSet ds = new DataSet();
            SqlDataAdapter sqlda1 = new SqlDataAdapter("select WorkerName,WorkerLogin,WorkerEmail,Wphoto from Worker inner join branchnum on branchnum.branchnumID=Worker.branchnumID where WorkerName='" + branchview.SelectedCells[0].Value.ToString() + "'", da.link());
            sqlda1.Fill(ds, "branchnum1");
            workernametxt.DataBindings.Add("Text", ds.Tables[0], "WorkerName");
            loginnametxt.DataBindings.Add("Text", ds.Tables[0], "WorkerLogin");
            emailtxt.DataBindings.Add("Text", ds.Tables[0], "WorkerEmail");
            string a = "";
            a = ds.Tables[0].Rows[0][3].ToString();
            if (a != "")
            {
                a = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + "/" + a.Substring(1, a.Length - 1);
                photobox.Image = Image.FromFile(a);
            }
        }
        //確定
        private void yesbtn_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}