本文实例讲述了asp.net类序列化生成xml文件的方法。分享给大家供大家参考,具体如下:
根据设计的需求需要开发多个商品的API 原XML文件如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
< urlset > < url > < loc >http://www.xxxxx.com/todaydetials.aspx?id=143</ loc > < data > < display > < website >爱购114</ website > < siteurl >http://www.xxxxx.com/</ siteurl > < city >杭州</ city > < webSitetitle ></ webSitetitle > < image ></ image > < startTime >2011-2-9</ startTime > < endTime >2011-2-15</ endTime > < value >3880</ value > < price >2088</ price > < rebate >0.53</ rebate > < bought >0</ bought > </ display > </ data > </ url > </ urlset > |
现在需求是要根据数据库有几条商品信息 相应的API XML文件出现几个URL节点! 采用类序列化成XML文件然后读取相应生成的XML文件就可以展示多个商品XML的信息 实现代码如下:
首先定义好XML 各个节点的数据及父子节点的关系类:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
|
#region 定义数据实体类xml数据结构 public class urlset { public List<url> urlList { get ; set ; } } public class url { public string loc { get ; set ; } public List<data> dataList { get ; set ; } } public class data { public List<display> displayList { get ; set ; } } public class display { public string website { get ; set ; } public string siteurl { get ; set ; } public string city { get ; set ; } public string webSitetitle { get ; set ; } public string image { get ; set ; } public string startTime { get ; set ; } public string endTime { get ; set ; } public double value { get ; set ; } public double price { get ; set ; } public double rebate { get ; set ; } public int bought { get ; set ; } } #endregion |
第二步:#region 定义获取网站信息实体类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
public class WebSiteInfo { /// <summary> /// 商品标题 /// </summary> public string title { get ; set ; } /// <summary> /// 商品发布时间 /// </summary> public DateTime createtime { get ; set ; } /// <summary> /// 商品图片 /// </summary> public string productimg { get ; set ; } /// <summary> /// 市场价 /// </summary> public decimal market_price { get ; set ; } /// <summary> /// 团购价 /// </summary> public decimal team_price { get ; set ; } /// <summary> /// 折扣价 /// </summary> public decimal zhekou_price { get ; set ; } /// <summary> /// 城市名称 /// </summary> public string cityName { get ; set ; } /// <summary> /// 商品开始时间 /// </summary> public DateTime begin_time { get ; set ; } /// <summary> /// 结束时间 /// </summary> public DateTime end_time { get ; set ; } /// <summary> /// 商家名称 /// </summary> public string merchants_id { get ; set ; } /// <summary> /// 本单详情 /// </summary> public string description { get ; set ; } /// <summary> /// 最低购买人数 /// </summary> public int lowBuNo { get ; set ; } /// <summary> /// 商家地址 /// </summary> public string Address { get ; set ; } /// <summary> /// 商家电话 /// </summary> public string Telphone { get ; set ; } /// <summary> /// 城市区号 /// </summary> public string cCode { get ; set ; } /// <summary> /// 文件夹名称 /// </summary> public string folderName { get ; set ; } /// <summary> /// 团购状态 /// </summary> public string StatusMessage { get ; set ; } /// <summary> /// 现在购买人数 /// </summary> public int nownumber { get ; set ; } /// <summary> /// 商品编号 /// </summary> public int productID { get ; set ; } } #endregion |
第三步:获取数据库商品信息记录并添加到对象的集合中(Arraylist):
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
#region 获取xml实体类信息 /// <summary> /// 获取xml实体类信息 /// </summary> /// <returns></returns> public static ArrayList GetWebModelInfo() { ArrayList list = new ArrayList(); string strSQL = "select a.id, a.merchantsID,a.cCode,a.prodCode,a.statue,a.now_number, a.title,a.createtime,a.productimg,a.market_price,a.team_price,a.zhekou_price,a.cityName,a.begin_time,a.end_time,a.description,a.lowBuyNo,b.Address,b.Tel from tg_product as a left join tg_merchants as b on a.merchantsID=b.merchants_id where a.ispublic=1 and statue>-1 and getdate()<dateadd(day,1,a.end_time) order by a.createtime desc" ; DataSet ds = FrameWork.Data.SqlHelper.ReturnDataSet(CommandType.Text, strSQL, null ); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { WebSiteInfo webModel = new WebSiteInfo(); //城市名称 webModel.cityName = dr[ "cityName" ].ToString(); //商品标题 webModel.title = dr[ "title" ].ToString(); //商品创建时间 webModel.createtime = Convert.ToDateTime(dr[ "createtime" ].ToString()); //商家名称 webModel.merchants_id = dr[ "merchantsID" ].ToString(); //商品图片 webModel.productimg = dr[ "productimg" ].ToString(); //市场价 webModel.market_price = Convert.ToDecimal(dr[ "market_price" ].ToString()); //团购价 webModel.team_price = Convert.ToDecimal(dr[ "team_price" ].ToString()); //折扣价 webModel.zhekou_price = Convert.ToDecimal(dr[ "zhekou_price" ].ToString()); //开始时间 webModel.begin_time = Convert.ToDateTime(dr[ "begin_time" ].ToString()); //结束时间 webModel.end_time = Convert.ToDateTime(dr[ "end_time" ].ToString()); //商品说明 webModel.description = dr[ "description" ].ToString(); //最低购买数量 webModel.lowBuNo = Convert.ToInt32(dr[ "lowBuyNo" ].ToString()); //商家电话 webModel.Telphone = dr[ "Tel" ].ToString(); //商家地址 webModel.Address = dr[ "Address" ].ToString(); //城市编号 webModel.cCode = dr[ "cCode" ].ToString(); //图片文件夹名称 webModel.folderName = dr[ "prodCode" ].ToString(); //现在购买人数 webModel.nownumber = Convert.ToInt32(dr[ "now_number" ].ToString()); //商品编号 webModel.productID = Convert.ToInt32(dr[ "id" ].ToString()); int status = Convert.ToInt32(dr[ "statue" ].ToString()); switch (status) { case 0: webModel.StatusMessage = "结束" ; break ; case 1: webModel.StatusMessage = "成功" ; break ; } list.Add(webModel); } } return list; } #endregion |
最后一步将数据库读取来的信息赋值到XML 数据类型中 并序列化成XML文件保存成XML格式的文件读取文件展现到界面:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
#region 页面加载 根据数据库商品记录数生成xml文件信息 /// <summary> /// 页面加载 根据数据库商品记录数生成xml文件信息 /// </summary> List<url> urlList = null ; urlset urlsetList = new urlset(); protected void Page_Load( object sender, EventArgs e) { if (!Page.IsPostBack) { ArrayList listinfo=GetWebModelInfo(); urlList = new List<url>(); for ( int i = 0; i < listinfo.Count; i++) { WebSiteInfo webInfo = listinfo[i] as WebSiteInfo; List<display> displayList = new List<display>(); display display = new display(); display.website = "爱购114" ; display.siteurl = "http://www.xxxxx.com/" ; //城市名称 display.city = webInfo.cityName; //商品标题 display.webSitetitle = webInfo.title; //商品图片 display.image = "http://211.155.235.30/tuangou/" + webInfo.folderName + "/" + webInfo.productimg; //商品开始时间 display.startTime = webInfo.begin_time.ToShortDateString(); //商品结束时间 display.endTime = webInfo.end_time.ToShortDateString(); //市场价 display.value = Convert.ToDouble(webInfo.market_price); //团购价 display.price = Convert.ToDouble(webInfo.team_price); //折扣价 display.rebate = Convert.ToDouble(webInfo.zhekou_price); //现在购买的人数 display.bought = webInfo.nownumber; displayList.Add(display); List<data> dataList = new List<data>(); data data = new data(); data.displayList = displayList; dataList.Add(data); url url = new url(); url.loc = String.Format( "http://www.xxxxx.com/todaydetials.aspx?id={0}" , webInfo.productID.ToString()); url.dataList = dataList; urlList.Add(url); urlsetList.urlList = urlList; } try { XmlSerializerNamespaces xmlns = new XmlSerializerNamespaces(); xmlns.Add(String.Empty, String.Empty); //构造字符串 StringBuilder sb = new StringBuilder(); //将字符串写入到stringWriter对象中 StringWriter sw = new StringWriter(sb); //xml序列化对象 typeof(类名) XmlSerializer ser = new XmlSerializer( typeof (urlset)); //把Stream对象和urlset一起传入,序列化出一个字符串sb ser.Serialize(sw, urlsetList, xmlns); sw.Close(); string FILE_NAME = HttpContext.Current.Server.MapPath( "API/54tuan.xml" ); FileInfo fi = new FileInfo(FILE_NAME); //如果文件己经存在则删除该文件 if (fi.Exists) { if (fi.Attributes.ToString().IndexOf( "ReadOnly" ) >= 0) { fi.Attributes = FileAttributes.Normal; } File.Delete(fi.Name); } //创建文件 并写入字符串 using (StreamWriter sWrite = File.CreateText(FILE_NAME)) { sWrite.Write(sb.ToString().Replace( "encoding=/" utf-16/ "" , "encoding=/" utf-8/ "" ).Replace( "<urlList>" , "" ).Replace( "</urlList>" , "" ).Replace( "<dataList>" , "" ).Replace( "</dataList>" , "" ).Replace( "<displayList>" , "" ).Replace( "<displayList>" , "" ).Replace( "</displayList>" , "" )); sWrite.Close(); } //输出序列化后xml文件 Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/xml" ; Response.WriteFile(HttpContext.Current.Server.MapPath( "API/54tuan.xml" )); Response.Flush(); Response.Close(); } catch (Exception ex) { Response.Write(ex.Message); } finally { } } } #endregion |
希望本文所述对大家asp.net程序设计有所帮助。