一：先看看解决方案资源管理器截图：

二：DepartmentDAL.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using HRMSys.Model;using System.Data;using System.Data.SqlClient;namespace HRMSys.DAL{   public class DepartmentDAL    {       /// 
       /// 将得到的表的形式转化为object对象字段的形式       /// 
       ///        /// 
             private Department ToModel(DataRow row)       {           Department dept = new Department();           dept.Id = (Guid)row["Id"];           dept.Name = (string)row["Name"];           dept.IsDelete=(bool) row["IsDelete"];           return dept;       }       /// 
       /// 显示所有未删除的部门信息       /// 
       /// 
      
       以部门为对象的泛型集合
             public IEnumerable
      
        ListAll()           //public List
       
         ListAll()       {           List
        
          list = new List
         
          ();           DataTable dt = sqlhelper.datatable("select * from T_Department where IsDelete=0");           foreach (DataRow row in dt.Rows)           {               Department dept = ToModel(row);               list.Add(dept);           }           return list;       }       /// 
          
       /// 得到指定id的部门       /// 
       /// 
                 /// 
          
           部门对象
                 public Department GetById(Guid id)       {           DataTable dt = sqlhelper.datatable("select * from T_Department where Id=@Id",               new SqlParameter("@Id", id));           if (dt.Rows.Count <= 0)           {               return null;           }           else           {               return ToModel(dt.Rows[0]);           }       }       /// 
          
       /// 更新指定部门id的部门名字       /// 
       /// 
                 /// 
                 public void Update(Guid id, string name)       {           sqlhelper.ExecuteNon(@"Update T_Department Set Name=@Name where Id=@Id",               new SqlParameter("@Name", name), new SqlParameter("@Id", id));       }       /// 
          
       /// 插入一条部门信息       /// 
       /// 
                 public void Insert(string name)       {           sqlhelper.ExecuteNon(@"Insert Into T_Department(Id,Name,IsDelete) values(newid(),@Name,0)",               new SqlParameter("@Name", name));       }       /// 
          
       /// 软删除指定部门id的部门       /// 
       /// 
                 public void DeleteById(Guid id)       {           sqlhelper.ExecuteNon(@"Update T_Department Set IsDelete=1 where Id=@Id",                new SqlParameter("@Id", id));       }    }}
         
        
       
      

