/// <summary> /// 查询所有的产品类别 /// </summary> /// <returns></returns> public List <ProductCategoryEntity> GetList() { string Key = string.Format(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE, this.CompanyID); List <ProductCategoryEntity> list = CacheHelper.Get(Key) as List <ProductCategoryEntity>; if (!list.IsNullOrEmpty()) { return(list); } ProductCategoryEntity entity = new ProductCategoryEntity(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.IncludeAll(); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID); list = this.ProductCategory.GetList(entity); if (!list.IsNullOrEmpty()) { foreach (ProductCategoryEntity item in list) { int depth = list.Where(a => a.Left <= item.Left && a.Right >= item.Right).Count(); item.Depth = depth; if (item.ParentNum.IsNotEmpty()) { ProductCategoryEntity parent = list.FirstOrDefault(a => a.SnNum == item.ParentNum); item.ParentName = item != null && parent.CateName != "Root" ? parent.CateName : string.Empty; } } CacheHelper.Insert(Key, list); } return(list); }
/// <summary> /// 查询所有的产品类别 /// </summary> /// <returns></returns> public List <ProductCategoryEntity> GetList() { List <ProductCategoryEntity> list = CacheHelper.Get(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE) as List <ProductCategoryEntity>; if (!list.IsNullOrEmpty()) { return(list); } ProductCategoryEntity entity = new ProductCategoryEntity(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.IncludeAll(); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); list = this.ProductCategory.GetList(entity); if (!list.IsNullOrEmpty()) { CacheHelper.Insert(CacheKey.JOOSHOW_PRODUCTCATEGORY_CACHE, list); } return(list); }
/// <summary> /// 查询产品类别分页 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List <ProductCategoryEntity> GetList(ProductCategoryEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); entity.OrderBy(a => a.ID, EOrderBy.DESC); int rowCount = 0; List <ProductCategoryEntity> list = this.ProductCategory.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; if (!list.IsNullOrEmpty()) { AdminProvider adminProvider = new AdminProvider(); foreach (ProductCategoryEntity item in list) { if (!item.CreateUser.IsEmpty()) { AdminEntity admin = adminProvider.GetAdmin(item.CreateUser); item.CreateUser = admin.IsNotNull() ? admin.UserName : item.CreateUser; } } } return(list); }