public int DeleteArticleCategoryById(int id) { // 删除栏目的同时 删除栏目下属的文章 IArticleCategoryService articleCategoryService = new ArticleCategoryService(); var articleCategory = articleCategoryService.GetArticleCategoryById(id); if(articleCategory!=null) { IArticleService articleService=new ArticleService(); //WHERE Lft BETWEEN @MyLeft AND @MyRight; var all = articleCategoryService.GetAllArticleCategory().Where(s => s.Lft>=articleCategory.Lft && s.Lft <= articleCategory.Rgt); foreach (ArticleCategoryInfo articleCategoryInfo in all) { articleService.DeleteByCategoryId(articleCategory.Id); } } return articleCategoryService.Delete(id); }
public int UpdateArticle() { IArticleService articleService = new ArticleService(); var model = new ArticleInfo(); model.Id = Convert.ToInt32(HttpContext.Current.Request.Params["ArticleId"]); model.CategoryId = Convert.ToInt32(HttpContext.Current.Request.Params["ArticleCategoryId"]); model.Title = HttpContext.Current.Request.Params["Title"]; model.SubTitle = HttpContext.Current.Request.Params["SubTitle"]; model.Summary = HttpContext.Current.Request.Params["Summary"]; model.Content = HttpContext.Current.Request.Params["Content"]; model.Keywords = HttpContext.Current.Request.Params["Keywords"]; model.MetaDesc = HttpContext.Current.Request.Params["MetaDesc"]; model.Source = HttpContext.Current.Request.Params["Source"]; model.AllowComments = true;//(int)HttpContext.Current.Request.Params["AllowComments"]; model.Clicks = Convert.ToInt32(HttpContext.Current.Request.Params["Clicks"] ?? "0"); model.ReadPassword = HttpContext.Current.Request.Params["ReadPassword"]; model.UserId = 0; model.DisplayOrder = OrderGenerator.NewOrder(); model.PublishDate = Convert.ToDateTime(HttpContext.Current.Request.Params["PublishDate"]); model.InDate = DateTime.Now; model.EditDate = DateTime.Now; model.FocusPicture = HttpContext.Current.Request.Params["FocusPicture"]; return articleService.Update(model); }
public int DeleteArticleById(int id) { IArticleService articleService = new ArticleService(); return articleService.Delete(id); }
public JQGridDataResult GetArticles() { // 每页显示记录数 int pageSize = int.Parse(HttpContext.Current.Request.QueryString["rows"]); // 当前页 int pageIndex = int.Parse(HttpContext.Current.Request.QueryString["page"]); IArticleService articleService = new ArticleService(); var data= articleService.GetArticles(pageSize, pageIndex, string.Empty); // 记录总数 int rowCount = data.TotalCount; // 总页数 int pageCount = rowCount % pageSize == 0 ? rowCount / pageSize : rowCount / pageSize + 1; var resultObj = new JQGridDataResult { // 总页数 PageCount = pageCount, // 当前页 PageIndex = pageIndex, // 总记录数 Total = rowCount, // 数据 Data = data }; return resultObj; }