protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { try { if (Page.Request.QueryString["CatId"] != null && Page.Request.QueryString["CatId"] != string.Empty) { catId = Convert.ToString(Page.Request.QueryString["CatId"]); } dvCatTitle.InnerText = Utilities.GetValueByField(CurrentWeb, ListsName.InternalName.CategoryList, FieldsName.CategoryList.InternalName.CategoryID, catId, "Text", FieldsName.CategoryList.InternalName.Title); DataTable dt = NewsBO.GetNewsByCatId(CurrentWeb, catId); dt = Utilities.GetNewsWithRowLimit(dt, 1); if (dt != null && dt.Rows.Count > 0) { //dvCatTitle.InnerText = Utilities.GetValueByField(CurrentWeb, ListsName.InternalName.CategoryList, FieldsName.CategoryList.InternalName.CategoryID, Convert.ToString(dt.Rows[0][FieldsName.NewsList.InternalName.NewsGroup]), "Text", FieldsName.CategoryList.InternalName.Title); dvContent.InnerHtml = Convert.ToString(dt.Rows[0][FieldsName.NewsList.InternalName.Content]); } } catch (Exception ex) { Utilities.LogToULS(ex.ToString()); } } }
protected void BindRepeater(string catId) { DataTable dt = NewsBO.GetNewsByCatId(CurrentWeb, catId); dt = Utilities.GetNewsWithRowLimit(dt, 1000); rptListNews.DataSource = dt; rptListNews.DataBind(); }
protected void BindRepeaterNews(string catId) { DataTable dt = NewsBO.GetNewsByCatId(CurrentWeb, catId); dt = Utilities.GetNewsWithRowLimit(dt, 6); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; if (Convert.ToString(dr[FieldsName.NewsList.InternalName.NewsUrl]) == string.Empty) { aImg.HRef = string.Format("../newsdetail.aspx?ID={0}&CatId={1}", dr["ID"], dr[FieldsName.NewsList.InternalName.NewsGroup]); } else { aImg.HRef = Convert.ToString(dr[FieldsName.NewsList.InternalName.NewsUrl]); aImg.Target = "_blank"; aLink.Target = aImg.Target; } aLink.HRef = aImg.HRef; aLink.InnerText = Convert.ToString(dr[FieldsName.NewsList.InternalName.Title]); var imgUrl = Convert.ToString(dr[FieldsName.NewsList.InternalName.ImageThumb]); if (imgUrl.Contains("http://")) { imgNews.Src = imgUrl; } else { imgNews.Src = WebUrl + "/" + Convert.ToString(dr[FieldsName.NewsList.InternalName.ImageThumb]); } spDesc.InnerText = Utilities.StripHTML(Convert.ToString(dr[FieldsName.NewsList.InternalName.Description])); } if (dt != null && dt.Rows.Count > 1) { dt.Rows.Remove(dt.Rows[0]); rptNews.DataSource = dt; rptNews.DataBind(); } }
protected void rptCate_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType.Equals(ListItemType.Item) || e.Item.ItemType.Equals(ListItemType.AlternatingItem)) { DataRowView drv = e.Item.DataItem as DataRowView; HtmlAnchor aLink = (HtmlAnchor)e.Item.FindControl("aLink"); aLink.HRef = string.Format("../news.aspx?CatId={0}", drv[FieldsName.CategoryList.InternalName.CategoryID]); aLink.InnerText = drv[FieldsName.NewsList.InternalName.Title].ToString(); //Bind rptNews1 if (e.Item.ItemIndex == 0) { DataTable dt = NewsBO.GetNewsByCatId(CurrentWeb, Convert.ToString(drv[FieldsName.CategoryList.InternalName.CategoryID])); dt = Utilities.GetNewsWithRowLimit(dt, 6); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; var imgUrl = Convert.ToString(dr[FieldsName.NewsList.InternalName.ImageThumb]); if (!imgUrl.Contains("http://")) { imgUrl = WebUrl + "/" + imgUrl; } ltrFirstNews.Text = string.Format("<div class='img_thumb_News'>" + "<img src='{0}' /></div>" + "<div class='intro_short_content_News'>" + "<a href='newsdetail.aspx?ID={1}&CatId={2}'>{3}</a></div>", imgUrl, dr["ID"], dr[FieldsName.NewsList.InternalName.NewsGroup], dr[FieldsName.NewsList.InternalName.Title]); } if (dt != null && dt.Rows.Count > 1) { dt.Rows.Remove(dt.Rows[0]); rptNews1.DataSource = dt; rptNews1.DataBind(); } } //Bind rptNews2 if (e.Item.ItemIndex == 1) { DataTable dt = NewsBO.GetNewsByCatId(CurrentWeb, Convert.ToString(drv[FieldsName.CategoryList.InternalName.CategoryID])); dt = Utilities.GetNewsWithRowLimit(dt, 6); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; var imgUrl = Convert.ToString(dr[FieldsName.NewsList.InternalName.ImageThumb]); if (!imgUrl.Contains("http://")) { imgUrl = WebUrl + "/" + imgUrl; } ltrSecondNews.Text = string.Format("<div class='img_thumb_News'>" + "<img src='{0}' /></div>" + "<div class='intro_short_content_News'>" + "<a href='newsdetail.aspx?ID={1}&CatId={2}'>{3}</a></div>", imgUrl, dr["ID"], dr[FieldsName.NewsList.InternalName.NewsGroup], dr[FieldsName.NewsList.InternalName.Title]); } if (dt != null && dt.Rows.Count > 1) { dt.Rows.Remove(dt.Rows[0]); rptNews2.DataSource = dt; rptNews2.DataBind(); } } //Bind rptNews3 if (e.Item.ItemIndex == 2) { DataTable dt = NewsBO.GetNewsByCatId(CurrentWeb, Convert.ToString(drv[FieldsName.CategoryList.InternalName.CategoryID])); dt = Utilities.GetNewsWithRowLimit(dt, 6); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; var imgUrl = Convert.ToString(dr[FieldsName.NewsList.InternalName.ImageThumb]); if (!imgUrl.Contains("http://")) { imgUrl = WebUrl + "/" + imgUrl; } ltrThirdNews.Text = string.Format("<div class='img_thumb_News'>" + "<img src='{0}' /></div>" + "<div class='intro_short_content_News'>" + "<a href='newsdetail.aspx?ID={1}&CatId={2}'>{3}</a></div>", imgUrl, dr["ID"], dr[FieldsName.NewsList.InternalName.NewsGroup], dr[FieldsName.NewsList.InternalName.Title]); } if (dt != null && dt.Rows.Count > 1) { dt.Rows.Remove(dt.Rows[0]); rptNews3.DataSource = dt; rptNews3.DataBind(); } } } }