/// <summary>
/// 获取最新文章
/// </summary>
/// <param name="model">文章类别名称</param>
public ArticleDspModel GetLatestArticle(string categoryname)
{
ISpecification <Article> spec = null;
if (string.IsNullOrEmpty(categoryname))
{
spec = new Specification <Article>(a => a.Id != Guid.Empty);
}
else
{
Guid aid = new FBS.Service.CategoryService().GetArticleCategoryByName(categoryname).CategoryID;
spec = new Specification <Article>(a => a.CategoryID == aid);
}
spec = spec.Skip(0).Take(1).OrderByDescending(a => a.CreationDate);
IRepository <Article> articleRep = Factory.Factory <IRepository <Article> > .GetConcrete <Article>();
Article myarticle = articleRep.Find(spec);
ArticleDspModel mymodel = new ArticleDspModel();
if (myarticle != null)
{
mymodel = new ArticleDspModel()
{
BriefTitle = myarticle.ArticleVO.BriefTitle, ArticleID = myarticle.Id, ClickCount = myarticle.ArticleVO.ClickCount, CreatedOn = myarticle.CreationDate, ImgName = myarticle.ImgName, Title = myarticle.ArticleVO.Title, SourceUrl = myarticle.ArticleVO.SourceUrl
};
}
return(mymodel);
}
public StatisticsInfo()
{
CMSService cms = new CMSService();
ArticleDspModel a = cms.GetLatestArticle(string.Empty);
if (null != a)
{
this.LastArticle = a;
}
this.ArticleCount = cms.GetArticleCountOfCategory(Guid.Empty);
//访问统计
//
}
/// <summary>
/// 获取最新文章
/// </summary>
/// <param name="index">最新文章的起始点</param>
/// <param name="count">获取的总条数</param>
/// <returns></returns>
public IList <ArticleDspModel> GetLatestArticles(int index, int count)
{
IRepository <Article> articleRep = Factory.Factory <IRepository <Article> > .GetConcrete <Article>();
IList <Article> list = articleRep.FindAll(new Specification <Article>(aa => aa.Id != Guid.Empty).OrderByDescending(a => a.ClickCount).Skip(index).Take(count));
IList <ArticleDspModel> mylist = new List <ArticleDspModel>();
foreach (Article a in list)
{
ArticleDspModel model = new ArticleDspModel()
{
ArticleID = a.Id, BriefTitle = a.ArticleVO.BriefTitle, ImgName = a.ImgName, Title = a.ArticleVO.Title, ClickCount = a.ArticleVO.ClickCount, CreatedOn = a.CreationDate
};
mylist.Add(model);
}
return(mylist);
}
public IList <ArticleDspModel> FetchArticleDspModelByKeyWords(string keywords, int index, int count)
{
IList <ArticleDspModel> articlelist = new List <ArticleDspModel>();//"Title like '%" + keywords + "%' or Body like '%" + keywords + "%'"
DbDataReader reader = helper.GetPageList("fbs_CMSArticle", "CreatedOn", "Title like '%" + keywords + "%'", index, count);
if (reader.HasRows)
{
while (reader.Read())
{
ArticleDspModel model = new ArticleDspModel();
model.ArticleID = new Guid(reader["ArticleID"].ToString());
model.ClickCount = System.Int16.Parse(reader["ClickCount"].ToString());
model.CreatedOn = DateTime.Parse(reader["CreatedOn"].ToString());
model.ImgName = reader["ImgName"].ToString();
model.Title = reader["Title"].ToString();
articlelist.Add(model);
}
}
return(articlelist);
}
public IList <ArticleDspModel> FetchAllArticleByCategoryID(Guid cid)
{
IRepository <Article> articleRep = Factory.Factory <IRepository <Article> > .GetConcrete <Article>();
IList <Article> alist = null;
IList <ArticleDspModel> target = new List <ArticleDspModel>();
try
{
alist = articleRep.FindAll(new Specification <Article>(a => a.CategoryID == cid));
foreach (Article a in alist)
{
ArticleDspModel tmp = new ArticleDspModel()
{
BriefTitle = a.ArticleVO.BriefTitle, ArticleID = a.Id, Title = a.ArticleVO.Title, ClickCount = a.ArticleVO.ClickCount, CreatedOn = a.CreationDate, ImgName = a.ImgName
};
target.Add(tmp);
}
}
catch { }
return(target);
}
/// <summary>
/// 获取某分类下的文章列表模型
/// </summary>
/// <param name="cid">分类编号</param>
/// <param name="startIndex">起始索引</param>
/// <param name="count">获取数目</param>
/// <returns>文章模型列表</returns>
public IList <ArticleDspModel> FetchArticleByCategoryID(Guid cid, int startIndex, int count)
{
IRepository <Article> articleRep = Factory.Factory <IRepository <Article> > .GetConcrete <Article>();
IList <Article> alist = null;
IList <ArticleDspModel> target = new List <ArticleDspModel>();
try
{
alist = articleRep.FindAll(new Specification <Article>(a => a.CategoryID == cid).Skip(startIndex).Take(count).OrderByDescending(a => a.CreationDate));
foreach (Article a in alist)
{
ArticleDspModel tmp = new ArticleDspModel()
{
SourceUrl = a.ArticleVO.SourceUrl, BriefTitle = a.ArticleVO.BriefTitle, ArticleID = a.Id, Title = a.ArticleVO.Title, ClickCount = a.ArticleVO.ClickCount, CreatedOn = a.CreationDate, ImgName = a.ImgName
};
target.Add(tmp);
}
}
catch { }
return(target);
}
