?? mainbranch.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 人事管理
{
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();
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -