示例#1
0
        public People getPersonHealth(short keyfield)
        {
            People p = new People();

            using (SqlConnection conn = new SqlConnection(DBConnect.GetSchoolConnStr()))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = "uspGetPersonHealth";
                    cmd.Parameters.Add("@keyfield", SqlDbType.SmallInt).Value = keyfield;
                    conn.Open();
                    SqlDataReader rdr = cmd.ExecuteReader();

                    while (rdr.Read())
                    {
                        Allergies a = new Allergies();
                        a.Keyfield           = DbUtilities.GetShort(rdr, "KeyField");
                        a.allergyDescription = rdr["Description"].ToString();
                        p.Allergies.Add(a);
                    }
                    rdr.NextResult();
                    if (rdr.HasRows)
                    {
                        while (rdr.Read())
                        {
                            Insurances i = new Insurances();
                            i.keyfield            = DbUtilities.GetShort(rdr, "keyfield");
                            i.InsuranceCo         = rdr["InsuranceCo"].ToString();
                            i.PolicyNum           = rdr["PolicyNum"].ToString();
                            i.SubscriberName      = rdr["SubscriberName"].ToString();
                            i.SubscriberNum       = rdr["SubscriberNum"].ToString();
                            i.SubscriberEmployer  = rdr["SubscriberEmployer"].ToString();
                            i.SubscriberJob       = rdr["SubscriberJob"].ToString();
                            i.SubscriberWorkPhone = rdr["SubscriberWorkPhone"].ToString();
                            p.Insurances.Add(i);
                        }
                    }
                    rdr.NextResult();
                    if (rdr.HasRows)
                    {
                        while (rdr.Read())
                        {
                            MedHist mh = new MedHist();
                            mh.keyfield                  = DbUtilities.GetShort(rdr, "KeyField");
                            mh.HealthCondition           = DbUtilities.GetByte(rdr, "HealthCondition");
                            mh.ConditionExplanation      = rdr["ConditionExplanation"].ToString();
                            mh.HealthTreatment           = rdr["HealthTreatment"].ToString();
                            mh.HasAsthma                 = DbUtilities.GetBool(rdr, "HasAsthma");
                            mh.HasSinusitis              = DbUtilities.GetBool(rdr, "HasSinusitis");
                            mh.HasBronchitis             = DbUtilities.GetBool(rdr, "HasBronchitis");
                            mh.HasKidneyTrouble          = DbUtilities.GetBool(rdr, "HasKidneyTrouble");
                            mh.HasHeartTrouble           = DbUtilities.GetBool(rdr, "HasHeartTrouble");
                            mh.HasDiabetes               = DbUtilities.GetBool(rdr, "HasDiabetes");
                            mh.HasDizziness              = DbUtilities.GetBool(rdr, "HasDizziness");
                            mh.HasStomachUpset           = DbUtilities.GetBool(rdr, "HasStomachUpset");
                            mh.HasHayFever               = DbUtilities.GetBool(rdr, "HasHayFever");
                            mh.Explanation               = rdr["Explanation"].ToString();
                            mh.PastOperationsOrIllnesses = rdr["PastOperationsOrIllnesses"].ToString();
                            mh.CurrentMeds               = rdr["CurrentMeds"].ToString();
                            mh.SpecialDietOrNeeds        = rdr["SpecialDietOrNeeds"].ToString();
                            mh.HadChickenPox             = DbUtilities.GetBool(rdr, "HadChickenPox");
                            mh.HadMeasles                = DbUtilities.GetBool(rdr, "HadMeasles");
                            mh.HadMumps                  = DbUtilities.GetBool(rdr, "HadMumps");
                            mh.HadWhoopingCough          = DbUtilities.GetBool(rdr, "HadWhoopingCough");
                            mh.OtherChildhoodDiseases    = rdr["OtherChildhoodDiseases"].ToString();
                            mh.DateOfTetanusShot         = DbUtilities.GetDateTime(rdr, "DateOfTetanusShot");
                            mh.FamilyDoctor              = rdr["FamilyDoctor"].ToString();
                            mh.FamilyDoctorPhone         = rdr["FamilyDoctorPhone"].ToString();
                            p.MedHist.Add(mh);
                        }
                    }
                }

                return(p);
            }
        }