/// <summary>
/// 获取接口数据
/// </summary>
/// <param name="entity"></param>
/// <param name="queryJson"></param>
/// <returns></returns>
public DataTable GetData(DataSourceEntity entity, string queryJson)
{
try
{
DataBaseLinkEntity dataBaseLinkEntity = dataBaseLinkService.GetEntity(entity.F_DbId);
if (dataBaseLinkEntity != null)
{
return(service.GetData(entity.F_Strsql, dataBaseLinkEntity.F_DbConnection, queryJson));
}
else
{
return(null);
}
}
catch (Exception)
{
throw;
}
}
public async Task GetInitData(string key = null)
{
try
{
await Clients.Client(Context.ConnectionId).SendAsync("OnInitDataSet", _dataSourceService.GetData(key), key);
}
catch (Exception e)
{
_logger.LogError(e, "Failed to get init data");
throw;
}
}
public IActionResult Patients(string sortOrder)
{
ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
var patientsObs = _dataSourceService.GetListData <ListObservation>("Observation", 0).ToList();
var patientsObsEnu = (IEnumerable <ListObservation>)patientsObs;
patientsObsEnu = patientsObsEnu.Where(x => x.subject != null);
patientsObsEnu = patientsObsEnu.Where(x => x.subject.reference != null);
patientsObsEnu = patientsObsEnu.Where(x => x.subject.reference.Split('/').Count() == 2);
var ids = patientsObsEnu.Select(x => x.subject.reference.Split('/')[1]).ToList();
ids.AddRange(TempValid);
var uniqIds = ids.ToHashSet();
var patients = new List <ListPatient>();
foreach (var id in uniqIds)
{
patients.Add(_dataSourceService.GetData <ListPatient>($"Patient/{id}"));
Console.Write(@$ "" "{id}" ",");
}
patients = patients.Where(x => x.name != null).ToList();
patients = patients.Where(x => x.name.Count >= 1).ToList();
patients = patients.Where(x => x.name.First().given != null).ToList();
if (sortOrder == "name_desc")
{
patients = patients.OrderByDescending(x => x.name.First().family).ToList();
}
else
{
patients = patients.OrderBy(x => x.name.First().family).ToList();
}
return(View(patients));
}
