private void grdArticleCategories_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = ((GridViewRow)((Control)e.CommandSource).NamingContainer).RowIndex; int categoryId = (int)this.grdArticleCategories.DataKeys[rowIndex].Value; int displaySequence = int.Parse((this.grdArticleCategories.Rows[rowIndex].FindControl("lblDisplaySequence") as Literal).Text); int replaceCategoryId = 0; int replaceDisplaySequence = 0; if (e.CommandName == "Fall") { if (rowIndex < (this.grdArticleCategories.Rows.Count - 1)) { replaceCategoryId = (int)this.grdArticleCategories.DataKeys[rowIndex + 1].Value; replaceDisplaySequence = int.Parse((this.grdArticleCategories.Rows[rowIndex + 1].FindControl("lblDisplaySequence") as Literal).Text); } } else if ((e.CommandName == "Rise") && (rowIndex > 0)) { replaceCategoryId = (int)this.grdArticleCategories.DataKeys[rowIndex - 1].Value; replaceDisplaySequence = int.Parse((this.grdArticleCategories.Rows[rowIndex - 1].FindControl("lblDisplaySequence") as Literal).Text); } if (replaceCategoryId > 0) { ArticleHelper.SwapArticleCategorySequence(categoryId, replaceCategoryId, displaySequence, replaceDisplaySequence); } if (e.CommandName == "Delete") { ArticleCategoryInfo articleCategory = ArticleHelper.GetArticleCategory(categoryId); if (ArticleHelper.DeleteArticleCategory(categoryId)) { ResourcesHelper.DeleteImage(articleCategory.IconUrl); } } base.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true); }
public static bool DeleteArticleCategory(int categoryId) { ArticleCategoryInfo articleCategoryInfo = new ArticleCategoryInfo(); articleCategoryInfo.CategoryId = categoryId; return(new ArticleCategoryDao().CreateUpdateDeleteArticleCategory(articleCategoryInfo, DataProviderAction.Delete)); }
public List <ComboTree> GetComboTreeChildren2(ComboTree comboTree, ArticleCategoryInfo category, List <ArticleCategoryInfo> data) { var childrens = data.Where(s => s.Depth == category.Depth + 1 && s.Lft > category.Lft && s.Rgt < category.Rgt); var childs = new List <ComboTree>(); foreach (var productCategoryInfo in childrens) { var child = new ComboTree(); child.Id = productCategoryInfo.Id; child.Text = productCategoryInfo.Name; childs.Add(child); } comboTree.Children = childs; foreach (var child in comboTree.Children) { var temp = data.FirstOrDefault(s => s.Id == child.Id); if (temp != null) { this.GetComboTreeChildren2(child, temp, data); } } return(comboTree.Children); }
public void UpdateArticleCategory(ArticleCategoryInfo articleCategory) { if (articleCategory == null) { throw new HimallException("未指定ArticleCategoryInfo实例"); } if (string.IsNullOrWhiteSpace(articleCategory.Name)) { throw new HimallException("未指定文章分类名称"); } if (articleCategory.ParentCategoryId != 0) { if (context.ArticleCategoryInfo.Count((ArticleCategoryInfo item) => item.Id == articleCategory.ParentCategoryId) == 0) { throw new HimallException(string.Concat("不存在父级为", articleCategory.ParentCategoryId, "的文章分类")); } } ArticleCategoryInfo name = context.ArticleCategoryInfo.FindById <ArticleCategoryInfo>(articleCategory.Id); if (name == null) { throw new HimallException(string.Concat("未找到id为", articleCategory.Id, "的对象")); } name.Name = articleCategory.Name; name.ParentCategoryId = articleCategory.ParentCategoryId; context.SaveChanges(); }
public JsonResult GetArticleCategory(long id) { ArticleCategoryInfo articleCategory = ServiceHelper.Create <IArticleCategoryService>().GetArticleCategory(id); var variable = new { id = id, name = articleCategory.Name, parentId = articleCategory.ParentCategoryId }; return(Json(variable)); }
public static bool DeleteArticleCategory(int categoryId) { ArticleCategoryInfo articleCategory = new ArticleCategoryInfo(); articleCategory.CategoryId = categoryId; return(CommentsProvider.Instance().CreateUpdateDeleteArticleCategory(articleCategory, DataProviderAction.Delete)); }
public void UpdateArticleCategory(ArticleCategoryInfo articleCategory) { if (articleCategory == null) { throw new HimallException("未指定ArticleCategoryInfo实例"); } if (string.IsNullOrWhiteSpace(articleCategory.Name)) { throw new HimallException("未指定文章分类名称"); } //检查文章分类是否存在,排除0的父分类,0为根级 if (articleCategory.ParentCategoryId != 0 && Context.ArticleCategoryInfo.Count(item => item.Id == articleCategory.ParentCategoryId) == 0) { throw new HimallException("不存在父级为" + articleCategory.ParentCategoryId + "的文章分类"); } ArticleCategoryInfo oriArticleCategory = Context.ArticleCategoryInfo.FindById(articleCategory.Id); if (oriArticleCategory == null) { throw new HimallException("未找到id为" + articleCategory.Id + "的对象"); } //修改 oriArticleCategory.Name = articleCategory.Name; oriArticleCategory.ParentCategoryId = articleCategory.ParentCategoryId; Context.SaveChanges();//保存更改 }
public ActionResult Add(long?id, string name, long parentId) { ArticleCategoryInfo articleCategoryInfo = new ArticleCategoryInfo() { Id = id.GetValueOrDefault(), Name = name, ParentCategoryId = parentId }; ArticleCategoryInfo articleCategoryInfo1 = articleCategoryInfo; IArticleCategoryService articleCategoryService = ServiceHelper.Create <IArticleCategoryService>(); if (articleCategoryService.CheckHaveRename(articleCategoryInfo1.Id, articleCategoryInfo1.Name)) { return(Json(new { success = false, msg = "不可添加、修改为同名栏目!" })); } long?nullable = id; if ((nullable.GetValueOrDefault() <= 0 ? true : !nullable.HasValue)) { articleCategoryService.AddArticleCategory(articleCategoryInfo1); } else { articleCategoryService.UpdateArticleCategory(articleCategoryInfo1); } return(Json(new { success = true })); }
private void btnSubmitArticleCategory_Click(object sender, EventArgs e) { ArticleCategoryInfo articleCategory = ArticleHelper.GetArticleCategory(this.categoryId); if (articleCategory != null) { string text2 = articleCategory.IconUrl = this.UploadImage(); articleCategory.Name = this.txtArticleCategoryiesName.Text.Trim(); articleCategory.Description = this.txtArticleCategoryiesDesc.Text.Trim(); ValidationResults validationResults = Validation.Validate(articleCategory, "ValArticleCategoryInfo"); string text3 = string.Empty; if (!validationResults.IsValid) { foreach (ValidationResult item in (IEnumerable <ValidationResult>)validationResults) { text3 += Formatter.FormatErrorMessage(item.Message); } this.ShowMsg(text3, false); } else { this.UpdateCategory(articleCategory); } } }
public ActionResult Foot() { IArticleCategoryService articleCategoryService = ServiceHelper.Create <IArticleCategoryService>(); IArticleService articleService = ServiceHelper.Create <IArticleService>(); ArticleCategoryInfo specialArticleCategory = articleCategoryService.GetSpecialArticleCategory(SpecialCategory.PageFootService); if (specialArticleCategory == null) { return(base.PartialView("~/Areas/Web/Views/Shared/Foot.cshtml")); } IQueryable <ArticleCategoryInfo> articleCategoriesByParentId = articleCategoryService.GetArticleCategoriesByParentId(specialArticleCategory.Id, false); IEnumerable <PageFootServiceModel> array = from item in articleCategoriesByParentId.ToArray() select new PageFootServiceModel() { CateogryName = item.Name, Articles = from t in articleService.GetArticleByArticleCategoryId(item.Id) where t.IsRelease select t }; ViewBag.PageFootService = array; ViewBag.PageFoot = base.CurrentSiteSetting.PageFoot; ViewBag.QRCode = base.CurrentSiteSetting.QRCode; ViewBag.SiteName = base.CurrentSiteSetting.SiteName; return(base.PartialView("~/Areas/Web/Views/Shared/Foot.cshtml")); }
public bool CreateUpdateDeleteArticleCategory(ArticleCategoryInfo articleCategory, DataProviderAction action) { bool result; if (null == articleCategory) { result = false; } else { DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_ArticleCategory_CreateUpdateDelete"); this.database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action); this.database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4); if (action != DataProviderAction.Create) { this.database.AddInParameter(storedProcCommand, "CategoryId", DbType.Int32, articleCategory.CategoryId); } if (action != DataProviderAction.Delete) { this.database.AddInParameter(storedProcCommand, "Name", DbType.String, articleCategory.Name); this.database.AddInParameter(storedProcCommand, "IconUrl", DbType.String, articleCategory.IconUrl); this.database.AddInParameter(storedProcCommand, "Description", DbType.String, articleCategory.Description); } this.database.ExecuteNonQuery(storedProcCommand); result = ((int)this.database.GetParameterValue(storedProcCommand, "Status") == 0); } return(result); }
public int Insert(ArticleCategoryInfo model) { var parent = this.GetArticleCategoryById(model.ParentId); model.Id = KeyGenerator.Instance.GetNextValue("ArticleCategory"); using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertArticleCategory")) { cmd.SetParameterValue("@Id", model.Id); cmd.SetParameterValue("@Title", model.Title); cmd.SetParameterValue("@Name", model.Name); cmd.SetParameterValue("@UrlPath", model.UrlPath); cmd.SetParameterValue("@Keywords", model.Keywords); cmd.SetParameterValue("@MetaDesc", model.MetaDesc); cmd.SetParameterValue("@ParentId", model.ParentId); cmd.SetParameterValue("@MyLeft", parent.Lft); cmd.SetParameterValue("@Description", model.Description); cmd.SetParameterValue("@InUserId", model.InUserId); cmd.SetParameterValue("@InDate", model.InDate); cmd.SetParameterValue("@EditDate", model.EditDate); cmd.SetParameterValue("@EditUserId", model.EditUserId); cmd.SetParameterValue("@DisplayOrder", model.DisplayOrder); cmd.SetParameterValue("@DataStatus", model.DataStatus); cmd.SetParameterValue("@Type", model.CategoryType); return(cmd.ExecuteNonQuery()); } }
public int Update(ArticleCategoryInfo info) { int check = 1; ArticleCategoryInfo acinfo = getAllById(info.ac_id); if (info.ac_id != info.ac_fatherId) { List <ArticleCategoryInfo> checkinfos = GetallSortData(info.ac_id); foreach (ArticleCategoryInfo ckinfo in checkinfos) { if (ckinfo.ac_id == info.ac_fatherId) { check = 0; } } if (check == 1) { if (acinfo.ac_fatherId == info.ac_fatherId) { countmath = acinfo.ac_sorting; } else { countmath = GetDataByFatherIdAndLidOrderSortDESC(info.ac_fatherId, lidValue); result = UpdataSorting(acinfo.ac_fatherId, acinfo.ac_sorting); foreach (ArticleCategoryInfo sortinfo in result) { db.Update(sortinfo.ac_name, sortinfo.ac_sorting - 1, sortinfo.ac_type, sortinfo.ac_fatherId, sortinfo.l_id, sortinfo.ac_id); } } return(db.Update(info.ac_name, countmath, info.ac_type, info.ac_fatherId, info.l_id, info.ac_id)); } } return(check); }
protected void Page_Load(object sender, EventArgs e) { btnSubmitArticleCategory.Click += new EventHandler(btnSubmitArticleCategory_Click); btnPicDelete.Click += new EventHandler(btnPicDelete_Click); if (!int.TryParse(base.Request.QueryString["CategoryId"], out categoryId)) { base.GotoResourceNotFound(); } else if (!base.IsPostBack) { ArticleCategoryInfo articleCategory = ArticleHelper.GetArticleCategory(categoryId); if (articleCategory == null) { base.GotoResourceNotFound(); } else { Globals.EntityCoding(articleCategory, false); txtArticleCategoryiesName.Text = articleCategory.Name; txtArticleCategoryiesDesc.Text = articleCategory.Description; imgPic.ImageUrl = articleCategory.IconUrl; btnPicDelete.Visible = !string.IsNullOrEmpty(imgPic.ImageUrl); imgPic.Visible = !string.IsNullOrEmpty(imgPic.ImageUrl); } } }
public void UpdateArticleCategory(ArticleCategoryInfo articleCategory) { if (articleCategory == null) { throw new HimallException("未指定ArticleCategoryInfo实例"); } if (string.IsNullOrWhiteSpace(articleCategory.Name)) { throw new HimallException("未指定文章分类名称"); } //检查文章分类是否存在,排除0的父分类,0为根级 //if (articleCategory.ParentCategoryId != 0 && Context.ArticleCategoryInfo.Count(item => item.Id == articleCategory.ParentCategoryId) == 0) if (articleCategory.ParentCategoryId != 0 && !DbFactory.Default.Get <ArticleCategoryInfo>().Where(item => item.Id == articleCategory.ParentCategoryId).Exist()) { throw new HimallException("不存在父级为" + articleCategory.ParentCategoryId + "的文章分类"); } //ArticleCategoryInfo oriArticleCategory = Context.ArticleCategoryInfo.FirstOrDefault(p => p.Id == articleCategory.Id); ArticleCategoryInfo oriArticleCategory = DbFactory.Default.Get <ArticleCategoryInfo>().Where(p => p.Id == articleCategory.Id).FirstOrDefault(); if (oriArticleCategory == null) { throw new HimallException("未找到id为" + articleCategory.Id + "的对象"); } //修改 oriArticleCategory.Name = articleCategory.Name; oriArticleCategory.ParentCategoryId = articleCategory.ParentCategoryId; //Context.SaveChanges();//保存更改 DbFactory.Default.Update(oriArticleCategory); }
protected void Page_Load(object sender, System.EventArgs e) { this.btnSubmitArticleCategory.Click += new System.EventHandler(this.btnSubmitArticleCategory_Click); this.btnPicDelete.Click += new System.EventHandler(this.btnPicDelete_Click); if (!int.TryParse(base.Request.QueryString["CategoryId"], out this.categoryId)) { base.GotoResourceNotFound(); return; } if (!base.IsPostBack) { ArticleCategoryInfo articleCategory = SubsiteCommentsHelper.GetArticleCategory(this.categoryId); if (articleCategory == null) { base.GotoResourceNotFound(); return; } Globals.EntityCoding(articleCategory, false); this.txtArticleCategoryiesName.Text = articleCategory.Name; this.txtArticleCategoryiesDesc.Text = articleCategory.Description; this.imgPic.ImageUrl = articleCategory.IconUrl; this.btnPicDelete.Visible = !string.IsNullOrEmpty(this.imgPic.ImageUrl); this.imgPic.Visible = !string.IsNullOrEmpty(this.imgPic.ImageUrl); } }
protected void InitInfo() { categoryId = CECRequest.GetQueryInt("categoryid", 0); Action = CECRequest.GetQueryString("action"); if (Action == "del") { bool isDelete = ArticleCategoryManage.DeleteCategory(categoryId); if (!isDelete) { Page.ClientScript.RegisterStartupScript(this.GetType(), "DelError", "alert('该分类可能有字分类,请先删掉子分类!');window.location.href='categorylist.aspx';", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "DeleSuccess", "alert('删除成功!');window.location.href='categorylist.aspx';", true); } return; } this.ddlcategoryList.BuildTree(ArticleCategoryManage.GetArticleCategoryTable(), "CategoryName", "CategoryId"); this.ddlcategoryList.SelectedValue = categoryId.ToString(); if (Action.ToLower() == "edit") { categoryInfo = ArticleCategoryManage.GetArticleCategoryInfo(categoryId); this.ddlcategoryList.SelectedValue = categoryInfo.ParentId.ToString(); } }
protected void Bind() { ArticleCategoryInfo info = acBLL.getAllById(id); if (info.ac_id != 0) { lbTitle.Text = info.ac_name; } }
protected override void AttachChildControls() { int.TryParse(this.Page.Request.QueryString["categoryId"], out this.categoryId); this.txtCategoryName = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtCategoryName"); this.txtCategoryId = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtCategoryId"); this.keyWord = this.Page.Request.QueryString["keyWord"]; if (!string.IsNullOrWhiteSpace(this.keyWord)) { this.keyWord = this.keyWord.Trim(); } this.rptArticles = (VshopTemplatedRepeater)this.FindControl("rptArticles"); this.txtTotalPages = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtTotal"); int pageIndex; if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex)) { pageIndex = 1; } int pageSize; if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize)) { pageSize = 20; } ArticleQuery articleQuery = new ArticleQuery(); if (!string.IsNullOrEmpty(this.Page.Request.QueryString["CategoryId"])) { int value = 0; if (int.TryParse(this.Page.Request.QueryString["CategoryId"], out value)) { ArticleCategoryInfo articleCategory = CommentBrowser.GetArticleCategory(value); if (articleCategory != null) { PageTitle.AddSiteNameTitle(articleCategory.Name); articleQuery.CategoryId = new int?(value); this.txtCategoryId.Value = value.ToString(); this.txtCategoryName.Value = articleCategory.Name; } else { PageTitle.AddSiteNameTitle("文章分类搜索页"); } } } articleQuery.Keywords = this.keyWord; articleQuery.PageIndex = pageIndex; articleQuery.PageSize = pageSize; articleQuery.SortBy = "AddedDate"; articleQuery.SortOrder = SortAction.Desc; DbQueryResult articleList = CommentBrowser.GetArticleList(articleQuery); this.rptArticles.DataSource = articleList.Data; this.rptArticles.DataBind(); int totalRecords = articleList.TotalRecords; this.txtTotalPages.SetWhenIsNotNull(totalRecords.ToString()); }
public static bool UpdateArticleCategory(ArticleCategoryInfo articleCategory) { if (null == articleCategory) { return(false); } Globals.EntityCoding(articleCategory, true); return(new ArticleCategoryDao().CreateUpdateDeleteArticleCategory(articleCategory, DataProviderAction.Update)); }
public static bool UpdateArticleCategory(ArticleCategoryInfo articleCategory) { if (articleCategory == null) { return(false); } Globals.EntityCoding(articleCategory, true); return(new ArticleCategoryDao().Update(articleCategory, null)); }
public static bool CreateArticleCategory(ArticleCategoryInfo articleCategory) { if (null == articleCategory) { return(false); } Globals.EntityCoding(articleCategory, true); return(CommentsProvider.Instance().CreateUpdateDeleteArticleCategory(articleCategory, DataProviderAction.Create)); }
public string getTitle(int id) { if (id == 0) { return("此項目為主類別"); } ArticleCategoryInfo info = acBLL.getAllById(id); return(info.ac_name); }
private void SearchHierarchyVailNow(int fid) { ArticleCategoryInfo info = getAllById(fid); if (info.ac_id != 0) { HerichCountMath += 1; SearchHierarchyVailNow(info.ac_fatherId); } }
public JsonResult List(int rows, int page) { ArticleCategoryInfo specialArticleCategory = ServiceHelper.Create <IArticleCategoryService>().GetSpecialArticleCategory(SpecialCategory.PlatformNews); PageModel <ArticleInfo> pageModel = ServiceHelper.Create <IArticleService>().Find(new long?(specialArticleCategory.Id), "", rows, page, false); var array = from item in pageModel.Models.ToArray() select new { id = item.Id, addDate = item.AddDate.ToString("yyyy-MM-dd"), title = item.Title }; return(Json(new { rows = array, total = pageModel.Total })); }
private void AddNewCategory(ArticleCategoryInfo category) { if (SubsiteCommentsHelper.CreateArticleCategory(category)) { this.Reset(); this.ShowMsg("成功添加了一个文章分类", true); return; } this.ShowMsg("未知错误", false); }
public List <ArticleCategoryInfo> UpdataSorting(int fatherid, int sorting) { List <ArticleCategoryInfo> infos = new List <ArticleCategoryInfo>(); IDataReader reader = db.UpdataSorting(fatherid, sorting, lidValue).CreateDataReader(); while (reader.Read()) { infos.Add(ArticleCategoryInfo.Populate(reader)); } return(infos); }
private void UpdateCategory(ArticleCategoryInfo category) { if (ArticleHelper.UpdateArticleCategory(category)) { base.CloseWindow(null); } else { this.ShowMsg("未知错误", false); } }
public void UpdateArticleCategoryDisplaySequence(long id, long displaySequence) { ArticleCategoryInfo articleCategoryInfo = context.ArticleCategoryInfo.FindById <ArticleCategoryInfo>(id); if (articleCategoryInfo == null) { throw new HimallException(string.Concat("未找到id为", id, "的对象")); } articleCategoryInfo.DisplaySequence = displaySequence; context.SaveChanges(); }
public void UpdateArticleCategoryName(long id, string name) { ArticleCategoryInfo articleCategoryInfo = context.ArticleCategoryInfo.FindById <ArticleCategoryInfo>(id); if (articleCategoryInfo == null) { throw new HimallException(string.Concat("未找到id为", id, "的对象")); } articleCategoryInfo.Name = name; context.SaveChanges(); }