Example #1
0
 public TestMainDiagnosis(MainDiagnosis r)
 {
     diagnos = r;
     diagnosisInfo = new TestDiagnosisInfo(diagnos.DiagnosisInfo);
     foreach (DiagnosisInfo i in diagnos.ComplicationDiagnosis)
         compDiagnosis.Add(new TestDiagnosisInfo(i));
 }
Example #2
0
 static public TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral)
 {
     using (NpgsqlConnection connection = Global.GetSqlConnection())
     {
         //опять DiagnosedDateSpecified, что с этим делать?
         //ещё есть какой-то idDiagnosisStatus и idLpu, так же idDiagnosisContainer - это не diagnosisType?
         string        finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "')";
         NpgsqlCommand person        = new NpgsqlCommand(finddiagnosis, connection);
         using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
         {
             while (diagnosisReader.Read())
             {
                 DiagnosisInfo diag = new DiagnosisInfo();
                 if (diagnosisReader["comment"] != DBNull.Value)
                 {
                     diag.Comment = Convert.ToString(diagnosisReader["comment"]);
                 }
                 if (diagnosisReader["diagnosis_date"] != DBNull.Value)
                 {
                     diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
                 }
                 TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
                 if (diagnosisReader["id_mkb_code"] != DBNull.Value)
                 {
                     tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(diagnosisReader["id_mkb_code"]));
                 }
                 return(tDiag);
             }
         }
     }
     return(null);
 }
Example #3
0
 public static List<TestDiagnosisInfo> BuildTestComplicationDiagnosisInfoFromDataBaseData(string idReferral)
 {
     List<TestDiagnosisInfo> diagnosis = new List<TestDiagnosisInfo>();
     using (NpgsqlConnection connection = Global.GetSqlConnection())
     {
         //опять DiagnosedDateSpecified, что с этим делать?
         //ещё есть какой-то idDiagnosisStatus и idLpu, так же idDiagnosisContainer - это не diagnosisType?
         string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "')";
         NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
         using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
         {
             while (diagnosisReader.Read())
             {
                 DiagnosisInfo diag = new DiagnosisInfo();
                 if (diagnosisReader["comment"].ToString() != "")
                     diag.Comment = Convert.ToString(diagnosisReader["comment"]);
                 if (diagnosisReader["diagnosis_date"].ToString() != "")
                     diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
                 TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
                 if (diagnosisReader["id_mkb_code"].ToString() != "")
                     tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(diagnosisReader["id_mkb_code"]));
                 diagnosis.Add(tDiag);
             }
         }
     }
     if (diagnosis.Count != 0)
         return diagnosis;
     else
         return null;
 }
Example #4
0
        public override bool Equals(Object obj)
        {
            TestDiagnosisInfo p = obj as TestDiagnosisInfo;

            if ((object)p == null)
            {
                return(false);
            }
            if (this.diagnosisInfo == p.diagnosisInfo)
            {
                return(true);
            }
            if ((this.diagnosisInfo == null) || (p.diagnosisInfo == null))
            {
                return(false);
            }
            if ((this.diagnosisInfo.Comment == p.diagnosisInfo.Comment) &&
                (this.diagnosisInfo.DiagnosedDate == p.diagnosisInfo.DiagnosedDate) &&
                (Global.IsEqual(this.diagnosisType, p.diagnosisType)) &&
                (Global.IsEqual(this.mkbCode, p.mkbCode)))
            {
                return(true);
            }
            else
            {
                this.FindMismatch(p);
                Global.errors3.Add("несовпадение TestDiagnosisInfo");
                return(false);
            }
        }
Example #5
0
 public TestMainDiagnosis(MainDiagnosis r)
 {
     diagnos       = r;
     diagnosisInfo = new TestDiagnosisInfo(diagnos.DiagnosisInfo);
     foreach (DiagnosisInfo i in diagnos.ComplicationDiagnosis)
     {
         compDiagnosis.Add(new TestDiagnosisInfo(i));
     }
 }
Example #6
0
        static public List <TestMainDiagnosis> BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral)
        {
            List <TestMainDiagnosis> tdi = new List <TestMainDiagnosis>();
            TestMainDiagnosis        md  = new TestMainDiagnosis(new MainDiagnosis());

            md.diagnosisInfo = TestDiagnosisInfo.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral);
            md.compDiagnosis = TestDiagnosisInfo.BuildTestComplicationDiagnosisInfoFromDataBaseData(idReferral);
            tdi.Add(md);
            return((tdi.Count != 0) ? tdi : null);
        }
Example #7
0
 public TestMainDiagnosis(MainDiagnosis r)
 {
     diagnos = r;
     diagnosisInfo = new TestDiagnosisInfo(diagnos.DiagnosisInfo);
     if ((diagnos.ComplicationDiagnosis != null) && (diagnos.ComplicationDiagnosis.Length != 0))
     {
         compDiagnosis = new List<TestDiagnosisInfo>();
         foreach (DiagnosisInfo i in diagnos.ComplicationDiagnosis)
             compDiagnosis.Add(new TestDiagnosisInfo(i));
     }
 }
