Esempio n. 1
0
 /// <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;
     }
 }
Esempio n. 2
0
 /// <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"]);
     }
 }