public override bool Equals(Object obj) { TestAmbStep p = obj as TestAmbStep; if ((object)p == null) { return(false); } if (this.ambStep == p.ambStep) { return(true); } if ((this.ambStep == null) || (p.ambStep == null)) { return(false); } if ((this.ambStep.IdVisitPlace == p.ambStep.IdVisitPlace) && (this.ambStep.IdVisitPurpose == p.ambStep.IdVisitPurpose) && Global.IsEqual(this.step, p.step) && Global.IsEqual(this.medRecords, p.medRecords)) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestAmbStep"); return(false); } }
private void FindMismatch(TestAmbStep astep) { if (this.ambStep.IdVisitPlace != astep.ambStep.IdVisitPlace) { Global.errors3.Add("несовпадение IdVisitPlace TestAmbStep"); } if (this.ambStep.IdVisitPurpose != astep.ambStep.IdVisitPurpose) { Global.errors3.Add("несовпадение IdVisitPurpose TestAmbStep"); } if (Global.GetLength(this.medRecords) != Global.GetLength(astep.medRecords)) { Global.errors3.Add("несовпадение длинны medRecords TestAmbStep"); } if (Global.GetLength(this.step) != Global.GetLength(astep.step)) { Global.errors3.Add("несовпадение длинны step TestAmbStep"); } }
public void AddStepToCase(string guid, string idLpu, string idPatientMis, string idCaseMis, StepBase s) { try { StepAmb sa = s as StepAmb; if ((object)sa != null) { client.AddStepToCase(guid, idLpu, idPatientMis, idCaseMis, s); TestAmbStep example = new TestAmbStep(sa, idLpu); if (!example.CheckStepInDataBase(guid, idPatientMis, idLpu, idCaseMis)) { Global.errors1.AddRange(Global.errors2); } } StepStat ss = s as StepStat; if ((object)ss != null) { client.AddStepToCase(guid, idLpu, idPatientMis, idCaseMis, s); TestStatStep example = new TestStatStep(ss, idLpu); if (!example.CheckStepInDataBase(guid, idPatientMis, idLpu, idCaseMis)) { Global.errors1.AddRange(Global.errors2); } } } catch (System.ServiceModel.FaultException <List <PixServiseTests.EMKServise.RequestFault> > e) { getErrors(e.Detail); } catch (System.ServiceModel.FaultException <PixServiseTests.EMKServise.RequestFault[]> e) { getErrors(e.Detail); } catch (System.ServiceModel.FaultException <PixServiseTests.EMKServise.RequestFault> e) { Global.errors1.Add(e.Detail.PropertyName + " - " + e.Detail.Message); getErrors(e.Detail.Errors); } }
public void AddStepToCase(string guid, string idLpu, string idPatientMis, string idCaseMis, StepBase s) { try { StepAmb sa = s as StepAmb; if ((object)sa != null) { client.AddStepToCase(guid, idLpu, idPatientMis, idCaseMis ,s); TestAmbStep example = new TestAmbStep(sa, idLpu); if (!example.CheckStepInDataBase(guid, idPatientMis, idLpu, idCaseMis)) { Global.errors1.AddRange(Global.errors2); } } StepStat ss = s as StepStat; if ((object)ss != null) { client.AddStepToCase(guid, idLpu, idPatientMis, idCaseMis, s); TestStatStep example = new TestStatStep(ss, idLpu); if (!example.CheckStepInDataBase(guid, idPatientMis, idLpu, idCaseMis)) Global.errors1.AddRange(Global.errors2); } } catch (System.ServiceModel.FaultException<List<PixServiseTests.EMKServise.RequestFault>> e) { getErrors(e.Detail); } catch (System.ServiceModel.FaultException<PixServiseTests.EMKServise.RequestFault[]> e) { getErrors(e.Detail); } catch (System.ServiceModel.FaultException<PixServiseTests.EMKServise.RequestFault> e) { Global.errors1.Add(e.Detail.PropertyName + " - " + e.Detail.Message); getErrors(e.Detail.Errors); } }
static public TestAmbCase BuildAmbCaseFromDataBaseData(string guid, string idlpu, string mis, string patientId) { if ((guid != string.Empty) && (idlpu != string.Empty) && (mis != string.Empty) && (patientId != string.Empty)) { string caseId = TestCaseBase.GetCaseId(guid, idlpu, mis, patientId); if (caseId != null) { CaseAmb ca = new CaseAmb(); using (SqlConnection connection = Global.GetSqlConnection()) { string findCase = "SELECT TOP(1) * FROM AmbCase WHERE IdCase = '" + caseId + "'"; SqlCommand caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { if (caseReader["IdCasePurpose"].ToString() != "") { ca.IdCasePurpose = Convert.ToByte(caseReader["IdCasePurpose"]); } if (caseReader["IdAmbResult"].ToString() != "") { ca.IdAmbResult = Convert.ToByte(caseReader["IdAmbResult"]); } if (caseReader["IsActive"].ToString() != "") { ca.IsActive = Convert.ToBoolean(caseReader["IsActive"]); } TestAmbCase ambcase = new TestAmbCase(guid, ca); ambcase.caseBase = TestCaseBase.BuildBaseCaseFromDataBaseData(guid, idlpu, mis, patientId); ambcase.ambSteps = TestAmbStep.BuildAmbTestStepsFromDataBase(caseId, ca.IdLpu); List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(caseId, ca.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.step.IdStepMis, null)) { ambcase.defaultStep = i; } } if (!Global.IsEqual(ambcase.defaultStep, null)) { ambcase.records = new List <TestMedRecord>(); List <TestService> ser = TestService.BuildServiseFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(ser, null)) { ambcase.records.AddRange(ser); } TestTfomsInfo forms = TestTfomsInfo.BuildTfomsInfoFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(forms, null)) { ambcase.records.Add(forms); } TestDeathInfo tdi = TestDeathInfo.BuildDeathInfoFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(tdi, null)) { ambcase.records.Add(tdi); } List <TestDiagnosis> td = TestDiagnosis.BuildDiagnosisFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(td, null)) { ambcase.records.AddRange(td); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(acdm, null)) { ambcase.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(trl, null)) { ambcase.records.AddRange(trl); } List <TestSickList> tsl = TestSickList.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep, patientId); if (!Global.IsEqual(tsl, null)) { ambcase.records.AddRange(tsl); } TestDischargeSummary tds = TestDischargeSummary.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(tds, null)) { ambcase.records.Add(tds); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(tlr, null)) { ambcase.records.AddRange(tlr); } TestConsultNote tcn = TestConsultNote.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(tcn, null)) { ambcase.records.Add(tcn); } TestDispensaryOne d1 = TestDispensaryOne.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(d1, null)) { ambcase.records.Add(d1); } List <TestAppointedMedication> ap = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(ap, null)) { ambcase.records.AddRange(ap); } if (ambcase.records.Count == 0) { ambcase.records = null; } } } return(ambcase); } } } } } return(null); }
static public List <TestAmbStep> BuildAmbTestStepsFromDataBase(string idCase, string caseLpu) { List <TestAmbStep> ambSteps = new List <TestAmbStep>(); if (idCase != string.Empty) { List <TestStepBase> steps = TestStepBase.BuildTestStepsFromDataBase(idCase, caseLpu); using (SqlConnection connection = Global.GetSqlConnection()) { foreach (TestStepBase i in steps) { string findSteps = "SELECT * FROM AmbStep WHERE IdStep = '" + i.idStep + "'"; SqlCommand stepsCommand = new SqlCommand(findSteps, connection); using (SqlDataReader stepsReader = stepsCommand.ExecuteReader()) { while (stepsReader.Read()) { StepAmb sa = new StepAmb(); if (stepsReader["IdVisitPlace"].ToString() != "") { sa.IdVisitPlace = Convert.ToByte(stepsReader["IdVisitPlace"]); } else { sa.IdVisitPlace = 0; } if (stepsReader["IdVisitPurpose"].ToString() != "") { sa.IdVisitPurpose = Convert.ToByte(stepsReader["IdVisitPurpose"]); } else { sa.IdVisitPurpose = 0; } TestAmbStep st = new TestAmbStep(sa, caseLpu); st.step = i; st.records = new List <TestMedRecord>(); List <TestService> s = TestService.BuildServiseFromDataBaseData(i.idStep); if (!Global.IsEqual(s, null)) { st.records.AddRange(s); } List <TestAppointedMedication> am = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(i.idStep); if (!Global.IsEqual(am, null)) { st.records.AddRange(am); } List <TestDiagnosis> diag = TestDiagnosis.BuildDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(diag, null)) { st.records.AddRange(diag); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(acdm, null)) { st.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(i.idStep); if (!Global.IsEqual(trl, null)) { st.records.AddRange(trl); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(i.idStep); if (!Global.IsEqual(tlr, null)) { st.records.AddRange(tlr); } if (st.records.Count == 0) { st.records = null; } ambSteps.Add(st); } } } } } if (ambSteps.Count != 0) { return(ambSteps); } else { return(null); } }
public bool CheckStepInDataBase(string guid, string patientMis, string idLpu, string caseMis) { TestAmbStep tas = TestAmbStep.BuildAmbTestStepsFromDataBase(guid, patientMis, idLpu, caseMis, this.step.step.IdStepMis); return(this == tas); }
public static List<TestAmbStep> BuildAmbTestStepsFromDataBase(string idCase, string caseLpu) { List<TestAmbStep> ambSteps = new List<TestAmbStep>(); if (idCase != string.Empty) { List<TestStepBase> steps = TestStepBase.BuildTestStepsFromDataBase(idCase, caseLpu); using (SqlConnection connection = Global.GetSqlConnection()) { foreach (TestStepBase i in steps) { string findSteps = "SELECT * FROM AmbStep WHERE IdStep = '" + i.idStep + "'"; SqlCommand stepsCommand = new SqlCommand(findSteps, connection); using (SqlDataReader stepsReader = stepsCommand.ExecuteReader()) { while (stepsReader.Read()) { StepAmb sa = new StepAmb(); if (stepsReader["IdVisitPlace"].ToString() != "") sa.IdVisitPlace = Convert.ToByte(stepsReader["IdVisitPlace"]); else sa.IdVisitPlace = 0; if (stepsReader["IdVisitPurpose"].ToString() != "") sa.IdVisitPurpose = Convert.ToByte(stepsReader["IdVisitPurpose"]); else sa.IdVisitPurpose = 0; TestAmbStep st = new TestAmbStep(sa, caseLpu); st.step = i; st.records = new List<TestMedRecord>(); List<TestService> s = TestService.BuildServiseFromDataBaseData(i.idStep); if (!Global.IsEqual(s, null)) st.records.AddRange(s); List<TestAppointedMedication> am = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(i.idStep); if (!Global.IsEqual(am, null)) st.records.AddRange(am); List<TestDiagnosis> diag = TestDiagnosis.BuildDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(diag, null)) st.records.AddRange(diag); TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(acdm, null)) st.records.Add(acdm); List<TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(i.idStep); if (!Global.IsEqual(trl, null)) st.records.AddRange(trl); List<TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(i.idStep); if (!Global.IsEqual(tlr, null)) st.records.AddRange(tlr); if (st.records.Count == 0) st.records = null; ambSteps.Add(st); } } } } } if (ambSteps.Count != 0) return ambSteps; else return null; }
private void FindMismatch(TestAmbStep astep) { if (this.ambStep.IdVisitPlace != astep.ambStep.IdVisitPlace) Global.errors3.Add("несовпадение IdVisitPlace TestAmbStep"); if (this.ambStep.IdVisitPurpose != astep.ambStep.IdVisitPurpose) Global.errors3.Add("несовпадение IdVisitPurpose TestAmbStep"); if (Global.GetLength(this.medRecords) != Global.GetLength(astep.medRecords)) Global.errors3.Add("несовпадение длинны medRecords TestAmbStep"); if (Global.GetLength(this.step) != Global.GetLength(astep.step)) Global.errors3.Add("несовпадение длинны step TestAmbStep"); }