private void FindMismatch(TestStepBase sb) { if (this.step.Comment != sb.step.Comment) { Global.errors3.Add("несовпадение Comment TestStepBase"); } if (this.step.DateEnd != sb.step.DateEnd) { Global.errors3.Add("несовпадение DateEnd TestStepBase"); } if (this.step.DateStart != sb.step.DateStart) { Global.errors3.Add("несовпадение DateStart TestStepBase"); } if (this.step.IdPaymentType != sb.step.IdPaymentType) { Global.errors3.Add("несовпадение IdPaymentType TestStepBase"); } if (this.step.IdStepMis != sb.step.IdStepMis) { Global.errors3.Add("несовпадение IdStepMis TestStepBase"); } if (Global.GetLength(step) != Global.GetLength(sb.step)) { Global.errors3.Add("несовпадение длины step TestStepBase"); } if (Global.GetLength(doctor) != Global.GetLength(sb.doctor)) { Global.errors3.Add("несовпадение длины doctor TestStepBase"); } }
public override bool Equals(Object obj) { TestStepBase p = obj as TestStepBase; if ((object)p == null) { return(false); } if (this.step == p.step) { return(true); } if ((this.step == null) || (p.step == null)) { return(false); } if ((this.step.Comment == p.step.Comment) && (this.step.DateEnd == p.step.DateEnd) && (this.step.DateStart == p.step.DateStart) && (this.step.IdPaymentType == p.step.IdPaymentType) && (this.step.IdStepMis == p.step.IdStepMis) && Global.IsEqual(this.doctor, p.doctor)) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestStepBase"); return(false); } }
public TestAmbStep(StepAmb sa, string caseLpu) { if (sa != null) { ambStep = sa; step = new TestStepBase(sa, caseLpu); if (sa.MedRecords != null) { records = new List<TestMedRecord>(); foreach (object i in sa.MedRecords) { Service s = i as Service; if (s != null) records.Add(new TestService(s, caseLpu)); AppointedMedication am = i as AppointedMedication; if (am != null) records.Add(new TestAppointedMedication(am, caseLpu)); Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestDiagnosis(diag, caseLpu)); ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) records.Add(new TestClinicMainDiagnosis(cmd, caseLpu)); Referral r = i as Referral; if (r != null) records.Add(new TestReferral(r, caseLpu)); LaboratoryReport lr = i as LaboratoryReport; if (lr != null) records.Add(new TestLaboratoryReport(lr, caseLpu)); } } } }
public TestStatStep(StepStat sa, string caseLpu) { if (sa != null) { statStep = sa; step = new TestStepBase(sa, caseLpu); if (sa.MedRecords != null) { records = new List <TestMedRecord>(); foreach (object i in sa.MedRecords) { Service s = i as Service; if (s != null) { records.Add(new TestService(s, caseLpu)); } AppointedMedication am = i as AppointedMedication; if (am != null) { records.Add(new TestAppointedMedication(am, caseLpu)); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestDiagnosis(diag, caseLpu)); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(cmd, caseLpu)); } Referral r = i as Referral; if (r != null) { records.Add(new TestReferral(r, caseLpu)); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { records.Add(new TestLaboratoryReport(lr, caseLpu)); } Form027U form = i as Form027U; if (form != null) { records.Add(new TestForm027U(form, caseLpu)); } } } } }
public static List<TestStepBase> BuildTestStepsFromDataBase(string idCase, string stepLpu) { List<TestStepBase> steps = new List<TestStepBase>(); if (idCase != string.Empty) { using (SqlConnection connection = Global.GetSqlConnection()) { string findSteps = "SELECT * FROM Step WHERE IdCase = '" + idCase + "'"; SqlCommand stepsCommand = new SqlCommand(findSteps, connection); using (SqlDataReader stepsReader = stepsCommand.ExecuteReader()) { while (stepsReader.Read()) { StepBase sb = new StepBase(); if (stepsReader["Comment"].ToString() != "") sb.Comment = Convert.ToString(stepsReader["Comment"]); else sb.Comment = null; if (stepsReader["DateEnd"].ToString() != "") sb.DateEnd = Convert.ToDateTime(stepsReader["DateEnd"]); else sb.DateEnd = DateTime.MinValue; if (stepsReader["DateStart"].ToString() != "") sb.DateStart = Convert.ToDateTime(stepsReader["DateStart"]); else sb.DateStart = DateTime.MinValue; if (stepsReader["IdPaymentType"].ToString() != "") sb.IdPaymentType = Convert.ToByte(stepsReader["IdPaymentType"]); else sb.IdPaymentType = 0; if (stepsReader["IdStepMis"].ToString() != "") sb.IdStepMis = Convert.ToString(stepsReader["IdStepMis"]); else sb.IdStepMis = null; TestStepBase step = new TestStepBase(sb, stepLpu); if (stepsReader["IdDoctor"].ToString() != "") step.doctor = TestDoctor.BuildTestDoctorFromDataBase(stepsReader["IdDoctor"].ToString()); else step.doctor = null; step.idStep = Convert.ToString(stepsReader["IdStep"]); steps.Add(step); } } } } if (steps.Count != 0) return steps; else return null; }
static public List <TestStepBase> BuildTestStepsFromDataBase(string idCase, string stepLpu) { List <TestStepBase> steps = new List <TestStepBase>(); if (idCase != string.Empty) { using (SqlConnection connection = Global.GetSqlConnection()) { string findSteps = "SELECT * FROM Step WHERE IdCase = '" + idCase + "'"; SqlCommand stepsCommand = new SqlCommand(findSteps, connection); using (SqlDataReader stepsReader = stepsCommand.ExecuteReader()) { while (stepsReader.Read()) { StepBase sb = new StepBase(); if (stepsReader["Comment"].ToString() != "") { sb.Comment = Convert.ToString(stepsReader["Comment"]); } else { sb.Comment = null; } if (stepsReader["DateEnd"].ToString() != "") { sb.DateEnd = Convert.ToDateTime(stepsReader["DateEnd"]); } else { sb.DateEnd = DateTime.MinValue; } if (stepsReader["DateStart"].ToString() != "") { sb.DateStart = Convert.ToDateTime(stepsReader["DateStart"]); } else { sb.DateStart = DateTime.MinValue; } if (stepsReader["IdPaymentType"].ToString() != "") { sb.IdPaymentType = Convert.ToByte(stepsReader["IdPaymentType"]); } else { sb.IdPaymentType = 0; } if (stepsReader["IdStepMis"].ToString() != "") { sb.IdStepMis = Convert.ToString(stepsReader["IdStepMis"]); } else { sb.IdStepMis = null; } TestStepBase step = new TestStepBase(sb, stepLpu); if (stepsReader["IdDoctor"].ToString() != "") { step.doctor = TestDoctor.BuildTestDoctorFromDataBase(stepsReader["IdDoctor"].ToString()); } else { step.doctor = null; } step.idStep = Convert.ToString(stepsReader["IdStep"]); steps.Add(step); } } } } if (steps.Count != 0) { return(steps); } else { 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; } } } } }
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 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 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(TestStepBase sb) { if (this.step.Comment != sb.step.Comment) Global.errors3.Add("несовпадение Comment TestStepBase"); if (this.step.DateEnd != sb.step.DateEnd) Global.errors3.Add("несовпадение DateEnd TestStepBase"); if (this.step.DateStart != sb.step.DateStart) Global.errors3.Add("несовпадение DateStart TestStepBase"); if (this.step.IdPaymentType != sb.step.IdPaymentType) Global.errors3.Add("несовпадение IdPaymentType TestStepBase"); if (this.step.IdStepMis != sb.step.IdStepMis) Global.errors3.Add("несовпадение IdStepMis TestStepBase"); if (Global.GetLength(step) != Global.GetLength(sb.step)) Global.errors3.Add("несовпадение длины step TestStepBase"); if (Global.GetLength(doctor) != Global.GetLength(sb.doctor)) Global.errors3.Add("несовпадение длины doctor TestStepBase"); }
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); }