/// <summary> /// 打开网点信息 /// </summary> /// <param name="filePath"></param> /// <returns></returns> private static List <SiteInfo> OpenFile(String filePath) { DataTable dt = ExcelHelper.ExcelToDataTable("输入", true, filePath); List <SiteInfo> lstSite = ConvertHelper <SiteInfo> .ConvertToList(dt); foreach (var site in lstSite) { BaiduResult geocoder = JsonHelper.JsonDeserialize <BaiduResult>(BaiduMap.Geocoder(site.address)); site.lat = geocoder.result.location.lat; site.lng = geocoder.result.location.lng; } return(lstSite); }