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 XmlNode GetNewsDetail() { XmlNode NewsDetailNode = xdoc.CreateElement("newsdetail"); DataTable dt = dal.GetNewDetail(Parameter.NewsID); //c.cateid,c.catename, //n.newsid,n.title,n.subtitle,n.brief,n.newscontent, //n.smallimageurl,n.author,n.newsfrom,n.videourl,n.imageurl,n.productid,n.inserttime,n.tags if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; XmlUtility.AddNewNode(NewsDetailNode, "newsid", Convert.ToString(row["newsid"])); XmlUtility.AddNewNode(NewsDetailNode, "title", Convert.ToString(row["title"])); XmlUtility.AddNewNode(NewsDetailNode, "subtitle", Convert.ToString(row["subtitle"])); XmlUtility.AddNewNode(NewsDetailNode, "cateid", Convert.ToString(row["cateid"])); XmlUtility.AddNewNode(NewsDetailNode, "catename", Convert.ToString(row["catename"])); XmlUtility.AddCDataNode(NewsDetailNode, "brief", Convert.ToString(row["brief"])); XmlUtility.AddCDataNode(NewsDetailNode, "newscontent", Convert.ToString(row["newscontent"])); XmlUtility.AddNewNode(NewsDetailNode, "smallimageurl", NewsImageRule.GetImageUrl(Convert.ToString(row["smallimageurl"]))); XmlUtility.AddNewNode(NewsDetailNode, "author", Convert.ToString(row["author"])); XmlUtility.AddNewNode(NewsDetailNode, "newsfrom", Convert.ToString(row["newsfrom"])); XmlUtility.AddNewNode(NewsDetailNode, "videourl", NewsVideoRule.GetVideoUrl(Convert.ToString(row["videourl"]))); XmlUtility.AddNewNode(NewsDetailNode, "imageurl", NewsImageRule.GetImageUrl(Convert.ToString(row["imageurl"]))); XmlUtility.AddNewNode(NewsDetailNode, "productid", Convert.ToString(row["productid"])); XmlUtility.AddNewNode(NewsDetailNode, "inserttime", Convert.ToDateTime(row["inserttime"]).ToString("yyyy-MM-dd hh:mm:ss")); XmlUtility.AddNewNode(NewsDetailNode, "tags", Convert.ToString(row["tags"])); } return(NewsDetailNode); }
public XmlNode GetCategoryInfo() { XmlNode CategoryInfoNode = xdoc.CreateElement("categoryinfo"); DataRow row = dal.GetCategoryInfo(Parameter.CategoryID); XmlUtility.AddNewNode(CategoryInfoNode, "categoryid", Convert.ToString(row["cateid"])); XmlUtility.AddNewNode(CategoryInfoNode, "categoryname", Convert.ToString(row["catename"])); XmlUtility.AddNewNode(CategoryInfoNode, "isendclass", (!(dal.GetCategorySonList(Parameter.CategoryID).Rows.Count > 0)).ToString()); XmlNode SearchPriceRangeNode = XmlUtility.AddNewNode(CategoryInfoNode, "priceranges", null); try { XmlDocument tempDoc = new XmlDocument(); tempDoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\" ?>" + row["PriceRange"]); XmlNodeList RangeNodes = tempDoc.SelectNodes("/PriceRange/Ranges/Range"); foreach (XmlNode n in RangeNodes) { XmlNode rNode = XmlUtility.AddNewNode(SearchPriceRangeNode, "range", null); //n.Attributes["minprice"] + "~" + n.Attributes["maxprice"]); XmlUtility.SetAtrributeValue(rNode, "min", n.Attributes["minprice"].Value); XmlUtility.SetAtrributeValue(rNode, "max", Convert.ToInt32(n.Attributes["maxprice"].Value) == -1 ? "0" : n.Attributes["maxprice"].Value); XmlUtility.SetAtrributeValue(rNode, "str", n.Attributes["minprice"].Value + "~" + (Convert.ToInt32(n.Attributes["maxprice"].Value) == -1 ? "0" : n.Attributes["maxprice"].Value)); } } catch (Exception ex) {} return(CategoryInfoNode); }
public XmlNode GetCategoryPathList() { XmlNode CategoryPathListNode = xdoc.CreateElement("categorypathlist"); foreach (DataRow row in dal.GetCategoryPathList(Parameter.CategoryPath).Rows) { XmlNode CategoryNode = XmlUtility.AddNewNode(CategoryPathListNode, "category", null); XmlUtility.AddNewNode(CategoryNode, "categoryid", row["cateid"].ToString()); XmlUtility.AddNewNode(CategoryNode, "categoryname", row["catename"].ToString()); } return(CategoryPathListNode); }
public XmlNode GetCategoryBrandList() { XmlNode BrandListNode = xdoc.CreateElement("brandlist"); foreach (DataRow row in dal.GetCategoryBrand(Parameter.CategoryID).Rows) { XmlNode BrandNode = XmlUtility.AddNewNode(BrandListNode, "brand", null); XmlUtility.AddNewNode(BrandNode, "brandid", Convert.ToString(row["brandid"])); XmlUtility.AddNewNode(BrandNode, "brandname", Convert.ToString(row["brandname"])); } return(BrandListNode); }
public XmlNode GetBrandCategoryList() { XmlNode BrandCategoryListNode = xdoc.CreateElement("brandcategory"); DataTable dt = dal.GetBrandCategoryList(Parameter.BrandID); foreach (DataRow row in dt.Rows) { XmlNode CategoryNode = XmlUtility.AddNewNode(BrandCategoryListNode, "category", null); XmlUtility.AddNewNode(CategoryNode, "categoryid", row["cateid"].ToString()); XmlUtility.AddNewNode(CategoryNode, "categoryname", row["catename"].ToString()); } return(BrandCategoryListNode); }
public XmlNode GetCategoryPathList() { XmlNode CategoryPathListNode = xdoc.CreateElement("categorypath"); DataTable dt = dal.GetCategoryPathList(Parameter.CategoryID); foreach (DataRow row in dt.Rows) { XmlNode CategoryNode = XmlUtility.AddNewNode(CategoryPathListNode, "category", null); XmlUtility.AddNewNode(CategoryNode, "categoryid", Convert.ToString(row["cateid"])); XmlUtility.AddNewNode(CategoryNode, "categoryname", Convert.ToString(row["catename"])); } return(CategoryPathListNode); }
public XmlNode GetNewsCategory() { XmlNode CategoryListNode = xdoc.CreateElement("categorylist"); DataTable dt = dal.GetCategoryList(0); foreach (DataRow row in dt.Rows) { XmlNode CagegoryNode = XmlUtility.AddNewNode(CategoryListNode, "category", null); XmlUtility.AddNewNode(CagegoryNode, "categoryid", Convert.ToString(row["cateid"])); XmlUtility.AddNewNode(CagegoryNode, "categoryname", Convert.ToString(row["catename"])); } return(CategoryListNode); }
public XmlNode GetProductTopicList() { XmlNode TopicListNode = xdoc.CreateElement("topics"); foreach (DataRow row in dal.GetProductTopicList(Parameter.ProductID).Rows) { XmlNode TopicNode = XmlUtility.AddNewNode(TopicListNode, "topic", null); XmlUtility.AddNewNode(TopicNode, "userid", Convert.ToString(row["userid"])); XmlUtility.AddNewNode(TopicNode, "title", Convert.ToString(row["title"])); XmlUtility.AddNewNode(TopicNode, "inserttime", Convert.ToDateTime(row["inserttime"]).ToString("yyyy-MM-dd")); XmlUtility.AddNewNode(TopicNode, "replynumber", Convert.ToString(row["replynum"])); } return(TopicListNode); }
public XmlNode GetProductSpecificationList() { XmlNode SpecificationListNode = xdoc.CreateElement("specifications"); DataTable dt = dal.GetProductSpecificationList(Parameter.ProductID, Parameter.CategoryID); foreach (DataRow row in dt.Rows) { XmlNode CategoryNode = XmlUtility.AddNewNode(SpecificationListNode, "specification", null); XmlUtility.AddNewNode(CategoryNode, "paraname", Convert.ToString(row["paraname"])); XmlUtility.AddNewNode(CategoryNode, "paravalue", Convert.ToString(row["paravalue"])); } return(SpecificationListNode); }
public XmlNode GetSplendidNewsList() { XmlNode SplendidNewsListNode = xdoc.CreateElement("splendidnewslist"); DataTable dt = dal.GetSplendidNewsList(0); foreach (DataRow row in dt.Rows) { XmlNode NewsNode = XmlUtility.AddNewNode(SplendidNewsListNode, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", Convert.ToString(row["newsid"])); XmlUtility.AddNewNode(NewsNode, "title", Convert.ToString(row["title"])); XmlUtility.AddNewNode(NewsNode, "brief", Convert.ToString(row["brief"])); XmlUtility.AddNewNode(NewsNode, "imageurl", NewsImageRule.GetImageUrl(Convert.ToString(row["imageurl"]))); } return(SplendidNewsListNode); }
public XmlNode GetProductQuestionList() { XmlNode QuestionListNode = xdoc.CreateElement("questions"); foreach (DataRow row in dal.GetProductQuestionList(Parameter.ProductID).Rows) { XmlNode QuestionNode = XmlUtility.AddNewNode(QuestionListNode, "question", null); XmlUtility.AddNewNode(QuestionNode, "userid", Convert.ToString(row["userid"])); XmlUtility.AddNewNode(QuestionNode, "questioncontent", Convert.ToString(row["content"])); XmlUtility.AddNewNode(QuestionNode, "questiontime", Convert.ToDateTime(row["inserttime"]).ToString("yyyy-MM-dd")); XmlUtility.AddNewNode(QuestionNode, "answercontent", Convert.ToString(row["answercontent"])); XmlUtility.AddNewNode(QuestionNode, "answertime", row["answertime"].ToString() == ""?"":Convert.ToDateTime(row["answertime"]).ToString("yyyy-MM-dd")); } return(QuestionListNode); }
public XmlNode GetNewsCommentList() { XmlNode CommentListNode = xdoc.CreateElement("comments"); DataTable dt = dal.GetNewsComments(Parameter.NewsID); foreach (DataRow row in dt.Rows) { XmlNode CommentNode = XmlUtility.AddNewNode(CommentListNode, "comment", null); XmlUtility.AddNewNode(CommentNode, "commentid", row["commentid"].ToString()); XmlUtility.AddNewNode(CommentNode, "userid", row["userid"].ToString()); XmlUtility.AddNewNode(CommentNode, "createtime", Convert.ToDateTime(row["createtime"]).ToString("yyyy-MM-dd")); XmlUtility.AddNewNode(CommentNode, "content", row["content"].ToString()); } return(CommentListNode); }
public XmlNode GetSalesProductList() { XmlNode SalesProductListNode = xdoc.CreateElement("salesproducts"); DataTable dt = dal.GetBrandHotSaleProductList(Parameter.BrandID); foreach (DataRow row in dt.Rows) { XmlNode ProductNode = XmlUtility.AddNewNode(SalesProductListNode, "product", null); XmlUtility.AddNewNode(ProductNode, "productid", Convert.ToString(row["productid"])); XmlUtility.AddNewNode(ProductNode, "productname", Convert.ToString(row["productname"])); XmlUtility.AddNewNode(ProductNode, "productimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["smallimage"]))); XmlUtility.AddNewNode(ProductNode, "price", Convert.ToDecimal(Convert.ToDecimal(row["MerchantPrice"]) - Convert.ToDecimal(row["reduceprice"])).ToString("00")); } return(SalesProductListNode); }
public XmlNode GetSameBrandProductList() { XmlNode BrandProductsNode = xdoc.CreateElement("samebrandproducts"); DataTable dt = dal.GetSameBrandProduct(Parameter.ProductID); foreach (DataRow row in dt.Rows) { XmlNode ProductNode = XmlUtility.AddNewNode(BrandProductsNode, "product", null); XmlUtility.AddNewNode(ProductNode, "productid", Convert.ToString(row["productid"])); XmlUtility.AddNewNode(ProductNode, "productname", Convert.ToString(row["productname"])); XmlUtility.AddNewNode(ProductNode, "productnameshort", Convert.ToString(row["productname"]).Length > 10 ? Convert.ToString(row["productname"]).Substring(0, 10) + ".." : Convert.ToString(row["productname"])); XmlUtility.AddNewNode(ProductNode, "price", Convert.ToDecimal(Convert.ToDecimal(row["MerchantPrice"]) - Convert.ToDecimal(row["reduceprice"])).ToString("00")); } return(BrandProductsNode); }
public XmlNode GetHotSaleProductList() { XmlNode HotSaleProductsNode = xdoc.CreateElement("hotsaleproduct"); DataTable dt = dal.GetHotSaleProduct(new CategoryModelBll().GetCategoryPath(Parameter.CategoryID)); foreach (DataRow row in dt.Rows) { XmlNode ProductNode = XmlUtility.AddNewNode(HotSaleProductsNode, "product", null); XmlUtility.AddNewNode(ProductNode, "productid", Convert.ToString(row["productid"])); XmlUtility.AddNewNode(ProductNode, "productname", Convert.ToString(row["productname"])); XmlUtility.AddNewNode(ProductNode, "productimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["smallimage"]))); XmlUtility.AddNewNode(ProductNode, "price", Convert.ToDecimal(Convert.ToDecimal(row["MerchantPrice"]) - Convert.ToDecimal(row["reduceprice"])).ToString("00")); } return(HotSaleProductsNode); }
public XmlNode GetBrandInfo() { XmlNode BrandInfoNode = xdoc.CreateElement("brandinfo"); DataTable dt = dal.GetBrandInfo(Parameter.BrandID); if (dt.Rows.Count > 0) { XmlUtility.AddNewNode(BrandInfoNode, "brandid", Convert.ToString(dt.Rows[0]["brandid"])); XmlUtility.AddNewNode(BrandInfoNode, "categoryid", Convert.ToString(Parameter.CategoryID)); XmlUtility.AddNewNode(BrandInfoNode, "ordertype", Convert.ToString(Parameter.OrderType)); XmlUtility.AddNewNode(BrandInfoNode, "brandname", Convert.ToString(dt.Rows[0]["brandname"])); XmlUtility.AddNewNode(BrandInfoNode, "brandlogo", CommonImageUpload.GetCommonImageFullUrl(Convert.ToString(dt.Rows[0]["brandlogo"]))); XmlUtility.AddNewNode(BrandInfoNode, "brief", Convert.ToString(dt.Rows[0]["brief"])); } return(BrandInfoNode); }
public XmlNode GetProductCommentList() { int RecordCount = 0; DataTable dt = dal.GetProductCommentList(Parameter.ProductID, out RecordCount); XmlNode CommentListNode = xdoc.CreateElement("comments"); XmlUtility.SetAtrributeValue(CommentListNode, "count", RecordCount.ToString()); foreach (DataRow row in dt.Rows) { XmlNode CommentNode = XmlUtility.AddNewNode(CommentListNode, "comment", null); XmlUtility.AddNewNode(CommentNode, "userid", Convert.ToString(row["userid"])); XmlUtility.AddNewNode(CommentNode, "content", Convert.ToString(row["content"])); XmlUtility.AddNewNode(CommentNode, "createtime", Convert.ToDateTime(row["createtime"]).ToString("yyyy-MM-dd")); } return(CommentListNode); }
public XmlNode GetCategoryList() { XmlNode CategoryListNode = xdoc.CreateElement("categorylist"); int AncestorID = new CategoryModelBll().GetAncestorID(Parameter.CategoryID); XmlNode AncestorInfoNode = XmlUtility.AddNewNode(CategoryListNode, "ancestorinfo", null); CategoryModel AncestorCategory = new CategoryModelBll().GetModel(AncestorID); XmlUtility.AddNewNode(AncestorInfoNode, "categoryid", Convert.ToString(AncestorID)); XmlUtility.AddNewNode(AncestorInfoNode, "categoryname", AncestorCategory.CateName); XmlNode CategoriesNode = XmlUtility.AddNewNode(CategoryListNode, "categories", null); DataTable RootCategories = dal.GetCategorySonList(AncestorID); foreach (DataRow row in RootCategories.Rows) { XmlNode FatherNode = XmlUtility.AddNewNode(CategoriesNode, "fathercategory", null); XmlUtility.SetAtrributeValue(FatherNode, "categoryid", Convert.ToString(row["cateid"])); XmlUtility.SetAtrributeValue(FatherNode, "categoryname", Convert.ToString(row["catename"])); int CategoryID = Convert.ToInt32(row["cateid"]); DataTable SonCategories = dal.GetCategorySonList(CategoryID); if (SonCategories.Rows.Count > 0) { foreach (DataRow srow in SonCategories.Rows) { XmlNode SonNode = XmlUtility.AddNewNode(FatherNode, "soncategory", null); XmlUtility.SetAtrributeValue(SonNode, "categoryid", Convert.ToString(srow["cateid"])); XmlUtility.SetAtrributeValue(SonNode, "categoryname", Convert.ToString(srow["catename"])); } } } return(CategoryListNode); }
public XmlDocument GetData(NameValueCollection TagParameter) { XmlDocument xdoc = new XmlDocument(); xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />"); XmlNode rootNode = xdoc.SelectSingleNode("/tag"); SecondhandProductBll bll = new SecondhandProductBll(); DataTable dt = bll.GetTopHotList(10); foreach (DataRow row in dt.Rows) { XmlNode DealListNode = XmlUtility.AddNewNode(rootNode, "deal", null); XmlUtility.AddNewNode(DealListNode, "pid", row["seproductid"].ToString()); XmlUtility.AddNewNode(DealListNode, "productname", row["seproductname"].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.GetTopSplendidNews(8); 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); }
public XmlDocument GetData(NameValueCollection TagParameter) { XmlDocument xdoc = new XmlDocument(); xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />"); XmlNode rootNode = xdoc.SelectSingleNode("/tag"); XmlNode PawnNode = XmlUtility.AddNewNode(rootNode, "pawn", null); DataTable dt1 = new PawnProductBll().GetNewestList(2, PawnProductStatus.已收当); foreach (DataRow row in dt1.Rows) { XmlNode PawnProductNode = XmlUtility.AddNewNode(PawnNode, "pawnproduct", null); XmlUtility.AddNewNode(PawnProductNode, "pid", row["pawnproductid"].ToString()); XmlUtility.AddNewNode(PawnProductNode, "productname", row["pawnproductname"].ToString()); XmlUtility.AddNewNode(PawnProductNode, "image", MagicWorldImageRule.GetMainImageUrl(row["smallimage"].ToString())); XmlUtility.AddNewNode(PawnProductNode, "price", row["sellingprice"].ToString()); XmlUtility.AddNewNode(PawnProductNode, "deadtime", Convert.ToDateTime(row["deadtime"]).ToString("yyyy-MM-dd")); } XmlNode RentNode = XmlUtility.AddNewNode(rootNode, "rent", null); DataTable dt2 = new RentProductBll().GetNewestList(10); foreach (DataRow row in dt2.Rows) { XmlNode RentProductNode = XmlUtility.AddNewNode(RentNode, "rentlist", null); XmlUtility.AddNewNode(RentProductNode, "rentid", row["rentid"].ToString()); XmlUtility.AddNewNode(RentProductNode, "rentname", row["rentname"].ToString()); XmlUtility.AddNewNode(RentProductNode, "createtime", Convert.ToDateTime(row["createtime"]).ToString("yyyy年MM月dd日")); } 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"); 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"); 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); }
public XmlDocument GetData(NameValueCollection TagParameter) { XmlDocument xdoc = new XmlDocument(); xdoc.LoadXml("<?xml version=\"1.0\" encoding=\"utf-8\"?><tag />"); XmlNode rootNode = xdoc.SelectSingleNode("/tag"); DataTable dt = new SecondhandProductBll().GetNewestList(9); foreach (DataRow row in dt.Rows) { XmlNode DealProductNode = XmlUtility.AddNewNode(rootNode, "deal", null); XmlUtility.AddNewNode(DealProductNode, "pid", row["pid"].ToString()); XmlUtility.AddNewNode(DealProductNode, "pname", row["pname"].ToString()); XmlUtility.AddNewNode(DealProductNode, "price", row["price"].ToString()); XmlUtility.AddNewNode(DealProductNode, "ptype", row["ptype"].ToString()); XmlUtility.AddNewNode(DealProductNode, "mediumimage", MagicWorldImageRule.GetMainImageUrl(row["mediumimage"].ToString())); XmlUtility.AddNewNode(DealProductNode, "inserttime", Convert.ToDateTime(row["inserttime"]).ToString("yyyy-MM-dd")); } return(xdoc); }
public XmlNode GetCategoryProperityList() { XmlNode ProperityListNode = xdoc.CreateElement("properitylist"); DataTable dt = dal.GetCategoryProperityList(Parameter.CategoryID); foreach (DataRow row in dt.Rows) { XmlNode ProperityNode = XmlUtility.AddNewNode(ProperityListNode, "prop", null); XmlUtility.AddNewNode(ProperityNode, "propid", row["paraid"].ToString()); XmlUtility.AddNewNode(ProperityNode, "propname", row["paraname"].ToString()); XmlNode ProperityValueNode = XmlUtility.AddNewNode(ProperityNode, "values", null); string[] values = row["paravalues"].ToString().Split(','); for (int i = 0; i < values.Length; i++) { XmlNode ValueNode = XmlUtility.AddNewNode(ProperityValueNode, "value", null); XmlUtility.AddNewNode(ValueNode, "valueid", i.ToString()); XmlUtility.AddNewNode(ValueNode, "value", values[i]); } } return(ProperityListNode); }
public XmlNode GetNewsList() { XmlNode NewsListNode = xdoc.CreateElement("newslist"); XmlNode ListNode = XmlUtility.AddNewNode(NewsListNode, "list", null); int RecordCount = 0, PageCount = 0; DataTable dt = dal.GetNewsList(Parameter.PageIndex, Config.ListPageSize, Parameter.CategoryID, out RecordCount, out PageCount); foreach (DataRow row in dt.Rows) { XmlNode NewsNode = XmlUtility.AddNewNode(ListNode, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", Convert.ToString(row["newsid"])); XmlUtility.AddNewNode(NewsNode, "title", Convert.ToString(row["title"])); XmlUtility.AddNewNode(NewsNode, "brief", Convert.ToString(row["brief"])); XmlUtility.AddNewNode(NewsNode, "imageurl", NewsImageRule.GetImageUrl(Convert.ToString(row["imageurl"]))); } //分页信息节点 XmlNode PageInfoNode = XmlUtility.AddNewNode(NewsListNode, "pageinfo", null); XmlUtility.SetAtrributeValue(PageInfoNode, "recordcount", RecordCount.ToString()); XmlUtility.SetAtrributeValue(PageInfoNode, "pagecount", PageCount.ToString()); XmlUtility.SetAtrributeValue(PageInfoNode, "currentpage", Parameter.PageIndex.ToString()); if (PageCount <= 11) //小于最大显示数目,全部显示即可 { for (int i = 1; i <= PageCount; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } } else //大于最大显示数据,需要根据pageindex决定显示页码 { XmlNode PageNodeS = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeS, "pageindex", 1.ToString()); if (Parameter.PageIndex == 1) { XmlUtility.SetAtrributeValue(PageNodeS, "isselected", "true"); } if (Parameter.PageIndex < 10) { for (int i = 2; i <= 10; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } XmlNode PageNodeME = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeME, "pageindex", "..."); } else { if (Parameter.PageIndex >= 10 && Parameter.PageIndex <= PageCount - 10) { XmlNode PageNodeMS = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeMS, "pageindex", "..."); for (int i = Parameter.PageIndex - 5; i < Parameter.PageIndex + 5; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } XmlNode PageNodeME = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeME, "pageindex", "..."); } else { if (Parameter.PageIndex > PageCount - 10) { XmlNode PageNodeMS = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeMS, "pageindex", "..."); for (int i = PageCount - 10; i <= PageCount - 1; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } } } } XmlNode PageNodeE = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeE, "pageindex", PageCount.ToString()); if (Parameter.PageIndex == PageCount) { XmlUtility.SetAtrributeValue(PageNodeE, "isselected", "true"); } } return(NewsListNode); }
public XmlNode GetProductInfo() { XmlNode ProductInfoNode = xdoc.CreateElement("productinfo"); //产品信息节点 XmlNode ProductNode = XmlUtility.AddNewNode(ProductInfoNode, "product", null); DataTable dt = dal.GetProductInfo(Parameter.ProductID); if (dt == null || dt.Rows == null || dt.Rows.Count <= 0) { throw new PublishException("商品不存在"); } if (Convert.ToInt32(dt.Rows[0]["status"]) != 1) { throw new PublishException("商品已下架"); } DataRow row = dt.Rows[0]; XmlUtility.AddNewNode(ProductNode, "productid", Convert.ToString(row["ProductId"])); XmlUtility.AddNewNode(ProductNode, "productname", Convert.ToString(row["ProductName"])); XmlUtility.AddNewNode(ProductNode, "productcode", Convert.ToString(row["ProductCode"])); XmlUtility.AddNewNode(ProductNode, "categorypath", Convert.ToString(row["CatePath"])); XmlUtility.AddNewNode(ProductNode, "categoryid", Convert.ToString(row["CateId"])); XmlUtility.AddNewNode(ProductNode, "tradeprice", Convert.ToString(row["TradePrice"])); XmlUtility.AddNewNode(ProductNode, "merchantprice", Convert.ToString(row["MerchantPrice"])); XmlUtility.AddNewNode(ProductNode, "actualprice", Convert.ToString(Convert.ToDecimal(row["MerchantPrice"]) - Convert.ToDecimal(row["reduceprice"]))); XmlUtility.AddNewNode(ProductNode, "tradeprice", Convert.ToString(row["ReducePrice"])); XmlUtility.AddNewNode(ProductNode, "stock", Convert.ToString(row["Stock"])); XmlUtility.AddNewNode(ProductNode, "stocktip", Convert.ToString(row["stocktip"])); XmlUtility.AddNewNode(ProductNode, "smallimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["SmallImage"]))); XmlUtility.AddNewNode(ProductNode, "mediumimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["MediumImage"]))); XmlUtility.AddNewNode(ProductNode, "largeimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["LargeImage"]))); XmlUtility.AddNewNode(ProductNode, "keywords", Convert.ToString(row["Keywords"])); XmlUtility.AddCDataNode(ProductNode, "brief", Convert.ToString(row["Brief"])); XmlUtility.AddNewNode(ProductNode, "pageview", Convert.ToString(row["PageView"])); XmlUtility.AddNewNode(ProductNode, "inserttime", Convert.ToString(row["InsertTime"])); XmlUtility.AddNewNode(ProductNode, "changetime", Convert.ToString(row["ChangeTime"])); XmlUtility.AddNewNode(ProductNode, "score", Convert.ToString(row["Score"])); XmlUtility.AddCDataNode(ProductNode, "specifications", Convert.ToString(row["specifications"])); XmlUtility.AddCDataNode(ProductNode, "packinglist", Convert.ToString(row["packinglist"])); XmlUtility.AddCDataNode(ProductNode, "saleservice", Convert.ToString(row["aftersaleservice"])); XmlUtility.AddCDataNode(ProductNode, "offerset", Convert.ToString(row["offerset"])); XmlNode MultiImagesNode = XmlUtility.AddNewNode(ProductNode, "multiimages", null); XmlNode MainImageNode = XmlUtility.AddNewNode(MultiImagesNode, "image", null); XmlUtility.AddNewNode(MainImageNode, "smallimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["SmallImage"]))); XmlUtility.AddNewNode(MainImageNode, "largeimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["MediumImage"]))); XmlUtility.AddNewNode(MainImageNode, "originimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["LargeImage"]))); foreach (DataRow imageRow in dal.GetProductMultiImage(Parameter.ProductID).Rows) { XmlNode MultiImageNode = XmlUtility.AddNewNode(MultiImagesNode, "image", null); XmlUtility.AddNewNode(MultiImageNode, "smallimage", ProductMultiImageRule.GetMultiImageUrl(Convert.ToString(imageRow["smallimage"]))); XmlUtility.AddNewNode(MultiImageNode, "largeimage", ProductMultiImageRule.GetMultiImageUrl(Convert.ToString(imageRow["largeimage"]))); XmlUtility.AddNewNode(MultiImageNode, "originimage", ProductMultiImageRule.GetMultiImageUrl(Convert.ToString(imageRow["originimage"]))); } //相关产品节点 XmlNode RelatedProductNode = XmlUtility.AddNewNode(ProductInfoNode, "relatedproducts", null); DataTable RelatedProductTable = dal.GetRelatedProduct(dt.Rows[0]["relateproducts"].ToString()); if (RelatedProductTable.Rows.Count > 0) { foreach (DataRow RelatedProductRow in RelatedProductTable.Rows) { XmlNode RelatedProduct = XmlUtility.AddNewNode(RelatedProductNode, "product", null); XmlUtility.AddNewNode(RelatedProduct, "productid", Convert.ToString(RelatedProductRow["productid"])); XmlUtility.AddNewNode(RelatedProduct, "productimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(RelatedProductRow["smallimage"]))); XmlUtility.AddNewNode(RelatedProduct, "productname", Convert.ToString(RelatedProductRow["productname"])); XmlUtility.AddNewNode(RelatedProduct, "productnameshort", Convert.ToString(RelatedProductRow["productname"]).Length > 10 ? Convert.ToString(RelatedProductRow["productname"]).Substring(0, 10) + ".." : Convert.ToString(RelatedProductRow["productname"])); XmlUtility.AddNewNode(RelatedProduct, "price", Convert.ToDecimal(Convert.ToDecimal(RelatedProductRow["MerchantPrice"]) - Convert.ToDecimal(RelatedProductRow["reduceprice"])).ToString("00")); } } //关联资讯节点 XmlNode RelatedNewsNode = XmlUtility.AddNewNode(ProductInfoNode, "relatednews", null); DataTable RelatedNewsTable = dal.GetRelatedNewsInfo(Parameter.ProductID); if (RelatedNewsTable != null && RelatedNewsTable.Rows.Count > 0) { XmlNode NewsNode = XmlUtility.AddNewNode(RelatedNewsNode, "news", null); XmlUtility.AddNewNode(NewsNode, "newsid", RelatedNewsTable.Rows[0]["newsid"].ToString()); XmlUtility.AddNewNode(NewsNode, "newscontent", RelatedNewsTable.Rows[0]["newscontent"].ToString()); } return(ProductInfoNode); }
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 XmlNode GetProductList() { XmlNode ProductListNode = xdoc.CreateElement("productlist"); int RecordCount = 0, PageCount = 0; DataTable dt; if (Parameter.Properities == null) { dt = dal.GetProductList(Parameter.CategoryID, Parameter.PageIndex, Parameter.BrandID, Parameter.PriceRange, Parameter.OrderValue, out RecordCount, out PageCount); } else { dt = dal.GetProductList(Parameter.CategoryID, Parameter.PageIndex, Parameter.BrandID, Parameter.PriceRange, Parameter.OrderValue, Parameter.Properities, out RecordCount, out PageCount); } //商品列表节点 XmlNode ProductsNode = XmlUtility.AddNewNode(ProductListNode, "products", null); foreach (DataRow row in dt.Rows) { XmlNode ProductNode = XmlUtility.AddNewNode(ProductsNode, "product", null); XmlUtility.AddNewNode(ProductNode, "productid", Convert.ToString(row["productid"])); XmlUtility.AddNewNode(ProductNode, "productname", Convert.ToString(row["productname"])); XmlUtility.AddNewNode(ProductNode, "smallimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["smallimage"]))); XmlUtility.AddNewNode(ProductNode, "mediumimage", ProductMainImageRule.GetMainImageUrl(Convert.ToString(row["mediumimage"]))); XmlUtility.AddNewNode(ProductNode, "tradeprice", Convert.ToString(row["tradeprice"])); XmlUtility.AddNewNode(ProductNode, "merchantprice", Convert.ToString(row["merchantprice"])); XmlUtility.AddNewNode(ProductNode, "categoryid", Convert.ToString(row["cateid"])); } //分页信息节点 XmlNode PageInfoNode = XmlUtility.AddNewNode(ProductListNode, "pageinfo", null); XmlUtility.SetAtrributeValue(PageInfoNode, "recordcount", RecordCount.ToString()); XmlUtility.SetAtrributeValue(PageInfoNode, "pagecount", PageCount.ToString()); XmlUtility.SetAtrributeValue(PageInfoNode, "currentpage", Parameter.PageIndex.ToString()); if (PageCount <= 11) //小于最大显示数目,全部显示即可 { for (int i = 1; i <= PageCount; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } } else //大于最大显示数据,需要根据pageindex决定显示页码 { XmlNode PageNodeS = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeS, "pageindex", 1.ToString()); if (Parameter.PageIndex == 1) { XmlUtility.SetAtrributeValue(PageNodeS, "isselected", "true"); } if (Parameter.PageIndex < 10) { for (int i = 2; i <= 10; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } XmlNode PageNodeME = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeME, "pageindex", "..."); } else { if (Parameter.PageIndex >= 10 && Parameter.PageIndex <= PageCount - 10) { XmlNode PageNodeMS = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeMS, "pageindex", "..."); for (int i = Parameter.PageIndex - 5; i < Parameter.PageIndex + 5; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } XmlNode PageNodeME = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeME, "pageindex", "..."); } else { if (Parameter.PageIndex > PageCount - 10) { XmlNode PageNodeMS = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeMS, "pageindex", "..."); for (int i = PageCount - 10; i <= PageCount - 1; i++) { XmlNode PageNode = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNode, "pageindex", i.ToString()); if (i == Parameter.PageIndex) { XmlUtility.SetAtrributeValue(PageNode, "isselected", "true"); } } } } } XmlNode PageNodeE = XmlUtility.AddNewNode(PageInfoNode, "page", ""); XmlUtility.SetAtrributeValue(PageNodeE, "pageindex", PageCount.ToString()); if (Parameter.PageIndex == PageCount) { XmlUtility.SetAtrributeValue(PageNodeE, "isselected", "true"); } } return(ProductListNode); }