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