private XmlDocument LoadData() { try { int pg = 0; int pagesize = Convert.ToInt32(Settings["limits"]); if (pagesize == 0) { pagesize = 4; } string source = "0"; if (Request.QueryString["source"] != null) { source = Request.QueryString["source"]; } else if (Settings["source"] != null) { source = Settings["source"].ToString(); } int pageNum; int numRecord; string newsgroupid = ""; string categoryid = ""; string newsgroupcode = ""; string categorycode = ""; XmlDocument doc = null; NewsController engine = new NewsController(); bool displayPaging = true; if (Settings["displayPaging"] != null) { displayPaging = bool.Parse(Settings["displayPaging"].ToString()); } bool displayTitle = true; if (Settings["displayTitle"] != null) { displayTitle = bool.Parse(Settings["displayTitle"].ToString()); } string titleCSSClass = ""; if (Settings["titleCSSClass"] != null) { titleCSSClass = Settings["titleCSSClass"].ToString(); } int numShortNews = 0; if (Settings["numShortNews"] != null) { numShortNews = int.Parse(Settings["numShortNews"].ToString()); } int imageWidth = 100; if (Settings["imageWidth"] != null) { imageWidth = int.Parse(Settings["imageWidth"].ToString()); } MLCategoryInfo category; switch (source) { case "0": // theo cat từ URL if (Request.QueryString["categoryid"] != null) { if (Request.QueryString["pg"] != null) { pg = Convert.ToInt32(Request.QueryString["pg"]) - 1; } categoryid = Request.QueryString["categoryid"]; if (displayTitle) { category = MLCategoryController.GetCategory(categoryid, System.Threading.Thread.CurrentThread.CurrentCulture.ToString(), false); if (category.MLCatName == null) { //ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.CatName + @"</a></div></div>"; ltTitle.Text = @"<div class=""" + titleCSSClass + @"""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.CatName + @"</a></div>"; } else { //ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.MLCatName.StringTextOrFallBack + @"</a></div></div>"; ltTitle.Text = @"<div class=""" + titleCSSClass + @"""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.MLCatName.StringTextOrFallBack + @"</a></div>"; } } doc = engine.LoadXML(categoryid, pg, pagesize, imageWidth, numShortNews); int pages = CountPageByCat(categoryid, pagesize); if (pages > 1) { string format = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "", "categoryid/" + categoryid, "pg/@@page"); paging.Visible = true; paging.showing(pages, pg, format); } if (!displayPaging) { paging.Visible = false; } } else { doc = new XmlDocument(); } break; case "1": // theo newsgroup từ URL if (Request.QueryString["newsgroupid"] != null) { if (Request.QueryString["pg"] != null) { pg = Convert.ToInt32(Request.QueryString["pg"]) - 1; } newsgroupid = Request.QueryString["newsgroupid"]; doc = engine.LoadXMLByNewsGroup(newsgroupid, pg, pagesize, imageWidth, numShortNews); int pages = CountPageByGroup(newsgroupid, pagesize); if (pages > 1) { string format = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "", "newsgroupid/" + newsgroupid, "pg/@@page"); paging.Visible = true; paging.showing(pages, pg, format); } if (!displayPaging) { paging.Visible = false; } } else { doc = new XmlDocument(); } break; case "2": // theo cat được chọn categoryid = this.Settings["categoryid"].ToString(); if (Request.QueryString["categoryid"] != null) { if (categoryid == Request.QueryString["categoryid"]) { if (Request.QueryString["pg"] != null) { pg = Convert.ToInt32(Request.QueryString["pg"]) - 1; } } else if (Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_cat_" + categoryid] != null) { pg = (int)Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_cat_" + categoryid]; } } if (displayTitle) { category = MLCategoryController.GetCategory(categoryid, System.Threading.Thread.CurrentThread.CurrentCulture.ToString(), false); if (category.MLCatName == null) { //ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.CatName + @"</a></div></div>"; ltTitle.Text = @"<div class=""" + titleCSSClass + @"""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.CatName + @"</a></div>"; } else { //ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.MLCatName.StringTextOrFallBack + @"</a></div></div>"; ltTitle.Text = @"<div class=""" + titleCSSClass + @"""><a href=""" + DotNetNuke.Common.Globals.NavigateURL(category.DesktopListID, "", "categoryid/" + categoryid) + @""">" + category.MLCatName.StringTextOrFallBack + @"</a></div>"; } } doc = engine.LoadXML(categoryid, pg, pagesize, imageWidth, numShortNews); pageNum = CountPageByCat(categoryid, pagesize); if (pageNum > 1) { string format = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "", "categoryid/" + categoryid, "pg/@@page"); paging.Visible = true; paging.showing(pageNum, pg, format); Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_cat_" + categoryid] = pg; } if (!displayPaging) { paging.Visible = false; } break; case "3": // theo newsgroup được chọn newsgroupid = this.Settings["newsgroupid"].ToString(); if (Request.QueryString["newsgroupid"] != null) { if (newsgroupid == Request.QueryString["newsgroupid"]) { if (Request.QueryString["pg"] != null) { pg = Convert.ToInt32(Request.QueryString["pg"]) - 1; } } else if (Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_group_" + newsgroupid] != null) { pg = (int)Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_group_" + newsgroupid]; } } doc = engine.LoadXMLByNewsGroup(newsgroupid, pg, pagesize, imageWidth, numShortNews); pageNum = CountPageByGroup(newsgroupid, pagesize); if (pageNum > 1) { string format = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "", "newsgroupid/" + newsgroupid, "pg/@@page"); paging.Visible = true; paging.showing(pageNum, pg, format); Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_group_" + newsgroupid] = pg; } if (!displayPaging) { paging.Visible = false; } break; case "4": // theo cat code categorycode = this.Settings["categorycode"].ToString(); if (Request.QueryString["categorycode"] != null) { if (categorycode == Request.QueryString["categorycode"]) { if (Request.QueryString["pg"] != null) { pg = Convert.ToInt32(Request.QueryString["pg"]) - 1; } } else if (Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_catcode_" + categorycode] != null) { pg = (int)Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_catcode_" + categorycode]; } } numRecord = 0; doc = engine.LoadXMLByCatCode(PortalId, categorycode, pg, pagesize, out numRecord, imageWidth, numShortNews); pageNum = CountPage(numRecord, pagesize); if (pageNum > 1) { string format = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "", "categorycode/" + categorycode, "pg/@@page"); paging.Visible = true; paging.showing(pageNum, pg, format); Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_catcode_" + categorycode] = pg; } if (!displayPaging) { paging.Visible = false; } break; case "5": // theo newsgroup code newsgroupcode = this.Settings["newsgroupcode"].ToString(); if (Request.QueryString["newsgroupcode"] != null) { if (newsgroupcode == Request.QueryString["newsgroupcode"]) { if (Request.QueryString["pg"] != null) { pg = Convert.ToInt32(Request.QueryString["pg"]) - 1; } } else if (Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_groupcode_" + newsgroupcode] != null) { pg = (int)Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_groupcode_" + newsgroupcode]; } } numRecord = 0; doc = engine.LoadXMLByGroupCode(PortalId, newsgroupcode, pg, pagesize, out numRecord, imageWidth, numShortNews); pageNum = CountPage(numRecord, pagesize); if (pageNum > 1) { string format = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "", "newsgroupcode/" + newsgroupcode, "pg/@@page"); paging.Visible = true; paging.showing(pageNum, pg, format); Session["currentPage_" + PortalSettings.ActiveTab.TabID.ToString() + "_groupcode_" + newsgroupcode] = pg; } if (!displayPaging) { paging.Visible = false; } break; case "6": // những bài đọc nhiều nhất doc = engine.LoadHotXML(pagesize, "", PortalId, imageWidth, numShortNews); break; case "7": // những bài mới nhất doc = engine.LoadNewestXML(pagesize, "", PortalId, imageWidth, numShortNews); break; } return(doc); } catch (Exception ex) { return(new XmlDocument()); } }
public XmlDocument MLLoadTreeXML(string editFormatUrl, bool ismenu, int PortalID, int source, string codes, string parentCat, string Locale) { DataTable dt = null; if (source == 0) { dt = LoadTree(ismenu, PortalID,""); } else if (source == 1) { dt = LoadTreeByCode(ismenu, PortalID, codes); } else if (source == 2) { dt = LoadTreeByParents(ismenu, PortalID, parentCat); } XmlDocument doc = new XmlDocument(); doc.LoadXml("<categories></categories>"); XmlElement root = doc.DocumentElement; for (int i = 0; i < dt.Rows.Count; i++) { XmlElement category = doc.CreateElement("category"); int tabid = Convert.ToInt32(dt.Rows[i]["DesktopListID"]); string link = DotNetNuke.Common.Globals.NavigateURL(tabid, "", "categoryid/" + dt.Rows[i]["CatID"].ToString()); if (dt.Rows[i]["NewsID"].ToString() != "0") { tabid = Convert.ToInt32(dt.Rows[i]["DesktopViewID"]); link = DotNetNuke.Common.Globals.NavigateURL(tabid, "", "id/" + dt.Rows[i]["NewsID"].ToString()); } string url_edit = editFormatUrl.Replace("@@catid", dt.Rows[i]["CatID"].ToString()); DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "ImgLevel1", DotNetNuke.Common.Globals.ApplicationPath + "/images/action_right.gif"); DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "ImgLevel2", DotNetNuke.Common.Globals.ApplicationPath + "/images/edit.gif"); DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "OrderNumber", dt.Rows[i]["OrderNumber"].ToString()); MLCategoryInfo fMLCat = MLCategoryController.GetCategory(dt.Rows[i]["CatID"].ToString(), Locale, false); if (fMLCat != null) { if (fMLCat.MLCatName != null) { DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "CatName", fMLCat.MLCatName.StringTextOrFallBack); } else { DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "CatName", fMLCat.CatName); } } else { DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "CatName", dt.Rows[i]["CatName"].ToString()); } DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "Level", dt.Rows[i]["Level"].ToString()); string indent = ""; int level = int.Parse(dt.Rows[i]["Level"].ToString()); for (int j = 1; j < level; j++) { indent += HttpContext.Current.Server.HtmlDecode(" "); } DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "Indent", indent); DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "CatCode", dt.Rows[i]["CatCode"].ToString()); DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "PortalID", dt.Rows[i]["PortalID"].ToString()); DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "link", link); DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "url_edit", url_edit); if (i % 2 == 1) DotNetNuke.NewsProvider.Utils.AddNode(doc, category, "odd", "true"); root.AppendChild(category); } return doc; }
public DataTable LoadTreeForMenu(int PortalID, int source, string codes, string parentCat, string Locale) { DataTable dt = null; if (source == 0) { dt = LoadTree(true, PortalID,""); } else if (source == 1) { dt = LoadTreeByCode(true, PortalID, codes); } else if (source == 2) { dt = LoadTreeByParents(true, PortalID, parentCat); } dt.Columns.Add(new DataColumn("Name", typeof(string))); dt.Columns.Add(new DataColumn("Link", typeof(string))); dt.Columns.Add(new DataColumn("Target", typeof(string))); dt.Columns.Add(new DataColumn("Image", typeof(string))); int MotherLevel = -1; for (int i = 0; i < dt.Rows.Count; i++) { bool visible = Convert.ToBoolean(dt.Rows[i]["Visible"]); int level = Convert.ToInt32(dt.Rows[i]["Level"]); if (visible) { if (MotherLevel < level && MotherLevel != -1) { dt.Rows[i]["Visible"] = false; } else if (MotherLevel >= level) { MotherLevel = -1; } } else { if (MotherLevel < level && MotherLevel == -1) { MotherLevel = level; } else if (MotherLevel > level) { MotherLevel = level; } else if (MotherLevel == level) { MotherLevel = level; } } dt.Rows[i]["Target"] = "_self"; dt.Rows[i]["Image"] = ""; int tabid = Convert.ToInt32(dt.Rows[i]["DesktopListID"]); string link = DotNetNuke.Common.Globals.NavigateURL(tabid, "", "categoryid/" + dt.Rows[i]["CatID"].ToString()); if (dt.Rows[i]["NewsID"].ToString() != "0") { tabid = Convert.ToInt32(dt.Rows[i]["DesktopViewID"]); link = DotNetNuke.Common.Globals.NavigateURL(tabid, "", "id/" + dt.Rows[i]["NewsID"].ToString()); } dt.Rows[i]["Link"] = link; MLCategoryInfo fMLCategory = MLCategoryController.GetCategory(dt.Rows[i]["CatID"].ToString(), Locale, false); if (fMLCategory != null) { if (fMLCategory.MLCatName != null) { dt.Rows[i]["Name"] = fMLCategory.MLCatName.StringText; } else { dt.Rows[i]["Name"] = fMLCategory.CatName; } } else { dt.Rows[i]["Name"] = dt.Rows[i]["CatName"].ToString(); } } for (int j = dt.Rows.Count - 1; j >= 0; j-- ) { if (!Convert.ToBoolean(dt.Rows[j]["Visible"])) { dt.Rows.RemoveAt(j); } } return dt; }
private string LoadData() { string returnText = ""; try { int pg = 0; int pagesize = Convert.ToInt32(Settings["limits"]); if (pagesize == 0) { pagesize = 4; } string source = "0"; if (Settings["source"] != null) { source = Settings["source"].ToString(); } int numRecord; string newsgroupid = ""; string categoryid = ""; string newsgroupcode = ""; string categorycode = ""; NewsController engine = new NewsController(); bool displayTitle = true; if (Settings["displayTitle"] != null) { displayTitle = bool.Parse(Settings["displayTitle"].ToString()); } string titleCSSClass = ""; if (Settings["titleCSSClass"] != null) { titleCSSClass = Settings["titleCSSClass"].ToString(); } int thumnailHeight = 100; if (Settings["thumbnailHeight"] != null) { thumnailHeight = int.Parse(Settings["thumbnailHeight"].ToString()); } int thumnailWidth = 100; if (Settings["thumbnailWidth"] != null) { thumnailWidth = int.Parse(Settings["thumbnailWidth"].ToString()); } if (Settings["slideHeight"] != null) { slideHeight = Settings["slideHeight"].ToString(); int iScrollDownPosition = int.Parse(slideHeight) - 40; scrollDownPosition = iScrollDownPosition.ToString(); } if (Settings["leftPartWidth"] != null) { leftPartWidth = Settings["leftPartWidth"].ToString(); } if (Settings["rightPartWidth"] != null) { rightPartWidth = Settings["rightPartWidth"].ToString(); } int titleLength = 150; if (Settings["titleLength"] != null) { titleLength = int.Parse(Settings["titleLength"].ToString()); } int descLength = 150; if (Settings["descLength"] != null) { descLength = int.Parse(Settings["descLength"].ToString()); } MLCategoryInfo category; switch (source) { case "0": // theo cat từ URL if (Request.QueryString["categoryid"] != null) { categoryid = Request.QueryString["categoryid"]; if (displayTitle) { category = MLCategoryController.GetCategory(categoryid, System.Threading.Thread.CurrentThread.CurrentCulture.ToString(), false); if (category.MLCatName == null) { ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner"">" + category.CatName + @"</div></div>"; } else { ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner"">" + category.MLCatName.StringTextOrFallBack + @"</div></div>"; } } returnText = engine.LoadTextAsYahooSlideshow(categoryid, pagesize, thumnailHeight, thumnailWidth, titleLength, descLength); } else { returnText = ""; } break; case "1": // theo newsgroup từ URL if (Request.QueryString["newsgroupid"] != null) { newsgroupid = Request.QueryString["newsgroupid"]; returnText = engine.LoadTextByNewsGroupAsYahooSlideshow(newsgroupid, pagesize, thumnailHeight, thumnailWidth, titleLength, descLength); } else { returnText = ""; } break; case "2": // theo cat được chọn categoryid = this.Settings["categoryid"].ToString(); if (displayTitle) { category = MLCategoryController.GetCategory(categoryid, System.Threading.Thread.CurrentThread.CurrentCulture.ToString(), false); if (category.MLCatName == null) { ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner"">" + category.CatName + @"</div></div>"; } else { ltTitle.Text = @"<div class=""" + titleCSSClass + @"_outer"">" + @"<div class=""" + titleCSSClass + @"_inner"">" + category.MLCatName.StringTextOrFallBack + @"</div></div>"; } } returnText = engine.LoadTextAsYahooSlideshow(categoryid, pagesize, thumnailHeight, thumnailWidth, titleLength, descLength); break; case "3": // theo newsgroup được chọn newsgroupid = this.Settings["newsgroupid"].ToString(); returnText = engine.LoadTextByNewsGroupAsYahooSlideshow(newsgroupid, pagesize, thumnailHeight, thumnailWidth, titleLength, descLength); break; case "4": // theo cat code categorycode = this.Settings["categorycode"].ToString(); returnText = engine.LoadTextByCatCodeAsYahooSlideshow(PortalId, categorycode, pagesize, thumnailHeight, thumnailWidth, titleLength, descLength); break; case "5": // theo newsgroup code newsgroupcode = this.Settings["newsgroupcode"].ToString(); returnText = engine.LoadTextByGroupCodeAsYahooSlideshow(PortalId, newsgroupcode, pagesize, thumnailHeight, thumnailWidth, titleLength, descLength); break; case "6": // những bài đọc nhiều nhất returnText = engine.LoadHotTextAsYahooSlideshow(pagesize, "", PortalId, thumnailHeight, thumnailWidth, titleLength, descLength); break; case "7": // những bài mới nhất returnText = engine.LoadNewestTextAsYahooSlideshow(pagesize, "", PortalId, thumnailHeight, thumnailWidth, titleLength, descLength); break; } return(returnText); } catch (Exception ex) { return(returnText); } }