/// <summary>
/// 获取目录主页内容
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
public List <htmlInfo> GetMainHtmlList()
{
List <htmlInfo> hList = new List <htmlInfo>();
// DataTable dt = SqlHelper.ExecuteDataSet(@"select title,titleImg,titleURL,addTime,columnId,columnName from
//( select
//RANK()OVER(PARTITION BY columnInfo.Id ORDER BY htmlInfo.addTime DESC) AS
//RANK2, title,titleImg,titleURL,addTime,htmlInfo.columnId,columnName from
//htmlInfo left join columnInfo On htmlInfo.columnId = columnInfo.Id) T
//where RANK2<=10 ").Tables[0];
DataTable dt = SqlHelperCatalog.ExecuteDataSet(@"select title,titleURL,titleImg,addTime,columnId from
( select
RANK()OVER(PARTITION BY columnId ORDER BY addTime DESC) AS
RANK2, title,titleImg,titleURL,addTime,columnId from
htmlPara ) T
where RANK2<=10").Tables[0];
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlInfo hInfo = new htmlInfo();
hInfo.title = (string)row["title"];
hInfo.titleImg = (string)row["titleImg"];
hInfo.titleURL = (string)row["titleURL"];
hInfo.columnId = (string)row["columnId"];//栏目Id
hInfo.addTime = row["addTime"].ToString();
//hInfo.realmNameId = (string)row["realmNameId"];//目录名
hList.Add(hInfo);
}
return(hList);
}
