/// <summary> /// 获取置顶新闻列表 /// </summary> /// <param name="newsType"></param> /// <param name="hot"></param> /// <param name="elite"></param> /// <param name="top"></param> /// <returns></returns> public IList <News> GetTopNewsList(NewsTypeStatus newsType, int hot, int elite, int top) { StringBuilder sqlQuery = new StringBuilder() .AppendFormat("SELECT TOP({0}) ", top) .Append("NewsID, Subject,OnTop,OnTopAll,IsElite,IsHot,IsLinks,LinkUrl,HighLight,ClassID,LastModifyDate ") .Append("FROM News "); //查询条件 sqlQuery.Append(" WHERE IsLock=1 AND IsDelete=0 "); //新闻类别 if (!newsType.Equals(NewsTypeStatus.NotSet)) { sqlQuery.AppendFormat(" AND {0}={1} ", News._ClassID, (byte)newsType); } //新闻状态 if (hot > 0) { sqlQuery.AppendFormat(" AND {0}={1} ", News._IsHot, hot); } if (elite > 0) { sqlQuery.AppendFormat(" AND {0}={1} ", News._IsElite, elite); } //排序 sqlQuery.Append(" ORDER By OnTopAll DESC,OnTop DESC,IssueDate DESC ,NewsID DESC"); return(Database.ExecuteObjectList <News>(sqlQuery.ToString())); }
/// <summary> /// 获取新闻摘要列表 /// </summary> /// <param name="newsType">新闻类别 0 全部,1 新闻,2 公告</param> /// <param name="hot">热点 1, 普通 0</param> /// <param name="elite">精华 1,普通 0</param> /// <param name="top">列表数目 最大值 50 条</param> /// <returns></returns> public IList <News> GetTopNewsList(int newsType, int hot, int elite, int top) { //参数检查 if (top > NEWS_TOP_MAX) { top = NEWS_TOP_MAX; } else if (top <= 0) { top = NEWS_TOP_MIN; } if (newsType > 2 || newsType < 0) { newsType = 0; } if (hot > 1 || hot < 0) { hot = 0; } if (elite > 1 || elite < 0) { elite = 0; } NewsTypeStatus newsTypeStatus = (NewsTypeStatus)newsType; IList <News> newsTopList = gamewebData.GetTopNewsList(newsTypeStatus, hot, elite, top); return(newsTopList); }