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); }