public async Task <PageResult <PageResultReplyDto> > ListByPageGroup(PageQueryParams queryParams) { var messagesList = _messagesClient.GetListByPage(queryParams); var lookupList = _lookUpValuesClient.GetLookUpValuesByType(new List <ComEntity.Filter.LookUpValues.LookUpValuesByTypeParams> { new ComEntity.Filter.LookUpValues.LookUpValuesByTypeParams { IsBetweenOt = true, LookUpName = "XXECP_MESSAGE_TYPE" } }); await messagesList; await lookupList; var result = from m in messagesList.Result.Data join p in lookupList.Result.Where(l => l.LOOKUP_TYPE == "XXECP_MESSAGE_TYPE") on m.MESSAGE_TYPE equals p.LOOKUP_CODE into temp from tt in temp.DefaultIfEmpty() select new PageResultReplyDto { ID = m.ID, MESSAGE_NUMBER = m.MESSAGE_NUMBER, MESSAGE_NAME = m.MESSAGE_NAME, MESSAGE_TEXT = m.MESSAGE_TEXT, MESSAGE_TYPE = m.MESSAGE_TYPE, MESSAGE_TYPE_NAME = tt == null? m.MESSAGE_TYPE:tt.LOOKUP_MEANING, MESSAGE_DESCRIPTION = m.MESSAGE_DESCRIPTION, CREATION_DATE = m.CREATION_DATE, CREATOR = m.CREATOR, LAST_UPDATE_DATE = m.LAST_UPDATE_DATE, EDITOR = m.EDITOR }; messagesList.Result.Data = result.ToList(); return(messagesList.Result); }
public async Task <JsonResult> GetLookUpValuesByType(LookUpValuesByTypeParams lookUpValuesByTypeParams) { var resultReply = await _lookUpValuesClient.GetLookUpValuesByType(new List <LookUpValuesByTypeParams> { lookUpValuesByTypeParams }); return(Json(resultReply)); }
public async Task <IViewComponentResult> InvokeAsync(LookUpValuesByTypeParams lookUpValuesByTypeParams) { var resultReply = await lookUpValuesClient.GetLookUpValuesByType(new List <LookUpValuesByTypeParams> { lookUpValuesByTypeParams }); ViewBag.defaultValue = lookUpValuesByTypeParams.defaultValue; return(View(resultReply)); }
/// <summary> /// ?檓琩墈?琩墈 /// </summary> /// <param name="lookupList"></param> /// <param name="lookupNameArray"></param> public void JoinSearchLookup(out Task <List <LookUpValuesByTypeDto> > lookupList, params string[] lookupNameArray) { lookupList = null; if (lookupNameArray.Length > 0) { List <ComEntity.Filter.LookUpValues.LookUpValuesByTypeParams> qParams = new List <ComEntity.Filter.LookUpValues.LookUpValuesByTypeParams>(); for (int i = 0; i < lookupNameArray.Length; i++) { qParams.Add(new ComEntity.Filter.LookUpValues.LookUpValuesByTypeParams { IsBetweenOt = true, LookUpName = lookupNameArray[i] }); } lookupList = _lookUpValuesClient.GetLookUpValuesByType(qParams); } }
/// <summary> /// 组合数据 /// </summary> /// <param name="queryParams"></param> /// <returns></returns> public async Task <PageResult <PageResultReplyDto> > ListByPageGroup(PageQueryParams queryParams) { var lookUpValuesList = _lookUpValuesClient.GetListByPage(queryParams); var lookUpList = _lookUpValuesClient.GetLookUpValuesByType(new List <LookUpValuesByTypeParams> { new LookUpValuesByTypeParams { IsBetweenOt = true, LookUpName = "YES_NO" } }); await lookUpValuesList; await lookUpList; var result = from v in lookUpValuesList.Result.Data join p in lookUpList.Result.Where(l => l.LOOKUP_TYPE == "YES_NO") on v.ENABLED_FLAG equals p.LOOKUP_CODE into temp from tt in temp.DefaultIfEmpty() select new PageResultReplyDto { ID = v.ID, LOOKUP_VALUES_ALL_ID = v.LOOKUP_VALUES_ALL_ID, LOOKUP_TYPE = v.LOOKUP_TYPE, LOOKUP_CODE = v.LOOKUP_CODE, LOOKUP_MEANING = v.LOOKUP_MEANING, LOOKUP_DESCRIPTION = v.LOOKUP_DESCRIPTION, ENABLED_FLAG = v.ENABLED_FLAG, ENABLED_FLAG_NAME = tt == null ? v.ENABLED_FLAG : tt.LOOKUP_MEANING, TAG = v.TAG, START_DATE_ACTIVE = v.START_DATE_ACTIVE, END_DATE_ACTIVE = v.END_DATE_ACTIVE, ATTIBUTE1 = v.ATTIBUTE1, ATTIBUTE2 = v.ATTIBUTE2, ATTIBUTE3 = v.ATTIBUTE3, ATTIBUTE4 = v.ATTIBUTE4, ATTIBUTE5 = v.ATTIBUTE5, CREATION_DATE = v.CREATION_DATE, CREATOR = v.CREATOR, LAST_UPDATE_DATE = v.LAST_UPDATE_DATE, EDITOR = v.EDITOR }; lookUpValuesList.Result.Data = result.ToList(); return(lookUpValuesList.Result); }