// 获取News Post列表
public DataSet Get_News_Posts(string CategoryID, string News_Status, string SortOrder, string Orientation, int TotalNumber)
{
string Table_Name = "NexusNews_Posts";
string Filter = "CategoryID IN (" + CategoryID
+ ")";
if (News_Status != "ALL")
{
Filter += " AND "
+ "News_Status = " + DataEval.QuoteText(News_Status);
}
Filter += " AND "
+ "News_Date <= " + DataEval.QuoteText(DataEval.DateTimeTypeConvert(DateTime.Now.ToString()));
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "News_Date " + Orientation;
}
else
{
SortOrder = SortOrder + " " + Orientation;
}
return(Show_Items(Table_Name, null, Filter, SortOrder, TotalNumber));
}
public DataSet Get_mBlog_Posts(string Ownership_UserID, string Post_Status, int NumberPerPage)
{
string Table_Name = "NexusBlog_Posts";
string Filter = "BlogGroupID = -1";
// Display Users Blog
if (Ownership_UserID != "ALL")
{
Filter += " AND "
+ "Ownership_UserID = " + DataEval.QuoteText(Ownership_UserID);
}
if (Post_Status != "ALL")
{
Filter += " AND "
+ "Post_Status = " + DataEval.QuoteText(Post_Status);
}
Filter += " AND "
+ "Post_Date <= " + DataEval.QuoteText(DataEval.DateTimeTypeConvert(DateTime.Now.ToString()));
string SortOrder = "Post_Date DESC";
return(Show_Items(Table_Name, null, Filter, SortOrder, NumberPerPage));
}