public ActionResult Delete(int ID, int Type)
{
var BlogModel = new BlogViewModels();
if (Type == 0)
{
var Emergency = db.Emergency.Where(r => r.School.Equals(SchoolID)).Where(r => r.ID == ID).FirstOrDefault();
if (Emergency != null)
{
Emergency.Delete = 1;
}
}
else if (Type == 1)
{
var News = db.NewsClass.Where(r => r.School.Equals(SchoolID)).Where(r => r.ID == ID).FirstOrDefault();
if (News != null)
{
News.Delete = 1;
}
}
else if (Type == 2)
{
var Post = db.Post.Where(r => r.School.Equals(SchoolID)).Where(r => r.ID == ID).FirstOrDefault();
if (Post != null)
{
Post.Delete = 1;
}
}
db.SaveChanges();
return(RedirectToAction("TAIndex"));
}
public BlogViewModels getBlogDetails(int id)
{
BlogArticle blogArticle = iblog.QueryWhere(p => p.bID == id).FirstOrDefault();
BlogArticle preBlog = iblog.QueryWhere(p => p.bID == id - 1).FirstOrDefault();
BlogArticle nextBolg = iblog.QueryWhere(p => p.bID == id + 1).FirstOrDefault();
blogArticle.btraffic++;
iblog.Edit(blogArticle, new string[] { "btraffic" });
iblog.SaveChanges();
//AutoMapper自动映射
Mapper.Initialize(p => p.CreateMap <BlogArticle, BlogViewModels>());
BlogViewModels models = Mapper.Map <BlogArticle, BlogViewModels>(blogArticle);
if (nextBolg != null)
{
models.next = nextBolg.btitle;
models.nextID = nextBolg.bID;
}
if (preBlog != null)
{
models.previous = preBlog.btitle;
models.previousID = preBlog.bID;
}
models.digest = blogArticle.bcontent.Length > 100 ? blogArticle.bcontent.Substring(0, 100) : blogArticle.bcontent;
return(models);
}
public ActionResult Edit(int ID, int Type)
{
var BlogModel = new BlogViewModels();
if (Type == 0)
{
var Emergency = db.Emergency.Where(r => r.School.Equals(SchoolID)).Where(r => r.ID == ID).FirstOrDefault();
if (Emergency != null)
{
BlogModel.Emergency = Emergency;
}
return(View(BlogModel));
}
else if (Type == 1)
{
var News = db.NewsClass.Where(r => r.School.Equals(SchoolID)).Where(r => r.ID == ID).FirstOrDefault();
if (News != null)
{
BlogModel.NewsList.Add(News);
}
return(View(BlogModel));
}
else if (Type == 2)
{
var Post = db.Post.Where(r => r.School.Equals(SchoolID)).Where(r => r.ID == ID).FirstOrDefault();
if (Post != null)
{
BlogModel.PostList.Add(Post);
}
return(View(BlogModel));
}
return(View());
}
/// <summary>
/// 获取视图博客详情信息(一般版本)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> getBlogDetails(int id)
{
var bloglist = await dal.Query(a => a.Id > 0, a => a.Id);
var blogArticle = (await dal.Query(a => a.Id == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
BlogArticle prevblog;
BlogArticle nextblog;
int blogIndex = bloglist.FindIndex(item => item.Id == id);
if (blogIndex >= 0)
{
try
{
// 上一篇
prevblog = blogIndex > 0 ? (((BlogArticle)(bloglist[blogIndex - 1]))) : null;
// 下一篇
nextblog = blogIndex + 1 < bloglist.Count() ? (BlogArticle)(bloglist[blogIndex + 1]) : null;
// 注意就是这里,mapper
models = IMapper.Map <BlogViewModels>(blogArticle);
#region 旧代码
//models = new BlogViewModels()
//{
// Submitter = blogArticle.Submitter,
// Title = blogArticle.Title,
// Category = blogArticle.Category,
// Content = blogArticle.Content,
// Traffic = blogArticle.Traffic,
// CommentNum = blogArticle.CommentNum,
// ModifyTime = blogArticle.ModifyTime,
// CreateTime = blogArticle.CreateTime,
// Remark = blogArticle.Remark,
//};
#endregion
if (nextblog != null)
{
models.Next = nextblog.Title;
models.NextId = nextblog.Id;
}
if (prevblog != null)
{
models.Previous = prevblog.Title;
models.PreviousId = prevblog.Id;
}
}
catch (Exception) { }
}
blogArticle.Traffic += 1;
await dal.Update(blogArticle, new List <string> {
"Traffic"
});
}
return(models);
}
// GET: Ntust
public ActionResult Index()
{
BlogViewModels blogs = new BlogViewModels();
blogs.PostList = db.Post.Where(r => r.School.Equals(SchoolID)).Where(r => r.Delete == 0).Where(r => r.Publish == 1).ToList();
blogs.NewsList = db.NewsClass.Where(r => r.School.Equals(SchoolID)).Where(r => r.Delete == 0).Where(r => r.Publish == 1).ToList();
blogs.Emergency = db.Emergency.Where(r => r.School.Equals(SchoolID))
.Where(r => r.Delete == 0).FirstOrDefault();
blogs.PostNum = blogs.PostList.Count;
blogs.NewsNum = blogs.NewsList.Count;
return(View(blogs));
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> GetBlogDetails(int id)
{
// 此处想获取上一条下一条数据，因此将全部数据list出来，有好的想法请提出
var bloglist = await base.Query(a => a.IsDeleted == false, a => a.bID);
var blogArticle = (await base.Query(a => a.bID == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
BlogArticle prevblog;
BlogArticle nextblog;
int blogIndex = bloglist.FindIndex(item => item.bID == id);
if (blogIndex >= 0)
{
try
{
prevblog = blogIndex > 0 ? bloglist[blogIndex - 1] : null;
nextblog = blogIndex + 1 < bloglist.Count() ? bloglist[blogIndex + 1] : null;
// 注意就是这里,mapper
models = _mapper.Map <BlogViewModels>(blogArticle);
if (nextblog != null)
{
models.next = nextblog.btitle;
models.nextID = nextblog.bID;
}
if (prevblog != null)
{
models.previous = prevblog.btitle;
models.previousID = prevblog.bID;
}
var entity2Viewmodel = _mapper.Map <BlogArticle>(models);
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
blogArticle.btraffic += 1;
await base.Update(blogArticle, new List <string> {
"btraffic"
});
}
return(models);
}
public async Task <BlogViewModels> GetBlogDetails(int id)
{
var bloglist = await base.Query(a => a.ArticleId > 0, a => a.ArticleId);
var blogArticle = (await base.Query(a => a.ArticleId == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
BlogArticle prevblog;
BlogArticle nextblog;
int blogIndex = bloglist.FindIndex(item => item.ArticleId == id);
if (blogIndex >= 0)
{
try
{
prevblog = blogIndex > 0 ? (((BlogArticle)(bloglist[blogIndex - 1]))) : null;
nextblog = blogIndex + 1 < bloglist.Count() ? (BlogArticle)(bloglist[blogIndex + 1]) : null;
// 注意就是这里,mapper
models = _mapper.Map <BlogViewModels>(blogArticle);
if (nextblog != null)
{
models.next = nextblog.ArticleTitle;
models.nextID = nextblog.ArticleId;
models.nextcoverimg = nextblog.ArticleCoverImage;
}
if (prevblog != null)
{
models.previous = prevblog.ArticleTitle;
models.previousID = prevblog.ArticleId;
models.precoverimg = prevblog.ArticleCoverImage;
}
}
catch (Exception) { }
}
blogArticle.ArticleVisitNumber += 1;
await base.Update(blogArticle, new List <string> {
"ArticleVisitNumber"
});
}
return(models);
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> getBlogDetails(int id)
{
var bloglist = await dal.Query(a => a.bID > 0, a => a.bID);
var blogArticle = (await dal.Query(a => a.bID == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
BlogArticle prevblog;
BlogArticle nextblog;
int blogIndex = bloglist.FindIndex(item => item.bID == id);
if (blogIndex >= 0)
{
try
{
prevblog = blogIndex > 0 ? (((BlogArticle)(bloglist[blogIndex - 1]))) : null;
nextblog = blogIndex + 1 < bloglist.Count() ? (BlogArticle)(bloglist[blogIndex + 1]) : null;
// 注意就是这里,mapper
models = IMapper.Map <BlogViewModels>(blogArticle);
if (nextblog != null)
{
models.next = nextblog.btitle;
models.nextID = nextblog.bID;
}
if (prevblog != null)
{
models.previous = prevblog.btitle;
models.previousID = prevblog.bID;
}
}
catch (Exception) { }
}
blogArticle.btraffic += 1;
await dal.Update(blogArticle, new List <string> {
"btraffic"
});
}
return(models);
}
/// <summary>
/// 获取视图博客详细信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> GetBlogDetails(int id)
{
var blogList = await base.Query(a => a.IsDeleted == false, a => a.BId);
var blogArticle = (await base.Query(a => a.BId == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
BlogArticle prevBlog;
BlogArticle nextBlog;
int blogIndex = blogList.FindIndex(index => index.BId == id);
if (blogIndex >= 0)
{
try
{
prevBlog = blogIndex > 0 ? blogList[blogIndex - 1] : null;
nextBlog = blogIndex + 1 < blogList.Count() ? blogList[blogIndex + 1] : null;
models = m_Mapper.Map <BlogViewModels>(blogArticle);
if (nextBlog != null)
{
models.Next = nextBlog.BTitle;
models.NextId = nextBlog.BId;
}
if (prevBlog != null)
{
models.Previous = prevBlog.BTitle;
models.PreviousId = prevBlog.BId;
}
var entity2ViewModel = m_Mapper.Map <BlogArticle>(models);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
blogArticle.BTraffic += 1;
//await base.Update(blogArticle, new List<string> { "BTraffic" });
}
return(models);
}
/// <summary>
/// 获取视图博客详情信息(一般版本)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> GetBlogDetails(int id)
{
// 此处想获取上一条下一条数据，因此将全部数据list出来，有好的想法请提出
var bloglist = await base.Query(a => a.bID > 0, a => a.bID);
var blogArticle = (await _dal.Query(a => a.bID == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
BlogArticle prevblog;
BlogArticle nextblog;
int blogIndex = bloglist.FindIndex(item => item.bID == id);
if (blogIndex >= 0)
{
try
{
//上一篇
prevblog = blogIndex > 0 ? bloglist[blogIndex - 1] : null;
//下一篇
nextblog = blogIndex + 1 < bloglist.Count() ? bloglist[blogIndex + 1] : null;
models = _mapper.Map <BlogViewModels>(blogArticle);
if (nextblog != null)
{
models.next = nextblog.btitle;
models.nextID = nextblog.bID;
}
if (prevblog != null)
{
models.previous = prevblog.btitle;
models.previousID = prevblog.bID;
}
}
catch (Exception) { }
}
blogArticle.btraffic += 1;
await _dal.Update(blogArticle, new List <string> {
"btraffic"
});
}
return(models);
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> GetBlogDetails(int id)
{
// 此处想获取上一条下一条数据，因此将全部数据list出来，有好的想法请提出
//var bloglist = await base.Query(a => a.IsDeleted==false, a => a.bID);
var blogArticle = (await base.Query(a => a.bID == id && a.bcategory == "技术博文")).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
models = _mapper.Map <BlogViewModels>(blogArticle);
//要取下一篇和上一篇，以当前id开始，按id排序后top(2)，而不用取出所有记录
//这样在记录很多的时候也不会有多大影响
var nextBlogs = await base.Query(a => a.bID >= id && a.IsDeleted == false && a.bcategory == "技术博文", 2, "bID");
if (nextBlogs.Count == 2)
{
models.next = nextBlogs[1].btitle;
models.nextID = nextBlogs[1].bID;
}
var prevBlogs = await base.Query(a => a.bID <= id && a.IsDeleted == false && a.bcategory == "技术博文", 2, "bID desc");
if (prevBlogs.Count == 2)
{
models.previous = prevBlogs[1].btitle;
models.previousID = prevBlogs[1].bID;
}
blogArticle.btraffic += 1;
await base.Update(blogArticle, new List <string> {
"btraffic"
});
}
return(models);
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> GetBlogDetails(int id)
{
// 此处想获取上一条下一条数据，因此将全部数据list出来，有好的想法请提出
//var bloglist = await base.Query(a => a.IsDeleted==false, a => a.bID);
var blogArticle = (await base.Query(a => a.bID == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
models = _mapper.Map <BlogViewModels>(blogArticle);
//要取下一篇和上一篇，以当前id开始，按id排序后top(2)，而不用取出所有记录
//这样在记录很多的时候也不会有多大影响
var nextBlogs = await base.Query(a => a.bID >= id && a.IsDeleted == false, 2, "bID");
if (nextBlogs.Count == 2)
{
models.next = nextBlogs[1].btitle;
models.nextID = nextBlogs[1].bID;
}
var prevBlogs = await base.Query(a => a.bID <= id && a.IsDeleted == false, 2, "bID desc");
if (prevBlogs.Count == 2)
{
models.previous = prevBlogs[1].btitle;
models.previousID = prevBlogs[1].bID;
}
//BlogArticle prevblog;
//BlogArticle nextblog;
//int blogIndex = bloglist.FindIndex(item => item.bID == id);
//if (blogIndex >= 0)
//{
// try
// {
// prevblog = blogIndex > 0 ? bloglist[blogIndex - 1] : null;
// nextblog = blogIndex + 1 < bloglist.Count() ? bloglist[blogIndex + 1] : null;
// // 注意就是这里,mapper
// models = _mapper.Map<BlogViewModels>(blogArticle);
// if (nextblog != null)
// {
// models.next = nextblog.btitle;
// models.nextID = nextblog.bID;
// }
// if (prevblog != null)
// {
// models.previous = prevblog.btitle;
// models.previousID = prevblog.bID;
// }
// var entity2Viewmodel = _mapper.Map<BlogArticle>(models);
// }
// catch (Exception ex) { throw new Exception(ex.Message); }
//}
blogArticle.btraffic += 1;
await base.Update(blogArticle, new List <string> {
"btraffic"
});
}
return(models);
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> getBlogDetails(int id)
{
var bloglist = await dal.Query(a => a.bID > 0, a => a.bID);
var idmin = bloglist.FirstOrDefault() != null?bloglist.FirstOrDefault().bID : 0;
var idmax = bloglist.LastOrDefault() != null?bloglist.LastOrDefault().bID : 1;
var idminshow = id;
var idmaxshow = id;
BlogArticle blogArticle = new BlogArticle();
blogArticle = (await dal.Query(a => a.bID == idminshow)).FirstOrDefault();
BlogArticle prevblog = new BlogArticle();
while (idminshow > idmin)
{
idminshow--;
prevblog = (await dal.Query(a => a.bID == idminshow)).FirstOrDefault();
if (prevblog != null)
{
break;
}
}
BlogArticle nextblog = new BlogArticle();
while (idmaxshow < idmax)
{
idmaxshow++;
nextblog = (await dal.Query(a => a.bID == idmaxshow)).FirstOrDefault();
if (nextblog != null)
{
break;
}
}
blogArticle.btraffic += 1;
await dal.Update(blogArticle, new List <string> {
"btraffic"
});
//注意就是这里
BlogViewModels models = IMapper.Map <BlogViewModels>(blogArticle);
if (nextblog != null)
{
models.next = nextblog.btitle;
models.nextID = nextblog.bID;
}
if (prevblog != null)
{
models.previous = prevblog.btitle;
models.previousID = prevblog.bID;
}
return(models);
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> getBlogDetails(int id)
{
//不用automapper的写法
//var bloglist = await dal.Query(a => a.bID > 0, a => a.bID);
//var idmin = bloglist.FirstOrDefault() != null ? bloglist.FirstOrDefault().bID : 0;
//var idmax = bloglist.LastOrDefault() != null ? bloglist.LastOrDefault().bID : 1;
//var idminshow = id;
//var idmaxshow = id;
//BlogArticle blogArticle = new BlogArticle();
//blogArticle = (await dal.Query(a => a.bID == idminshow)).FirstOrDefault();
//BlogArticle prevblog = new BlogArticle();
//while (idminshow > idmin)
//{
// idminshow--;
// prevblog = (await dal.Query(a => a.bID == idminshow)).FirstOrDefault();
// if (prevblog != null)
// {
// break;
// }
//}
//BlogArticle nextblog = new BlogArticle();
//while (idmaxshow < idmax)
//{
// idmaxshow++;
// nextblog = (await dal.Query(a => a.bID == idmaxshow)).FirstOrDefault();
// if (nextblog != null)
// {
// break;
// }
//}
//blogArticle.btraffic += 1;
//await dal.Update(blogArticle, new List<string> { "btraffic" });
//BlogViewModels models = new BlogViewModels()
//{
// bsubmitter = blogArticle.bsubmitter,
// btitle = blogArticle.btitle,
// bcategory = blogArticle.bcategory,
// bcontent = blogArticle.bcontent,
// btraffic = blogArticle.btraffic,
// bcommentNum = blogArticle.bcommentNum,
// bUpdateTime = blogArticle.bUpdateTime,
// bCreateTime = blogArticle.bCreateTime,
// bRemark = blogArticle.bRemark,
//};
//if (nextblog != null)
//{
// models.next = nextblog.btitle;
// models.nextID = nextblog.bID;
//}
//if (prevblog != null)
//{
// models.previous = prevblog.btitle;
// models.previousID = prevblog.bID;
//}
//return models;
//使用automapper的写法
var bloglist = await dal.Query(a => a.bID > 0, a => a.bID);
var blogArticle = (await dal.Query(a => a.bID == id)).FirstOrDefault();
BlogViewModels models = null;
if (blogArticle != null)
{
BlogArticle prevblog;
BlogArticle nextblog;
int blogIndex = bloglist.FindIndex(item => item.bID == id);
if (blogIndex >= 0)
{
try
{
// 上一篇
prevblog = blogIndex > 0 ? (((BlogArticle)(bloglist[blogIndex - 1]))) : null;
// 下一篇
nextblog = blogIndex + 1 < bloglist.Count() ? (BlogArticle)(bloglist[blogIndex + 1]) : null;
// 注意就是这里,mapper
models = _mapper.Map <BlogViewModels>(blogArticle);
if (nextblog != null)
{
models.next = nextblog.btitle;
models.nextID = nextblog.bID;
}
if (prevblog != null)
{
models.previous = prevblog.btitle;
models.previousID = prevblog.bID;
}
}
catch (Exception) { }
}
blogArticle.btraffic += 1;
await dal.Update(blogArticle, new List <string> {
"btraffic"
});
}
return(models);
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public BlogViewModels getBlogDetails(int id)
{
var bloglist = dal.QueryWhere(a => a.bID > 0).OrderBy(d => d.bID).ToList();
var idmin = bloglist.FirstOrDefault() != null?bloglist.FirstOrDefault().bID : 0;
var idmax = bloglist.LastOrDefault() != null?bloglist.LastOrDefault().bID : 1;
var idminshow = id;
var idmaxshow = id;
BlogArticle blogArticle = new BlogArticle();
blogArticle = dal.QueryWhere(a => a.bID == idminshow).FirstOrDefault();
BlogArticle prevblog = new BlogArticle();
while (idminshow > idmin)
{
idminshow--;
prevblog = dal.QueryWhere(a => a.bID == idminshow).FirstOrDefault();
if (prevblog != null)
{
break;
}
}
BlogArticle nextblog = new BlogArticle();
while (idmaxshow < idmax)
{
idmaxshow++;
nextblog = dal.QueryWhere(a => a.bID == idmaxshow).FirstOrDefault();
if (nextblog != null)
{
break;
}
}
blogArticle.btraffic += 1;
dal.Edit(blogArticle, new string[] { "btraffic" });
dal.SaverChanges();
//AutoMapper自动映射
Mapper.Initialize(cfg => cfg.CreateMap <BlogArticle, BlogViewModels>());
BlogViewModels models = Mapper.Map <BlogArticle, BlogViewModels>(blogArticle);
if (nextblog != null)
{
models.next = nextblog.btitle;
models.nextID = nextblog.bID;
}
if (prevblog != null)
{
models.previous = prevblog.btitle;
models.previousID = prevblog.bID;
}
models.digest = Tools.ReplaceHtmlTag(blogArticle.bcontent).Length > 100 ? Tools.ReplaceHtmlTag(blogArticle.bcontent).Substring(0, 200) : Tools.ReplaceHtmlTag(blogArticle.bcontent);
return(models);
}
/// <summary>
/// 获取视图博客详情信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BlogViewModels> GetBlogDetailsAsync(int id)
{
var bloglist = await _blogArticleRepository.Query(a => a.bID > 0, a => a.bID);
var idmin = bloglist.FirstOrDefault() != null?bloglist.FirstOrDefault().bID : 0;
var idmax = bloglist.LastOrDefault() != null?bloglist.LastOrDefault().bID : 1;
var idminshow = id;
var idmaxshow = id;
BlogArticle blogArticle = new BlogArticle();
blogArticle = (await _blogArticleRepository.Query(a => a.bID == idminshow)).FirstOrDefault();
BlogArticle prevblog = new BlogArticle();
while (idminshow > idmin)
{
idminshow--;
prevblog = (await _blogArticleRepository.Query(a => a.bID == idminshow)).FirstOrDefault();
if (prevblog != null)
{
break;
}
}
BlogArticle nextblog = new BlogArticle();
while (idmaxshow < idmax)
{
idmaxshow++;
nextblog = (await _blogArticleRepository.Query(a => a.bID == idmaxshow)).FirstOrDefault();
if (nextblog != null)
{
break;
}
}
blogArticle.btraffic += 1;
await _blogArticleRepository.Update(blogArticle, new List <string> {
"btraffic"
}, null, " bID == " + blogArticle.bID.ToString());
BlogViewModels models = new BlogViewModels()
{
bsubmitter = blogArticle.bsubmitter,
btitle = blogArticle.btitle,
bcategory = blogArticle.bcategory,
bcontent = blogArticle.bcontent,
btraffic = blogArticle.btraffic,
bcommentNum = blogArticle.bcommentNum,
bUpdateTime = blogArticle.bUpdateTime,
bCreateTime = blogArticle.bCreateTime,
bRemark = blogArticle.bRemark,
};
if (nextblog != null)
{
models.next = nextblog.btitle;
models.nextID = nextblog.bID;
}
if (prevblog != null)
{
models.previous = prevblog.btitle;
models.previousID = prevblog.bID;
}
return(models);
}