Example #8
0
 public TestMainDiagnosis(MainDiagnosis r)
 {
     diagnos       = r;
     diagnosisInfo = new TestDiagnosisInfo(diagnos.DiagnosisInfo);
     if ((diagnos.ComplicationDiagnosis != null) && (diagnos.ComplicationDiagnosis.Length != 0))
     {
         compDiagnosis = new List <TestDiagnosisInfo>();
         foreach (DiagnosisInfo i in diagnos.ComplicationDiagnosis)
         {
             compDiagnosis.Add(new TestDiagnosisInfo(i));
         }
     }
 }
Example #9
0
 private void FindMismatch(TestDiagnosisInfo r)
 {
     if (this.diagnosisInfo.Comment != r.diagnosisInfo.Comment)
     {
         Global.errors3.Add("Несовпадение Comment TestDiagnosisInfo");
     }
     if (this.diagnosisInfo.DiagnosedDate != r.diagnosisInfo.DiagnosedDate)
     {
         Global.errors3.Add("Несовпадение DiagnosedDate TestDiagnosisInfo");
     }
     if (Global.GetLength(this.diagnosisType) != Global.GetLength(r.diagnosisType))
     {
         Global.errors3.Add("Несовпадение длины diagnosisInfo TestDiagnosisInfo");
     }
     if (Global.GetLength(this.mkbCode) != Global.GetLength(r.mkbCode))
     {
         Global.errors3.Add("Несовпадение длины ComplicationDiagnosis TestDiagnosisInfo");
     }
 }
Example #10
0
 static public TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral, string idLpu)
 {
     if (idLpu != "")
     {
         using (NpgsqlConnection connection = Global.GetSqlConnection())
         {
             string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral +
                                    "' AND id_diagnosis_container = '" + complication + "' AND id_lpu = '" +
                                    idLpu + "'";
             NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
             using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
             {
                 while (diagnosisReader.Read())
                 {
                     DiagnosisInfo diag = new DiagnosisInfo();
                     if (diagnosisReader["comment"] != DBNull.Value)
                     {
                         diag.Comment = Convert.ToString(diagnosisReader["comment"]);
                     }
                     if (diagnosisReader["diagnosis_date"] != DBNull.Value)
                     {
                         diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
                     }
                     TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
                     if (diagnosisReader["id_diagnosis_status"] != DBNull.Value)
                     {
                         tDiag.diagnosisType =
                             TestCoding.BuildCodingFromDataBaseData(
                                 diagnosisReader["id_diagnosis_status"].ToString());
                     }
                     if (diagnosisReader["id_mkb_code"] != DBNull.Value)
                     {
                         tDiag.mkbCode =
                             TestCoding.BuildCodingFromDataBaseData(
                                 Convert.ToString(diagnosisReader["id_mkb_code"]));
                     }
                     return(tDiag);
                 }
             }
         }
     }
     return(null);
 }
Example #11
0
 public static TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral, string idLpu)
 {
     if (idLpu != "")
     {
         using (NpgsqlConnection connection = Global.GetSqlConnection())
         {
             string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral +
                                    "' AND id_diagnosis_container = '" + complication + "' AND id_lpu = '" +
                                    idLpu + "'";
             NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
             using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
             {
                 while (diagnosisReader.Read())
                 {
                     DiagnosisInfo diag = new DiagnosisInfo();
                     if (diagnosisReader["comment"] != DBNull.Value)
                         diag.Comment = Convert.ToString(diagnosisReader["comment"]);
                     if (diagnosisReader["diagnosis_date"] != DBNull.Value)
                         diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
                     TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
                     if (diagnosisReader["id_diagnosis_status"] != DBNull.Value)
                         tDiag.diagnosisType =
                             TestCoding.BuildCodingFromDataBaseData(
                                 diagnosisReader["id_diagnosis_status"].ToString());
                     if (diagnosisReader["id_mkb_code"] != DBNull.Value)
                         tDiag.mkbCode =
                             TestCoding.BuildCodingFromDataBaseData(
                                 Convert.ToString(diagnosisReader["id_mkb_code"]));
                     return tDiag;
                 }
             }
         }
     }
     return null;
 }
Example #12
0
 private void FindMismatch(TestDiagnosisInfo r)
 {
     if (this.diagnosisInfo.Comment != r.diagnosisInfo.Comment)
         Global.errors3.Add("Несовпадение Comment TestDiagnosisInfo");
     if (this.diagnosisInfo.DiagnosedDate != r.diagnosisInfo.DiagnosedDate)
         Global.errors3.Add("Несовпадение DiagnosedDate TestDiagnosisInfo");
     if (Global.GetLength(this.diagnosisType) != Global.GetLength(r.diagnosisType))
         Global.errors3.Add("Несовпадение длины diagnosisInfo TestDiagnosisInfo");
     if (Global.GetLength(this.mkbCode) != Global.GetLength(r.mkbCode))
         Global.errors3.Add("Несовпадение длины ComplicationDiagnosis TestDiagnosisInfo");
 }