private void SetPatientSearchResults(string searchTerm, string searchType)
{
SearchController ct = new SearchController();
string datasetSQL = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]);
// Determine type of search, if identifier or normal search
DataTable results = new DataTable();
if (!string.IsNullOrEmpty(searchType) && searchType.Equals(PROTOCOL_PARTICIPANT_ID_CODE))
{
results = ct.FindPatientByIdentifier(searchTerm, PROTOCOL_PARTICIPANT_ID_CODE, datasetSQL).Tables[0];
// add identifier columns
if (PatientResults.Columns.Count == 3)
{
BoundField identifierColumn = new BoundField();
identifierColumn.DataField = "Identifier";
PatientResults.Columns.Add(identifierColumn);
}
}
else if (CanViewPatientInfo)
{
results = ct.FindPatient(searchTerm, datasetSQL).Tables[0];
}
isSingleResult = results.Rows.Count == 1;
PatientResults.DataSource = GetPatientParticipantTable(results);
PatientResults.DataBind();
}
private void UpdateTable_Click(object sender, EventArgs e)
{
RefreshData();
PatientResults.Update();
PatientResults.Columns[0].Width = 110;
PatientResults.Columns[1].Width = 232;
PatientResults.Columns[2].Visible = false;
}
protected void btnSearch_Click(object sender, CommandEventArgs e)
{
string strSearch = searchTxtBox.Value;
string datasetSql = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]);
SpecimenManagerDa da = new SpecimenManagerDa();
SearchController sc = new SearchController();
DataTable dt;
if (searchType == "LastNameMRN")
{
dt = sc.FindPatient(strSearch, datasetSql).Tables[0];;
}
else
{
dt = sc.FindPatientByIdentifier(strSearch, _identifierType, datasetSql).Tables[0];
}
int n = dt.Rows.Count;
if (n > 0)
{
if (n == 1)
{
patientId = Int32.Parse(dt.Rows[0]["PatientId"].ToString());
Response.Redirect("AccessionsContainer.aspx?patientId=" + EncryptPatientId(patientId.ToString()) + "&specimenaccessionId=0");
}
else
{
PatientResults.DataSource = dt;
PatientResults.DataBind();
PDFormDiv.Style.Add("display", "block");
noRecordsFound.Visible = false;
}
}
else
{
PDFormDiv.Style.Add("display", "none");
noRecordsFound.Visible = true;
}
}
private void PatientDataForm_Load(object sender, EventArgs e)
{
PatientName.Text = Patient.FullName;
PatientBirthDate.Text = Patient.BirthDate.ToShortDateString();
if (Patient.Male == Male.Female)
{
PatientMale.Text = "Женский";
}
else
{
PatientMale.Text = "Мужской";
}
PatientHeight.Text = Patient.Height.ToString() + " см";
PatientWeight.Text = Patient.Weight.ToString() + " кг";
_container = new EntityModelContainer();
PatientResults.DataSource = (from measuredData in _container.MeasuredDataSet
where measuredData.OwnerCode == Patient.UserCode
orderby measuredData.CreatingTime
select new { Дата = measuredData.CreatingTime.ToString(), езультат = measuredData.Value, Тип = "Измерение" }).Union(
from healthStatus in _container.HealthStatusSet
where healthStatus.OwnerCode == Patient.UserCode
select new { Дата = healthStatus.CreatingTime.ToString(), езультат = healthStatus.Status, Тип = "Статус" }).ToList();
PatientResults.Update();
PatientResults.Columns[0].Width = 100;
PatientResults.Columns[1].Width = 245;
PatientResults.Columns[2].Visible = false;
excelThread =
new Thread(ExcelWorker.WriteResults);
EndPeriod.MaxDate = DateTime.Now;
}