public ActionResult LabelCategory(int page, int label_id) //博客栏目页面
{
tb_set_article_label[] tb_Sets = db.tb_set_article_label.SqlQuery("select * from tb_set_article_label where label_id = " + label_id).ToArray();
tb_articles[] articles = new tb_articles[4];
if (tb_Sets.Length > 0)
{
for (int i = (page - 1); i < page; i++)
{
int Out = 0;
for (int j = (i * 4); j < tb_Sets.Length; j++)
{
articles[Out] = db.tb_articles.SqlQuery("select * from tb_articles where article_id = " + tb_Sets[j].article_id).FirstOrDefault();
Out++;
if (Out == 4)
{
break;
}
}
}
}
HttpContext.Session["labelpage"] = page;
HttpContext.Session["label_id"] = label_id;
HttpContext.Session["articleCount"] = (page - 1) * 4;
return(View(articles));
}
public ActionResult DeleteConfirmed(long id)
{
tb_articles tb_articles = db.tb_articles.Find(id);
db.tb_articles.Remove(tb_articles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Articles/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_articles tb_articles = db.tb_articles.Find(id);
if (tb_articles == null)
{
return(HttpNotFound());
}
return(View(tb_articles));
}
//GET:Articles/UpdateArticle/5
public ActionResult UpdateArticle(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_articles tb_articles = db.tb_articles.Find(id);
if (tb_articles == null)
{
return(HttpNotFound());
}
Handler.id = Convert.ToInt32(id);
return(View(tb_articles));
}
// GET: Articles/Delete/5
public ActionResult Delete(long?id)
{
tb_articles tb_articles = db.tb_articles.Find(id);
tb_set_article_sort set_sort = db.tb_set_article_sort.SqlQuery("select * from tb_set_article_sort where article_id =" + id).FirstOrDefault();
db.tb_set_article_sort.Remove(set_sort);
tb_set_article_label[] set_label = db.tb_set_article_label.SqlQuery("select * from tb_set_article_label where article_id =" + id).ToArray();
foreach (var item in set_label)
{
db.tb_set_article_label.Remove(item);
}
db.tb_articles.Remove(tb_articles);
db.SaveChanges();
CommanFile actionFile = new CommanFile();
actionFile.DeleteFile(Convert.ToString(id + 1000));
return(Redirect("/YjLihouT/Articles/Article?page=1"));
}
public ActionResult article(int id) //文章中转站
{
tb_articles articles = db.tb_articles.Find(id);
articles.article_views++;
db.tb_articles.Attach(articles);
db.Entry(articles).State = EntityState.Modified;
db.SaveChanges();
string filename = Convert.ToString(id + 1000);
CommanFile comfile = new CommanFile();
Handler.id = id;
if (comfile.CopyFileBool(filename))
{
return(RedirectToAction("../../articles/" + filename + ".html"));
}
return(RedirectToAction("/Home/Index"));
}
//改变文章标签
public void ArticleLabel(tb_articles articles, tb_labels label, string item)
{
if (label != null)
{
tb_set_article_label article_label = db.tb_set_article_label.SqlQuery("select * from tb_set_article_label where label_id =" + label.label_id).FirstOrDefault(); //指定文章标签id
article_label.label_id = label.label_id; //给定标签id
article_label.article_id = articles.article_id; //给文章id
db.tb_set_article_label.Attach(article_label);
db.Entry(article_label).State = EntityState.Modified;
db.SaveChanges();
}
else
{
tb_labels add_label = new tb_labels();
add_label.label_name = item;
tb_sorts sorts = db.tb_sorts.SqlQuery("select * from tb_sorts where sort_id = " + Convert.ToInt32(HttpContext.Request.Form["category"])).FirstOrDefault();
add_label.label_alias = sorts.sort_name;
add_label.label_description = "";
db.tb_labels.Add(add_label);
db.SaveChanges();
}
}
public ActionResult Add([Bind(Include = "article_id,user_id,article_title,article_content,article_description,article_label_img,article_views,article_comment_count,article_date,article_like_count")] tb_articles tb_articles)
{
if (ModelState.IsValid)
{
tb_articles.user_id = 1;
tb_articles.article_title = HttpContext.Request.Form["title"];
tb_articles.article_content = HttpContext.Request.Form["content"];
tb_articles.article_description = HttpContext.Request.Form["describe"]; //文章描述
tb_articles.article_label_img = HttpContext.Request.Form["titlepic"]; //文章标签图片地址
tb_articles.article_views = 0; //流量量
tb_articles.article_comment_count = 0; //评论总数
tb_articles.article_date = Convert.ToDateTime(DateTime.Now.ToString());
tb_articles.article_like_count = 0; //点赞数
//文章设置关键字
if (HttpContext.Request.Form["keywords"] != "")
{
tb_articles.article_keyword = HttpContext.Request.Form["keywords"];
}
db.tb_articles.Add(tb_articles);
db.SaveChanges();
tb_articles now_article = db.tb_articles.SqlQuery("select * from tb_articles order by article_id desc").FirstOrDefault();
//文章设置分类
tb_set_article_sort article_sort = new tb_set_article_sort();
article_sort.article_id = now_article.article_id;
article_sort.sort_id = Convert.ToInt32(HttpContext.Request.Form["category"]);
db.tb_set_article_sort.Add(article_sort);
db.SaveChanges();
//文章设置标签表
string[] label;
if (HttpContext.Request.Form["tags"] != "")/* || HttpContext.Request.Form["keywords"] != ""*/
{
label = HttpContext.Request.Form["tags"].Split(',');
List <string> strList = new List <string>(label);
for (int i = 0; i < label.Length; i++)
{
if (label[i] == "")
{
strList.RemoveAt(i);
}
}
foreach (string item in strList)
{
tb_labels labels = db.tb_labels.SqlQuery("select * from tb_labels where label_name = '" + item + "'").FirstOrDefault();
if (labels != null)
{
tb_set_article_label article_label = new tb_set_article_label();
article_label.article_id = now_article.article_id; //给定文章id
article_label.label_id = labels.label_id; //给定标签id
db.tb_set_article_label.Add(article_label);
db.SaveChanges();
}
}
}
return(Redirect("/YjLihouT/Articles/Article?page=1"));
}
return(View(tb_articles));
}
public ActionResult UpdateArticle([Bind(Include = "article_id,user_id,article_title,article_content,article_description,article_label_img,article_views,article_comment_count,article_date,article_like_count")] tb_articles tb_articles, long?id)
{
if (ModelState.IsValid)
{
//修改需要对主键赋值，注意：这里需要对所有字段赋值，没有赋值的字段会用NULL更新到数据库
tb_articles = db.tb_articles.SqlQuery("select * from tb_articles where article_id = '" + id + "'").FirstOrDefault();
tb_articles.article_id = Convert.ToInt32(id);
tb_articles.article_title = HttpContext.Request.Form["title"];
tb_articles.article_content = HttpContext.Request.Form["content"];
tb_articles.article_date = Convert.ToDateTime(DateTime.Now.ToString());
tb_articles.article_description = HttpContext.Request.Form["describe"]; //文章描述
tb_articles.article_label_img = HttpContext.Request.Form["titlepic"]; //文章标签图片地址
tb_articles.article_keyword = HttpContext.Request.Form["keywords"]; //文章关键字
//将实体附加到对象管理器中
db.tb_articles.Attach(tb_articles);
//获取到user的状态实体，可以修改其状态
var setEntry = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(tb_articles);
setEntry.SetModifiedProperty("article_title");
setEntry.SetModifiedProperty("article_content");
setEntry.SetModifiedProperty("article_date");
if (tb_articles.article_label_img != "")
{
setEntry.SetModifiedProperty("article_label_img");
}
if (tb_articles.article_description != "")
{
setEntry.SetModifiedProperty("article_description");
}
if (tb_articles.article_keyword != "")
{
setEntry.SetModifiedProperty("article_keyword");
}
//文章设置标签表
string[] labels;
tb_set_article_label[] article_labels = db.tb_set_article_label.SqlQuery("select * from tb_set_article_label where article_id =" + tb_articles.article_id).ToArray();
if (HttpContext.Request.Form["tags"] != "")/* || HttpContext.Request.Form["keywords"] != ""*/
{
labels = HttpContext.Request.Form["tags"].Split(',');
List <string> strList = new List <string>(labels);
for (int i = 0; i < labels.Length; i++)
{
if (labels[i] == "")
{
strList.RemoveAt(i);
}
}
if (article_labels.Length == strList.Count())
{
foreach (string item in strList)
{
tb_labels label = db.tb_labels.SqlQuery("select * from tb_labels where label_name = '" + item + "'").FirstOrDefault();
if (label != null)
{
ArticleLabel(tb_articles, label, item);
db.SaveChanges();
}
}
}
if (article_labels.Length > strList.Count())
{
for (int i = 0; i < article_labels.Length; i++)
{
tb_labels label = db.tb_labels.Find(article_labels[i].label_id);
for (int j = 0; j < strList.Count(); j++)
{
if (label.label_name != strList[j])
{
db.tb_set_article_label.Remove(article_labels[i]);
db.SaveChanges();
}
}
}
//for (int i = 0; i < labels.Length; i++)
//{
// tb_labels label = db.tb_labels.SqlQuery("select * from tb_labels where label_name = '" + labels[i] + "'").FirstOrDefault();
// ArticleLabel(tb_articles, label, labels[i]);
// db.SaveChanges();
//}
}
if (article_labels.Length < strList.Count())
{
for (int i = article_labels.Length; i < strList.Count(); i++)
{
for (int j = 0; j < strList.Count(); j++)
{
for (int k = 0; k < article_labels.Length; k++)
{
tb_labels label2 = db.tb_labels.SqlQuery("select * from tb_labels where label_id = '" + article_labels[k].label_id + "'").FirstOrDefault();
if (label2.label_name != strList[j])
{
tb_labels label = db.tb_labels.SqlQuery("select * from tb_labels where label_name = '" + strList[j] + "'").FirstOrDefault();
if (label != null)
{
tb_set_article_label article_Label = new tb_set_article_label();
article_Label.article_id = tb_articles.article_id;
article_Label.label_id = label.label_id;
db.tb_set_article_label.Add(article_Label);
db.SaveChanges();
}
}
}
}
;
}
}
}
;
return(Redirect("/YjLihouT/Articles/Article?page=1"));
}
return(View(tb_articles));
}
private void GetArticle(HttpContext context) //获得文章对象将转化为json数据类型
{
tb_articles articles = db.tb_articles.Find(id);
context.Response.Write(f.StToJSON(articles));
}
