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
It is mined here 0349
taiyuan 0351
datong 0352
yangquan 0353
jinzhong 0354
changzhi 0355
jincheng 0356
linfen 0357
luliang 0358
yuncheng 0359
xinzhou 0350
Inner Mongolia area code
Hohhot, 0471
baotou 0472
The wuhai 0473
wulanchabu 0474
tgo 0475
chifeng 0476
ordos 0477
bayinnaoer 0478
Xilingol league 0479
The hulunbuir 0470
Xingan league 0482
La shan au 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
The rising sun 0421
Set up a file 0427
huludao 0429
Jilin area code
changchun 0431
Ji Lin 0432
yanbian 0433
4 flat 0434
tonghua 0435
baicheng 0436
long-withering 0437
matsubara 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
That is suihua 0455
Heihe river 0456
Greater hinggan mountains area 0457
yichun 0458
daqing 0459
7 A river 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
huaian 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
6 Ann 0564
Chaohu lake 0565
chizhou 0566
Fujian area code
fuzhou 0591
xiamen 0592
ningde 0593
putian 0594
quanzhou 0595
zhangzhou 0596
longyan 0597
3 Ming 0598
nanping 0599
Jiangxi area code
nanchang 0791
9 jiang 0792
shangrao 0793
fuzhou 0794
yichun 0795
gian 0796
ganzhou 0797
jingdezhen 0798
pingxiang 0799
at 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
Luo river 0395
zhumadian 0396
3 Gate gorge 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
10 weir 0719
xiangfan 0710
suizhou 0722
jingmen 0724
Jianghan xiantao 0728
tianmen 0728
qianjiang 0728
Hunan area code
changsha 0731
zhuzhou 0731
xiangtan 0731
Zhuzhou (once used) 0732
Xiangtan (used) 0733
hengyang 0734
chenzhou 0735
changde 0736
yiyang 0737
loudi 0738
shaoyang 0739
yueyang 0730
Xiangxi tujia and miao autonomous prefecture 0743
zhangjiajie 0744
Which is 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 area code
nanning 0771
The left part 0771
liuzhou 0772
The guest 0772
guilin 0773
wuzhou 0774
Congratulation state 0774
Your port 0775
yulin 0775
The baise 0776
qinzhou 0777
hechi 0778
The north sea 0779
fangchenggang 0770
4 Sichuan area code
chengdu 028
panzhihua 0812
zigong 0813
mianyang 0816
nanchong 0817
dazhou 0818
suining 0825
cross 0826
pakistan-china 0827
yibin 0831
neijiang 0832
great 0832
leshan 0833
meishan 0833
Liangshan yi autonomous prefecture 0834
ya 0835
Ganzi Tibetan autonomous prefecture 0836
Aba Tibetan and qiang autonomous prefecture 0837
deyang 0838
guangyuan 0839
luzhou 0830
Hainan area code
Haikou city 0898
3 The city 0898
5 Refers to the mountain city, 0898
qionghai 0898
danzhou 0898
Wenchang, 0898
wanning 0898
dongfang 0898
chengmai 0898
Ding an 0898
tunchang 0898
lingao 0898
Baisha li autonomous county 0898
Changjiang li autonomous county 0898
Ledong li autonomous county 0898
Lingshui li autonomous county 0898
Baoting li miao autonomous county 0898
Qiongzhong li miao autonomous county 0898
Xisha 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 buyi and miao autonomous prefecture 0854
Qiandongnan miao and dong autonomous prefecture 0855
Tongren region 0856
bijie 0857
6 Plate of water 0858
Buyi and miao autonomous prefecture, southwest guizhou province 0859
Yunnan area code
kunming 0871
Dali bai autonomous prefecture 0872
Honghe hani and yi autonomous prefecture 0873
qujing 0874
baoshan 0875
Wenshan zhuang and miao autonomous prefecture 0876
yuxi 0877
Chuxiong yi autonomous prefecture 0878
simao 0879
zhaotong 0870
lincang 0883
Nujiang lisu autonomous prefecture 0886
Diqing Tibetan autonomous prefecture 0887
lijiang 0888
Xishuangbanna dai autonomous prefecture 0691
Dehong dai and jingpo autonomous prefecture 0692
Tibet area code
Lhasa 0891
Shigatse area 0892
shannan 0893
nyingchi 0894
Changdu area 0895
In naqu 0896
ali 0897
Shaanxi area code
Xi 'an 029
yanan 0911
Yulin. 0912
weinan 0913
shangluo 0914
ankang 0915
Hanzhong city 0916
baoji 0917
tongchuan 0919
Gansu area code
lanzhou 0931
dingxi 0932
Of out 0933
qingyang 0934
wuwei 0935
jinchang 0935
Zhang ye 0936
jiuquan 0937
jiayuguan 0937
tianshui 0938
longnan 0939
Linxia hui autonomous prefecture 0930
Gannan Tibetan autonomous prefecture 0941
silver 0943
Qinghai area code
xining 0971
Whereas haidong539 area 0972
Huangnan Tibetan autonomous prefecture 0973
Hainan Tibetan autonomous prefecture 0974
Guoluo Tibetan autonomous prefecture 0975
Yushu Tibetan autonomous prefecture 0976
Delingha, haixi Mongolian and Tibetan autonomous prefecture 0977
Heli Mongolian and Tibetan autonomous prefecture golmud 0979
Haibei Tibetan autonomous prefecture 0970
Ningxia area code
yinchuan 0951
making 0952
hui 0953
evalution 0954
Central defender 0955
Xinjiang area code
urumqi 0991
Kuitun, yili kazakh autonomous prefecture 0992
shihezi 0993
Changji hui autonomous prefecture 0994
Turpan area 0995
Bayingoleng Mongolian autonomous prefecture 0996
aksu 0997
Kashgar region 0998
Yining, yili kazakh autonomous prefecture 0999
karamay 0990
Tuscaloosa area 0901
Hami region 0902
Hotan region 0903
Altay region 0906
Kizilsu kirgiz autonomous prefecture 0908
Bortala Mongolian autonomous prefecture 0909";
return data;
}
}
}