/// <summary> /// 从DataReader中读取数据,并为BasicExamination对象需要进行显示的属性赋值。该方法主要由该类的子类调用。 /// </summary> /// <param name="sqlDataReader">IDataReader</param> /// <param name="basicExamination">基础体检表(BasicExamination)实例对象</param> protected void ReadBasicExaminationPageData(IDataReader dataReader, BasicExamination basicExamination) { // 编号 if (dataReader["Id"] != DBNull.Value) { basicExamination.Id = Convert.ToInt32(dataReader["Id"]); } // 居民号 if (dataReader["ResidentId"] != DBNull.Value) { basicExamination.ResidentId = Convert.ToString(dataReader["ResidentId"]); } // 姓名 if (dataReader["TheName"] != DBNull.Value) { basicExamination.TheName = Convert.ToString(dataReader["TheName"]); } // 体检编号 if (dataReader["CheckID"] != DBNull.Value) { basicExamination.CheckID = Convert.ToString(dataReader["CheckID"]); } // 体检日期 if (dataReader["CheckDate"] != DBNull.Value) { basicExamination.CheckDate = Convert.ToString(dataReader["CheckDate"]); } // 体检医生 if (dataReader["Doctor"] != DBNull.Value) { basicExamination.Doctor = Convert.ToString(dataReader["Doctor"]); } // 症状 if (dataReader["SymptomsId"] != DBNull.Value) { //参照完整性捆绑对象 basicExamination.Symptoms = T_Symptoms.GetDataById(Convert.ToInt32(dataReader["SymptomsId"])) ?? T_Symptoms.Empty; } }
/// <summary> /// 从DataReader中读取数据,并为BasicExamination对象的所有属性赋值。该方法主要由该类的子类调用。 /// </summary> /// <param name="sqlDataReader">IDataReader</param> /// <param name="basicExamination">基础体检表(BasicExamination)实例对象</param> protected void ReadBasicExaminationAllData(IDataReader dataReader, BasicExamination basicExamination) { // 编号 if (dataReader["Id"] != DBNull.Value) { basicExamination.Id = Convert.ToInt32(dataReader["Id"]); } // 居民号 if (dataReader["ResidentId"] != DBNull.Value) { basicExamination.ResidentId = Convert.ToString(dataReader["ResidentId"]); } // 姓名 if (dataReader["TheName"] != DBNull.Value) { basicExamination.TheName = Convert.ToString(dataReader["TheName"]); } // 体检编号 if (dataReader["CheckID"] != DBNull.Value) { basicExamination.CheckID = Convert.ToString(dataReader["CheckID"]); } // 体检日期 if (dataReader["CheckDate"] != DBNull.Value) { basicExamination.CheckDate = Convert.ToString(dataReader["CheckDate"]); } // 体检医生 if (dataReader["Doctor"] != DBNull.Value) { basicExamination.Doctor = Convert.ToString(dataReader["Doctor"]); } // 症状 if (dataReader["SymptomsId"] != DBNull.Value) { basicExamination.Symptoms = T_Symptoms.GetDataById(Convert.ToInt32(dataReader["SymptomsId"])) ?? T_Symptoms.Empty; } // 体温 if (dataReader["Temperature"] != DBNull.Value) { basicExamination.Temperature = Convert.ToDecimal(dataReader["Temperature"]); } // 脉率 if (dataReader["BPM"] != DBNull.Value) { basicExamination.BPM = Convert.ToDecimal(dataReader["BPM"]); } // 呼吸频率 if (dataReader["RR"] != DBNull.Value) { basicExamination.RR = Convert.ToDecimal(dataReader["RR"]); } // 血压 if (dataReader["BP"] != DBNull.Value) { basicExamination.BP = Convert.ToDecimal(dataReader["BP"]); } // 身高 if (dataReader["Height"] != DBNull.Value) { basicExamination.Height = Convert.ToDecimal(dataReader["Height"]); } // 体重 if (dataReader["Weight"] != DBNull.Value) { basicExamination.Weight = Convert.ToDecimal(dataReader["Weight"]); } // 腰围 if (dataReader["Waist"] != DBNull.Value) { basicExamination.Waist = Convert.ToDecimal(dataReader["Waist"]); } // 体质指数 if (dataReader["BMI"] != DBNull.Value) { basicExamination.BMI = Convert.ToDecimal(dataReader["BMI"]); } // 体育锻炼 if (dataReader["PhysicalExercise"] != DBNull.Value) { basicExamination.PhysicalExercise = Convert.ToString(dataReader["PhysicalExercise"]); } // 饮食习惯 if (dataReader["EatingHabitsId"] != DBNull.Value) { basicExamination.EatingHabits = T_EatingHabits.GetDataById(Convert.ToInt32(dataReader["EatingHabitsId"])) ?? T_EatingHabits.Empty; } // 吸烟情况 if (dataReader["Smoking"] != DBNull.Value) { basicExamination.Smoking = Convert.ToString(dataReader["Smoking"]); } // 饮酒情况 if (dataReader["Drinking"] != DBNull.Value) { basicExamination.Drinking = Convert.ToString(dataReader["Drinking"]); } // 职业暴露情况 if (dataReader["OccupationalExposure"] != DBNull.Value) { basicExamination.OccupationalExposure = Convert.ToString(dataReader["OccupationalExposure"]); } }