/// <summary> /// 字典分页信息 /// </summary> /// <param name="query"></param> /// <returns></returns> public Task <PagedResults <SystemDictionaryOutput> > PagingDictionaryQuery(SystemDictionaryPagingInput query) { string swhere = ""; if (!string.IsNullOrWhiteSpace(query.Id)) { swhere += $" And dic.ParentId='{query.Id}'"; } string sql = $@" select dic.*,dic1.Name ParentName from Sys_Dictionary dic left join Sys_Dictionary dic1 on dic.ParentId=dic1.DictionaryId where 1=1 {swhere}"; return(SqlMapperUtil.PagingQuery <SystemDictionaryOutput>(sql, query)); }
/// <summary> /// 字典分页信息 /// </summary> /// <param name="query"></param> /// <returns></returns> public Task <PagedResults <SystemDictionaryOutput> > PagingDictionaryQuery(SystemDictionaryPagingInput query) { return(_systemDictionaryRepository.PagingDictionaryQuery(query)); }
public async Task <JsonResult> GetPagingDictionary(SystemDictionaryPagingInput queryParam) { return(JsonForGridPaging(await _systemDictionaryLogic.PagingDictionaryQuery(queryParam))); }