public virtual DataPage <ContentPost> GetPageBySection(int sectionId, int pageSize)
{
DataPage <ContentPostSection> list = ContentPostSection.findPage("SectionId=" + sectionId + " and SaveStatus=" + SaveStatus.Normal + " order by PostId desc", pageSize);
DataPage <ContentPost> xResult = list.Convert <ContentPost>(populatePost(list.Results));
// 兼容旧版
if (xResult.RecordCount == 0)
{
return(ContentPost.findPage("SectionId=" + sectionId + " and SaveStatus=" + SaveStatus.Normal, pageSize));
}
else
{
return(xResult);
}
}
public virtual DataPage <ContentPost> GetBySearch(int appId, String key, int pageSize)
{
return(ContentPost.findPage("AppId=" + appId + " and Title like '%" + key + "%' and SaveStatus=" + SaveStatus.Normal + " order by Id desc", pageSize));
}
public virtual DataPage <ContentPost> GetTrashByApp(int appId, int pageSize)
{
return(ContentPost.findPage("AppId=" + appId + " and SaveStatus=" + SaveStatus.Delete + " order by Id desc", pageSize));
}
//--------------------------------------------------------------------------------------------------------------
public virtual DataPage <ContentPost> GetPageByCreator(int creatorId, IMember owner, int appId)
{
String condition = string.Format("CreatorId={0} and OwnerId={1} and OwnerType='{2}' and AppId={3} and SaveStatus={4}", creatorId, owner.Id, owner.GetType().FullName, appId, SaveStatus.Normal);
return(ContentPost.findPage(condition));
}
public DataPage <ContentPost> GetPageTrash()
{
DataPage <ContentPost> list = ContentPost.findPage("SaveStatus=" + SaveStatus.SysDelete, 20);
return(list);
}
public virtual DataPage <ContentPost> GetPage()
{
DataPage <ContentPost> list = ContentPost.findPage("SaveStatus<>" + SaveStatus.SysDelete, 20);
return(list);
}
public virtual DataPage <ContentPost> GetByApp(long appId, int pageSize)
{
return(ContentPost.findPage("AppId=" + appId + " and SaveStatus=" + SaveStatus.Normal + " order by Id desc", pageSize));
}
