玩轉i設計 - 船長: 4月 2011

C# .Net 與 Google Map 靜態地圖擷取

string strResult = "fail";
FileStream fileStream = null;
//設定圖片長寛
int mapWidth = Convert.ToInt16(System.Configuration.ConfigurationManager.AppSettings["MapImageWidth"]);
int mapHeight = Convert.ToInt16(System.Configuration.ConfigurationManager.AppSettings["MapImageHeight"]);
//設定GoogleMapKey
string apikey = System.Configuration.ConfigurationManager.AppSettings["GoogleMapKey"].ToString();
string url = "http://maps.google.com.tw/staticmap?center=" + Latitude + "," + Longitude + "&zoom=16&size=" + mapWidth.ToString() + "x" + mapHeight.ToString() + "&maptype=roadmap&markers=" + Latitude + "," + Longitude + "&key=" + apikey + "&sensor=false";
WebRequest myrequest = WebRequest.Create(url);
WebResponse mywebresponse = myrequest.GetResponse();
//讀取地圖靜態圖片資料
Stream mystream = mywebresponse.GetResponseStream();

string gifFile = string.Format("{0}\\{1}\\{2}\\Map.gif", System.Configuration.ConfigurationManager.AppSettings["ImagesFolder"], StoreID, ObjectID);

if (!System.IO.File.Exists(gifFile))
{
   System.IO.Directory.CreateDirectory(System.IO.Path.GetDirectoryName(gifFile));
}

fileStream = File.Create(gifFile);
byte[] buffer = new byte[102400];
int bytesRead;
while (true)
{
   //開始將資料流寫入到disk
   bytesRead = mystream.Read(buffer, 0, buffer.Length);
   if (bytesRead == 0)
       break;
   fileStream.Write(buffer, 0, bytesRead);
   strResult = "OK";
}

C# .Net 與 Google Map 地址定位取回經緯度

//設定 GoogleMapKey
string apikey = System.Configuration.ConfigurationManager.AppSettings["GoogleMapKey"].ToString();
string url = "http://maps.google.com.tw/maps/geo?q=" + Address + "&output=xml&key=" + apikey + "&sensor=false";
WebRequest myrequest = WebRequest.Create(url);

System.Net.WebResponse mywebresponse = myrequest.GetResponse();
Stream mystream = mywebresponse.GetResponseStream();
//讀取定位結果資料
StreamReader sr = new System.IO.StreamReader(mystream, System.Text.Encoding.UTF8);
string XmlText = sr.ReadToEnd();
int index1 = XmlText.IndexOf("coordinates");
int index2 = XmlText.IndexOf("</coordinates>");
string Point = XmlText.Substring(index1 + 12, index2 - index1 - 12);
//解析出 Longitude
Longitude = Point.Substring(0, Point.IndexOf(","));
//解析出 Latitude
Latitude = Point.Substring(Point.IndexOf(",") + 1, Point.LastIndexOf(",") - Point.IndexOf(",") - 1);

using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RMSDBConnection"].ToString()))
{
  con.Open();
  //更新Map_X , Map_Y
  using (SqlCommand commandU = new SqlCommand("Update Object Set Map_X = @Map_X, Map_Y = @Map_Y where ObjectID = @ObjectID", con))
  {
      commandU.Parameters.Add(new SqlParameter("Map_X", Longitude));
      commandU.Parameters.Add(new SqlParameter("Map_Y", Latitude));
      commandU.Parameters.Add(new SqlParameter("ObjectID", ObjectID));
      commandU.ExecuteNonQuery();
  }
  con.Close();
}