/// <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));
 }
Exemple #3
0
 public async Task <JsonResult> GetPagingDictionary(SystemDictionaryPagingInput queryParam)
 {
     return(JsonForGridPaging(await _systemDictionaryLogic.PagingDictionaryQuery(queryParam)));
 }