Copy Code code as follows:
Using System;
Using System.Collections.Generic;
Using System.Linq;
Using System.Web;
Using System.Web.UI;
Using System.Web.UI.WebControls;
Using System.Text.RegularExpressions;
Using System.IO;
Using System.Text;
Using System.Data;
Namespace Sjlerp
{
public partial class WebForm1:System.Web.UI.Page
{
protected void Page_Load (object sender, EventArgs e)
{
dictionary<string, string> cityandnum =
Regex.Matches (City.data, @ "[^\r].*?\r")
. Cast<match> ()
. Select (c => regex.replace (C.value, @ "\s", ""))
. Aggregate (New dictionary<string, string> (), (Reval, item) =>
{
if (Regex.IsMatch (item, @ "[\u4e00-\u9fa5]+\d+"))
{
String word = Regex.match (item, @ "[\u4e00-\u9fa5]+"). Value;
String num = Regex.match (item, @ "\d+"). Value;
Reval. ADD (Word, num);
}
return Reval;
});
Adohelper.executecommand ("CREATE TABLE kaixuantest (city varchar (max), num varchar (max)");
Cityandnum.tolist (). ForEach (c =>
{
String sql = string. Format ("Insert kaixuantest Select ' {0} ', ' {1} '", C.key,c.value);
Adohelper.executecommand (SQL);
});
}
}
}
public class city
{
public static string data
{
Get
{
return @ "Beijing area code
Beijing 010
Tianjin Area code
Tianjin 022
Hebei Area code
Shijiazhuang 0311
Baoding 0312
Zhangjiakou 0313
Chengde 0314
Tangshan 0315
Langfang 0316
Cangzhou 0317
Hengshui 0318
Xingtai 0319
Handan 0310
Qinhuangdao 0335
Shanxi Area code
Shuozhou 0349
Taiyuan 0351
Datong 0352
Yangquan 0353
Jinzhong 0354
Changzhi 0355
Jincheng 0356
Linfen 0357
Lvliang 0358
Yuncheng 0359
Xinzhou 0350
Inner Mongolia Area code
Hohhot 0471
Baotou 0472
Wuhai 0473
Wulanchabu 0474
Tongliao 0475
Chifeng 0476
Ordos 0477
Bayan nur 0478
Xilin Gol League 0479
Hulunbeier 0470
Xing ' an union 0482
Alxa League 0483
Liaoning Area code
Shenyang 024
Dalian 0411
Anshan 0412
Fushun 0413
Benxi 0414
Dandong 0415
Jinzhou 0416
Yingkou 0417
Fuxin 0418
Liaoyang 0419
Tieling 0410
Chaoyang 0421
Panjin 0427
Huludao 0429
Jilin Area Code
Changchun 0431
Jilin 0432
Yanbian 0433
Siping 0434
Tonghua 0435
Baicheng 0436
Liaoyuan 0437
Songyuan 0438
Baishan 0439
Hunchun 0440
Zhejiang Area code
Hangzhou 0571
Huzhou 0572
Jiaxing 0573
Ningbo 0574
Shaoxing 0575
Taizhou 0576
Wenzhou 0577
Lishui 0578
Jinhua 0579
Quzhou 0570
Zhoushan 0580
Heilongjiang Area code
Harbin 0451
Qiqihar 0452
Mudanjiang 0453
Jiamusi 0454
Suihua 0455
Heihe 0456
Da Hinggan Ling 0457
Yichun 0458
Daqing 0459
Qitaihe 0464
Jixi 0467
Hegang 0468
Shuangyashan 0469
Shanghai Area Code
Shanghai 021
Jiangsu Area Code
Nanjing 025
Zhenjiang 0511
Suzhou 0512
Nantong 0513
Yangzhou 0514
Yancheng 0515
Xuzhou 0516
Huai ' an 0517
Lianyungang 0518
Changzhou 0519
Wuxi 0510
Taizhou 0523
Suqian 0527
Anhui Area Code
Hefei 0551
Bengbu 0552
Wuhu 0553
Huainan 0554
Ma On Shan 0555
Anqing 0556
Suzhou 0557
Fuyang 0558
Bozhou 0558
Huangshan 0559
Chuzhou 0550
Huaibei 0561
Tongling 0562
Xuancheng 0563
Liu'an 0564
Chaohu 0565
Chizhou 0566
Fujian Area code
Fuzhou 0591
Xiamen 0592
Ningde 0593
Putian 0594
Quanzhou 0595
Zhangzhou 0596
Longyan 0597
Sanming 0598
Nanping 0599
Jiangxi Area Code
Nanchang 0791
Jiujiang 0792
Shangrao 0793
Fuzhou 0794
Yichun 0795
Ji ' an 0796
Ganzhou 0797
Jingdezhen 0798
Pingxiang 0799
Xinyu 0790
Yingtan 0701
Shandong Area Code
Jinan 0531
Qingdao 0532
Zibo 0533
Texas 0534
Yantai 0535
Weifang 0536
Jining 0537
Taian 0538
Linyi 0539
Heze 0530
Binzhou 0543
Dongying 0546
Weihai 0631
Zaozhuang 0632
Rizhao 0633
Laiwu 0634
Liaocheng 0635
Henan Area Code
Zhengzhou 0371
Anyang 0372
Xinxiang 0373
Xuchang 0374
Pingdingshan 0375
Xinyang 0376
Nanyang 0377
Kaifeng 0378
Luoyang 0379
Shangqiu 0370
Jiaozuo 0391
Jiyuan 0391
Hebi 0392
Puyang 0393
Zhoukou 0394
Luohe 0395
Zhumadian 0396
Sanmenxia 0398
Hubei Area code
Wuhan 027
Ezhou 0711
Xiaogan 0712
Huanggang 0713
Yellowstone 0714
Xianning 0715
Jingzhou 0716
Yichang 0717
Enshi Tujia and Miao Autonomous Prefecture 0718
Shiyan 0719
Xiangfan 0710
Suizhou 0722
Jingmen 0724
Jianghan Peach 0728
Tianmen 0728
Qianjiang 0728
Hunan Area code
Changsha 0731
Zhuzhou 0731
Xiangtan 0731
Zhuzhou (formerly Used) 0732
Xiangtan (formerly Used) 0733
Hengyang 0734
Chenzhou 0735
Changde 0736
Yiyang 0737
Loudi 0738
Shaoyang 0739
Yueyang 0730
Xiangxi Tujia 0743
Zhangjiajie 0744
Huaihua 0745
Yongzhou 0746
Guangdong Area Code
Guangzhou 020
Jiangmen 0750
Shaoguan 0751
Huizhou 0752
Meizhou 0753
Shantou 0754
Shenzhen 0755
Zhuhai 0756
Foshan 0757
Zhaoqing 0758
Zhanjiang 0759
Zhongshan 0760
Heyuan 0762
Qingyuan 0763
Yunfu 0766
Chaozhou 0768
Dongguan 0769
Shanwei 0660
Yangjiang 0662
Jieyang 0663
Maoming 0668
Guangxi number
Nanning 0771
Chongzuo 0771
Liuzhou 0772
Guest 0772
Guilin 0773
Wuzhou 0774
Hezhou 0774
Guigang 0775
Yulin 0775
Baise 0776
Qinzhou 0777
Hechi 0778
Beihai 0779
Fangchenggang 0770
Sichuan Area Code
Chengdu 028
Panzhihua 0812
Zigong 0813
Mianyang 0816
Nanchong 0817
Dazhou 0818
Suining 0825
Guang an 0826
Bazhong 0827
Yibin 0831
Neijiang 0832
Ziyang 0832
Leshan 0833
Meishan 0833
Liangshan Yi Autonomous Prefecture 0834
Yaan 0835
Ganzi Tibetan Autonomous Prefecture 0836
Aba Tibetan and Qiang Autonomous Prefecture 0837
Deyang 0838
Guangyuan 0839
Luzhou 0830
Hainan Area code
Haikou 0898
Sanya 0898
Wuzhishan 0898
Qionghai 0898
Zhanzhou 0898
Wenchang 0898
Wanning 0898
Oriental City 0898
Chengmai County 0898
Dingan County 0898
Tunchang County 0898
Lingao County 0898
Baisha County 0898
Cangjiang County 0898
Ledong County 0898
Lingshuix County 0898
Baoting County 0898
QIONGZHONGZZX County 0898
Paracel Islands 0898
Nansha Islands 0898
Zhongsha Islands 0898
YANGPU Economic Development Zone 0898
Chongqing Area Code
Chongqing 023
Guizhou Area code
Guiyang 0851
Zunyi 0852
Anshun 0853
Qiannan Buyei and Miao Autonomous Prefecture 0854
Southeast Guizhou Miao and Dong Autonomous Prefecture 0855
Tongren 0856
Bijie 0857
Liupanshui 0858
Southwest Guizhou Buyei and Miao Autonomous Prefecture 0859
Yunnan Area Code
Kunming 0871
Dali Bai Autonomous Prefecture 0872
Honghe 0873
Qujing 0874
Baoshan 0875
Wenshan 0876
Yuxi 0877
Chuxiongzhou 0878
Simao 0879
Zhaotong 0870
Lincang 0883
Nujiang Lisu Prefecture 0886
Dêqên Tibetan Autonomous Prefecture 0887
Lijiang 0888
Xishuangbanna Dai Autonomous Prefecture 0691
Dehong Dai and Jingpo Autonomous Prefecture 0692
Tibet Area Code
Lhasa 0891
Xigazê 0892
Shannan 0893
Linzhi 0894
Changdu 0895
Nagchu 0896
ALDQ 0897
Shaanxi Area Code
Xian 029
Yanan 0911
Yulin 0912
Weinan 0913
Shangluo 0914
Ankang 0915
Hanzhong 0916
Baoji 0917
Tongchuan 0919
Gansu Area Code
Lanzhou 0931
Dingxi 0932
Pingliang 0933
Qingyang 0934
Wuwei 0935
Jinchang 0935
Zhangye 0936
Jiuquan 0937
Jiayuguan 0937
Tianshui 0938
South Longnan 0939
Linxia Hui Autonomous Prefecture 0930
Gannan Tibetan Autonomous Prefecture 0941
Silver 0943
Qinghai Area code
Xining 0971
Haidong Prefecture 0972
Huangnan Tibetan Autonomous Prefecture 0973
Hainan Tibetan Autonomous Prefecture 0974
Golog Tibetan Autonomous Prefecture 0975
Yushu Tibetan Autonomous Prefecture 0976
Sea Simon Haixi Tibetan Autonomous Prefecture Delinha 0977
Sea Simon Haixi Tibetan Autonomous Prefecture Golmud 0979
Haibei Tibetan Autonomous Prefecture 0970
Ningxia Area Code
Yinchuan 0951
Shizuishan 0952
Wuzhong 0953
Guyuan 0954
Zhongwei 0955
Xinjiang area Code
Urumqi 0991
Ili Kazak Zizhizhou Kuitun 0992
Shihezi 0993
Changji Hui Autonomous Prefecture 0994
Turpan 0995
Bayangol Mongol Autonomous Prefecture 0996
Aksu Prefecture 0997
Kashgar 0998
Ili Kazak Zizhizhou Yining 0999
Karamay 0990
Tacheng 0901
Hami 0902
Hotan 0903
Altay 0906
KIZILSU Kirgiz Zizhizhou 0908
Bortala Mongol Autonomous Prefecture 0909 ";
return data;
}
}
}
