using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.SqlClient;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;

namespace?Baog
{
????public?partial?class?admin?:?Form
????{
????????public?admin（）
????????{
????????????InitializeComponent（）;
????????}

????????#region??　//顯示當前時間
????????private?void?timer1_Tick（object?sender?EventArgs?e）
????????{
????????????lab_time.Text?=?“當前時間:“?+?System.DateTime.Now.ToString（“yyyy年MM月dd?dddd?HH時mm分ss秒“）;
????????}

????????#endregion

????????#region??//管理員窗口“人員管理”的初始信息
????????private?void?admin_Load（object?sender?EventArgs?e）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（“server=（local）;integrated?security=sspi;database=db_wang“）;
????????????conn.Open（）;
????????????SqlCommand?comm?=?new?SqlCommand（“select?Sno?as?部門編號Sname?as?部門名稱?from?usersection“?conn）;//
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（comm）;//創建數據適配對象?da
????????????DataSet?ds?=?new?DataSet（）;//創建DataSet對象ds
????????????da.Fill（ds?“section“）;//填充數據集
????????????DataTable?dt?=?ds.Tables[“section“];
????????????dataGridView3.DataSource?=?ds.Tables[“section“];
????????????com_usersection.DataSource?=?dt;
????????????com_usersection.DisplayMember?=?“部門名稱“;
????????????conn.Close（）;

????????}
????????#endregion

????????#region//綁定人員管理的部門以及各個部門對應的員工
????????private?void?com_usersection_SelectedIndexChanged（object?sender?EventArgs?e）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（“server=（local）;integrated?security=sspi;database=db_wang“）;
????????????conn.Open（）;
????????????SqlCommand?comm?=?new?SqlCommand（“select?Uno?as?工號Uname?as?姓名Usex?as?性別convert（nvarchar（10）Ubirthday?20）?as?出生日期?Sno?as?部門編號?from?usermanagement?where?sno?=（select?sno?from?usersection?where?sname=‘“?+?com_usersection.Text?+?“‘）“?conn）;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（comm）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds?“username“）;
????????????dataGridView1.DataSource?=?ds.Tables[“username“];
????????????DataTable?dt?=?ds.Tables[“username“];
????????????listBox1.DataSource?=?dt;
????????????listBox1.DisplayMember?=?“姓名“;
????????????conn.Close（）;
????????}

????????#endregion
????????#region//listBox1里的鼠標事件
????????private?void?listBox1_MouseClick（object?sender?MouseEventArgs?e）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（“server=（local）;integrated?security=sspi;database=db_wang“）;
????????????conn.Open（）;
????????????SqlCommand?comm?=?new?SqlCommand（“select?Uno?as?編號?uname?as?姓名usex?as?性別convert（nvarchar（10）Ubirthday?20）?as?出生日期Upic?as?照片Pshow?as?健康狀況utype?as?身份?from?usermanagement?where?uname?=‘“?+?listBox1.Text?+?“‘“?conn）;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（comm）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds?“usermessage“）;
????????????dataGridView1.DataSource?=?ds.Tables[“

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????901??2008-09-23?15:11??最新寶鋼\Baog.sln

????..A..H.?????27648??2008-11-27?12:16??最新寶鋼\Baog.suo

?????文件????1048576??2008-09-25?17:02??最新寶鋼\db_wang_Log.LDF

?????文件????1769472??2008-09-25?17:02??最新寶鋼\db_wang_Data.MDF

?????文件???????5728??2008-09-24?17:09??最新寶鋼\Baog\Main_yuang.cs

?????文件???????4978??2008-09-24?17:09??最新寶鋼\Baog\Baog.csproj

?????文件??????20721??2008-09-24?16:58??最新寶鋼\Baog\Main_yuang.Designer.cs

?????文件????????463??2008-09-23?15:49??最新寶鋼\Baog\Program.cs

?????文件???????5620??2008-09-25?16:40??最新寶鋼\Baog\Register.cs

?????文件???????6008??2008-09-23?16:01??最新寶鋼\Baog\admin.resx

?????文件????????330??2008-09-24?17:12??最新寶鋼\Baog\Pw.cs

?????文件???????7941??2008-09-25?16:13??最新寶鋼\Baog\admin.cs

?????文件??????12100??2008-09-23?15:29??最新寶鋼\Baog\admin.Designer.cs

?????文件??????15118??2008-09-23?15:29??最新寶鋼\Baog\Register.Designer.cs

?????文件???????2237??2008-09-24?17:12??最新寶鋼\Baog\Pw.Designer.cs

?????文件??????12267??2008-09-24?17:10??最新寶鋼\Baog\Apm.Designer.cs

?????文件???????6012??2008-09-24?16:58??最新寶鋼\Baog\Main_yuang.resx

?????文件???????5814??2008-09-24?17:12??最新寶鋼\Baog\Pw.resx

?????文件????????381??2008-11-27?11:50??最新寶鋼\Baog\obj\Baog.csproj.FileList.txt

?????文件????????180??2008-09-23?15:23??最新寶鋼\Baog\obj\Debug\Baog.Properties.Resources.resources

?????文件?????126976??2008-10-09?22:22??最新寶鋼\Baog\obj\Debug\Baog.exe

?????文件??????64282??2008-10-09?22:22??最新寶鋼\Baog\obj\Debug\Baog.Login.resources

?????文件????????180??2008-09-23?16:01??最新寶鋼\Baog\obj\Debug\Baog.admin.resources

?????文件?????114176??2008-10-09?22:22??最新寶鋼\Baog\obj\Debug\Baog.pdb

?????文件????????180??2008-09-24?16:58??最新寶鋼\Baog\obj\Debug\Baog.Main_yuang.resources

?????文件????????180??2008-09-25?10:44??最新寶鋼\Baog\obj\Debug\Baog.NurseForm.resources

?????文件????????180??2008-09-25?10:08??最新寶鋼\Baog\obj\Debug\Baog.Pw.resources

?????文件???????1080??2008-10-09?22:22??最新寶鋼\Baog\obj\Debug\Baog.csproj.GenerateResource.Cache

?????文件???????5632??2005-12-08?14:51??最新寶鋼\Baog\bin\Debug\Baog.vshost.exe

?????文件?????126976??2008-10-09?22:22??最新寶鋼\Baog\bin\Debug\Baog.exe

............此處省略25個文件信息