// 获取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)); }