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);
}