/// <summary> /// 查询基础字典参数 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <IActionResult> GetSelectJson(BaseInput input) { var data = from r in await _itemsDetailApp.GetItemList(input == null? "" : input.KeyValue) select new { id = r.F_ItemCode, text = r.F_ItemName }; return(Ok(data)); }
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); }
public async Task <IActionResult> GetSelectJson(string enCode) { var data = from r in await _itemsDetailApp.GetItemList(enCode) select new { id = r.F_ItemCode, text = r.F_ItemName }; return(Content(data.ToJson())); }