public override bool Equals(Object obj)
{
TestRecommendation p = obj as TestRecommendation;
if ((object)p == null)
{
return(false);
}
if (this.recommendation == p.recommendation)
{
return(true);
}
if ((this.recommendation == null) || (p.recommendation == null))
{
return(false);
}
if ((this.recommendation.Date == p.recommendation.Date) &&
(this.recommendation.Text == p.recommendation.Text) &&
Global.IsEqual(this.doctor, p.doctor))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestRecommendation");
return(false);
}
}
public static List<TestRecommendation> BuildSickListFromDataBaseData(string idDispensaryStage1)
{
List<TestRecommendation> llr = new List<TestRecommendation>();
if (idDispensaryStage1 != "")
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findR = "SELECT * FROM Recommendation WHERE idDispensaryStage1 = '" + idDispensaryStage1 + "'";
SqlCommand Rcommand = new SqlCommand(findR, connection);
using (SqlDataReader RReader = Rcommand.ExecuteReader())
{
while (RReader.Read())
{
Recommendation r = new Recommendation();
if (RReader["Text"].ToString() != "")
r.Text = RReader["Text"].ToString();
if (RReader["Date"].ToString() != "")
r.Date = Convert.ToDateTime(RReader["Date"]);
TestRecommendation tr = new TestRecommendation(r);
if (RReader["IdDoctor"].ToString() != "")
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(RReader["IdDoctor"].ToString());
llr.Add(tr);
}
}
}
}
if (llr.Count != 0)
return llr;
else
return null;
}
private void FindMismatch(TestRecommendation r)
{
if (this.recommendation.Date != r.recommendation.Date)
{
Global.errors3.Add("Несовпадение Date TestRecommendation");
}
if (this.recommendation.Text != r.recommendation.Text)
{
Global.errors3.Add("Несовпадение Text TestRecommendation");
}
if (Global.GetLength(this.doctor) != Global.GetLength(r.doctor))
{
Global.errors3.Add("Несовпадение длины doctor TestRecommendation");
}
}
static public List <TestRecommendation> BuildSickListFromDataBaseData(string idDispensaryStage1)
{
List <TestRecommendation> llr = new List <TestRecommendation>();
if (idDispensaryStage1 != "")
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findR = "SELECT * FROM Recommendation WHERE idDispensaryStage1 = '" + idDispensaryStage1 + "'";
SqlCommand Rcommand = new SqlCommand(findR, connection);
using (SqlDataReader RReader = Rcommand.ExecuteReader())
{
while (RReader.Read())
{
Recommendation r = new Recommendation();
if (RReader["Text"].ToString() != "")
{
r.Text = RReader["Text"].ToString();
}
if (RReader["Date"].ToString() != "")
{
r.Date = Convert.ToDateTime(RReader["Date"]);
}
TestRecommendation tr = new TestRecommendation(r);
if (RReader["IdDoctor"].ToString() != "")
{
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(RReader["IdDoctor"].ToString());
}
llr.Add(tr);
}
}
}
}
if (llr.Count != 0)
{
return(llr);
}
else
{
return(null);
}
}
private void FindMismatch(TestRecommendation r)
{
if (this.recommendation.Date != r.recommendation.Date)
Global.errors3.Add("Несовпадение Date TestRecommendation");
if (this.recommendation.Text != r.recommendation.Text)
Global.errors3.Add("Несовпадение Text TestRecommendation");
if (Global.GetLength(this.doctor) != Global.GetLength(r.doctor))
Global.errors3.Add("Несовпадение длины doctor TestRecommendation");
}
static public TestDispensaryOne BuildSickListFromDataBaseData(string idStep)
{
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idDispensaryOne);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findDO = "SELECT TOP(1) * FROM DispensaryStage1, DispensaryStage1HealthGroup WHERE DispensaryStage1.idDispensaryStage1 = (SELECT MAX(idDispensaryStage1) FROM DispensaryStage1 WHERE IdMedDocument = '" + i.idMedDocument + "') AND DispensaryStage1.idDispensaryStage1 = DispensaryStage1HealthGroup.idDispensaryStage1";
SqlCommand DOcommand = new SqlCommand(findDO, connection);
using (SqlDataReader DOReader = DOcommand.ExecuteReader())
{
while (DOReader.Read())
{
DispensaryOne r = new DispensaryOne();
r.HealthGroup = new HealthGroup();
r.HealthGroup.HealthGroupInfo = new HealthGroupInfo();
if (DOReader["IsGuested"].ToString() != "")
{
r.IsGuested = Convert.ToBoolean(DOReader["IsGuested"]);
}
if (DOReader["HasExtraResearchRefferal"].ToString() != "")
{
r.HasExtraResearchRefferal = Convert.ToBoolean(DOReader["HasExtraResearchRefferal"]);
}
if (DOReader["IsUnderObservation"].ToString() != "")
{
r.IsUnderObservation = Convert.ToBoolean(DOReader["IsUnderObservation"]);
}
if (DOReader["HasExpertCareRefferal"].ToString() != "")
{
r.HasExpertCareRefferal = Convert.ToBoolean(DOReader["HasExpertCareRefferal"]);
}
if (DOReader["HasPrescribeCure"].ToString() != "")
{
r.HasPrescribeCure = Convert.ToBoolean(DOReader["HasPrescribeCure"]);
}
if (DOReader["HasHealthResortRefferal"].ToString() != "")
{
r.HasHealthResortRefferal = Convert.ToBoolean(DOReader["HasHealthResortRefferal"]);
}
if (DOReader["HasSecondStageRefferal"].ToString() != "")
{
r.HasSecondStageRefferal = Convert.ToBoolean(DOReader["HasSecondStageRefferal"]);
}
if (DOReader["IdHealthGroup"].ToString() != "")
{
r.HealthGroup.HealthGroupInfo.IdHealthGroup = Convert.ToByte(DOReader["IdHealthGroup"]);
}
if (DOReader["Date"].ToString() != "")
{
r.HealthGroup.HealthGroupInfo.Date = Convert.ToDateTime(DOReader["Date"]);
}
r.Header = i.DocHead;
r.CreationDate = i.CreationDate;
TestDispensaryOne tdo = new TestDispensaryOne(r);
if (DOReader["IdDoctor"].ToString() != "")
{
tdo.hdDoctor = TestDoctor.BuildTestDoctorFromDataBase((DOReader["IdDoctor"]).ToString());
}
if (DOReader["idDispensaryStage1"].ToString() != "")
{
tdo.recom = TestRecommendation.BuildSickListFromDataBaseData(DOReader["idDispensaryStage1"].ToString());
}
tdo.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
tdo.attachment = i;
return(tdo);
}
}
}
}
}
}
return(null);
}
