public override bool Equals(Object obj) { TestDiagnosis p = obj as TestDiagnosis; if ((object)p == null) { return(false); } if ((this.info == p.info) && (Global.IsEqual(this.doctor, p.doctor))) { return(true); } if ((this.info == null) || (p.info == null)) { return(false); } if (Global.IsEqual(this.info, p.info) && Global.IsEqual(this.doctor, p.doctor)) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestDiagnosis"); return(false); } }
public static List<TestDiagnosis> BuildDiagnosisFromDataBaseDate(string IdStep, string IdParentDiagnosis = "") { List<TestDiagnosis> tdList = new List<TestDiagnosis>(); if (IdStep != "") { using (SqlConnection connection = Global.GetSqlConnection()) { string findTD = ""; if (IdParentDiagnosis == "") findTD = "SELECT * FROM Diagnosis WHERE IdStep = '" + IdStep + "' AND IdDiagnosisType <> '" + IdClinicMainDiagnosis + "' AND IdParentDiagnosis IS NULL"; else findTD = "SELECT * FROM Diagnosis WHERE IdStep = '" + IdStep + "' AND IdDiagnosisType <> '" + IdClinicMainDiagnosis + "' AND IdParentDiagnosis = '" + IdParentDiagnosis + "'"; SqlCommand TDcommand = new SqlCommand(findTD, connection); using (SqlDataReader TDReader = TDcommand.ExecuteReader()) { while (TDReader.Read()) { Diagnosis d = new Diagnosis(); TestDiagnosis td = new TestDiagnosis(d); td.info = TestDiagnosisInfo.BuildDiagnosisFromDataBaseDate(TDReader["IdDiagnosis"].ToString()); if (TDReader["IdDiagnosedDoctor"].ToString() != "") td.doctor = TestDoctor.BuildTestDoctorFromDataBase(TDReader["IdDiagnosedDoctor"].ToString()); tdList.Add(td); } } } } if (tdList.Count != 0) return tdList; else return null; }
static public TestClinicMainDiagnosis BuildTestClinicMainDiagnosisFromDataBaseDate(string idStep) { using (SqlConnection connection = Global.GetSqlConnection()) { string findTD = "SELECT TOP(1) * FROM Diagnosis WHERE IdDiagnosis = (SELECT MAX(IdDiagnosis) FROM Diagnosis WHERE IdStep = '" + idStep + "' AND IdDiagnosisType = '" + TestDiagnosis.IdClinicMainDiagnosis + "' AND IdParentDiagnosis is NULL)"; SqlCommand TDcommand = new SqlCommand(findTD, connection); using (SqlDataReader TDReader = TDcommand.ExecuteReader()) { while (TDReader.Read()) { if (TDReader["IdParentDiagnosis"].ToString() == "") { ClinicMainDiagnosis d = new ClinicMainDiagnosis(); TestClinicMainDiagnosis td = new TestClinicMainDiagnosis(d); td._diagnosis = TestDiagnosis.BuildDiagnosisFromDataBaseDate(idStep, TDReader["IdDiagnosis"].ToString()); td.diagnosInfo = TestDiagnosisInfo.BuildDiagnosisFromDataBaseDate(TDReader["IdDiagnosis"].ToString()); if (TDReader["IdDiagnosedDoctor"].ToString() != "") { td.doctor = TestDoctor.BuildTestDoctorFromDataBase(TDReader["IdDiagnosedDoctor"].ToString()); } return(td); } } } } return(null); }
private void FindMismatch(TestDiagnosis t) { if (Global.GetLength(this.doctor) != Global.GetLength(t.doctor)) { Global.errors3.Add("Несовпадение длины doctor TestDiagnosis"); } if (Global.GetLength(this.info) != Global.GetLength(t.info)) { Global.errors3.Add("Несовпадение длины info TestDiagnosis"); } }
static public List <TestDiagnosis> BuildDiagnosisFromDataBaseDate(string IdStep, string IdParentDiagnosis = "") { List <TestDiagnosis> tdList = new List <TestDiagnosis>(); if (IdStep != "") { using (SqlConnection connection = Global.GetSqlConnection()) { string findTD = ""; if (IdParentDiagnosis == "") { findTD = "SELECT * FROM Diagnosis WHERE IdStep = '" + IdStep + "' AND IdDiagnosisType <> '" + IdClinicMainDiagnosis + "' AND IdParentDiagnosis IS NULL"; } else { findTD = "SELECT * FROM Diagnosis WHERE IdStep = '" + IdStep + "' AND IdDiagnosisType <> '" + IdClinicMainDiagnosis + "' AND IdParentDiagnosis = '" + IdParentDiagnosis + "'"; } SqlCommand TDcommand = new SqlCommand(findTD, connection); using (SqlDataReader TDReader = TDcommand.ExecuteReader()) { while (TDReader.Read()) { Diagnosis d = new Diagnosis(); TestDiagnosis td = new TestDiagnosis(d); td.info = TestDiagnosisInfo.BuildDiagnosisFromDataBaseDate(TDReader["IdDiagnosis"].ToString()); if (TDReader["IdDiagnosedDoctor"].ToString() != "") { td.doctor = TestDoctor.BuildTestDoctorFromDataBase(TDReader["IdDiagnosedDoctor"].ToString()); } tdList.Add(td); } } } } if (tdList.Count != 0) { return(tdList); } else { return(null); } }
public bool CheckDocumentInCase(MedRecord i, string idLpu) { TestMedRecord doc = null; Service serv = i as Service; if (serv != null) doc = new TestService(serv); TfomsInfo tfi = i as TfomsInfo; if (tfi != null) doc = new TestTfomsInfo(tfi); DeathInfo di = i as DeathInfo; if (di != null) doc = new TestDeathInfo(di); Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) doc = new TestDiagnosis(diag, idLpu); ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) doc = new TestClinicMainDiagnosis(cmd, idLpu); AnatomopathologicalClinicMainDiagnosis acmd = i as AnatomopathologicalClinicMainDiagnosis; if ((acmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) doc = new TestClinicMainDiagnosis(acmd, idLpu); Referral r = i as Referral; if (r != null) doc = new TestReferral(r, idLpu); SickList sl = i as SickList; if (sl != null) doc = new TestSickList(sl, idLpu); DischargeSummary ds = i as DischargeSummary; if (ds != null) doc = new TestDischargeSummary(ds, idLpu); LaboratoryReport lr = i as LaboratoryReport; if (lr != null) doc = new TestLaboratoryReport(lr, idLpu); ConsultNote cn = i as ConsultNote; if (cn != null) doc = new TestConsultNote(cn, idLpu); DispensaryOne d1 = i as DispensaryOne; if ((d1 != null) && (caseBase.idCaseType == dispensaryId)) doc = new TestDispensaryOne(d1, idLpu); AppointedMedication ap = i as AppointedMedication; if (ap != null) doc = new TestAppointedMedication(ap, idLpu); Form027U form = i as Form027U; if (form != null) doc = new TestForm027U(form, idLpu); if (Global.IsEqual(doc, null)) { Global.errors1.Add("Документ не найден"); return true; } foreach (TestMedRecord document in this.medRecords) if (Global.IsEqual(doc, document)) return true; return false; }
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 bool CheckDocumentInCase(MedRecord i, string idLpu) { TestMedRecord doc = null; Service serv = i as Service; if (serv != null) { doc = new TestService(serv); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { doc = new TestTfomsInfo(tfi); } DeathInfo di = i as DeathInfo; if (di != null) { doc = new TestDeathInfo(di); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestDiagnosis(diag, idLpu); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestClinicMainDiagnosis(cmd, idLpu); } AnatomopathologicalClinicMainDiagnosis acmd = i as AnatomopathologicalClinicMainDiagnosis; if ((acmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestClinicMainDiagnosis(acmd, idLpu); } Referral r = i as Referral; if (r != null) { doc = new TestReferral(r, idLpu); } SickList sl = i as SickList; if (sl != null) { doc = new TestSickList(sl, idLpu); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { doc = new TestDischargeSummary(ds, idLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { doc = new TestLaboratoryReport(lr, idLpu); } ConsultNote cn = i as ConsultNote; if (cn != null) { doc = new TestConsultNote(cn, idLpu); } DispensaryOne d1 = i as DispensaryOne; if ((d1 != null) && (caseBase.idCaseType == dispensaryId)) { doc = new TestDispensaryOne(d1, idLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { doc = new TestAppointedMedication(ap, idLpu); } Form027U form = i as Form027U; if (form != null) { doc = new TestForm027U(form, idLpu); } if (Global.IsEqual(doc, null)) { Global.errors1.Add("Документ не найден"); return(true); } foreach (TestMedRecord document in this.medRecords) { if (Global.IsEqual(doc, document)) { return(true); } } return(false); }
public void ChangeUpdateAmbCase(string guid, CaseAmb ca) { GUID = guid.ToLower(); if (ca != null) { this.caseAmb.IsActive = ca.IsActive; if (ca.IdAmbResult != 0) { this.caseAmb.IdAmbResult = ca.IdAmbResult; } if (ca.IdCasePurpose != 0) { this.caseAmb.IdCasePurpose = ca.IdCasePurpose; } caseBase.UpdateCaseBase(guid, ca); if (ca.MedRecords != null) { List <TestMedRecord> newMedRecords = new List <TestMedRecord>(); TestTfomsInfo tfi = null; TestClinicMainDiagnosis cmd = null; TestDischargeSummary ds = null; TestConsultNote cn = null; TestDispensaryOne d1 = null; foreach (object i in ca.MedRecords) { Service ser = i as Service; if (ser != null) { newMedRecords.Add(new TestService(ser, ca.IdLpu)); } TfomsInfo tf = i as TfomsInfo; if (tf != null) { tfi = new TestTfomsInfo(tf); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { newMedRecords.Add(new TestDiagnosis(diag, ca.IdLpu)); } ClinicMainDiagnosis cm = i as ClinicMainDiagnosis; if ((cm != null) && (cm.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(cm, ca.IdLpu); } Referral r = i as Referral; if (r != null) { newMedRecords.Add(new TestReferral(r, ca.IdLpu)); } SickList sl = i as SickList; if (sl != null) { newMedRecords.Add(new TestSickList(sl, ca.IdLpu)); } DischargeSummary pds = i as DischargeSummary; if (pds != null) { ds = new TestDischargeSummary(pds, ca.IdLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { newMedRecords.Add(new TestLaboratoryReport(lr, ca.IdLpu)); } ConsultNote pcn = i as ConsultNote; if (pcn != null) { cn = new TestConsultNote(pcn, ca.IdLpu); } DispensaryOne d = i as DispensaryOne; if (d != null) { d1 = new TestDispensaryOne(d, ca.IdLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { newMedRecords.Add(new TestAppointedMedication(ap, ca.IdLpu)); } } if (Global.GetLength(this.medRecords) != 0) { foreach (object i in this.medRecords) { TestService ser = i as TestService; if (!Global.IsEqual(ser, null)) { newMedRecords.Add(ser); } TestTfomsInfo tf = i as TestTfomsInfo; if (!Global.IsEqual(tfi, null) && !Global.IsEqual(tf, null)) { newMedRecords.Add(tf); } else if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } TestDiagnosis diag = i as TestDiagnosis; if (!Global.IsEqual(diag, null)) { newMedRecords.Add(diag); } TestClinicMainDiagnosis cm = i as TestClinicMainDiagnosis; if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } else if (!Global.IsEqual(cm, null)) { newMedRecords.Add(cm); } TestReferral r = i as TestReferral; if (!Global.IsEqual(r, null)) { newMedRecords.Add(r); } TestSickList sl = i as TestSickList; if (!Global.IsEqual(sl, null)) { newMedRecords.Add(sl); } TestDischargeSummary pds = i as TestDischargeSummary; if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } else if (!Global.IsEqual(pds, null)) { newMedRecords.Add(pds); } TestLaboratoryReport lr = i as TestLaboratoryReport; if (!Global.IsEqual(lr, null)) { newMedRecords.Add(lr); } TestConsultNote pcn = i as TestConsultNote; if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } else if (!Global.IsEqual(pcn, null)) { newMedRecords.Add(pcn); } TestDispensaryOne d = i as TestDispensaryOne; if (!Global.IsEqual(d1, null)) { newMedRecords.Add(d1); } else if (!Global.IsEqual(d, null)) { newMedRecords.Add(d); } TestAppointedMedication ap = i as TestAppointedMedication; if (!Global.IsEqual(ap, null)) { newMedRecords.Add(ap); } } } else { if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } } this.records = newMedRecords; } } }
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); } }
static public List <TestStatStep> BuildStatStepsFromDataBase(string idCase, string caseLpu) { List <TestStatStep> statSteps = new List <TestStatStep>(); 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 HospStep WHERE IdStep = '" + i.idStep + "'"; SqlCommand stepsCommand = new SqlCommand(findSteps, connection); using (SqlDataReader stepsReader = stepsCommand.ExecuteReader()) { while (stepsReader.Read()) { StepStat sa = new StepStat(); if (stepsReader["BedNo"].ToString() != "") { sa.BedNumber = Convert.ToString(stepsReader["BedNo"]); } else { sa.BedNumber = null; } if (stepsReader["IdBedProfile"].ToString() != "") { sa.BedProfile = Convert.ToByte(stepsReader["IdBedProfile"]); } else { sa.BedProfile = 0; } if (stepsReader["DaySpend"].ToString() != "") { sa.DaySpend = Convert.ToUInt16(stepsReader["DaySpend"]); } else { sa.DaySpend = 0; } if (stepsReader["HospitalDepartment"].ToString() != "") { sa.HospitalDepartmentName = Convert.ToString(stepsReader["HospitalDepartment"]); } else { sa.HospitalDepartmentName = null; } if (stepsReader["IdHospitalDepartment"].ToString() != "") { sa.IdHospitalDepartment = Convert.ToString(stepsReader["IdHospitalDepartment"]); } else { sa.IdHospitalDepartment = null; } if (stepsReader["IdRegimenType"].ToString() != "") { sa.IdRegimen = Convert.ToByte(stepsReader["IdRegimenType"]); } else { sa.IdRegimen = 0; } if (stepsReader["WardNumber"].ToString() != "") { sa.WardNumber = Convert.ToString(stepsReader["WardNumber"]); } else { sa.WardNumber = null; } TestStatStep st = new TestStatStep(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; } statSteps.Add(st); } } } } } if (statSteps.Count != 0) { return(statSteps); } else { return(null); } }
private void FindMismatch(TestDiagnosis t) { if (Global.GetLength(this.doctor) != Global.GetLength(t.doctor)) Global.errors3.Add("Несовпадение длины doctor TestDiagnosis"); if (Global.GetLength(this.info) != Global.GetLength(t.info)) Global.errors3.Add("Несовпадение длины info TestDiagnosis"); }
public void ChangeUpdateStatCase(string guid, CaseStat cs) { GUID = guid.ToLower(); if (cs != null) { if (cs.DeliveryCode != null) { this.caseStat.DeliveryCode = cs.DeliveryCode; } if (cs.IdIntoxicationType != 0) { this.caseStat.IdIntoxicationType = cs.IdIntoxicationType; } if (cs.IdPatientConditionOnAdmission != 0) { this.caseStat.IdPatientConditionOnAdmission = cs.IdPatientConditionOnAdmission; } if (cs.IdTypeFromDiseaseStart != 0) { this.caseStat.IdTypeFromDiseaseStart = cs.IdTypeFromDiseaseStart; } if (cs.IdTransportIntern != 0) { this.caseStat.IdTransportIntern = cs.IdTransportIntern; } if (cs.IdHospChannel != 0) { this.caseStat.IdHospChannel = cs.IdHospChannel; } this.caseStat.RW1Mark = cs.RW1Mark; this.caseStat.AIDSMark = cs.AIDSMark; caseBase.UpdateCaseBase(guid, cs); if (cs.MedRecords != null) { List <TestMedRecord> newMedRecords = new List <TestMedRecord>(); TestTfomsInfo tfi = null; TestClinicMainDiagnosis cmd = null; TestDischargeSummary ds = null; TestConsultNote cn = null; TestDeathInfo tdi = null; foreach (object i in cs.MedRecords) { Service ser = i as Service; if (ser != null) { newMedRecords.Add(new TestService(ser, cs.IdLpu)); } TfomsInfo tf = i as TfomsInfo; if (tf != null) { tfi = new TestTfomsInfo(tf); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { newMedRecords.Add(new TestDiagnosis(diag, cs.IdLpu)); } ClinicMainDiagnosis cd = i as ClinicMainDiagnosis; if ((cd != null) && (cs.HospResult != IdDeath) && (cd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(cd, cs.IdLpu); } ClinicMainDiagnosis ca = i as ClinicMainDiagnosis; if ((ca != null) && (cs.HospResult == IdDeath) && (ca.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(ca, cs.IdLpu); } Referral r = i as Referral; if (r != null) { newMedRecords.Add(new TestReferral(r, cs.IdLpu)); } SickList sl = i as SickList; if (sl != null) { newMedRecords.Add(new TestSickList(sl, cs.IdLpu)); } DischargeSummary pds = i as DischargeSummary; if (pds != null) { ds = new TestDischargeSummary(pds, cs.IdLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { newMedRecords.Add(new TestLaboratoryReport(lr, cs.IdLpu)); } ConsultNote pcn = i as ConsultNote; if (pcn != null) { cn = new TestConsultNote(pcn, cs.IdLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { newMedRecords.Add(new TestAppointedMedication(ap, cs.IdLpu)); } DeathInfo di = i as DeathInfo; if (di != null) { tdi = new TestDeathInfo(di); } Form027U form = i as Form027U; if (form != null) { newMedRecords.Add(new TestForm027U(form, cs.IdLpu)); //? } } if (Global.GetLength(this.medRecords) != 0) { foreach (object i in this.medRecords) { TestService ser = i as TestService; if (!Global.IsEqual(ser, null)) { newMedRecords.Add(ser); } TestTfomsInfo tf = i as TestTfomsInfo; if (!Global.IsEqual(tfi, null) && (!Global.IsEqual(tf, null))) { newMedRecords.Add(tf); } else if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } TestDiagnosis diag = i as TestDiagnosis; if (!Global.IsEqual(diag, null)) { newMedRecords.Add(diag); } TestClinicMainDiagnosis cm = i as TestClinicMainDiagnosis; if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } else if (!Global.IsEqual(cm, null)) { newMedRecords.Add(cm); } TestReferral r = i as TestReferral; if (!Global.IsEqual(r, null)) { newMedRecords.Add(r); } TestSickList sl = i as TestSickList; if (!Global.IsEqual(sl, null)) { newMedRecords.Add(sl); } TestDischargeSummary pds = i as TestDischargeSummary; if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } else if (!Global.IsEqual(pds, null)) { newMedRecords.Add(pds); } TestLaboratoryReport lr = i as TestLaboratoryReport; if (!Global.IsEqual(lr, null)) { newMedRecords.Add(lr); } TestConsultNote pcn = i as TestConsultNote; if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } else if (!Global.IsEqual(pcn, null)) { newMedRecords.Add(pcn); } TestAppointedMedication ap = i as TestAppointedMedication; if (!Global.IsEqual(ap, null)) { newMedRecords.Add(ap); } TestDeathInfo di = i as TestDeathInfo; if (!Global.IsEqual(tdi, null) && (!Global.IsEqual(di, null))) { newMedRecords.Add(di); } else if (!Global.IsEqual(tdi, null)) { newMedRecords.Add(tdi); } TestForm027U form = i as TestForm027U; if (!Global.IsEqual(form, null)) { newMedRecords.Add(form); } } } else { if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } if (!Global.IsEqual(tdi, null)) { newMedRecords.Add(tdi); } } this.records = newMedRecords; } } }
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); }