单位人事信息管理 C#源程序实训报告 - 图文

}

private string teleophone;

public string Teleophone {

get { return teleophone; } set { teleophone = value; } }

private string phone;

public string Phone {

get { return phone; } set { phone = value; } }

private string address;

public string Address {

get { return address; } set { address = value; } }

private string school;

public string School {

get { return school; } set { school = value; } }

private string zhichen;

public string Zhichen {

get { return zhichen; } set { zhichen = value; } }

private string bumen;

public string Bumen {

get { return bumen; } set { bumen = value; } }

#endregion

2、 PersonManager类的代码：

#region 方法

//员工查询个人信息方法

public Person Find(string PersonNo, string pwd) {

//数据库部分

OleDbConnection mycon = new OleDbConnection(\data source=zhigong.mdb\);

OleDbCommand mycom = new OleDbCommand(\员工号]='\ + PersonNo + \密码]='\ + pwd + \, mycon); mycon.Open();

OleDbDataReader dr = mycom.ExecuteReader();

Person p = new Person(); if (dr.Read() == false) {

p = null; } else {

p.Sex = dr[\性别\].ToString(); p.Name = dr[\姓名\].ToString(); p.Birthday = dr[\年龄\].ToString(); p.Mingzu = dr[\民族\].ToString(); p.Jiguan = dr[\籍贯\].ToString(); p.Hunying = dr[\婚姻状况\].ToString(); p.Xueli = dr[\学历\].ToString(); p.Id = dr[\身份证号\].ToString(); p.Zhiwu = dr[\职务\].ToString(); p.Teleophone = dr[\手机号\].ToString(); p.Phone = dr[\家庭电话\].ToString(); p.Address = dr[\家庭住址\].ToString(); p.School = dr[\毕业学校\].ToString(); p.Zhichen = dr[\职称\].ToString(); p.Bumen = dr[\部门\].ToString();

}

mycon.Close(); return p;

}

//管理员查询员工信息方法

public List Find(string PersonNo, string name, string partment,string xueli) {

//数据库部分

OleDbConnection mycon = new OleDbConnection(\data source=zhigong.mdb\);

OleDbCommand mycom = new OleDbCommand(\员工号]='\ + PersonNo + \姓名]='\ + name + \部门]='\ + partment + \学历]='\ + xueli + \, mycon);

mycon.Open();

OleDbDataReader dr = mycom.ExecuteReader();

List p;

if (dr.Read() == false) //第一次读 {

p = null; } else {

p = new List();

do {

Person p1 = new Person(); p1.Sex = dr[\性别\].ToString(); p1.Name = dr[\姓名\].ToString(); p1.Birthday = dr[\年龄\].ToString(); p1.Mingzu = dr[\民族\].ToString(); p1.Jiguan = dr[\籍贯\].ToString(); p1.Hunying = dr[\婚姻状况\].ToString(); p1.Xueli = dr[\学历\].ToString(); p1.Id = dr[\身份证号\].ToString(); p1.Zhiwu = dr[\职务\].ToString(); p1.Teleophone = dr[\手机号\].ToString(); p1.Phone = dr[\家庭电话\].ToString(); p1.Address = dr[\家庭住址\].ToString(); p1.School = dr[\毕业学校\].ToString(); p1.Zhichen = dr[\职称\].ToString(); p1.Bumen = dr[\部门\].ToString();

p.Add(p1);

}

while (dr.Read() == true); }

mycon.Close(); return p; }

//管理员修改员工信息方法

public Person Find(string PersonNo) {

//数据库部分

OleDbConnection mycon = new OleDbConnection(\data source=zhigong.mdb\);

OleDbCommand mycom = new OleDbCommand(\员工号]='\ + PersonNo + \, mycon); mycon.Open();

OleDbDataReader dr = mycom.ExecuteReader();

Person p = new Person(); if (dr.Read() == false) {

p = null; } else {

p.Sex = dr[\性别\].ToString(); p.Name = dr[\姓名\].ToString(); p.Birthday = dr[\年龄\].ToString(); p.Mingzu = dr[\民族\].ToString(); p.Jiguan = dr[\籍贯\].ToString(); p.Hunying = dr[\婚姻状况\].ToString(); p.Xueli = dr[\学历\].ToString(); p.Id = dr[\身份证号\].ToString(); p.Zhiwu = dr[\职务\].ToString(); p.Teleophone = dr[\手机号\].ToString(); p.Phone = dr[\家庭电话\].ToString(); p.Address = dr[\家庭住址\].ToString(); p.School = dr[\毕业学校\].ToString(); p.Zhichen = dr[\职称\].ToString(); p.Bumen = dr[\部门\].ToString();

}

mycon.Close();