public override bool Equals(Object obj) { TestMainDiagnosis p = obj as TestMainDiagnosis; if ((object)p == null) { return(false); } if (this.diagnos == p.diagnos) { return(true); } if ((this.diagnos == null) || (p.diagnos == null)) { return(false); } if ((Global.IsEqual(this.diagnosisInfo, p.diagnosisInfo)) && (Global.IsEqual(this.ComplicationDiagnosis, p.ComplicationDiagnosis))) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestMainDiagnosis"); return(false); } }
static public TestReferralSource BuildSourceFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_source_lpu_case_mis, id_referral_source_mo_mis, id_source_lpu FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY id_referral DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { ReferralSource p = new ReferralSource(); while (personFromDataBase.Read()) { if (personFromDataBase["id_source_lpu_case_mis"] != DBNull.Value) { p.IdCaseMis = Convert.ToString(personFromDataBase["id_source_lpu_case_mis"]); } if (personFromDataBase["id_referral_source_mo_mis"] != DBNull.Value) { p.IdReferralMis = Convert.ToString(personFromDataBase["id_referral_source_mo_mis"]); } TestReferralSource pers = new TestReferralSource(p); pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_source_lpu"])); pers.docs = TestDoctor.BuildDoctorFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"])); pers.diag = TestMainDiagnosis.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"])); return(pers); } } } return(new TestReferralSource(null)); }
public static 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; }
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); }
private void FindMismatch(TestMainDiagnosis r) { if (Global.GetLength(this.diagnosisInfo) != Global.GetLength(r.diagnosisInfo)) { Global.errors3.Add("Несовпадение длины diagnosisInfo TestMainDiagnosis"); } if (Global.GetLength(this.ComplicationDiagnosis) != Global.GetLength(r.ComplicationDiagnosis)) { Global.errors3.Add("Несовпадение длины ComplicationDiagnosis TestMainDiagnosis"); } }
static public TestReferralTarget BuildTargetFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_target_lpu, is_referral_review_target_mo, referral_review_date_target_mo, reception_appoint_date, reception_appoint_time_comment, reception_appoint_additional_comment, id_target_lpu_case_mis FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY record_created DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { ReferralTarget p = new ReferralTarget(); while (personFromDataBase.Read()) { //зачем тут диагнозы и доктора и ReferralReviewDate и IsReferralReviewed? if (personFromDataBase["id_target_lpu_case_mis"] != DBNull.Value) { p.IdCaseMis = Convert.ToString(personFromDataBase["id_target_lpu_case_mis"]); } if (personFromDataBase["is_referral_review_target_mo"] != DBNull.Value) { p.IsReferralReviewed = Convert.ToBoolean(personFromDataBase["is_referral_review_target_mo"]); } if (personFromDataBase["reception_appoint_additional_comment"] != DBNull.Value) { p.ReceptionAppointComment = Convert.ToString(personFromDataBase["reception_appoint_additional_comment"]); } if (personFromDataBase["reception_appoint_time_comment"] != DBNull.Value) { p.ReceptionAppointTime = Convert.ToString(personFromDataBase["reception_appoint_time_comment"]); } if (personFromDataBase["reception_appoint_date"] != DBNull.Value) { p.ReceptionAppointDate = Convert.ToDateTime(personFromDataBase["reception_appoint_date"]); } if (personFromDataBase["referral_review_date_target_mo"] != DBNull.Value) { p.ReferralReviewDate = Convert.ToDateTime(personFromDataBase["referral_review_date_target_mo"]); } TestReferralTarget pers = new TestReferralTarget(p); pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_target_lpu"])); pers.docs = TestDoctor.BuildDoctorFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_target_lpu"])); pers.diag = TestMainDiagnosis.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_target_lpu"])); return(pers); } } } return(null); }
private void FindMismatch(TestMainDiagnosis r) { if (Global.GetLength(this.diagnosisInfo) != Global.GetLength(r.diagnosisInfo)) Global.errors3.Add("Несовпадение длины diagnosisInfo TestMainDiagnosis"); if (Global.GetLength(this.ComplicationDiagnosis) != Global.GetLength(r.ComplicationDiagnosis)) Global.errors3.Add("Несовпадение длины ComplicationDiagnosis TestMainDiagnosis"); }