GBRSGB/CZKJ.GBRS2/Logic/PublicTypeLogic.cs

using System.Collections.Generic;
using System.Linq;
using CZFW.Framework.Logic;
using CZKJ.GBRS2.Entity;
using CZKJ.GBRS2.Interface;

namespace CZKJ.GBRS2.Logic
{
    public class PublicTypeLogic : LogicBase<PublicTypeEntity>, IPublicType
    {
        public IList<PublicTypeEntity> GetChildList(int? parentId)
        {
            var queryable = Queryable;
            if (parentId.HasValue)
            {
                queryable = queryable.Where(x => x.ParentId == parentId);
            }
            var typeList = new List<PublicTypeEntity>();
            typeList.AddRange(GetList(queryable.ToList()));
            return typeList;
        }
        IList<PublicTypeEntity> list = new List<PublicTypeEntity>();
        private IList<PublicTypeEntity> GetList(IList<PublicTypeEntity> typelist)
        {
            foreach (var item in typelist)
            {
                var count = Queryable.Count(x => x.ParentId == item.Id);
                if (count == 0)
                {
                    list.Add(item);
                }
                else
                {
                    GetList(Queryable.Where(x => x.ParentId == item.Id).ToList());
                }
            }
            return list;
        }
        public IList<PublicTypeEntity> GetParentList()
        {
            var list = Queryable.ToList();
            var typeList = new List<PublicTypeEntity>();
            foreach (var item in list)
            {
                var count = list.Count(x => x.ParentId == item.Id);
                if (count > 0)
                {
                    typeList.Add(item);
                }
            }
            return typeList;
        }
        public IList<PublicTypeEntity> GetList(int? parentId, string keywords, int pageIndex, int pageSize, out int rowsCount)
        {
            var queryable = Queryable;
            if (parentId.HasValue)
            {
                queryable = queryable.Where(x => x.ParentId == parentId);
            }
            if (!string.IsNullOrWhiteSpace(keywords))
            {
                queryable = queryable.Where(x => x.Name.Contains(keywords));
            }
            rowsCount = queryable.Count();
            var result = from a in queryable
                         join b in DbContext.Set<PublicTypeEntity>() on a.ParentId equals b.Id into temp
                         from c in temp.DefaultIfEmpty()
                         select new
                         {
                             Id = a.Id,
                             Name = a.Name,
                             Description = a.Description,
                             ParentName = c == null ? "" : c.Name,
                             SortOrder = a.SortOrder,
                             ParentId = a.ParentId
                         };
            return result.OrderByDescending(x => x.SortOrder).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(x => new PublicTypeEntity
            {
                Id = x.Id,
                Name = x.Name,
                ParentId = x.ParentId,
                Description = x.Description,
                ParentName = x.ParentName,
                SortOrder = x.SortOrder
            }).ToList();
        }
      
    }
}