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();
}
protected override void OnDisappearing()
{
base.OnDisappearing();
DiagnosisList.FadeTo(0, 1000, Easing.SinInOut);
doctorDetails.FadeTo(0, 1200, Easing.SinInOut);
dignosisPage.FadeTo(0, 1400, Easing.SinInOut);
}
/// <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);
}
protected override void OnAppearing()
{
base.OnAppearing();
dignosisPage.Opacity = 0;
doctorDetails.Opacity = 0;
DiagnosisList.Opacity = 0;
dignosisPage.FadeTo(1, 1000, Easing.SinInOut);
doctorDetails.FadeTo(1, 1200, Easing.SinInOut);
DiagnosisList.FadeTo(1, 1400, Easing.SinInOut);
}
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]);
}
}
}
/// <summary>
/// Обновляет перечень диагнозов по всем тестам
/// </summary>
public void RefreshDiagnoses()
{
var accessor = DiagnosisItem.Accessor.Instance(null);
DiagnosisList.Clear();
using (var manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance))
{
var fieldTests = FieldTests;
foreach (var ft in fieldTests)
{
if (ft.IsMarkedToDelete)
{
continue;
}
//если результат не индикативный, то эти диагнозы не добавляем
var idResult = ft.idfsPensideTestResult;
var idTestType = ft.idfsPensideTestName;
if (idResult == null)
{
continue;
}
var matrix =
ft.TestResultLookup.FirstOrDefault(
r => (r.idfsPensideTestName == idTestType) && (r.idfsPensideTestResult == idResult));
if (matrix == null)
{
continue;
}
if (!matrix.blnIndicative.HasValue)
{
continue;
}
if (!matrix.blnIndicative.Value)
{
continue;
}
var idDiagnosis = ft.idfsDiagnosis;
if (!idDiagnosis.HasValue)
{
continue;
}
if (DiagnosisList.Count(s => s.idfsDiagnosis == idDiagnosis) == 0)
{
var diag = ft.DiagnosisLookup.FirstOrDefault(d => d.idfsDiagnosis == idDiagnosis);
if (diag != null)
{
AddDiagnosisToList(accessor, manager, idDiagnosis.Value, diag.DiagnosisName);
}
}
}
foreach (var lt in LabTests) //TODO LabTestsFake?
{
if (lt.IsMarkedToDelete)
{
continue;
}
//если у лаб.теста результат не индикативный, то не добавляем его диагноз
//// commented by Vdovin because blnIndicative is absent
//if (!lt.blnIndicative.HasValue) continue;
//if (!lt.blnIndicative.Value) continue;
var idDiagnosis = lt.idfsDiagnosis;
if (DiagnosisList.Count(s => s.idfsDiagnosis == idDiagnosis) == 0)
{
var diag = DiagnosesLookup.SingleOrDefault(c => c.idfsDiagnosis == idDiagnosis);
if (diag != null)
{
AddDiagnosisToList(accessor, manager, idDiagnosis, diag.name);
}
}
}
//дополняем диагнозами из Summary
foreach (var summary in Summaries)
{
if (summary.IsMarkedToDelete)
{
continue;
}
foreach (var diag in summary.DiagnosisList)
{
if (diag.IsMarkedToDelete)
{
continue;
}
if (diag.Diagnoses != null)
{
AddDiagnosisToList(accessor, manager, diag.Diagnoses.idfsDiagnosis, diag.Diagnoses.name);
}
}
}
}
}
