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 NewsCategoryModel GetSelectedRegionInfo(out bool IsEndClass) { string regionPath = String.Empty; string country = Request.Form["category0"]; string province = Request.Form["category1"]; string city = Request.Form["category2"]; string county = Request.Form["category3"]; int curRegionId = 0; if (curRegionId == 0 && !String.IsNullOrEmpty(county)) int.TryParse(county, out curRegionId); if (curRegionId == 0 && !String.IsNullOrEmpty(city)) int.TryParse(city, out curRegionId); if (curRegionId == 0 && !String.IsNullOrEmpty(province)) int.TryParse(province, out curRegionId); if (curRegionId == 0 && !String.IsNullOrEmpty(country)) int.TryParse(country, out curRegionId); NewsCategoryModel result = null; IsEndClass = false; if (curRegionId > 0) { result = new NewsCategoryModelBll().GetModel(curRegionId); IsEndClass = !new NewsCategoryModelBll().HasChild(result.CateID); } return result; }
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 void GetSearchCondition() { SearchCondition = ""; if (CheckBox_NewsID.Checked) { if (PageValidate.IsNumber(TextBox_NewsID.Text)) { SearchCondition += " and newsid=" + Convert.ToInt32(TextBox_NewsID.Text); } else { MessageBox.Show(this,"请输入正确的新闻ID"); return; } } if (CheckBox_NewsName.Checked) { if (!String.IsNullOrEmpty(TextBox_NewsName.Text)) { SearchCondition += " and title like '%" + TextBox_NewsName.Text.Trim().Replace("'","") + "%'"; } else { MessageBox.Show(this, "请输入新闻标题"); return; } } if (CheckBox_Category.Checked) { bool test; NewsCategoryModel model = NewsCategorySelect1.GetSelectedRegionInfo(out test); if (model != null) { SearchCondition += " and dbo.GetNewsCategoryPath(cateid)+'/' like dbo.GetNewsCategoryPath(" + model.CateID + ")+'/%'"; if (!CheckBox_Category.Checked) CheckBox_Category.Checked = true; string CategoryPath = new NewsCategoryModelBll().GetPath(model.CateID); //CategoryPath = CategoryPath.Contains("/") ? CategoryPath.Substring(0, CategoryPath.LastIndexOf("/")) : CategoryPath; NewsCategorySelect1.PresetRegionInfo(CategoryPath); } else { MessageBox.Show(this, "请选择分类"); return; } } }
public void PopulateNodes(TreeNodeCollection nodes, int ParentID) { NewsCategoryModelBll bll = new NewsCategoryModelBll(); DataTable dt = bll.GetList(ParentID); for (int i = 0; i < dt.Rows.Count; i++) { TreeNode tn = new TreeNode(); tn.Text = dt.Rows[i]["catename"].ToString(); tn.Value = dt.Rows[i]["cateid"].ToString(); tn.ImageToolTip = dt.Rows[i]["catename"].ToString(); tn.ToolTip = dt.Rows[i]["catename"].ToString(); nodes.Add(tn); PopulateNodes(tn.ChildNodes, Convert.ToInt32(dt.Rows[i]["cateid"])); } }
public XmlDocument GetData(NameValueCollection TagParameter) { XmlDocument xdoc = new XmlDocument(); xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />"); XmlNode rootNode = xdoc.SelectSingleNode("/tag"); NewsCategoryModelBll bll = new NewsCategoryModelBll(); DataTable dt = bll.GetList(22); foreach (DataRow row in dt.Rows) { XmlNode CategoryNode = XmlUtility.AddNewNode(rootNode, "category", null); XmlUtility.AddNewNode(CategoryNode, "categoryid", row["cateid"].ToString()); XmlUtility.AddNewNode(CategoryNode, "categoryname", row["catename"].ToString()); } return xdoc; }
private DataTable ProcessCategory(DataTable dt) { string ForeFlatRootUrl = ConfigurationManager.AppSettings["foreFlatRootUrl"]; dt.Columns.Add("catename"); dt.Columns.Add("fronturl"); foreach (DataRow row in dt.Rows) { row["catename"] = new NewsCategoryModelBll().GetModel(Convert.ToInt32(row["cateid"])).CateName; row["fronturl"] = String.Format("{0}news-{1}.html", ForeFlatRootUrl.EndsWith("/") ? ForeFlatRootUrl : ForeFlatRootUrl + "/", row["newsid"]); } return dt; }