private XmlNode GetNode(int CategoryID, XmlDocument xdoc) { XmlNode TempNode = xdoc.CreateElement("categorynode"); NewsModelBll bll = new NewsModelBll(); NewsCategoryModel CategoryModel = new NewsCategoryModelBll().GetModel(CategoryID); DataTable dt = bll.GetTopCategoryNews(6, CategoryID); XmlNode NewsCategoryNode = XmlUtility.AddNewNode(TempNode, "category", null); if (CategoryModel != null) { XmlUtility.AddNewNode(NewsCategoryNode, "categoryid", CategoryModel.CateID.ToString()); XmlUtility.AddNewNode(NewsCategoryNode, "categoryname", CategoryModel.CateName); XmlNode NewsListNode = XmlUtility.AddNewNode(TempNode, "newslist", null); foreach (DataRow row in dt.Rows) { XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString()); XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString()); XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString())); XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString())); } } return TempNode; }
public XmlDocument GetData(NameValueCollection TagParameter) { XmlDocument xdoc = new XmlDocument(); xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />"); XmlNode rootNode = xdoc.SelectSingleNode("/tag"); int CategoryID = 43; NewsModelBll bll = new NewsModelBll(); NewsCategoryModel CategoryModel = new NewsCategoryModelBll().GetModel(CategoryID); DataTable dt = bll.GetTopCategoryNews(6, CategoryID); XmlNode NewsCategoryNode = XmlUtility.AddNewNode(rootNode, "category", null); if (CategoryModel != null) { XmlUtility.AddNewNode(NewsCategoryNode, "categoryid", CategoryModel.CateID.ToString()); XmlUtility.AddNewNode(NewsCategoryNode, "categoryname", CategoryModel.CateName); XmlNode NewsListNode = XmlUtility.AddNewNode(rootNode, "newslist", null); foreach (DataRow row in dt.Rows) { XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString()); XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString()); XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString())); XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString())); } } return xdoc; }
public XmlDocument GetData(NameValueCollection TagParameter) { XmlDocument xdoc = new XmlDocument(); xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />"); XmlNode rootNode = xdoc.SelectSingleNode("/tag"); NewsModelBll bll = new NewsModelBll(); XmlNode CategoryNodel1 = XmlUtility.AddNewNode(rootNode, "category1", null); NewsCategoryModel Category1Model = new NewsCategoryModelBll().GetModel(3); DataTable dt1 = bll.GetTopCategoryNews(6, 3); XmlNode NewsCategoryNode1 = XmlUtility.AddNewNode(CategoryNodel1, "category", null); XmlNode NewsListNode1 = XmlUtility.AddNewNode(CategoryNodel1, "newslist", null); if (Category1Model != null) { XmlUtility.AddNewNode(NewsCategoryNode1, "categoryid", Category1Model.CateID.ToString()); XmlUtility.AddNewNode(NewsCategoryNode1, "categoryname", Category1Model.CateName); foreach (DataRow row in dt1.Rows) { XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode1, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString()); XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString().Length > 15 ? row["title"].ToString().Substring(0, 14) + "..." : row["title"].ToString()); XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString())); XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString())); } } XmlNode CategoryNode2 = XmlUtility.AddNewNode(rootNode, "category2", null); NewsCategoryModel CategoryModel2 = new NewsCategoryModelBll().GetModel(6); DataTable dt2 = bll.GetTopCategoryNews(6, 6); XmlNode NewsCategoryNode2 = XmlUtility.AddNewNode(CategoryNode2, "category", null); XmlNode NewsListNode2 = XmlUtility.AddNewNode(CategoryNode2, "newslist", null); if (CategoryModel2 != null) { XmlUtility.AddNewNode(NewsCategoryNode2, "categoryid", CategoryModel2.CateID.ToString()); XmlUtility.AddNewNode(NewsCategoryNode2, "categoryname", CategoryModel2.CateName); foreach (DataRow row in dt2.Rows) { XmlNode NewsNode = XmlUtility.AddNewNode(NewsListNode2, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString()); XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString().Length > 17 ? row["title"].ToString().Substring(0, 16) + "..." : row["title"].ToString()); XmlUtility.AddNewNode(NewsNode, "image", NewsImageRule.GetImageUrl(row["imageurl"].ToString())); XmlUtility.AddNewNode(NewsNode, "video", NewsVideoRule.GetVideoUrl(row["videourl"].ToString())); } } return xdoc; }
public XmlDocument GetData(NameValueCollection TagParameter) { XmlDocument xdoc = new XmlDocument(); xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />"); XmlNode rootNode = xdoc.SelectSingleNode("/tag"); NewsModelBll bll = new NewsModelBll(); DataTable dt = bll.GetTopViewedNews(15); foreach(DataRow row in dt.Rows) { XmlNode NewsNode = XmlUtility.AddNewNode(rootNode, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", row["newsid"].ToString()); XmlUtility.AddNewNode(NewsNode, "title", row["title"].ToString()); } return xdoc; }