Esempio n. 1
0
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        public SqlSugarPagedList <SysOrg> GetOrgList(OrgListRequestDto dto)
        {
            var query = dbClint.Queryable <SysOrg>().Where(o => o.IsDeleted == false);

            query.WhereIF(!string.IsNullOrWhiteSpace(dto.OrgName), o => o.OrgName.Contains(dto.OrgName.Trim()));
            query.WhereIF(dto.ParentOrgId.HasValue, o => o.ParentOrgId == dto.ParentOrgId || o.OrgId == dto.ParentOrgId);
            int total = 0;
            var list  = query.ToPageList(dto.Page, dto.Limit, ref total);

            return(new SqlSugarPagedList <SysOrg>()
            {
                PageIndex = dto.Page,
                PageSize = dto.Limit,
                Items = list,
                TotalCount = total
            });
        }
Esempio n. 2
0
 public SqlSugarPagedList <SysOrg> GetOrgList([FromBody] OrgListRequestDto dto)
 {
     return(_sysOrgService.GetOrgList(dto));
 }