public ActionResult GetRelatedProducts(int categoryId)
{
var returnModel = new ProductDetailViewModel();
returnModel.SStore = MyStore;
returnModel.SCategory = ProductCategoryService.GetProductCategory(categoryId);
returnModel.SRelatedProducts = ProductRepository.GetProductByTypeAndCategoryId(MyStore.Id, StoreConstants.ProductType, categoryId).Take(5).ToList();
String partialViewName = @"pProducts\pRelatedProducts";
var html = this.RenderPartialToString(partialViewName, new ViewDataDictionary(returnModel));
return(Json(html, JsonRequestBehavior.AllowGet));
}
public List <ComboTree> GetComboTreeCategory(int id)
{
IProductCategoryService productCategoryService = new ProductCategoryService();
var data = productCategoryService.GetProductCategory();
List <ComboTree> result = new List <ComboTree>();
var root = data.Where(s => s.Depth == id);
foreach (var categoryInfo in root)
{
var comboTree = new ComboTree();
comboTree.Id = categoryInfo.Id;
comboTree.Text = categoryInfo.Name;
comboTree.Children = GetComboTreeChildren(comboTree, categoryInfo, data);
result.Add(comboTree);
}
return(result);
}
public object GetProductCategory()
{
IProductCategoryService productCategoryService = new ProductCategoryService();
var data = productCategoryService.GetProductCategory();
// 每页显示记录数
int pageSize = 10;
// 记录总数
int rowCount = data.Count;
// 总页数
int pageCount = rowCount % pageSize == 0 ? rowCount / pageSize : rowCount / pageSize + 1;
var resultObj = new JQGridDataResult
{
// 总页数
PageCount = pageCount,
// 当前页
PageIndex = 1,
// 总记录数
Total = rowCount,
// 数据
Data = from item in data
select new
{
cell = new string[]
{
item.Id.ToString(),
item.Name,
item.Desc,
item.CategoryId.ToString(),
item.MediumPicture,
item.Depth.ToString(),
item.Parent,
(item.Rgt == item.Lft + 1).ToString(),
"true",
"true"
}
}
};
return(resultObj);
}
public object DeleteProductCategoryById(int id)
{
IProductCategoryService productCategoryService = new ProductCategoryService();
var productCategory = productCategoryService.GetProductCategoryById(id);
if (productCategory != null)
{
//WHERE Lft BETWEEN @MyLeft AND @MyRight;
var all =
productCategoryService.GetProductCategory().Where(
s => s.Lft >= productCategory.Lft && s.Rgt <= productCategory.Rgt);
IProductService productService = new ProductService();
foreach (ProductCategoryInfo productCategoryInfo in all)
{
productService.DeleteProductByCategoryId(productCategory.Id);
}
}
return(productCategoryService.DeleteById(id));
}
public static IQueryable GetProductCategory()
{
return(ProductCategoryService.GetProductCategory());
}
public object GetAllProductCategory()
{
IProductCategoryService productCategoryService = new ProductCategoryService();
return(productCategoryService.GetProductCategory().Where(s => s.Depth != 0).ToList());
}
