【正文】 int num = (strSql)。 + () + 39。 + + 39。 + () + 39。 + () + 39。 + + 39。 + () + 39。 + + 39。 + + 39。 + + 39。 + () + 39。 + () + 39。 return。 int i = (str)。//退出事件 } else { string str =//創(chuàng)建SQL字符串 select count(*) from tb_employee where employeeID=39。//退出事件 } else { if ( != 11) { (手機(jī)號碼為11位)。//彈出消息對話框 } } private void toolStripLabel1_Click(object sender, EventArgs e) { if (() == || () == || () == || () == || () == || () == || () == ||()==) { (請將信息填寫完整, 警告,//彈出消息對話框 , )。//設(shè)置打開文件路徑信息 (tb_userJob,txtYGZhiwu, 1)。//添加路徑信息 strg += \。//截取路徑信息 strg = (0, (\\))。//設(shè)置默認(rèn)選項(xiàng) string strg = ()。//設(shè)置默認(rèn)選項(xiàng) = 0。//綁定下拉列表 = 0。//加載員工頭像 } catch//捕獲異常 { (加載圖片出錯(cuò))。//創(chuàng)建數(shù)據(jù)庫操作對象 private void toolStripLabel4_Click(object sender, EventArgs e) { ()。 } } }}添加員工界面如圖84.圖84 添加員工界面界面代碼如下： public partial class frmAddEmployee : Form { public frmAddEmployee() { InitializeComponent()。//刪除員工信息 (刪除成功, 提示,//彈出消息對話框 , )。 (DelSql)。//得到ID string DelSql =//創(chuàng)建SQL字符串 delete from tb_employee where employeeID=39。 return。//為字段賦值 ()。//創(chuàng)建員工信息窗體對象 = YGName。//退出事件 } else { string YGName = //得到員工姓名 [2].()。//執(zhí)行窗體Load事件 } private void toolStripLabel2_Click(object sender, EventArgs e) { if ( == 0) { (//彈出消息對話框 請選擇要修改的數(shù)據(jù), 提示, , )。//顯示圖片信息 } } private void frmEmployee_Activated(object sender, EventArgs e) { ()。//顯示模式對話框 } } private void dgvEmployee_Click(object sender, EventArgs e) { if ( 0) { string YGName = [1].()。//為字段賦值 = [1].()。//獲取員工名稱 frmEmployeeInfo info = new frmEmployeeInfo()。 return。//創(chuàng)建添加員工信息窗體對象 ()。//定義數(shù)據(jù)列寬度 [1].Width = 80。 (dgvEmployee, strsql)。 from tb_employee where employeeDept=39。,employeeAccession as 39。,employeePhone as 39。,employeeDuty as 39。,employeeMarriage as 39。,employeeNation as 39。,employeeBirthday as 39。,employeeDept as 39。,employeeSex as 39。,employeeName as 39。,employeeID as 39。//將查詢信息綁定到DataGridView控件 } else { string strsql =//創(chuàng)建查詢字符串 select ID as 39。 from tb_employee。,employeeAccession as 39。,employeePhone as 39。,employeeDuty as 39。,employeeMarriage as 39。,employeeNation as 39。,employeeBirthday as 39。,employeeDept as 39。,employeeSex as 39。,employeeName as 39。,employeeID as 39。//得到選中節(jié)點(diǎn)的字符串 if (str == 所有部門) { string SQLStr = //創(chuàng)建查詢字符串 select ID as 39。//定義數(shù)據(jù)列寬度 [1].Width = 80。 (dgvEmployee, str)。 from tb_employee where employeeName like 39。,employeeAccession as 39。,employeePhone as 39。,employeeDuty as 39。,employeeMarriage as 39。,employeeNation as 39。,employeeBirthday as 39。,employeeDept as 39。,employeeSex as 39。,employeeName as 39。,employeeID as 39。//展開所有節(jié)點(diǎn) } private void toolStripTextBox1_TextChanged(object sender, EventArgs e) { string str =//創(chuàng)建查詢字符串 select ID as 39。//關(guān)閉數(shù)據(jù)讀取器 ()。//創(chuàng)建數(shù)據(jù)讀取器 while (())//讀取數(shù)據(jù) { (sdr[DepName].ToString())。//打開數(shù)據(jù)庫連接 SqlCommand cmd = new SqlCommand(select * from tb_department, conn)。//添加節(jié)點(diǎn) SqlConnection conn = ()。//定義SQL字符串 =(sql).ToString()+人。//設(shè)置圖像列表的索引 =0。//定義數(shù)據(jù)列寬度 = imageList1。//將查詢信息綁定到DataGridView控件 [0].Width = 40。 from tb_employee。,employeeAccession as 39。,employeePhone as 39。,employeeDuty as 39。,employeeMarriage as 39。,employeeNation as 39。,employeeBirthday as 39。,employeeDept as 39。,employeeSex as 39。,employeeName as 39。,employeeID as 39。//創(chuàng)建數(shù)據(jù)庫操作對象 private void frmEmployee_Load(object sender, EventArgs e) { string str = //創(chuàng)建查詢字符串 select ID as 39。圖83 企業(yè)員工信息界面界面代碼如下： public partial class frmEmployee : Form { public frmEmployee() { InitializeComponent()。 } private void frmMain_FormClosed(object sender, FormClosedEventArgs e) { ()。 } private void 工資總結(jié)ToolStripMenuItem_Click(object sender, EventArgs e) { frmUserPay userpay = new frmUserPay()。 } private void 考勤津貼ToolStripMenuItem_Click(object sender, EventArgs e) { frmUserKqManage kqmanage = new frmUserKqManage()。 ()。 ()。 = this。 ()。 } private void 退出ToolStripMenuItem_Click(object sender, EventArgs e) { if ((確定退出本系統(tǒng)嗎？, 提示, , ) == ) { ()。 } } private void 檔案管理ToolStripMenuItem_Click(object sender, EventArgs e) { frmEmployee employee = new frmEmployee()。 string power = [0].Rows[0][3].ToString()。 + User + 39。 = ()。//創(chuàng)建數(shù)據(jù)庫操作對象 private void frmMain_Load(object sender, EventArgs e) { = User。 public string Logintime。