整理代碼，發現有一個從兩張表里讀取城市列表，然后linq和lambda表達式來獲取城市名的函數，代碼如下：

1 public static string GetCityHotelText(string city, int VerNum) 2 { 3 string ucbcField, airPortField; 4 string cityText = ucbcField = airPortField = ""; 5 //vernum控制中英文顯示版本 6 if (VerNum == 1) 7 { 8 ucbcField = "CityNameEN"; 9 airPortField = "CityName_en"; 10 } 11 else 12 { 13 ucbcField = "CityNameCN"; 14 airPortField = "CityName_zh"; 15 } 16 //兩張表，datatable，讀表的方法就不寫了 17 DataTable ucbcs = null; 18 DataTable airPorts =null; 19 try 20 { 21 var query = ucbcs.AsEnumerable().Where(ucbc => ucbc.Field<string>("CityCode").ToLower() == city.ToLower()); 22 if (query.Any()) 23 { 24 cityText = query.First().Field<string>(ucbcField); 25 } 26 else 27 { 28 var query2 = from airPort in airPorts.AsEnumerable() 29 where airPort.Field<string>("Code").ToLower() == city.ToLower() 30 select airPort; 31 if (query2.Any()) 32 { 33 cityText = query2.First().Field<string>(airPortField); 34 } 35 } 36 } 37 catch (Exception e) 38 { 39 } 40 if (string.IsNullOrEmpty(cityText)) 41 { 42 cityText = city; 43 } 44 return cityText; 45 }

?

轉載于:https://www.cnblogs.com/Lvkang/p/9354739.html

總結

以上是生活随笔為你收集整理的.NET获取城市信息（将三字代码转换成城市名）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。