/// <summary> /// 添加各种选项 /// </summary> /// <param name="articleId">文章ID</param> /// <param name="ops">一级选项名字,二级选项名字</param> /// <returns></returns> public static bool addOptions(int articleId, Dictionary <string, string> ops) { List <int> opsls = new List <int>(); foreach (KeyValuePair <string, string> s in ops) { opsls.Add(LabelHelper.getOptionId(s.Key, s.Value)); } try { using (var db = new PaperDbEntities()) { //增加所有选项 foreach (int id in opsls) { TypeConnection tc = new TypeConnection(); tc.ArticleId = articleId; tc.OptionId = id; db.TypeConnection.Add(tc); } db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
/// <summary> /// 移除某一个类型(关键字,一级类型,二级类型) /// </summary> /// <param name="rmId">移除项目的ID</param> /// <param name="queryString">移除项目的类型(keyword,firstLevel,secondLevel)</param> /// <returns>是否移除成功</returns> public static bool removeItem(int rmId, string queryString) { try { using (var db = new PaperDbEntities()) { switch (queryString) { case "keyword": KeyWords keyword = db.KeyWords.Single(a => a.id == rmId); db.KeyWords.Remove(keyword); break; case "firstLevel": Category category = db.Category.Single(a => a.id == rmId); db.Category.Remove(category); break; case "secondLevel": Option option = db.Option.Single(a => a.id == rmId); db.Option.Remove(option); break; } db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
/// <summary> /// 删除文章 /// </summary> /// <param name="articleID">文章ID</param> /// <returns></returns> public static bool delArticle(int articleID) { try { using (var db = new PaperDbEntities()) { Article ar = db.Article.SingleOrDefault(a => a.id == articleID); db.Article.Remove(ar); db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
/// <summary> /// 更新文章 /// </summary> /// <param name="newAr">待更新文章对象</param> /// <returns>是否添加成功</returns> public static bool updateArticle(Article newAr) { try { using (var db = new PaperDbEntities()) { Article oldAr = db.Article.Single(a => a.id == newAr.id); db.Entry(oldAr).CurrentValues.SetValues(newAr); db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
/// <summary> /// 添加新文章 /// </summary> /// <param name="ar">待添加文章对象</param> /// <returns>添加成功返回文章ID,否则返回-1</returns> public static int addArticle(Article ar) { try { using (var db = new PaperDbEntities()) { db.Article.Add(ar); db.SaveChanges(); Article tmp = db.Article.Single(a => a.Title == ar.Title && a.Author == ar.Author); return(tmp.id); } } catch (Exception ex) { return(-1); } }
/// <summary> /// 删除文章类型选项记录 /// </summary> /// <param name="typeConnId"></param> /// <returns></returns> public static bool delTypeConnection(List <int> typeConnId) { try { using (var db = new PaperDbEntities()) { foreach (int id in typeConnId) { TypeConnection kc = db.TypeConnection.Single(a => a.id == id); db.TypeConnection.Remove(kc); } db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
/// <summary> /// 添加各种选项,通过给出optionId /// </summary> /// <param name="articleId"></param> /// <param name="opsId"></param> /// <returns></returns> public static bool addOptions(int articleId, List <int> opsId) { try { using (var db = new PaperDbEntities()) { foreach (int i in opsId) { TypeConnection tc = new TypeConnection(); tc.ArticleId = articleId; tc.OptionId = i; db.TypeConnection.Add(tc); } db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
protected void btnSecondLevel_Click(object sender, EventArgs e) { string secondLevelVal = txtSecondLevel.Text.Trim(); if (secondLevelVal.Equals(string.Empty)) { Response.Write(JSHelper.alert("二级分类不能为空,请重新输入!")); } else { try { using (var db = new PaperDbEntities()) { Category c = db.Category.Single(a => a.Name == dplFirstLevel.SelectedValue); Option tmp = db.Option.SingleOrDefault(a => a.Name == secondLevelVal && a.CategoryId == c.id); if (tmp == null) { Option secondLevel = new Option(); secondLevel.Name = secondLevelVal; secondLevel.CategoryId = LabelHelper.getCategoryIdByName(dplFirstLevel.SelectedValue); db.Option.Add(secondLevel); db.SaveChanges(); Response.Write(JSHelper.alert("添加成功!", "manageLabel.aspx")); } else { Response.Write(JSHelper.alert("二级分类重复,请检查!")); } } } catch (Exception ex) { //ex.Message; Response.Write(JSHelper.alert("添加失败,请重新尝试!")); } } }
/// <summary> /// 添加关键字 /// </summary> /// <param name="articleId">文章id</param> /// <param name="keywordId">关键字id 列表</param> /// <returns>是否成功</returns> public static bool addKeywords(int articleId, List <int> keywordId) { try { using (var db = new PaperDbEntities()) { //增加所有关键字 foreach (int id in keywordId) { KeyWordConnection kc = new KeyWordConnection(); kc.ArticleId = articleId; kc.KeyWordId = id; db.KeyWordConnection.Add(kc); } db.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
protected void btnFirstLevel_Click(object sender, EventArgs e) { string firstLevelVal = txtFirstLevel.Text.Trim(); if (firstLevelVal.Equals(string.Empty)) { Response.Write(JSHelper.alert("一级分类不能为空,请重新输入!")); } else { try { using (var db = new PaperDbEntities()) { Category tmp = db.Category.SingleOrDefault(a => a.Name == firstLevelVal); if (tmp == null) { Category firstLevel = new Category(); firstLevel.Name = firstLevelVal; db.Category.Add(firstLevel); db.SaveChanges(); Response.Write(JSHelper.alert("添加成功!", "manageLabel.aspx")); } else { Response.Write(JSHelper.alert("一级分类重复,请检查!")); } } } catch (Exception ex) { //ex.Message; Response.Write(JSHelper.alert("添加失败,请重新尝试!")); } } }
protected void btnKeyword_Click(object sender, EventArgs e) { string keywordvalu = txtKeyword.Text.Trim(); if (keywordvalu.Equals(string.Empty)) { Response.Write(JSHelper.alert("关键词不能为空,请重新输入!")); } else { try { using (var db = new PaperDbEntities()) { KeyWords tmp = db.KeyWords.SingleOrDefault(a => a.Name == keywordvalu); if (tmp == null) { KeyWords keyword = new KeyWords(); keyword.Name = keywordvalu; db.KeyWords.Add(keyword); db.SaveChanges(); Response.Write(JSHelper.alert("添加成功!", "manageLabel.aspx")); } else { Response.Write(JSHelper.alert("关键词重复,请检查!")); } } } catch (Exception ex) { //ex.Message; Response.Write(JSHelper.alert("添加失败,请重新尝试!")); } } }