public override bool Equals(Object obj) { TestReferralTarget p = obj as TestReferralTarget; if ((object)p == null) { return(false); } if (this.target == p.target) { return(true); } if ((this.target == null) || (p.target == null)) { return(false); } if ((this.target.IdCaseMis == p.target.IdCaseMis) && (this.target.IsReferralReviewed == p.target.IsReferralReviewed) && (this.target.ReceptionAppointComment == p.target.ReceptionAppointComment) && (this.target.ReceptionAppointDate == p.target.ReceptionAppointDate) && (this.target.ReceptionAppointTime == p.target.ReceptionAppointTime) && (this.target.ReferralReviewDate == p.target.ReferralReviewDate) && (Global.IsEqual(this.lpu, p.lpu)) && (Global.IsEqual(this.mainDiagnosis, p.mainDiagnosis)) && (Global.IsEqual(this.doctors, p.doctors))) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestReferralTarget"); return(false); } }
static public TestReferral BuildReferralFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findR = "SELECT * FROM public.referral WHERE id_referral = '" + idReferral + "'"; // string findR = "select id_patient_person from public.referral"; NpgsqlCommand Rcommand = new NpgsqlCommand(findR, connection); using (NpgsqlDataReader RReader = Rcommand.ExecuteReader()) { while (RReader.Read()) { TestReferral r = new TestReferral(); r.evInfo = TestEventsInfo.BuildAdditionalFromDataBaseData(idReferral); if (RReader["id_patient_person"] != DBNull.Value) { r.patient = TestPatient.BuildPatientFromDataBaseData(RReader["id_patient_person"].ToString(), RReader["id_patient_source_mo_mis"].ToString()); } r.refInfo = TestReferralInfo.BuildPersonFromDataBaseData(idReferral); r.refSourse = TestReferralSource.BuildSourceFromDataBaseData(idReferral); r.refSurvey = TestReferralSurvey.BuildAdditionalFromDataBaseData(idReferral); r.refTarget = TestReferralTarget.BuildTargetFromDataBaseData(idReferral); return(r); } } } return(null); }
public TestReferral(Referral r, string idLpu = "") { evInfo = new TestEventsInfo(r.EventsInfo); patient = new TestPatient(r.Patient); refInfo = new TestReferralInfo(r.ReferralInfo); refSurvey = new TestReferralSurvey(r.ReferralSurvey); refSourse = new TestReferralSource(r.Source); refTarget = new TestReferralTarget(r.Target); }
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); }
static public TestReferralTarget BuildTargetFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_target_lpu_case_mis, is_referral_review_target_mo, reception_appoint_additional_comment, reception_appoint_time_comment, referral_review_date_target_mo, id_target_lpu, reception_appoint_date 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()) { ReferralTarget p = new ReferralTarget(); while (personFromDataBase.Read()) { //что делать с DateSpecified и Мисами? if (personFromDataBase["id_target_lpu_case_mis"] != DBNull.Value) { p.IdCaseMis = Convert.ToString(personFromDataBase["id_source_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); if (personFromDataBase["id_target_lpu"] != DBNull.Value) { pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_target_lpu"])); } return(pers); } } } return(null); }
private void FindMismatch(TestReferralTarget r) { if (this.target.IdCaseMis != r.target.IdCaseMis) { Global.errors3.Add("Несовпадение IdCaseMis TestReferralTarget"); } if (this.target.IsReferralReviewed != r.target.IsReferralReviewed) { Global.errors3.Add("Несовпадение IsReferralReviewed TestReferralTarget"); } if (this.target.ReceptionAppointComment != r.target.ReceptionAppointComment) { Global.errors3.Add("Несовпадение ReceptionAppointComment TestReferralTarget"); } if (this.target.ReceptionAppointDate != r.target.ReceptionAppointDate) { Global.errors3.Add("Несовпадение ReceptionAppointDate TestReferralTarget"); } if (this.target.ReceptionAppointTime != r.target.ReceptionAppointTime) { Global.errors3.Add("Несовпадение ReceptionAppointTime TestReferralTarget"); } if (this.target.ReferralReviewDate != r.target.ReferralReviewDate) { Global.errors3.Add("Несовпадение ReferralReviewDate TestReferralTarget"); } if (Global.GetLength(this.doctors) != Global.GetLength(r.doctors)) { Global.errors3.Add("Несовпадение длинны documents TestReferralTarget"); } if (Global.GetLength(this.mainDiagnosis) != Global.GetLength(r.mainDiagnosis)) { Global.errors3.Add("Несовпадение длинны mainDiagnosis TestReferralTarget"); } if (Global.GetLength(this.lpu) != Global.GetLength(r.lpu)) { Global.errors3.Add("Несовпадение длинны lpu TestReferralTarget"); } }