public async Task <List <ImportScheduleModel> > ImportDatas(DateTime startDate, string filePath)
{
var defaultDialysisType = await _itemsDetailApp.GetDefaultDialysisType() ?? "HD";
var list = new List <ImportScheduleModel>();
NPOIExcel excel = new NPOIExcel();
var dialysisTypes = (await _itemsDetailApp.GetItemList("DialysisType")).Select(t => t.F_ItemCode).OrderByDescending(t => t.Length).ToList();
var records = excel.ToListForSchedule("排班明细", filePath, dialysisTypes, 4, 0);
//var groups =
var groups = (await _itemsDetailApp.GetItemList("BedGroup")).Select(t => t.F_ItemCode).ToList();
var beds = await _dialysisMachineApp.GetList();
var patients = await _patientApp.GetList();
foreach (var item in records.GroupBy(t => t.F_GroupName))
{
if (!groups.Contains(item.Key))
{
continue;
}
foreach (var child in item.GroupBy(t => t.F_DialysisBedNo))
{
var findBed = beds.Find(t => t.F_GroupName == item.Key && t.F_DialylisBedNo == child.Key);
if (findBed == null)
{
continue;
}
foreach (var ele in child)
{
var patient = patients.Find(t => t.F_Name == ele.F_Name.Trim());
if (patient == null)
{
continue;
}
list.Add(new ImportScheduleModel
{
F_GroupName = item.Key,
F_DialysisBedNo = child.Key,
F_BId = findBed.F_Id,
F_VisitDate = startDate.AddDays(ele.DayOfWeek - 1),
F_VisitNo = ele.F_VisitNo,
F_PId = patient.F_Id,
F_DialysisNo = patient.F_DialysisNo,
F_Name = patient.F_Name,
F_DialysisType = ele.F_DialysisType ?? defaultDialysisType,
F_Sort = findBed.F_ShowOrder.ToInt()
});
}
}
}
return(list);
}
