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