/// <summary> /// 删除文章(基础) /// </summary> /// <param name="varticle"></param> public void DelBaseArticle(int id,int parentid) { using (YQBlogEntities entity = new YQBlogEntities()) { entity.fun_articledel(id, parentid); } }
/// <summary> /// 添加文章 /// </summary> public int AddArticle(blog_varticle varticle) { using (YQBlogEntities entity = new YQBlogEntities()) { blog_varticle obj = varticle; entity.blog_varticle.AddObject(obj); entity.SaveChanges(); return obj.id; } }
/// <summary> /// 更新文章(VArticle整体更新) /// </summary> public void UpdateVArticle(blog_varticle varticle) { using (YQBlogEntities entity = new YQBlogEntities()) { var obj = entity.blog_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(blog_varticle varitcle) { using (YQBlogEntities entity = new YQBlogEntities()) { var query = entity.blog_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(); } } }