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);
}
public TestDiagnosis(Diagnosis d, string idLpu = "")
{
if (d != null)
{
document = d;
info = new TestDiagnosisInfo(d.DiagnosisInfo);
doctor = new TestDoctor(d.Doctor, idLpu);
}
}
public TestDiagnosis(Diagnosis d, string idLpu = "")
{
if (d != null)
{
document = d;
info = new TestDiagnosisInfo(d.DiagnosisInfo);
doctor = new TestDoctor(d.Doctor, idLpu);
}
}
public TestClinicMainDiagnosis(Diagnosis d, string idLpu = "")
{
if (d != null)
{
if (d.DiagnosisInfo != null)
diagnosInfo = new TestDiagnosisInfo(d.DiagnosisInfo);
if (d.Doctor != null)
doctor = new TestDoctor(d.Doctor, idLpu);
}
}
public TestClinicMainDiagnosis(Diagnosis d, string idLpu = "")
{
if (d != null)
{
if (d.DiagnosisInfo != null)
{
diagnosInfo = new TestDiagnosisInfo(d.DiagnosisInfo);
}
if (d.Doctor != null)
{
doctor = new TestDoctor(d.Doctor, idLpu);
}
}
}
public TestClinicMainDiagnosis(ClinicMainDiagnosis d, string idLpu = "")
{
if (d != null)
{
if (d.DiagnosisInfo != null)
diagnosInfo = new TestDiagnosisInfo(d.DiagnosisInfo);
if (d.Complications != null)
{
_diagnosis = new List<TestDiagnosis>();
foreach (Diagnosis i in d.Complications)
_diagnosis.Add(new TestDiagnosis(i, idLpu));
}
if (d.Doctor != null)
doctor = new TestDoctor(d.Doctor, idLpu);
}
}
private void FindMismatch(TestDiagnosisInfo td)
{
if (this.info.Comment != td.info.Comment)
{
Global.errors3.Add("Несовпадение Comment TestDiagnosisInfo");
}
if (this.info.DiagnosedDate != td.info.DiagnosedDate)
{
Global.errors3.Add("Несовпадение DiagnosedDate TestDiagnosisInfo");
}
if (this.info.DiagnosisChangeReason != td.info.DiagnosisChangeReason)
{
Global.errors3.Add("Несовпадение DiagnosisChangeReason DiagnosisChangeReason");
}
if (this.info.DiagnosisStage != td.info.DiagnosisStage)
{
Global.errors3.Add("Несовпадение DiagnosisStage TestDiagnosisInfo");
}
if (this.info.IdDiagnosisType != td.info.IdDiagnosisType)
{
Global.errors3.Add("Несовпадение IdDiagnosisType TestDiagnosisInfo");
}
if (this.info.IdDiseaseType != td.info.IdDiseaseType)
{
Global.errors3.Add("Несовпадение IdDiseaseType TestDiagnosisInfo");
}
if (this.info.IdDispensaryState != td.info.IdDispensaryState)
{
Global.errors3.Add("Несовпадение IdDispensaryState TestDiagnosisInfo");
}
if (this.info.IdTraumaType != td.info.IdTraumaType)
{
Global.errors3.Add("Несовпадение IdTraumaType TestDiagnosisInfo");
}
if (this.info.MedicalStandard != td.info.MedicalStandard)
{
Global.errors3.Add("Несовпадение MedicalStandard TestDiagnosisInfo");
}
if (this.info.MESImplementationFeature != td.info.MESImplementationFeature)
{
Global.errors3.Add("Несовпадение MESImplementationFeature TestDiagnosisInfo");
}
if (this.info.MkbCode != td.info.MkbCode)
{
Global.errors3.Add("Несовпадение MkbCode TestDiagnosisInfo");
}
}
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 TestClinicMainDiagnosis(ClinicMainDiagnosis d, string idLpu = "")
{
if (d != null)
{
if (d.DiagnosisInfo != null)
{
diagnosInfo = new TestDiagnosisInfo(d.DiagnosisInfo);
}
if (d.Complications != null)
{
_diagnosis = new List <TestDiagnosis>();
foreach (Diagnosis i in d.Complications)
{
_diagnosis.Add(new TestDiagnosis(i, idLpu));
}
}
if (d.Doctor != null)
{
doctor = new TestDoctor(d.Doctor, idLpu);
}
}
}
public override bool Equals(Object obj)
{
TestDiagnosisInfo p = obj as TestDiagnosisInfo;
if ((object)p == null)
{
return(false);
}
if (this.info == p.info)
{
return(true);
}
if ((this.info == null) || (p.info == null))
{
return(false);
}
if ((this.info.Comment == p.info.Comment) &&
(this.info.DiagnosedDate == p.info.DiagnosedDate) &&
(this.info.DiagnosisChangeReason == p.info.DiagnosisChangeReason) &&
(this.info.DiagnosisStage == p.info.DiagnosisStage) &&
(this.info.IdDiagnosisType == p.info.IdDiagnosisType) &&
(this.info.IdDiseaseType == p.info.IdDiseaseType) &&
(this.info.IdDispensaryState == p.info.IdDispensaryState) &&
(this.info.IdTraumaType == p.info.IdTraumaType) &&
(this.info.MedicalStandard == p.info.MedicalStandard) &&
(this.info.MESImplementationFeature == p.info.MESImplementationFeature) &&
(this.info.MkbCode == p.info.MkbCode))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestDiagnosisInfo");
return(false);
}
}
private void FindMismatch(TestDiagnosisInfo td)
{
if (this.info.Comment != td.info.Comment)
Global.errors3.Add("Несовпадение Comment TestDiagnosisInfo");
if (this.info.DiagnosedDate != td.info.DiagnosedDate)
Global.errors3.Add("Несовпадение DiagnosedDate TestDiagnosisInfo");
if (this.info.DiagnosisChangeReason != td.info.DiagnosisChangeReason)
Global.errors3.Add("Несовпадение DiagnosisChangeReason DiagnosisChangeReason");
if (this.info.DiagnosisStage != td.info.DiagnosisStage)
Global.errors3.Add("Несовпадение DiagnosisStage TestDiagnosisInfo");
if (this.info.IdDiagnosisType != td.info.IdDiagnosisType)
Global.errors3.Add("Несовпадение IdDiagnosisType TestDiagnosisInfo");
if (this.info.IdDiseaseType != td.info.IdDiseaseType)
Global.errors3.Add("Несовпадение IdDiseaseType TestDiagnosisInfo");
if (this.info.IdDispensaryState != td.info.IdDispensaryState)
Global.errors3.Add("Несовпадение IdDispensaryState TestDiagnosisInfo");
if (this.info.IdTraumaType != td.info.IdTraumaType)
Global.errors3.Add("Несовпадение IdTraumaType TestDiagnosisInfo");
if (this.info.MedicalStandard != td.info.MedicalStandard)
Global.errors3.Add("Несовпадение MedicalStandard TestDiagnosisInfo");
if (this.info.MESImplementationFeature != td.info.MESImplementationFeature)
Global.errors3.Add("Несовпадение MESImplementationFeature TestDiagnosisInfo");
if (this.info.MkbCode != td.info.MkbCode)
Global.errors3.Add("Несовпадение MkbCode TestDiagnosisInfo");
}