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