private void GetRecommendRoom() { string tempstr = string.Empty; QPS.NEW.BLL.Room room = new QPS.NEW.BLL.Room(); DataTable dt = room.GetDataTableList("select top 50 * from Room where IfRecommend=1 order by id desc"); if (dt!=null) { for (int i = 0; i < dt.Rows.Count;i++ ) { tempstr += "<li><span><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\"><img src=\"/" + dt.Rows[i]["ImagePath"].ToString() + "\" alt=\"" + dt.Rows[i]["Name"].ToString() + "\"></a></span><p><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\">" + dt.Rows[i]["Name"].ToString() + "</a></p></li>\r\n"; } } this.RecommendRoom.Text = tempstr; }
private void GetRecommendRoom() { string tempstr = string.Empty; QPS.NEW.BLL.Room room = new QPS.NEW.BLL.Room(); DataTable dt = room.GetDataTableList("select top 50 * from Room where IfRecommend=1 order by id desc"); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { tempstr += "<li><span><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\"><img src=\"/" + dt.Rows[i]["ImagePath"].ToString() + "\" alt=\"" + dt.Rows[i]["Name"].ToString() + "\"></a></span><p><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\">" + dt.Rows[i]["Name"].ToString() + "</a></p></li>\r\n"; } } this.RecommendRoom.Text = tempstr; }