/// <summary>
/// 添加文章
/// </summary>
/// <param name="varticle"></param>
public int AddArticle(cms_varticle varticle)
{
using (CmsEntities entity = new CmsEntities())
{
cms_varticle obj = varticle;
entity.cms_varticle.AddObject(obj);
entity.SaveChanges();
return obj.id;
}
}
/// <summary>
/// 删除文章
/// </summary>
/// <param name="varticle"></param>
public void DelArticle(cms_varticle varticle)
{
using (CmsEntities entity = new CmsEntities())
{
var query = entity.cms_varticle.FirstOrDefault(m => m.id == varticle.id);
if (query != null)
{
entity.cms_varticle.DeleteObject(query);
entity.SaveChanges();
}
}
}
/// <summary>
/// 获取论坛板块信息 CategoryModel
/// </summary>
public BbsBoardModel GetBbsBoard(CategoryModel c)
{
cms_varticle lastpost = new cms_varticle();
BbsBoardModel board = new BbsBoardModel();
if (c != null)
{
board = GetBbsBoardStat(Utils.StrToInt(c.CateId));
board.CateId = c.CateId;
board.Path = c.Path;
board.CateName = c.CateName;
board.ReName = c.ReName;
board.SubCount = c.SubCount;
board.ReplyPermit = c.ReplyPermit;
board.ParentId = c.ParentId;
}
return board;
}
public ActionResult AdminAdd(ArticleModel model)
{
//添加[ValidateInput(false)]特性，否则提交内容有html代码会报错
if (ModelState.IsValid)
{
cms_varticle obj = new cms_varticle();
CategoryModel category = cmsService.GetCategoryByID(model.CateId);
obj.articleid = 0;
obj.typeid = Utils.StrToInt(category.Type);
obj.cateid = model.CateId;
obj.catename = category.CateName;
obj.catepath = category.Path; ;
obj.title = Utils.FileterStr(model.Title);
obj.summary = Utils.FileterStr(Server.UrlDecode(model.Summary));
obj.content = Utils.FileterStr(Server.UrlDecode(Utils.DownloadImages(model.Content, "/Content"+configinfo.WebPath+"Upload/", configinfo.Weburl)));
obj.ip = Utils.GetIP();
obj.tags = (string.IsNullOrWhiteSpace(model.Tags) ? "" : model.Tags).Trim();
obj.layer = 0;
obj.orderid = 1;
obj.parentid = 0;
obj.replypermit = model.ReplyPermit;
obj.seodescription = Utils.RemoveHtml((string.IsNullOrWhiteSpace(model.SeoDescription) ? "" : model.SeoDescription)).Trim();
obj.seokeywords = Utils.RemoveHtml((string.IsNullOrWhiteSpace(model.Seokeywords) ? "" : model.Seokeywords)).Trim();
obj.seometas = string.IsNullOrWhiteSpace(model.SeoMetas) ? "" : model.SeoMetas;
obj.seotitle = Utils.RemoveHtml((string.IsNullOrWhiteSpace(model.SeoTitle) ? "" : model.SeoTitle)).Trim();
obj.rename = Utils.RemoveHtml((string.IsNullOrWhiteSpace(model.ReName) ? "" : model.ReName)).Trim();
obj.status = model.Status;
obj.userid = 1;
obj.username = User.Identity.Name;
obj.iscommend = model.IsCommend;
obj.istop = model.IsTop;
int re=cmsService.AddArticle(obj);
return Redirect(configinfo.WebPath+"Admin/AdminArticle/?tid="+obj.typeid);
}
return View(model);
}
//文章链接url
public static string GetArticleUrl(cms_varticle varticle)
{
return configinfo.WebPath + (!string.IsNullOrWhiteSpace(varticle.rename) ? "article/" + varticle.rename : "archive/" + varticle.id.ToString());
}
/// <summary>
/// 更新文章(VArticle整体更新)
/// </summary>
/// <param name="varticle"></param>
public void UpdateVArticle(cms_varticle varticle)
{
using (CmsEntities entity = new CmsEntities())
{
var obj = entity.cms_varticle.FirstOrDefault(m => m.id == varticle.id);
if (obj != null)
{
obj.title = varticle.title;
obj.cateid = varticle.cateid;
obj.catename = varticle.catename;
obj.catepath = varticle.catepath;
obj.summary = varticle.summary;
obj.content = varticle.content;
obj.tags = varticle.tags;
obj.seodescription = varticle.seodescription;
obj.seokeywords = varticle.seokeywords;
obj.seometas = varticle.seometas;
obj.seotitle = varticle.seotitle;
obj.rename = varticle.rename;
obj.status = varticle.status;
obj.replypermit = varticle.replypermit;
obj.iscommend = varticle.iscommend;
obj.istop = varticle.istop;
entity.SaveChanges();
}
}
}
/// <summary>
/// 更新文章(Article表更新)
/// </summary>
public void UpdateArticle(cms_varticle varitcle)
{
using (CmsEntities entity = new CmsEntities())
{
var query = entity.cms_article.FirstOrDefault(m => m.id == varitcle.id);
if (query != null)
{
query.typeid = varitcle.typeid;
query.cateid = varitcle.cateid;
query.catepath = varitcle.catepath;
query.articleid = varitcle.articleid;
query.parentid = varitcle.parentid;
query.layer = varitcle.layer;
query.subcount = varitcle.subcount;
query.catename = varitcle.catename;
query.userid = varitcle.userid;
query.username = varitcle.username;
query.title = varitcle.title;
query.summary = varitcle.summary;
query.content = varitcle.content;
query.viewcount = varitcle.viewcount;
query.orderid = varitcle.orderid;
query.replypermit = varitcle.replypermit;
query.status = varitcle.status;
query.ip = varitcle.ip;
query.favor = varitcle.favor;
query.against = varitcle.against;
query.createdate = varitcle.createdate;
entity.SaveChanges();
}
}
}
/// <summary>
/// 文章修改
/// </summary>
public ActionResult AdminEdit(int id)
{
ViewBag.CI = configinfo;
//根据ID获取文章信息
cms_varticle obj = new cms_varticle();
obj = cmsService.GetArticleByID(id);
//把修改操作需要的字段赋给ArticleModel对象
ArticleModel model = new ArticleModel();
model.ID = obj.id;
model.CateId = obj.cateid;
model.Title = Utils.FileterStr(obj.title);
model.Summary = string.IsNullOrWhiteSpace(obj.summary) ? "" : obj.summary;
model.Content = string.IsNullOrWhiteSpace(obj.content) ? "" : obj.content;
model.Tags = string.IsNullOrWhiteSpace(obj.tags) ? "" : obj.tags;
model.SeoDescription = string.IsNullOrWhiteSpace(obj.seodescription) ? "" : obj.seodescription;
model.Seokeywords = string.IsNullOrWhiteSpace(obj.seokeywords) ? "" : obj.seokeywords;
model.SeoMetas = string.IsNullOrWhiteSpace(obj.seometas) ? "" : obj.seometas;
model.SeoTitle = string.IsNullOrWhiteSpace(obj.seotitle) ? "" : obj.seotitle;
model.ReName = string.IsNullOrWhiteSpace(obj.rename) ? "" : obj.rename;
model.Status = obj.status;
model.ReplyPermit = obj.replypermit;
model.IsCommend = obj.iscommend;
model.IsTop = obj.istop;
ViewData["CateId"] = new SelectList(cmsService.getFCategoryList(obj.typeid.ToString(),""," -- "), "CateId", "CateName", model.CateId);
return View(model);
}
public ActionResult AdminDel(int id, int parentid)
{
try
{
cms_varticle obj = new cms_varticle();
obj.id = id;
obj.parentid = parentid;
cmsService.DelArticle(obj);
}
catch (Exception)
{
return Content( "删除失败！", "text/html;charset=UTF-8");
}
return Content("删除成功！", "text/html;charset=UTF-8");
}
