//栏目，标签值
private void GetSortAndLabel(HttpContext context)
{
tb_set_article_sort set_sort = db.tb_set_article_sort.SqlQuery("select * from tb_set_article_sort where article_id =" + context.Request.Form["sort"]).FirstOrDefault();
tb_sorts sort = db.tb_sorts.Find(set_sort.sort_id);
tb_set_article_label[] set_label = db.tb_set_article_label.SqlQuery("select * from tb_set_article_label where article_id = " + context.Request.Form["label"]).ToArray();
tb_labels label = new tb_labels();
string[] json = new string[set_label.Length];
for (int i = 0; i < set_label.Length; i++)
{
label = db.tb_labels.Find(Convert.ToInt32(set_label[i].label_id));
json[i] = f.OjToJson(label);
json[i] = json[i].Replace("\"", "\\\"");
json[i] = json[i].Replace(Convert.ToString('"'), "\\'");
json[i] = "\\\"json" + (i + 1) + "\\\":\\\"" + json[i] + "\\\"";
}
string labelStr = "{" + (string.Join(",", json)) + "}";
//string json1 = f.StToJSON(sort.sort_name);
//string json2 = f.StToJSON(label.label_name);
string sortStr = f.OjToJson(sort);
sortStr = sortStr.Replace("\"", "\\\"");
//context.Response.Write("{\"sort_name\":\"" + json1 + "\",\"label_name\":\"" + json2 + "\"}");
context.Response.Write("{\"sort\":\"" + sortStr + "\",\"label\":\"" + labelStr + "\"}");
}
// 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"));
}
//指定文章标签和分类
private void ArticleOfSortOrLabel(HttpContext context)
{
string sortname = "", labelname = "";
tb_set_article_sort article_sort = db.tb_set_article_sort.SqlQuery("select * from tb_set_article_sort where article_id = " + id).FirstOrDefault();
tb_set_article_label[] article_label = db.tb_set_article_label.SqlQuery("select * from tb_set_article_label where article_id = " + id).ToArray();
if (article_sort != null && article_label.Length > 0)
{
tb_sorts sort = db.tb_sorts.Find(article_sort.sort_id);
sortname = sort.sort_name;
for (int i = 0; i < article_label.Length; i++)
{
tb_labels label = db.tb_labels.Find(article_label[i].label_id);
labelname += label.label_name;
if (i != article_label.Length - 1)
{
labelname += ",";
}
}
}
context.Response.Write("{\"sortname\":\"" + sortname + "\",\"labelname\":\"" + labelname + "\"}");
}
public ActionResult DeleteAll()
{
tb_articles[] articles = db.tb_articles.SqlQuery("select * from tb_articles").ToArray();
foreach (tb_articles item in articles)
{
string checkbox = HttpContext.Request.Form["checkbox&" + item.article_id];
if (checkbox != null)
{
tb_set_article_sort set_sort = db.tb_set_article_sort.SqlQuery("select * from tb_set_article_sort where article_id =" + item.article_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 =" + item.article_id).ToArray();
foreach (var item2 in set_label)
{
db.tb_set_article_label.Remove(item2);
}
db.tb_articles.Remove(item);
db.SaveChanges();
CommanFile actionFile = new CommanFile();
actionFile.DeleteFile(Convert.ToString(item.article_id + 1000));
}
}
return(Redirect("/YjLihouT/Articles/Article?page=1"));
}
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));
}
