/// <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"]);
}
}
