/// <summary> /// 从DataReader中读取数据,并为Employee对象需要进行显示的属性赋值。该方法主要由该类的子类调用。 /// </summary> /// <param name="sqlDataReader">IDataReader</param> /// <param name="employee">员工信息(Employee)实例对象</param> protected void ReadEmployeePageData(IDataReader dataReader, Employee employee) { // 自动编号 if (dataReader["Id"] != DBNull.Value) { employee.Id = Convert.ToInt32(dataReader["Id"]); } // 工号 if (dataReader["BadgeId"] != DBNull.Value) { employee.BadgeId = Convert.ToString(dataReader["BadgeId"]); } // 姓名 if (dataReader["Name"] != DBNull.Value) { employee.Name = Convert.ToString(dataReader["Name"]); } // 性别 if (dataReader["SexId"] != DBNull.Value) { Sex tmpSex = Sex.GetDataById(Convert.ToInt32(dataReader["SexId"])); if (tmpSex != null) { employee.Sex = tmpSex; } } // 毕业学校 if (dataReader["GraduateSchool"] != DBNull.Value) { employee.GraduateSchool = Convert.ToString(dataReader["GraduateSchool"]); } // 联系电话 if (dataReader["ContactPhone"] != DBNull.Value) { employee.ContactPhone = Convert.ToString(dataReader["ContactPhone"]); } }
/// <summary> /// 将界面控件中的值,绑定给关联对象。 /// </summary> private void BindFormlToObject() { if (!DataValid.IsNullOrInt(DrpSex.SelectedValue.ToString())) { throw new CustomException("“性别”的编号,不是一个有效的整数,请您重新输入。"); } if (!DataValid.IsNullOrDateTime(TxtDateOfBirth.Text)) { throw new CustomException("“出生日期”不是一个有效格式的日期,正确格式应为“" + DateTime.Now.ToString("yyyy-MM-dd") + "”,请您重新输入。"); } if (!DataValid.IsNullOrInt(DrpDepartment.SelectedValue.ToString())) { throw new CustomException("“所在部门”的自动编号,不是一个有效的整数,请您重新输入。"); } employee.BadgeId = DataValid.GetNullOrString(TxtBadgeId.Text); // 工号 employee.Name = DataValid.GetNullOrString(TxtName.Text); // 姓名 employee.Sex = Sex.GetDataById(DataValid.GetNullOrInt(DrpSex.SelectedValue.ToString()).Value); // 性别 employee.DateOfBirth = DataValid.GetNullOrDateTime(TxtDateOfBirth.Text); // 出生日期 employee.IDCardId = DataValid.GetNullOrString(TxtIDCardId.Text); // 身份证号 employee.Nationa = DataValid.GetNullOrString(TxtNationa.Text); // 民族 employee.PoliticalLandscape = DataValid.GetNullOrString(TxtPoliticalLandscape.Text); // 政治面貌 employee.MaritalStatus = DataValid.GetNullOrString(TxtMaritalStatus.Text); // 婚姻状况 employee.PlaceOfHouseholdRegistration = DataValid.GetNullOrString(TxtPlaceOfHouseholdRegistration.Text); // 户口所在地 employee.Department = (DataValid.GetNullOrInt(DrpDepartment.SelectedValue.ToString()) != null) ? DepartmentBLL.GetDataById(DataValid.GetNullOrInt(DrpDepartment.SelectedValue.ToString()).Value) : null; // 所在部门 employee.ResidenceAddress = DataValid.GetNullOrString(TxtResidenceAddress.Text); // 现居住住址 employee.GraduateSchool = DataValid.GetNullOrString(TxtGraduateSchool.Text); // 毕业学校 employee.FieldOfStudy = DataValid.GetNullOrString(TxtFieldOfStudy.Text); // 所学专业 employee.GraduationDate = DataValid.GetNullOrString(TxtGraduationDate.Text); // 毕业时间 employee.AcademicQualifications = DataValid.GetNullOrString(TxtAcademicQualifications.Text); // 学历 employee.ContactPhone = DataValid.GetNullOrString(TxtContactPhone.Text); // 联系电话 employee.EmergencyContacts = DataValid.GetNullOrString(TxtEmergencyContacts.Text); // 紧急联系人 employee.EmergencyTelephone = DataValid.GetNullOrString(TxtEmergencyTelephone.Text); // 紧急电话 }
/// <summary> /// 从DataReader中读取数据,并为Employee对象的所有属性赋值。该方法主要由该类的子类调用。 /// </summary> /// <param name="sqlDataReader">IDataReader</param> /// <param name="employee">员工信息(Employee)实例对象</param> protected void ReadEmployeeAllData(IDataReader dataReader, Employee employee) { // 自动编号 if (dataReader["Id"] != DBNull.Value) { employee.Id = Convert.ToInt32(dataReader["Id"]); } // 工号 if (dataReader["BadgeId"] != DBNull.Value) { employee.BadgeId = Convert.ToString(dataReader["BadgeId"]); } // 姓名 if (dataReader["Name"] != DBNull.Value) { employee.Name = Convert.ToString(dataReader["Name"]); } // 性别 if (dataReader["SexId"] != DBNull.Value) { Sex tmpSex = Sex.GetDataById(Convert.ToInt32(dataReader["SexId"])); if (tmpSex != null) { employee.Sex = tmpSex; } } // 出生日期 if (dataReader["DateOfBirth"] != DBNull.Value) { employee.DateOfBirth = Convert.ToDateTime(dataReader["DateOfBirth"]); } // 身份证号 if (dataReader["IDCardId"] != DBNull.Value) { employee.IDCardId = Convert.ToString(dataReader["IDCardId"]); } // 民族 if (dataReader["Nationa"] != DBNull.Value) { employee.Nationa = Convert.ToString(dataReader["Nationa"]); } // 政治面貌 if (dataReader["PoliticalLandscape"] != DBNull.Value) { employee.PoliticalLandscape = Convert.ToString(dataReader["PoliticalLandscape"]); } // 婚姻状况 if (dataReader["MaritalStatus"] != DBNull.Value) { employee.MaritalStatus = Convert.ToString(dataReader["MaritalStatus"]); } // 户口所在地 if (dataReader["PlaceOfHouseholdRegistration"] != DBNull.Value) { employee.PlaceOfHouseholdRegistration = Convert.ToString(dataReader["PlaceOfHouseholdRegistration"]); } // 所在部门 if (dataReader["DepartmentId"] != DBNull.Value) { Department tmpDepartment = DepartmentDAL.Instance.GetDataById(Convert.ToInt32(dataReader["DepartmentId"])); if (tmpDepartment != null) { employee.Department = tmpDepartment; } } // 现居住住址 if (dataReader["ResidenceAddress"] != DBNull.Value) { employee.ResidenceAddress = Convert.ToString(dataReader["ResidenceAddress"]); } // 毕业学校 if (dataReader["GraduateSchool"] != DBNull.Value) { employee.GraduateSchool = Convert.ToString(dataReader["GraduateSchool"]); } // 所学专业 if (dataReader["FieldOfStudy"] != DBNull.Value) { employee.FieldOfStudy = Convert.ToString(dataReader["FieldOfStudy"]); } // 毕业时间 if (dataReader["GraduationDate"] != DBNull.Value) { employee.GraduationDate = Convert.ToString(dataReader["GraduationDate"]); } // 学历 if (dataReader["AcademicQualifications"] != DBNull.Value) { employee.AcademicQualifications = Convert.ToString(dataReader["AcademicQualifications"]); } // 联系电话 if (dataReader["ContactPhone"] != DBNull.Value) { employee.ContactPhone = Convert.ToString(dataReader["ContactPhone"]); } // 紧急联系人 if (dataReader["EmergencyContacts"] != DBNull.Value) { employee.EmergencyContacts = Convert.ToString(dataReader["EmergencyContacts"]); } // 紧急电话 if (dataReader["EmergencyTelephone"] != DBNull.Value) { employee.EmergencyTelephone = Convert.ToString(dataReader["EmergencyTelephone"]); } }