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");
}
}
