//此方法是使用了XmlDataDocument
1 for (int i = 0; i < companyInfo.Tables[0].Rows.Count; i++)
2 {
3 string result = string.Empty;
4 HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://c2.keyue.net/QPAPITRAN/CopInfo/Code/" + companyInfo.Tables[0].Rows[i]["海关编码"].ToString());
5 request.Timeout = 10000;
6 request.AllowAutoRedirect = false;
7 HttpWebResponse response = (HttpWebResponse)request.GetResponse();
8 if (response.StatusCode == HttpStatusCode.OK)
9 {
10 StreamReader sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
11 result = sr.ReadToEnd();
12 sr.Close();
13 }
14
15
16 if (result.Contains("CopName"))
17 {
18
19 XmlDataDocument xd = new XmlDataDocument();
20 DataSet ds = new DataSet();
21 xd.LoadXml(result);
22 ds.ReadXml(new XmlNodeReader(xd));
23
24 if (ds != null && ds.Tables[0].Rows.Count > 0)
25 {
26 ExecuteSql(" update " + txtDBName.Text.Trim() + " set 企业名称 = '" + ds.Tables[0].Rows[0]["CopName"].ToString() +
27 "', 企业分级标志 = '" + ds.Tables[0].Rows[0]["CopType"].ToString() +
28 "', 有效日期 = '" + ds.Tables[0].Rows[0]["AvailDate"].ToString() +
29 "' where 海关编码='" + companyInfo.Tables[0].Rows[i]["海关编码"].ToString() + "'");
30 }
31
32 }
33
34
35 }
