//public ReferralTupleDto[] GetReferralList(string guid, string idLpu, byte idReferralType, DateTime startDate, DateTime endDate) //{ // List<TestReferralTuple> list = new List<TestReferralTuple>(); // var a = client.GetReferralList(guid, idLpu, idReferralType, startDate, endDate); // if (a != null) // { // foreach (var i in a) // { // list.Add(new TestReferralTuple(i)); // } // } // Global.IsEqual(a, TestReferralTuple.BuildTestReferralTuple(idReferralType, startDate, endDate)); // return a; //} public void CancelCase(string guid, string idLpu, string idPatientMis, string idCaseMis) { try { client.CancelCase(guid, idLpu, idPatientMis, idCaseMis); TestCaseBase cb = TestCaseBase.BuildBaseCaseFromDataBaseData(guid, idLpu, idCaseMis, TestPerson.GetPersonId(guid, idLpu, idPatientMis)); if (!cb.isCanceld) { Global.errors1.Add("Случай не был отменён"); } } 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 TestAmbStep BuildAmbTestStepsFromDataBase(string guid, string patientMis, string idLpu, string caseMis, string stepMis) { string patientId = TestPerson.GetPersonId(guid, idLpu, patientMis); if (patientId != null) { string caseId = TestCaseBase.GetCaseId(guid, idLpu, caseMis, patientId); return(BuildAmbTestStepsFromDataBase(caseId, idLpu).Last(st => st.step.step.IdStepMis == stepMis)); } return(null); }
public override bool Equals(Object obj) { TestCaseBase p = obj as TestCaseBase; if ((object)p == null) { return(false); } if ((Global.IsEqual(this.doctorInCharge, p.doctorInCharge)) && (this.caseBase.CloseDate == p.caseBase.CloseDate) && (Global.IsEqual(this.guardian, p.guardian)) && (Global.IsEqual(this.patient, p.patient)) && (Global.IsEqual(this.authenticator, p.authenticator)) && (Global.IsEqual(this.autor, p.autor)) && (Global.IsEqual(this.legalAuthenticator, p.legalAuthenticator)) && (this.caseBase.Comment == p.caseBase.Comment) && (this.caseBase.Confidentiality == p.caseBase.Confidentiality) && (this.caseBase.CuratorConfidentiality == p.caseBase.CuratorConfidentiality) && (this.caseBase.DoctorConfidentiality == p.caseBase.DoctorConfidentiality) && (this.caseBase.HistoryNumber == p.caseBase.HistoryNumber) && (this.caseBase.IdCaseAidType == p.caseBase.IdCaseAidType) && //(this.caseBase.IdPatientMIS == p.caseBase.IdPatientMIS) && (this.caseBase.IdCaseMis == p.caseBase.IdCaseMis) && (this.caseBase.IdCaseResult == p.caseBase.IdCaseResult) && (this.caseBase.IdLpu == p.caseBase.IdLpu) && (this.caseBase.IdPaymentType == p.caseBase.IdPaymentType) && (this.caseBase.OpenDate == p.caseBase.OpenDate)) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestCaseBase"); return(false); } }
private void FindMismatch(TestCaseBase cb) { if (this.caseBase.CloseDate != cb.caseBase.CloseDate) { Global.errors3.Add("несовпадение CloseDate TestCaseBase"); } if (this.caseBase.Comment != cb.caseBase.Comment) { Global.errors3.Add("несовпадение Comment TestCaseBase"); } if (this.caseBase.Confidentiality != cb.caseBase.Confidentiality) { Global.errors3.Add("несовпадение Confidentiality TestCaseBase"); } if (this.caseBase.CuratorConfidentiality != cb.caseBase.CuratorConfidentiality) { Global.errors3.Add("несовпадение CuratorConfidentiality TestCaseBase"); } if (this.caseBase.DoctorConfidentiality != cb.caseBase.DoctorConfidentiality) { Global.errors3.Add("несовпадение DoctorConfidentiality TestCaseBase"); } if (this.caseBase.HistoryNumber != cb.caseBase.HistoryNumber) { Global.errors3.Add("несовпадение HistoryNumber TestCaseBase"); } if (this.caseBase.IdCaseAidType != cb.caseBase.IdCaseAidType) { Global.errors3.Add("несовпадение IdCaseAidType TestCaseBase"); } if (this.caseBase.IdCaseMis != cb.caseBase.IdCaseMis) { Global.errors3.Add("несовпадение IdCaseMis TestCaseBase"); } if (this.caseBase.IdCaseResult != cb.caseBase.IdCaseResult) { Global.errors3.Add("несовпадение IdCaseResult TestCaseBase"); } if (this.caseBase.IdLpu != cb.caseBase.IdLpu) { Global.errors3.Add("несовпадение IdLpu TestCaseBase"); } if (this.caseBase.IdPaymentType != cb.caseBase.IdPaymentType) { Global.errors3.Add("несовпадение IdPaymentType TestCaseBase"); } if (this.caseBase.OpenDate != cb.caseBase.OpenDate) { Global.errors3.Add("несовпадение OpenDate TestCaseBase"); } if (Global.GetLength(this.guardian) != Global.GetLength(cb.guardian)) { Global.errors3.Add("несовпадение длины guardian TestCaseBase"); } if (Global.GetLength(this.patient) != Global.GetLength(cb.patient)) { Global.errors3.Add("несовпадение длины patient TestCaseBase"); } if (Global.GetLength(this.autor) != Global.GetLength(cb.autor)) { Global.errors3.Add("несовпадение длины autor TestCaseBase"); } if (Global.GetLength(this.authenticator) != Global.GetLength(cb.authenticator)) { Global.errors3.Add("несовпадение длины authenticator TestCaseBase"); } if (Global.GetLength(this.legalAuthenticator) != Global.GetLength(cb.legalAuthenticator)) { Global.errors3.Add("несовпадение длины legalAuthenticator TestCaseBase"); } }
static public TestCaseBase BuildBaseCaseFromDataBaseData(string guid, string idlpu, string mis, string idPerson) { //idPerson = TestPerson.GetPersonId(guid, idlpu, idPerson); string caseId = GetCaseId(guid, idlpu, mis, idPerson); if (caseId != null) { using (SqlConnection connection = Global.GetSqlConnection()) { string IdDoctor = ""; string IdGuardian = ""; int idCaseT = 0; bool isCanceld = false; CaseBase p = new CaseBase(); string findCase = "SELECT TOP(1) * FROM \"Case\" WHERE IdCase = '" + caseId + "'"; SqlCommand caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { if (caseReader["CloseDate"].ToString() != "") { p.CloseDate = Convert.ToDateTime(caseReader["CloseDate"]); } else { p.CloseDate = DateTime.MinValue; } if (caseReader["Comment"].ToString() != "") { p.Comment = Convert.ToString(caseReader["Comment"]); } else { p.Comment = null; } if (caseReader["HistoryNumber"].ToString() != "") { p.HistoryNumber = Convert.ToString(caseReader["HistoryNumber"]); } else { p.HistoryNumber = null; } if (caseReader["IdCaseAidType"].ToString() != "") { p.IdCaseAidType = Convert.ToByte(caseReader["IdCaseAidType"]); } else { p.IdCaseAidType = 0; } if (caseReader["IdCaseMis"].ToString() != "") { p.IdCaseMis = Convert.ToString(caseReader["IdCaseMis"]); } else { p.IdCaseMis = null; } if (caseReader["IdCaseResult"].ToString() != "") { p.IdCaseResult = Convert.ToByte(caseReader["IdCaseResult"]); } else { p.IdCaseResult = 0; } if (caseReader["IdCasePaymentType"].ToString() != "") { p.IdPaymentType = Convert.ToByte(caseReader["IdCasePaymentType"]); } else { p.IdPaymentType = 0; } if (caseReader["OpenDate"].ToString() != "") { p.OpenDate = Convert.ToDateTime(caseReader["OpenDate"]); } else { p.OpenDate = DateTime.MinValue; } if (caseReader["IDDoctor"].ToString() != "") { IdDoctor = Convert.ToString(caseReader["IDDoctor"]); } if (caseReader["IdGuardian"].ToString() != "") { IdGuardian = Convert.ToString(caseReader["IDGuardian"]); } if (caseReader["IdCaseType"].ToString() != "") { idCaseT = Convert.ToInt32(caseReader["IdCaseType"]); } isCanceld = Convert.ToBoolean(caseReader["IsCancelled"]); } } findCase = "SELECT * FROM mm_AccessRole2Case WHERE IdCase = '" + caseId + "'"; caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { switch (caseReader["IdAccessRole"].ToString()) { case "1": p.Confidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]); break; case "2": p.DoctorConfidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]); break; case "3": p.CuratorConfidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]); break; } } } p.IdCaseMis = mis; p.IdLpu = idlpu; TestCaseBase cb = new TestCaseBase(guid, p); cb.idCaseType = idCaseT; cb.isCanceld = isCanceld; if (IdDoctor != "") { cb.doctorInCharge = TestDoctor.BuildTestDoctorFromDataBase(IdDoctor); } else { cb.doctorInCharge = null; } if (IdGuardian != "") { cb.guardian = TestGuardian.BuildTestGuardianFromDataBase(IdGuardian, idPerson); } else { cb.guardian = null; } if (idPerson != "") { cb.patient = TestPatient.BuildPatientFromDataBaseData(patientId: idPerson); } else { cb.patient = null; } findCase = "SELECT * FROM mm_Author2Case WHERE IdCase = '" + caseId + "'"; caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { switch (caseReader["IdAuthorshipType"].ToString()) { case "1": cb.autor = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 1); break; case "3": cb.authenticator = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 3); break; case "4": cb.legalAuthenticator = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 4); break; } } } return(cb); } } return(null); }
public static TestMasterCase BuildTestMasterCase(string guid, string idlpu, string patientIdmis, string mis = "") { if ((guid != string.Empty) && (idlpu != string.Empty) && (patientIdmis != string.Empty)) { string patientId = TestPerson.GetPersonId(guid, idlpu, patientIdmis); string caseId = TestCaseBase.GetCaseId(guid, idlpu, mis, patientId); if (caseId != null) { TestMasterCase mcase = new TestMasterCase(); mcase.caseBase = TestCaseBase.BuildBaseCaseFromDataBaseData(guid, idlpu, mis, patientId); List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(caseId, idlpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { mcase.defaultStep = i; } } if (!Global.IsEqual(mcase.defaultStep, null)) { mcase.records = new List <TestMedRecord>(); List <TestService> serv = TestService.BuildServiseFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(serv, null)) { mcase.records.AddRange(serv); } TestTfomsInfo forms = TestTfomsInfo.BuildTfomsInfoFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(forms, null)) { mcase.records.Add(forms); } TestDeathInfo tdi = TestDeathInfo.BuildDeathInfoFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(tdi, null)) { mcase.records.Add(tdi); } List <TestDiagnosis> td = TestDiagnosis.BuildDiagnosisFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(td, null)) { mcase.records.AddRange(td); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(acdm, null)) { mcase.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(trl, null)) { mcase.records.AddRange(trl); } List <TestSickList> tsl = TestSickList.BuildSickListFromDataBaseData(mcase.defaultStep.idStep, patientId); if (!Global.IsEqual(tsl, null)) { mcase.records.AddRange(tsl); } TestDischargeSummary tds = TestDischargeSummary.BuildSickListFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(tds, null)) { mcase.records.Add(tds); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(tlr, null)) { mcase.records.AddRange(tlr); } TestConsultNote tcn = TestConsultNote.BuildSickListFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(tcn, null)) { mcase.records.Add(tcn); } TestDispensaryOne d1 = TestDispensaryOne.BuildSickListFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(d1, null)) { mcase.records.Add(d1); } List <TestAppointedMedication> ap = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(ap, null)) { mcase.records.AddRange(ap); } List <TestForm027U> form = TestForm027U.BuildForm027UFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(form, null)) { mcase.records.AddRange(form); } } } return(mcase); } } return(null); }
public TestAmbCase(string guid, CaseAmb ca) { GUID = guid.ToLower(); if (ca != null) { caseAmb = ca; caseBase = new TestCaseBase(guid, ca); if (ca.Steps != null) { ambSteps = new List <TestAmbStep>(); foreach (StepAmb i in ca.Steps) { ambSteps.Add(new TestAmbStep(i, ca.IdLpu)); } } if (ca.MedRecords != null) { records = new List <TestMedRecord>(); foreach (object i in ca.MedRecords) { Service ser = i as Service; if (ser != null) { records.Add(new TestService(ser, ca.IdLpu)); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { records.Add(new TestTfomsInfo(tfi)); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(cmd, ca.IdLpu)); } if (cmd == null) { Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(diag, ca.IdLpu)); } if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestDiagnosis(diag, ca.IdLpu)); } } Referral r = i as Referral; if (r != null) { records.Add(new TestReferral(r, ca.IdLpu)); } SickList sl = i as SickList; if (sl != null) { records.Add(new TestSickList(sl, ca.IdLpu)); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { records.Add(new TestDischargeSummary(ds, ca.IdLpu)); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { records.Add(new TestLaboratoryReport(lr, ca.IdLpu)); } ConsultNote cn = i as ConsultNote; if (cn != null) { records.Add(new TestConsultNote(cn, ca.IdLpu)); } DispensaryOne d1 = i as DispensaryOne; if ((d1 != null) && (ca.IdCaseType == TestAmbCase.dispanseryId)) { records.Add(new TestDispensaryOne(d1, ca.IdLpu)); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { records.Add(new TestAppointedMedication(ap, ca.IdLpu)); } } } if ((ca.IdLpu != null) && (ca.IdPatientMis != null)) { List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(TestCaseBase.GetCaseId(guid, ca.IdLpu, ca.IdCaseMis, TestPerson.GetPersonId(guid, ca.IdLpu, ca.IdPatientMis)), ca.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { defaultStep = i; } } } } } }
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); }
public TestStatCase(string guid, CaseStat cs) { GUID = guid.ToLower(); if (cs != null) { caseStat = cs; caseBase = new TestCaseBase(guid, cs); if (cs.Steps != null) { statSteps = new List<TestStatStep>(); foreach (StepStat i in cs.Steps) { statSteps.Add(new TestStatStep(i, cs.IdLpu)); } } if (cs.MedRecords != null) { records = new List<TestMedRecord>(); foreach (object i in cs.MedRecords) { Service ser = i as Service; if (ser != null) records.Add(new TestService(ser, cs.IdLpu)); TfomsInfo tfi = i as TfomsInfo; if (tfi != null) records.Add(new TestTfomsInfo(tfi)); DeathInfo di = i as DeathInfo; if (di != null) records.Add(new TestDeathInfo(di)); ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cs.HospResult != IdDeath) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestClinicMainDiagnosis(cmd, cs.IdLpu)); AnatomopathologicalClinicMainDiagnosis acmd = i as AnatomopathologicalClinicMainDiagnosis; if ((acmd != null) && (cs.HospResult == IdDeath) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestClinicMainDiagnosis(acmd, cs.IdLpu)); if ((cmd == null) && (acmd == null)) { Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestDiagnosis(diag, cs.IdLpu)); if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestClinicMainDiagnosis(diag, cs.IdLpu)); } Referral r = i as Referral; if (r != null) records.Add(new TestReferral(r, cs.IdLpu)); SickList sl = i as SickList; if (sl != null) records.Add(new TestSickList(sl, cs.IdLpu)); DischargeSummary ds = i as DischargeSummary; if (ds != null) records.Add(new TestDischargeSummary(ds, cs.IdLpu)); LaboratoryReport lr = i as LaboratoryReport; if (lr != null) records.Add(new TestLaboratoryReport(lr, cs.IdLpu)); ConsultNote cn = i as ConsultNote; if (cn != null) records.Add(new TestConsultNote(cn, cs.IdLpu)); AppointedMedication ap = i as AppointedMedication; if (ap != null) records.Add(new TestAppointedMedication(ap, cs.IdLpu)); Form027U form = i as Form027U; if (form != null) records.Add(new TestForm027U(form, cs.IdLpu)); } } if ((cs.IdLpu != null) && (cs.IdPatientMis != null)) { List<TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(TestCaseBase.GetCaseId(guid, cs.IdLpu, cs.IdCaseMis, TestPerson.GetPersonId(guid, cs.IdLpu, cs.IdPatientMis)), cs.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) defaultStep = i; } } } } }
public TestAmbCase(string guid, CaseAmb ca) { GUID = guid.ToLower(); if (ca != null) { caseAmb = ca; caseBase = new TestCaseBase(guid, ca); if (ca.Steps != null) { ambSteps = new List<TestAmbStep>(); foreach (StepAmb i in ca.Steps) { ambSteps.Add(new TestAmbStep(i, ca.IdLpu)); } } if (ca.MedRecords != null) { records = new List<TestMedRecord>(); foreach (object i in ca.MedRecords) { Service ser = i as Service; if (ser != null) records.Add(new TestService(ser, ca.IdLpu)); TfomsInfo tfi = i as TfomsInfo; if (tfi != null) records.Add(new TestTfomsInfo(tfi)); ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestClinicMainDiagnosis(cmd, ca.IdLpu)); if (cmd == null) { Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestClinicMainDiagnosis(diag, ca.IdLpu)); if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestDiagnosis(diag, ca.IdLpu)); } Referral r = i as Referral; if (r != null) records.Add(new TestReferral(r, ca.IdLpu)); SickList sl = i as SickList; if (sl != null) records.Add(new TestSickList(sl, ca.IdLpu)); DischargeSummary ds = i as DischargeSummary; if (ds != null) records.Add(new TestDischargeSummary(ds, ca.IdLpu)); LaboratoryReport lr = i as LaboratoryReport; if (lr != null) records.Add(new TestLaboratoryReport(lr, ca.IdLpu)); ConsultNote cn = i as ConsultNote; if (cn != null) records.Add(new TestConsultNote(cn, ca.IdLpu)); DispensaryOne d1 = i as DispensaryOne; if ((d1 != null) && (ca.IdCaseType == TestAmbCase.dispanseryId)) records.Add(new TestDispensaryOne(d1, ca.IdLpu)); AppointedMedication ap = i as AppointedMedication; if (ap != null) records.Add(new TestAppointedMedication(ap, ca.IdLpu)); } } if ((ca.IdLpu != null) && (ca.IdPatientMis != null)) { List<TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(TestCaseBase.GetCaseId(guid, ca.IdLpu, ca.IdCaseMis, TestPerson.GetPersonId(guid, ca.IdLpu, ca.IdPatientMis)), ca.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) defaultStep = i; } } } } }
public static TestCaseBase BuildBaseCaseFromDataBaseData(string guid, string idlpu, string mis, string idPerson) { //idPerson = TestPerson.GetPersonId(guid, idlpu, idPerson); string caseId = GetCaseId(guid, idlpu, mis, idPerson); if (caseId != null) { using (SqlConnection connection = Global.GetSqlConnection()) { string IdDoctor = ""; string IdGuardian = ""; int idCaseT = 0; bool isCanceld = false; CaseBase p = new CaseBase(); string findCase = "SELECT TOP(1) * FROM \"Case\" WHERE IdCase = '" + caseId + "'"; SqlCommand caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { if (caseReader["CloseDate"].ToString() != "") p.CloseDate = Convert.ToDateTime(caseReader["CloseDate"]); else p.CloseDate = DateTime.MinValue; if (caseReader["Comment"].ToString() != "") p.Comment = Convert.ToString(caseReader["Comment"]); else p.Comment = null; if (caseReader["HistoryNumber"].ToString() != "") p.HistoryNumber = Convert.ToString(caseReader["HistoryNumber"]); else p.HistoryNumber = null; if (caseReader["IdCaseAidType"].ToString() != "") p.IdCaseAidType = Convert.ToByte(caseReader["IdCaseAidType"]); else p.IdCaseAidType = 0; if (caseReader["IdCaseMis"].ToString() != "") p.IdCaseMis = Convert.ToString(caseReader["IdCaseMis"]); else p.IdCaseMis = null; if (caseReader["IdCaseResult"].ToString() != "") p.IdCaseResult = Convert.ToByte(caseReader["IdCaseResult"]); else p.IdCaseResult = 0; if (caseReader["IdCasePaymentType"].ToString() != "") p.IdPaymentType = Convert.ToByte(caseReader["IdCasePaymentType"]); else p.IdPaymentType = 0; if (caseReader["OpenDate"].ToString() != "") p.OpenDate = Convert.ToDateTime(caseReader["OpenDate"]); else p.OpenDate = DateTime.MinValue; if (caseReader["IDDoctor"].ToString() != "") IdDoctor = Convert.ToString(caseReader["IDDoctor"]); if (caseReader["IdGuardian"].ToString() != "") IdGuardian = Convert.ToString(caseReader["IDGuardian"]); if (caseReader["IdCaseType"].ToString() != "") idCaseT = Convert.ToInt32(caseReader["IdCaseType"]); isCanceld = Convert.ToBoolean(caseReader["IsCancelled"]); } } findCase = "SELECT * FROM mm_AccessRole2Case WHERE IdCase = '" + caseId + "'"; caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { switch (caseReader["IdAccessRole"].ToString()) { case "1": p.Confidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]); break; case "2": p.DoctorConfidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]); break; case "3": p.CuratorConfidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]); break; } } } p.IdCaseMis = mis; p.IdLpu = idlpu; TestCaseBase cb = new TestCaseBase(guid, p); cb.idCaseType = idCaseT; cb.isCanceld = isCanceld; if (IdDoctor != "") cb.doctorInCharge = TestDoctor.BuildTestDoctorFromDataBase(IdDoctor); else cb.doctorInCharge = null; if (IdGuardian != "") cb.guardian = TestGuardian.BuildTestGuardianFromDataBase(IdGuardian, idPerson); else cb.guardian = null; if (idPerson != "") cb.patient = TestPatient.BuildPatientFromDataBaseData(patientId: idPerson); else cb.patient = null; findCase = "SELECT * FROM mm_Author2Case WHERE IdCase = '" + caseId + "'"; caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { switch (caseReader["IdAuthorshipType"].ToString()) { case "1": cb.autor = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 1); break; case "3": cb.authenticator = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 3); break; case "4": cb.legalAuthenticator = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 4); break; } } } return cb; } } return null; }
private void FindMismatch(TestCaseBase cb) { if (this.caseBase.CloseDate != cb.caseBase.CloseDate) Global.errors3.Add("несовпадение CloseDate TestCaseBase"); if (this.caseBase.Comment != cb.caseBase.Comment) Global.errors3.Add("несовпадение Comment TestCaseBase"); if (this.caseBase.Confidentiality != cb.caseBase.Confidentiality) Global.errors3.Add("несовпадение Confidentiality TestCaseBase"); if (this.caseBase.CuratorConfidentiality != cb.caseBase.CuratorConfidentiality) Global.errors3.Add("несовпадение CuratorConfidentiality TestCaseBase"); if (this.caseBase.DoctorConfidentiality != cb.caseBase.DoctorConfidentiality) Global.errors3.Add("несовпадение DoctorConfidentiality TestCaseBase"); if (this.caseBase.HistoryNumber != cb.caseBase.HistoryNumber) Global.errors3.Add("несовпадение HistoryNumber TestCaseBase"); if (this.caseBase.IdCaseAidType != cb.caseBase.IdCaseAidType) Global.errors3.Add("несовпадение IdCaseAidType TestCaseBase"); if (this.caseBase.IdCaseMis != cb.caseBase.IdCaseMis) Global.errors3.Add("несовпадение IdCaseMis TestCaseBase"); if (this.caseBase.IdCaseResult != cb.caseBase.IdCaseResult) Global.errors3.Add("несовпадение IdCaseResult TestCaseBase"); if (this.caseBase.IdLpu != cb.caseBase.IdLpu) Global.errors3.Add("несовпадение IdLpu TestCaseBase"); if (this.caseBase.IdPaymentType != cb.caseBase.IdPaymentType) Global.errors3.Add("несовпадение IdPaymentType TestCaseBase"); if (this.caseBase.OpenDate != cb.caseBase.OpenDate) Global.errors3.Add("несовпадение OpenDate TestCaseBase"); if (Global.GetLength(this.guardian) != Global.GetLength(cb.guardian)) Global.errors3.Add("несовпадение длины guardian TestCaseBase"); if (Global.GetLength(this.patient) != Global.GetLength(cb.patient)) Global.errors3.Add("несовпадение длины patient TestCaseBase"); if (Global.GetLength(this.autor) != Global.GetLength(cb.autor)) Global.errors3.Add("несовпадение длины autor TestCaseBase"); if (Global.GetLength(this.authenticator) != Global.GetLength(cb.authenticator)) Global.errors3.Add("несовпадение длины authenticator TestCaseBase"); if (Global.GetLength(this.legalAuthenticator) != Global.GetLength(cb.legalAuthenticator)) Global.errors3.Add("несовпадение длины legalAuthenticator TestCaseBase"); }
public TestStatCase(string guid, CaseStat cs) { GUID = guid.ToLower(); if (cs != null) { caseStat = cs; caseBase = new TestCaseBase(guid, cs); if (cs.Steps != null) { statSteps = new List <TestStatStep>(); foreach (StepStat i in cs.Steps) { statSteps.Add(new TestStatStep(i, cs.IdLpu)); } } if (cs.MedRecords != null) { records = new List <TestMedRecord>(); foreach (object i in cs.MedRecords) { Service ser = i as Service; if (ser != null) { records.Add(new TestService(ser, cs.IdLpu)); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { records.Add(new TestTfomsInfo(tfi)); } DeathInfo di = i as DeathInfo; if (di != null) { records.Add(new TestDeathInfo(di)); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cs.HospResult != IdDeath) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(cmd, cs.IdLpu)); } AnatomopathologicalClinicMainDiagnosis acmd = i as AnatomopathologicalClinicMainDiagnosis; if ((acmd != null) && (cs.HospResult == IdDeath) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(acmd, cs.IdLpu)); } if ((cmd == null) && (acmd == null)) { Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestDiagnosis(diag, cs.IdLpu)); } if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(diag, cs.IdLpu)); } } Referral r = i as Referral; if (r != null) { records.Add(new TestReferral(r, cs.IdLpu)); } SickList sl = i as SickList; if (sl != null) { records.Add(new TestSickList(sl, cs.IdLpu)); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { records.Add(new TestDischargeSummary(ds, cs.IdLpu)); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { records.Add(new TestLaboratoryReport(lr, cs.IdLpu)); } ConsultNote cn = i as ConsultNote; if (cn != null) { records.Add(new TestConsultNote(cn, cs.IdLpu)); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { records.Add(new TestAppointedMedication(ap, cs.IdLpu)); } Form027U form = i as Form027U; if (form != null) { records.Add(new TestForm027U(form, cs.IdLpu)); } } } if ((cs.IdLpu != null) && (cs.IdPatientMis != null)) { List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(TestCaseBase.GetCaseId(guid, cs.IdLpu, cs.IdCaseMis, TestPerson.GetPersonId(guid, cs.IdLpu, cs.IdPatientMis)), cs.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { defaultStep = i; } } } } } }
static public TestStatCase BuildAmbCaseFromDataBaseData(string guid, string idlpu, string mis, string patientId) { if ((guid != string.Empty) && (idlpu != string.Empty) && (mis != string.Empty)) { string caseId = TestCaseBase.GetCaseId(guid, idlpu, mis, patientId); if (caseId != null) { CaseStat ca = new CaseStat(); using (SqlConnection connection = Global.GetSqlConnection()) { string findCase = "SELECT TOP(1) * FROM HospCase WHERE IdCase = '" + caseId + "'"; SqlCommand caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { if (caseReader["DeliveredCode"].ToString() != "") { ca.DeliveryCode = Convert.ToString(caseReader["DeliveredCode"]); } if (caseReader["IdIntoxicationType"].ToString() != "") { ca.IdIntoxicationType = Convert.ToByte(caseReader["IdIntoxicationType"]); } if (caseReader["IdPatientConditionOnAdmission"].ToString() != "") { ca.IdPatientConditionOnAdmission = Convert.ToByte(caseReader["IdPatientConditionOnAdmission"]); } if (caseReader["IdTypeFromDiseaseStart"].ToString() != "") { ca.IdTypeFromDiseaseStart = Convert.ToByte(caseReader["IdTypeFromDiseaseStart"]); } if (caseReader["IdTransportIntern"].ToString() != "") { ca.IdTransportIntern = Convert.ToByte(caseReader["IdTransportIntern"]); } if (caseReader["IdHospChannel"].ToString() != "") { ca.IdHospChannel = Convert.ToByte(caseReader["IdHospChannel"]); } if (caseReader["RW1Mark"].ToString() != "") { ca.RW1Mark = Convert.ToBoolean(caseReader["RW1Mark"]); } if (caseReader["AIDSMark"].ToString() != "") { ca.AIDSMark = Convert.ToBoolean(caseReader["AIDSMark"]); } TestStatCase statcase = new TestStatCase(guid, ca); statcase.caseBase = TestCaseBase.BuildBaseCaseFromDataBaseData(guid, idlpu, mis, patientId); statcase.statSteps = TestStatStep.BuildStatStepsFromDataBase(caseId, ca.IdLpu); List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(caseId, ca.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { statcase.defaultStep = i; } } if (!Global.IsEqual(statcase.defaultStep, null)) { statcase.records = new List <TestMedRecord>(); List <TestService> serv = TestService.BuildServiseFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(serv, null)) { statcase.records.AddRange(serv); } TestTfomsInfo forms = TestTfomsInfo.BuildTfomsInfoFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(forms, null)) { statcase.records.Add(forms); } TestDeathInfo tdi = TestDeathInfo.BuildDeathInfoFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(tdi, null)) { statcase.records.Add(tdi); } List <TestDiagnosis> td = TestDiagnosis.BuildDiagnosisFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(td, null)) { statcase.records.AddRange(td); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(acdm, null)) { statcase.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(trl, null)) { statcase.records.AddRange(trl); } List <TestSickList> tsl = TestSickList.BuildSickListFromDataBaseData(statcase.defaultStep.idStep, patientId); if (!Global.IsEqual(tsl, null)) { statcase.records.AddRange(tsl); } TestDischargeSummary tds = TestDischargeSummary.BuildSickListFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(tds, null)) { statcase.records.Add(tds); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(tlr, null)) { statcase.records.AddRange(tlr); } TestConsultNote tcn = TestConsultNote.BuildSickListFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(tcn, null)) { statcase.records.Add(tcn); } List <TestAppointedMedication> ap = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(ap, null)) { statcase.records.AddRange(ap); } List <TestForm027U> form = TestForm027U.BuildForm027UFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(form, null)) { statcase.records.AddRange(form); } if (statcase.records.Count == 0) { statcase.records = null; } } } return(statcase); } } } } } return(null); }