public object UpdateProductCategoryByCategoryId() { var model = new ProductCategoryInfo(); model.Id = Convert.ToInt32(HttpContext.Current.Request.Params["CategoryId"]); model.Name = HttpContext.Current.Request.Params["CategoryName"]; model.Desc = (string)HttpContext.Current.Request.Params["desc"]; model.BigPicture = HttpContext.Current.Request.Params["BigPicture"]; model.SmallPicture = HttpContext.Current.Request.Params["SmallPicture"]; model.MediumPicture = HttpContext.Current.Request.Params["mediumpicture"]; model.Content = HttpContext.Current.Request.Params["desc"]; var display = 0; if (int.TryParse(HttpContext.Current.Request.Form["DisplayOrder"], out display)) { model.DisplayOrder = display; } else { model.DisplayOrder = display; } //model.ParentId = int.Parse(HttpContext.Current.Request.Form["parentSelect"]); IProductCategoryService productCategoryService = new ProductCategoryService(); return productCategoryService.Update(model); }
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 bool InsertProductCategory() { //var option = int.Parse(HttpContext.Current.Request.Form["parentSelect"]); var model = new ProductCategoryInfo(); model.Name=HttpContext.Current.Request.Form["CategoryName"]; model.Desc = HttpContext.Current.Request.Form["desc"]; model.MediumPicture = HttpContext.Current.Request.Form["mediumpicture"]; model.ParentId = int.Parse(HttpContext.Current.Request.Form["parentSelect"]); var display = 0; if(int.TryParse(HttpContext.Current.Request.Form["DisplayOrder"],out display)) { model.DisplayOrder = display; } else { model.DisplayOrder = display; } IProductCategoryService productCategoryService=new ProductCategoryService(); return productCategoryService.Insert(model, 1) > 0; }
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 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 GetAllProductCategory() { IProductCategoryService productCategoryService = new ProductCategoryService(); return productCategoryService.GetProductCategory().Where(s=>s.Depth!=0).ToList(); }
public object DeleteProductCategoryOnlyById(int id) { IProductCategoryService productCategoryService = new ProductCategoryService(); return productCategoryService.DeleteCurrentNodeOnlyById(id); }