/// <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);
}