/// <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("添加失败，请重新尝试!"));
}
}
}