三：EmployeeDAL.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using HRMSys.Model;using System.Data;using System.Data.SqlClient;namespace HRMSys.DAL{    public class EmployeeDAL    {        /// 
        /// 将表的列转换为EmployeeList对象的字段        /// 
        ///         /// 
              public EmployeeList ToEmployeeListModel(DataRow row)        {            EmployeeList employee = new EmployeeList();            employee.Address = (string)row["Address"];            employee.BaseSalary = (int)row["BaseSalary"];            employee.BirthDay = (DateTime)row["BirthDay"];            employee.ContractEndDay = (DateTime)row["ContractEndDay"];            employee.ContractStartDay = (DateTime)row["ContractStartDay"];            employee.Department =GetNameByGuidDE( (Guid)row["DepartmentId"]);//            employee.Education= GetNameByGuidID((Guid)row["EducationId"]);/////            employee.Email = (string)row["Email"];            employee.EmergencyContact = (string)sqlhelper.FromDbValue(row["EmergencyContact"]);            employee.Gender = GetNameByGuidID((Guid)row["GenderId"]);///            employee.Id = (Guid)row["Id"];            employee.IdNum = (string)row["IdNum"];            employee.InDate = (DateTime)row["InDate"];            employee.Major = (string)sqlhelper.FromDbValue(row["Major"]);            employee.Marriage = GetNameByGuidID((Guid)row["MarriageId"]);/            employee.Name = (string)row["Name"];            employee.Nationality = (string)row["Nationality"];            employee.NativeAddr = (string)row["NativeAddr"];            employee.Number = (string)row["Number"];            employee.PartyStatus = GetNameByGuidID((Guid)row["PartyStatusId"]);//            employee.Position = (string)row["Position"];            employee.Remarks = (string)sqlhelper.FromDbValue(row["Remarks"]);            employee.Resume = (string)sqlhelper.FromDbValue(row["Resume"]);            employee.School = (string)sqlhelper.FromDbValue(row["School"]);            employee.TelNum = (string)row["TelNum"];            employee.IsStopped = (bool)row["IsStopped"];            //todo:如果员工非常多，那么Photo会增加内存占用            //employee.Photo = (byte[])sqlhelper.FromDbValue(row["Photo"]);            return employee;        }        /// 
        /// 将表转换为Employee对象的字段        /// 
        ///         /// 
              public Employee ToEmployeeModel(DataRow row)        {            Employee employee = new Employee();            employee.Address = (string)row["Address"];            employee.BaseSalary = (int)row["BaseSalary"];            employee.BirthDay = (DateTime)row["BirthDay"];            employee.ContractEndDay = (DateTime)row["ContractEndDay"];            employee.ContractStartDay = (DateTime)row["ContractStartDay"];            employee.DepartmentId = (Guid)row["DepartmentId"];//            employee.EducationId = (Guid)row["EducationId"];/////            employee.Email = (string)row["Email"];            employee.EmergencyContact = (string)sqlhelper.FromDbValue(row["EmergencyContact"]);            employee.GenderId = (Guid)row["GenderId"];///            employee.Id = (Guid)row["Id"];            employee.IdNum = (string)row["IdNum"];            employee.InDate = (DateTime)row["InDate"];            employee.Major = (string)sqlhelper.FromDbValue(row["Major"]);            employee.MarriageId = (Guid)row["MarriageId"];/            employee.Name = (string)row["Name"];            employee.Nationality = (string)row["Nationality"];            employee.NativeAddr = (string)row["NativeAddr"];            employee.Number = (string)row["Number"];            employee.PartyStatusId = (Guid)row["PartyStatusId"];//            employee.Position = (string)row["Position"];            employee.Remarks = (string)sqlhelper.FromDbValue(row["Remarks"]);            employee.Resume = (string)sqlhelper.FromDbValue(row["Resume"]);            employee.School = (string)sqlhelper.FromDbValue(row["School"]);            employee.TelNum = (string)row["TelNum"];            employee.IsStopped = (bool)row["IsStopped"];            //todo:如果员工非常多，那么Photo会增加内存占用            //employee.Photo = (byte[])sqlhelper.FromDbValue(row["Photo"]);            return employee;        }        /// 
        /// 软删除指定id的员工信息        /// 
        ///         public void DeleteById(Guid id)        {            //update T_Operator set IsLocked=@IsLocked  where Id=@Id"           int i= sqlhelper.ExecuteNon("update T_Employee set IsStopped =1 where Id=@Id",                new SqlParameter ("@Id",id));                     }        /// 
        /// 指定id从idname中取得名字        /// 
        ///         /// 
              public string GetNameByGuidID(Guid id)        {            DataTable table= sqlhelper.datatable("select Name from T_IdName where Id=@Id",                new SqlParameter("@Id",id));            DataRow row = table.Rows[0];            return (string) row["Name"];        }        /// 
        /// 指定id从department中取得名字        /// 
        ///         /// 
              public string GetNameByGuidDE(Guid id)        {            DataTable table = sqlhelper.datatable("select Name from T_Department where Id=@Id",                new SqlParameter("@Id", id));            DataRow row = table.Rows[0];            return (string)row["Name"];        }        /// 
        /// 得到所有未删除的员工的所有信息        /// 
        /// 
      
       Employee数组
              public EmployeeList[] ListAll()        {            DataTable table = sqlhelper.datatable("select * from T_Employee where IsStopped=0");            EmployeeList[] items = new EmployeeList[table.Rows.Count];            for (int i = 0; i < table.Rows.Count; i++)            {                EmployeeList employee = ToEmployeeListModel(table.Rows[i]);                items[i] = employee;            }            return items;        }        /// 
        /// 得到指定id的员工信息        /// 
        ///         /// 
      
       Employee对象
              public Employee GetById(Guid id)        {            DataTable table = sqlhelper.datatable("select * from T_Employee where Id=@Id",                new SqlParameter("@Id", id));            if (table.Rows.Count == 1)            {                return ToEmployeeModel(table.Rows[0]);            }            else            {                throw new Exception();            }        }        /// 
        /// 插入一条员工数据        /// 
        ///         public void Insert(Employee employee)        {            sqlhelper.ExecuteNon(@"INSERT INTO [T_Employee]           ([Id],[Number],[Name],[BirthDay],[InDate],[MarriageId],[PartyStatusId],[Nationality]           ,[NativeAddr],[EducationId],[Major],[School],[Address],[BaseSalary],[Email]           ,[IdNum],[TelNum],[EmergencyContact],[DepartmentId],[Position],[ContractStartDay]           ,[ContractEndDay],[Resume],[Remarks],[IsStopped],[GenderId])            VALUES(newid(),@Number,@Name,@BirthDay,@InDate,@MarriageId,@PartyStatusId,@Nationality           ,@NativeAddr,@EducationId,@Major,@School,@Address,@BaseSalary,@Email           ,@IdNum,@TelNum,@EmergencyContact,@DepartmentId,@Position,@ContractStartDay           ,@ContractEndDay,@Resume,@Remarks,0,@GenderId)", new SqlParameter("@Number", employee.Number)                                                         , new SqlParameter("@Name", employee.Name)                                                         , new SqlParameter("@BirthDay", employee.BirthDay)                                                         , new SqlParameter("@InDate", employee.InDate)                                                         , new SqlParameter("@MarriageId", employee.MarriageId)                                                         , new SqlParameter("@PartyStatusId", employee.PartyStatusId)                                                         , new SqlParameter("@Nationality", employee.Nationality)                                                         , new SqlParameter("@NativeAddr", employee.NativeAddr)                                                         , new SqlParameter("@EducationId", employee.EducationId)                                                         , new SqlParameter("@Major", sqlhelper.ToDbValue(employee.Major))                                                         , new SqlParameter("@School", sqlhelper.ToDbValue(employee.School))                                                         , new SqlParameter("@Address", employee.Address)                                                         , new SqlParameter("@BaseSalary", employee.BaseSalary)                                                         , new SqlParameter("@Email", sqlhelper.ToDbValue(employee.Email))                                                         , new SqlParameter("@IdNum", employee.IdNum)                                                         , new SqlParameter("@TelNum", employee.TelNum)                                                         , new SqlParameter("@EmergencyContact", sqlhelper.ToDbValue(employee.EmergencyContact))                                                         , new SqlParameter("@DepartmentId", employee.DepartmentId)                                                         , new SqlParameter("@Position", employee.Position)                                                         , new SqlParameter("@ContractStartDay", employee.ContractStartDay)                                                         , new SqlParameter("@ContractEndDay", employee.ContractEndDay)                                                         , new SqlParameter("@Resume", sqlhelper.ToDbValue(employee.Resume))                                                         , new SqlParameter("@Remarks", sqlhelper.ToDbValue(employee.Remarks))                                                         , new SqlParameter("@GenderId", employee.GenderId)                                                        );        }        /// 
        /// 更新一条员工数据数据        /// 
        ///          public void Update(Employee employee)        {            sqlhelper.ExecuteNon(@"Update T_Employee set             [Number]=@Number,[Name]=@Name,[BirthDay]=@BirthDay,[InDate]=@InDate,            [MarriageId]=@MarriageId,[PartyStatusId]=@PartyStatusId,[Nationality]=@Nationality,            [NativeAddr]=@NativeAddr,[EducationId]=@EducationId,[Major]=@Major,[School]=@School,            [Address]=@Address,[BaseSalary]=@BaseSalary,[Email]=@Email,            [IdNum]=@IdNum,[TelNum]=@TelNum,[EmergencyContact]=@EmergencyContact,            [DepartmentId]=@DepartmentId,[Position]=@Position,[ContractStartDay]=@ContractStartDay,            [ContractEndDay]=@ContractEndDay,[Resume]=@Resume,[Remarks]=@Remarks,[GenderId]=@GenderId                        Where Id=@Id", new SqlParameter("@Number", employee.Number)                                                         , new SqlParameter("@Name", employee.Name)                                                         , new SqlParameter("@BirthDay", employee.BirthDay)                                                         , new SqlParameter("@InDate", employee.InDate)                                                         , new SqlParameter("@MarriageId", employee.MarriageId)                                                         , new SqlParameter("@PartyStatusId", employee.PartyStatusId)                                                         , new SqlParameter("@Nationality", employee.Nationality)                                                         , new SqlParameter("@NativeAddr", employee.NativeAddr)                                                         , new SqlParameter("@EducationId", employee.EducationId)                                                         , new SqlParameter("@Major", sqlhelper.ToDbValue(employee.Major))                                                         , new SqlParameter("@School", sqlhelper.ToDbValue(employee.School))                                                         , new SqlParameter("@Address", employee.Address)                                                         , new SqlParameter("@BaseSalary", employee.BaseSalary)                                                         , new SqlParameter("@Email", sqlhelper.ToDbValue(employee.Email))                                                         , new SqlParameter("@IdNum", employee.IdNum)                                                         , new SqlParameter("@TelNum", employee.TelNum)                                                         , new SqlParameter("@EmergencyContact", sqlhelper.ToDbValue(employee.EmergencyContact))                                                         , new SqlParameter("@DepartmentId", employee.DepartmentId)                                                         , new SqlParameter("@Position", employee.Position)                                                         , new SqlParameter("@ContractStartDay", employee.ContractStartDay)                                                         , new SqlParameter("@ContractEndDay", employee.ContractEndDay)                                                         , new SqlParameter("@Resume", sqlhelper.ToDbValue(employee.Resume))                                                         , new SqlParameter("@Remarks", sqlhelper.ToDbValue(employee.Remarks))                                                         , new SqlParameter("@GenderId", employee.GenderId)                                                         , new SqlParameter("@Id", employee.Id));        }        }}

四：IdNameDAL.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using HRMSys.Model;using System.Data.SqlClient;using System.Data;namespace HRMSys.DAL{    public class IdNameDAL    {        //按分类得到所要的数据        public IdName[] GetByCategery(string categery)        {          DataTable table=  sqlhelper.datatable("select Id,Name from T_IdName where Categery=@Categery",                new SqlParameter("@Categery", categery));          IdName[] idnam = new IdName[table.Rows.Count] ;                    for (int i = 0; i < table.Rows.Count; i++)          {                DataRow row=table.Rows[i];                IdName idname = new IdName();              idname.Id=(Guid) row["Id"];              idname.Name=(string)row["Name"];              idnam[i] = idname;                        }          return idnam;        }    }}

五：sqlhelper.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace HRMSys.DAL{     static class sqlhelper    {        static SqlConnection conn;        static SqlCommand cmd;        /// 
        /// 返回受影响的行数        /// 
       public static readonly  string  constr =            ConfigurationManager.ConnectionStrings["constr"].ConnectionString;        public static int ExecuteNon(string sql,params SqlParameter[] parameter )        {            using (conn = new SqlConnection(constr))            {                conn.Open();                using ( cmd = conn.CreateCommand())                {                    cmd.CommandText = sql;                    cmd.Parameters.AddRange(parameter);                    return cmd.ExecuteNonQuery();                }            }         }        /// 
        ///返回结果的首行首列        /// 
        ///         ///         /// 
              public static int ExecuteSca(string sql, params SqlParameter[] parameter)        {            using (conn = new SqlConnection(constr))            {                conn.Open();                using (cmd = conn.CreateCommand())                {                    cmd.CommandText = sql;                    cmd.Parameters.AddRange(parameter);                    int result = (int) cmd.ExecuteScalar();                    return result;                }            }        }        /// 
        /// 返回一个数据流        /// 
        ///         ///         /// 
              public static object SqldataRea(string sql, params SqlParameter[] parameter)        {            using ( conn = new SqlConnection(constr))            {                conn.Open();                using (cmd = conn.CreateCommand())                {                    cmd.CommandText = sql;                    cmd.Parameters.AddRange(parameter);                    SqlDataReader sdr= sdr=cmd.ExecuteReader();                                        return sdr;                }            }        }        /// 
        /// 返回一个表        /// 
        ///         ///         /// 
              public static DataTable datatable(string sql, params SqlParameter[] parameter)        {            using ( conn = new SqlConnection(constr))            {                conn.Open();                using (cmd = conn.CreateCommand())                {                    cmd.CommandText = sql;                    cmd.Parameters.AddRange(parameter);                    SqlDataAdapter sda = new SqlDataAdapter(cmd);                    DataSet ds = new DataSet();                    sda.Fill(ds);                    return ds.Tables[0];                }            }        }         /// 
         /// 可空的处理,将数据库的可空类型转换为vs里的可空类型         /// 
         ///          /// 
              public static object FromDbValue(object value)        {            if (value == DBNull.Value)            {                return null;            }            else            {                return value;            }        }         /// 
         /// 将vs里的可空类型转换为数据库里的可空类型         /// 
         ///          /// 
              public static object ToDbValue(object value)        {            if (value == null)            {                return DBNull.Value;            }            else            {                return value;            }        }    }}

六：Department.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace HRMSys.Model{    public class Department    {        public Guid Id { get; set; }        public string Name { get; set; }        public bool IsDelete { get; set; }    }}

七：Employee.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace HRMSys.Model{    public class Employee    {        public Guid Id        {            get;            set;        }        /// 
        /// 工号        /// 
        public string Number        {            get;            set;        }        public string Name        {            get;            set;        }        /// 
        /// 性别Id        /// 
        public Guid GenderId        {            get;            set;        }        //因为图片如果一次性读取到Model中会非常耗内存，因此需要的时候再去单独读取，不在Model中建字段        /// 
        /// 出生日期        /// 
        public DateTime BirthDay        {            get;            set;        }        /// 
        /// 入职日期        /// 
        public DateTime InDate        {            get;            set;        }        /// 
        /// 婚姻状态Id        /// 
        public Guid MarriageId        {            get;            set;        }        /// 
        /// 政治面貌Id        /// 
        public Guid PartyStatusId        {            get;            set;        }        /// 
        /// 民族        /// 
        public string Nationality        {            get;            set;        }        /// 
        /// 籍贯        /// 
        public string NativeAddr        {            get;            set;        }        /// 
        /// 教育程度Id        /// 
        public Guid EducationId        {            get;            set;        }        /// 
        /// 专业        /// 
        public string Major        {            get;            set;        }        /// 
        /// 毕业院校        /// 
        public string School        {            get;            set;        }        /// 
        /// 地址        /// 
        public string Address        {            get;            set;        }        /// 
        /// 基本工资        /// 
        public int BaseSalary        {            get;            set;        }        /// 
        /// Email        /// 
        public string Email        {            get;            set;        }        /// 
        /// 有效身份证号        /// 
        public string IdNum        {            get;            set;        }        /// 
        /// 联系电话        /// 
        public string TelNum        {            get;            set;        }        /// 
        /// 紧急联系人信息        /// 
        public string EmergencyContact        {            get;            set;        }        /// 
        /// 部门Id        /// 
        public Guid DepartmentId        {            get;            set;        }        /// 
        /// 职位        /// 
        public string Position        {            get;            set;        }        /// 
        /// 合同起始时间        /// 
        public DateTime ContractStartDay        {            get;            set;        }        /// 
        /// 合同到期时间        /// 
        public DateTime ContractEndDay        {            get;            set;        }        /// 
        /// 简历        /// 
        public string Resume        {            get;            set;        }        /// 
        /// 备注        /// 
        public string Remarks        {            get;            set;        }        /// 
        /// 照片        /// 
        //public byte[] Photo        //{        //    get;        //    set;        //}        public bool IsStopped        {            get;            set;        }    }}

八：EmployeeList.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace HRMSys.Model{    public class EmployeeList    {        public Guid Id        {            get;            set;        }        /// 
        /// 工号        /// 
        public string Number        {            get;            set;        }        public string Name        {            get;            set;        }        /// 
        /// 性别        /// 
        public string Gender        {            get;            set;        }        //因为图片如果一次性读取到Model中会非常耗内存，因此需要的时候再去单独读取，不在Model中建字段        /// 
        /// 出生日期        /// 
        public DateTime BirthDay        {            get;            set;        }        /// 
        /// 入职日期        /// 
        public DateTime InDate        {            get;            set;        }        /// 
        /// 婚姻状态        /// 
        public string Marriage        {            get;            set;        }        /// 
        /// 政治面貌        /// 
        public string PartyStatus        {            get;            set;        }        /// 
        /// 民族        /// 
        public string Nationality        {            get;            set;        }        /// 
        /// 籍贯        /// 
        public string NativeAddr        {            get;            set;        }        /// 
        /// 教育程度        /// 
        public string Education        {            get;            set;        }        /// 
        /// 专业        /// 
        public string Major        {            get;            set;        }        /// 
        /// 毕业院校        /// 
        public string School        {            get;            set;        }        /// 
        /// 地址        /// 
        public string Address        {            get;            set;        }        /// 
        /// 基本工资        /// 
        public int BaseSalary        {            get;            set;        }        /// 
        /// Email        /// 
        public string Email        {            get;            set;        }        /// 
        /// 有效身份证号        /// 
        public string IdNum        {            get;            set;        }        /// 
        /// 联系电话        /// 
        public string TelNum        {            get;            set;        }        /// 
        /// 紧急联系人信息        /// 
        public string EmergencyContact        {            get;            set;        }        /// 
        /// 部门        /// 
        public string Department        {            get;            set;        }        /// 
        /// 职位        /// 
        public string Position        {            get;            set;        }        /// 
        /// 合同起始时间        /// 
        public DateTime ContractStartDay        {            get;            set;        }        /// 
        /// 合同到期时间        /// 
        public DateTime ContractEndDay        {            get;            set;        }        /// 
        /// 简历        /// 
        public string Resume        {            get;            set;        }        /// 
        /// 备注        /// 
        public string Remarks        {            get;            set;        }        /// 
        /// 照片        /// 
        //public byte[] Photo        //{        //    get;        //    set;        //}        public bool IsStopped        {            get;            set;        }    }}

九：IdName.cs源代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace HRMSys.Model{    public class IdName    {        public Guid Id { get;set;}        public string Name{
   get;set;}    }}

十：DeptEditWindow.cs源代码

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using HRMSys.DAL;namespace HYMSys.UI.SystemMgr{    public partial class DeptEditWindow : Form    {        public DeptEditWindow()        {            InitializeComponent();        }        public bool IsAdd { get; set; }        public Guid DepartmentId { get; set; }        public bool load { get; set; }        /// 
        /// 保存        /// 
        ///         ///         private void button1_Click(object sender, EventArgs e)        {            if (IsAdd == true)            {                DepartmentDAL dal = new DepartmentDAL();                dal.Insert(tb_Dename.Text);                MessageBox.Show("插入成功");            }            else            {                DepartmentDAL dal = new DepartmentDAL();                dal.Update(DepartmentId, tb_Dename.Text);                MessageBox.Show("修改成功");            }        }        /// 
        /// 取消        /// 
        ///         ///         private void button2_Click(object sender, EventArgs e)        {            DeptEditWindow ed = new DeptEditWindow();            this.Close();        }        /// 
        /// 窗口关闭设置刷新list窗口的参数为true        /// 
        ///         ///         private void DeptEditWindow_FormClosing(object sender, FormClosingEventArgs e)        {                       load = true;        }    }}

十一：DeptMgrWindow.cs源代码

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using HRMSys.DAL;namespace HYMSys.UI.SystemMgr{    public partial class DeptMgrWindow : Form    {        public DeptMgrWindow()        {            InitializeComponent();        }        private void load()        {            DepartmentDAL de = new DepartmentDAL();            dataGridView1.DataSource = de.ListAll();        }        /// 
        /// 窗体自动加载部门信息        /// 
        ///         ///         private void DeptMgrWindow_Load(object sender, EventArgs e)        {            load();        }        /// 
        /// 部门添加        /// 
        ///         ///         private void toolsb_add_Click(object sender, EventArgs e)        {            DeptEditWindow ed = new DeptEditWindow();            ed.IsAdd = true;            ed.ShowDialog();            if (ed.load == true)            {                //ed.load这个是刚新建的窗口的字段                load();//这个是本类中的方法            }        }        /// 
        /// 部门删除        /// 
        ///         ///         private void toolsb_delete_Click(object sender, EventArgs e)        {            Guid id = (Guid)dataGridView1.CurrentRow.Cells[0].Value;            string name = (string)dataGridView1.CurrentRow.Cells[1].Value;            DepartmentDAL da = new DepartmentDAL();            //MessageBox.Show("真的要删除--"+name+"--吗?","警告!",MessageBoxButtons.OKCancel)==DialogResult.Yes)是Yes将始终不成立,不会删除            if (MessageBox.Show("真的要删除--"+name+"--吗?","警告!",MessageBoxButtons.OKCancel)==DialogResult.OK)            {                da.DeleteById(id);                load();                MessageBox.Show(name+"已删除");            }                    }        /// 
        /// 部门修改        /// 
        ///         ///         private void toolsb_edit_Click(object sender, EventArgs e)        {            DeptEditWindow ed = new DeptEditWindow();            ed.DepartmentId=(Guid)dataGridView1.CurrentRow.Cells[0].Value;            ed.IsAdd = false;            ed.ShowDialog();            if (ed.load == true)            {                load();            }        }           }}

十二：EmployeeEditWindow.cs源代码

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using HRMSys.DAL;using HRMSys.Model;namespace HYMSys.UI.EmployeeMgr//不要将文件夹的名字写的和model的名字一样,这样就将命名空间和model重名了{    public partial class EmployeeEditWindow : Form    {        public EmployeeEditWindow()        {            InitializeComponent();        }        public bool IsAdd { get; set; }        public Guid EditId { get; set; }        public bool IsLoad { get; set; }        public bool IsSave { get; set; }        Employee em = new Employee();                //得到有默认值的tb的text长度        int number;        /// 
        /// 绑定数据        /// 
        public void binding()        {                        DepartmentDAL dal = new DepartmentDAL();            IdNameDAL idName = new IdNameDAL();            cb_EducationId.DataSource = idName.GetByCategery("学历");            cb_GenderId.DataSource = idName.GetByCategery("性别");            cb_MarriageId.DataSource = idName.GetByCategery("婚姻状况");            cb_PartyStatusId.DataSource = idName.GetByCategery("政治面貌");            cb_DepartmentId.DataSource = dal.ListAll();            IsSave = true;            //部门id            cb_DepartmentId.DisplayMember = "Name";            cb_DepartmentId.ValueMember = "Id";            if (em.DepartmentId != null)                cb_DepartmentId.SelectedValue = em.DepartmentId;            //学历id            cb_EducationId.DisplayMember = "Name";            cb_EducationId.ValueMember = "Id";            if (em.DepartmentId != null)//如果不为空将选择好的数据绑定上                cb_EducationId.SelectedValue = em.EducationId;            //性别id            cb_GenderId.DisplayMember = "Name";            cb_GenderId.ValueMember = "Id";            if (em.DepartmentId != null)                cb_GenderId.SelectedValue = em.GenderId;            //婚姻状况id            cb_MarriageId.DisplayMember = "Name";            cb_MarriageId.ValueMember = "Id";            if (em.DepartmentId != null)                cb_MarriageId.SelectedValue = em.MarriageId;            //政治面貌id            cb_PartyStatusId.DisplayMember = "Name";            cb_PartyStatusId.ValueMember = "Id";            if (em.DepartmentId != null)                cb_PartyStatusId.SelectedValue = em.PartyStatusId;            //其他的数据绑定            tb_Address.DataBindings.Add("Text", em, "Address", false, DataSourceUpdateMode.OnPropertyChanged);            tb_BaseSalary.DataBindings.Add("Text", em, "BaseSalary", false, DataSourceUpdateMode.OnPropertyChanged);            dtp_BirthDay.DataBindings.Add("Value", em, "BirthDay", true, DataSourceUpdateMode.OnPropertyChanged);            dtp_ContractEndDay.DataBindings.Add("Value", em, "ContractEndDay", true, DataSourceUpdateMode.OnPropertyChanged);            dtp_ContractStartDay.DataBindings.Add("Value", em, "ContractStartDay", true, DataSourceUpdateMode.OnPropertyChanged);            //dtp_ContractStartDay.DataBindings.Add("Value", em, "ContractStartDay", true);            tb_Email.DataBindings.Add("Text", em, "Email", false, DataSourceUpdateMode.OnPropertyChanged);            tb_EmergencyContact.DataBindings.Add("Text", em, "EmergencyContact", false, DataSourceUpdateMode.OnPropertyChanged);            tb_IdNum.DataBindings.Add("Text", em, "IdNum", false, DataSourceUpdateMode.OnPropertyChanged);            dtp_Indate.DataBindings.Add("Value", em, "InDate", true, DataSourceUpdateMode.OnPropertyChanged);            tb_Major.DataBindings.Add("Text", em, "Major", false, DataSourceUpdateMode.OnPropertyChanged);            tb_Name.DataBindings.Add("Text", em, "Name", false, DataSourceUpdateMode.OnPropertyChanged);            tb_Nationality.DataBindings.Add("Text", em, "Nationality", false, DataSourceUpdateMode.OnPropertyChanged);            tb_NativeAddr.DataBindings.Add("Text", em, "NativeAddr", false, DataSourceUpdateMode.OnPropertyChanged);            tb_Number.DataBindings.Add("Text", em, "Number", false, DataSourceUpdateMode.OnPropertyChanged);            //pb_Photo.DataBindings.Add(new Binding("pb_Photo", em, "Photo", true));            tb_Position.DataBindings.Add("Text", em, "Position", false, DataSourceUpdateMode.OnPropertyChanged);            tb_Remarks.DataBindings.Add("Text", em, "Remarks", false, DataSourceUpdateMode.OnPropertyChanged);            //tabControl1.TabPages[2].DataBindings.Add("Text", em, "Resume", true, DataSourceUpdateMode.OnPropertyChanged);            tb_school.DataBindings.Add("Text", em, "School", false, DataSourceUpdateMode.OnPropertyChanged);            tb_TelNum.DataBindings.Add("Text", em, "TelNum", false, DataSourceUpdateMode.OnPropertyChanged);        }        /// 
        /// 窗口关闭时将刷新置为true        /// 
        ///         ///         private void EmployeeEditWindow_FormClosing(object sender, FormClosingEventArgs e)        {            IsLoad = true;        }        /// 
        /// 添加时自动载入默认值,数据绑定和初始化        /// 
        ///         ///         private void EmployeeEditWindow_Load(object sender, EventArgs e)        {            if (IsAdd==true)            {                #region                //combobox的数据绑定                binding();                //将合同到期日在今天的基础上加1年                dtp_ContractEndDay.Value = DateTime.Now.AddYears(1);                dtp_BirthDay.Value = DateTime.Now.AddYears(-24);                dtp_ContractStartDay.Value = DateTime.Now;                dtp_Indate.Value = DateTime.Now;                tb_Nationality.Text = "汉族";                tb_BaseSalary.Text = "3000";                tb_Email.Text = "@qq.com";                tb_Number.Text = "HMJ";                number = tb_Number.Text.Length;                #endregion            }            else            {                Employee list = new Employee();                EmployeeDAL dal = new EmployeeDAL();                list = dal.GetById(EditId);                em = list;                binding();             }        }             /// 
        /// textboxToRed将背景颜色变红        /// 
        ///         private void textboxToRed(TextBox tb,int length)        {                        if (tb.Text.Length <= length)            {                tb.BackColor = Color.Red;//将背景变为红色                IsSave = false;            }            else            {                tb.BackColor = DefaultBackColor;//将背景置为默认颜色            }        }        /// 
        /// ComboxToRed将背景颜色变红        /// 
        ///         private void ComboxToRed(ComboBox cb)        {            if (cb.Text.Length <= 0)            {                cb.BackColor = Color.Red;//将背景变为红色                IsSave = false;            }            else            {                cb.BackColor = DefaultBackColor;//将背景置为默认颜色            }        }        /// 
        /// 保存        /// 
        ///         ///         private void button1_Click(object sender, EventArgs e)        {            if (IsAdd)            {                #region                //检查必填项,如果为空显示为红色                textboxToRed(tb_Address, 0);                textboxToRed(tb_IdNum, 0);                textboxToRed(tb_Name, 0);                textboxToRed(tb_Number, number);//工号和默认值长度比较                textboxToRed(tb_Position, 0);                textboxToRed(tb_TelNum, 0);                textboxToRed(tb_NativeAddr, 0);                ComboxToRed(cb_DepartmentId);                ComboxToRed(cb_EducationId);                ComboxToRed(cb_GenderId);                ComboxToRed(cb_MarriageId);                ComboxToRed(cb_PartyStatusId);                //这里不用再赋值,已经绑定了,怎么将外键id显示为对应的名字呢?cb_PartyStatusId.SelectedValue = em.PartyStatusId;                #region                //EmployeeDAL dal = new EmployeeDAL();                //Employee em = new Employee();                //em.EducationId = cb_EducationId.ValueMember;//                //em.Address = tb_Address.Text;                //em.BaseSalary = Convert.ToInt32(tb_BaseSalary.Text);                //em.BirthDay = dtp_BirthDay.Value;                //em.ContractEndDay = dtp_ContractEndDay.Value;                //em.ContractStartDay = dtp_ContractStartDay.Value;                //em.DepartmentId = cb_DepartmentId.ValueMember;                //em.Email = tb_Email.Text;                //em.EmergencyContact = tb_EmergencyContact.Text;                //em.GenderId = cb_GenderId.ValueMember;                ////em.Id=不用输的                //em.IdNum = tb_IdNum.Text;                //em.InDate = dtp_Indate.Value;                //em.Major = tb_Major.Text;                //em.MarriageId = cb_MarriageId.ValueMember;//要转换为guid婚姻                //em.Name = tb_Name.Text;                //em.Nationality = tb_Nationality.Text;                //em.NativeAddr = tb_NativeAddr.Text;                //em.Number = tb_Number.Text;                //em.PartyStatusId = cb_PartyStatusId.ValueMember;                //em.Photo = pb_Photo;                //em.Position = tb_Position.Text;                //em.Remarks = tb_Remarks.Text;                //em.Resume = tabControl1.TabPages[2].ToString();//简历                //em.School = tb_school.Text;                //em.TelNum = tb_TelNum.Text;                #endregion                if (IsSave == true)                {                    EmployeeDAL darl = new EmployeeDAL();                    //将数据结果给object对象                    em.DepartmentId = (Guid)cb_DepartmentId.SelectedValue;                    em.EducationId = (Guid)cb_EducationId.SelectedValue;                    em.GenderId = (Guid)cb_GenderId.SelectedValue;                    em.MarriageId = (Guid)cb_MarriageId.SelectedValue;                    em.PartyStatusId = (Guid)cb_PartyStatusId.SelectedValue;                    darl.Insert(em);                    MessageBox.Show("成功插入一条员工数据");                    IsLoad = true;                }                #endregion            }            else             {                EmployeeDAL dal = new EmployeeDAL();                dal.Update(em);                MessageBox.Show("更改成功!");            }        }            }}

十三：EmployeeListWindow.cs源代码

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using HRMSys.DAL;using HRMSys.Model;namespace HYMSys.UI.EmployeeMgr{    public partial class EmployeeListWindow : Form    {        public EmployeeListWindow()        {            InitializeComponent();        }        /// 
        /// 加载所有信息        /// 
        public EmployeeList[] load()        {            EmployeeDAL de = new EmployeeDAL();                       return de.ListAll();                               }               /// 
        /// 添加员工        /// 
        ///         ///         private void toolsb_add_Click(object sender, EventArgs e)        {            EmployeeEditWindow edit = new EmployeeEditWindow();            edit.IsAdd = true;            edit.ShowDialog();            if (edit.IsLoad == true)            {                dataGridView1.DataSource = load();            }        }        /// 
        /// 删除员工        /// 
        ///         ///         private void toolsb_delete_Click(object sender, EventArgs e)        {            Guid id=(Guid)dataGridView1.CurrentRow.Cells[1].Value;            string name=(string)dataGridView1.CurrentRow.Cells[3].Value;            if (MessageBox.Show("真的要删除---"+name+"---吗?","警告!",MessageBoxButtons.OKCancel)==DialogResult.OK)            {                EmployeeDAL dal = new EmployeeDAL();                dal.DeleteById(id);                dataGridView1.DataSource = load();            }                    }        /// 
        /// 修改员工信息        /// 
        ///         ///         private void toolsb_edit_Click(object sender, EventArgs e)        {            EmployeeEditWindow edit = new EmployeeEditWindow();           edit.EditId = (Guid)dataGridView1.CurrentRow.Cells[1].Value;           edit.IsAdd = false;            edit.ShowDialog();            if (edit.IsLoad == true)            {                dataGridView1.DataSource = load();            }        }        /// 
        /// 自动加载所有员工信息        /// 
        ///         ///         private void EmployeeListWindow_Load(object sender, EventArgs e)        {                        dataGridView1.DataSource= load();                    }    }}

十四：作品图