private void txtID_EditValueChanged(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtID.Text) || string.IsNullOrWhiteSpace(txtID.Text)) { gridControl1.DataSource = Diagnosis_cu.ItemsList; return; } txtAbbreviation.EditValue = null; txtName.Text = null; if (DiagnosisList == null) { DiagnosisList = new List <Diagnosis_cu>(); } Diagnosis_cu diagnosis = Diagnosis_cu.ItemsList.Find(item => Convert.ToInt32(item.ID).Equals(Convert.ToInt32(txtID.EditValue))); if (diagnosis != null) { DiagnosisList.Add(diagnosis); } gridControl1.DataSource = DiagnosisList; gridControl1.RefreshDataSource(); }
/// <summary> /// /// </summary> /// <param name="accessor"></param> /// <param name="manager"></param> /// <param name="idDiagnosis"></param> /// <param name="diagnosisName"></param> private void AddDiagnosisToList(DiagnosisItem.Accessor accessor, DbManagerProxy manager, long idDiagnosis, string diagnosisName) { var di = accessor.CreateNewT(manager, this); di.idfVectorSurveillanceSession = idfVectorSurveillanceSession; di.idfsDiagnosis = idDiagnosis; di.NationalName = diagnosisName; DiagnosisList.Add(di); }
private void btnSearch_Click(object sender, System.EventArgs e) { if (DiagnosisList == null) { DiagnosisList = new List <Diagnosis_cu>(); } if (!string.IsNullOrEmpty(txtID.Text) && !string.IsNullOrWhiteSpace(txtID.Text)) { switch (SearchPanelType) { case SearchPanelType.DiagnosisSearch: Diagnosis_cu diagnosis = Diagnosis_cu.ItemsList.Find(item => Convert.ToInt32(item.ID).Equals(Convert.ToInt32(txtID.EditValue))); if (diagnosis != null) { DiagnosisList.Add(diagnosis); } gridControl1.DataSource = DiagnosisList; gridControl1.RefreshDataSource(); return; } } if (!string.IsNullOrEmpty(txtAbbreviation.Text) && !string.IsNullOrWhiteSpace(txtAbbreviation.Text)) { switch (SearchPanelType) { case SearchPanelType.DiagnosisSearch: DiagnosisList = Diagnosis_cu.ItemsList .Where(item => item.Abbreviation != null && item.Abbreviation.Contains(txtAbbreviation.Text)).ToList(); gridControl1.DataSource = DiagnosisList; gridControl1.RefreshDataSource(); return; } } if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrWhiteSpace(txtName.Text)) { switch (SearchPanelType) { case SearchPanelType.DiagnosisSearch: DiagnosisList = Diagnosis_cu.ItemsList.Where(item => item.Name_P != null && item.Name_P.Contains(txtName.Text) || item.Name_S != null && item.Name_S.Contains(txtName.Text)).ToList(); gridControl1.DataSource = DiagnosisList; gridControl1.RefreshDataSource(); return; } } }
public void GetDiagnosisPatient() { DBClass.openConnection(); //) CAST(DateOfBirth AS date), convert(Date, DateOfBirth, 23) //select distinct convert(VARCHAR, DataDiagnosis, 23) , NotesDiagnosis, LastNameTherapist from therapists, diagnosis where(diagnosis.IDPatient = '2') and therapists.LastNameTherapist = (select LastNameTherapist from therapists where IDTherapist = '2') DBClass.sql = "select distinct IDDiagnosis, convert(VARCHAR, DataDiagnosis, 23) , NotesDiagnosis, LastNameTherapist " + "from therapists, diagnosis " + "where (diagnosis.IDPatient = '" + infoPatientTemp[0] + "') and therapists.LastNameTherapist = (select LastNameTherapist from therapists where IDTherapist = '2')"; DBClass.cmd.CommandType = CommandType.Text; DBClass.cmd.CommandText = DBClass.sql; DBClass.da = new SqlDataAdapter(DBClass.cmd); DBClass.dt = new DataTable(); DBClass.da.Fill(DBClass.dt); // wyciągamy dane int j = 0; DiagnosisList.Clear(); using (SqlDataReader reader = DBClass.cmd.ExecuteReader()) { while (reader.Read()) { for (j = 0; j <= reader.FieldCount - 1; j++) // Looping throw colums { data[j] = reader.GetValue(j).ToString(); } if (data[7] == null) { data[7] = ""; } DiagnosisList.Add(new DiagnosisModel { IDDiagnosis = (data[0]), DataDiagnosis = data[1], NotesDiagnosis = data[2], LastNameTherapist = data[3] }); //Console.WriteLine("IDTherapist - " + data[7] + data[8]); } } }