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;
}
