使用ef,ajax实现不同省份显示不同城市
1，首先我们要创建一个数据库，名字就叫：ProvCity,里面有两张表，TProvince和TCity，前面
加个T表示这是一个表(Table),不是视图(View).
下面是创建这两张表的sql server语句:
View Code
if exists (select * from sysobjects where id = OBJECT_ID('[TProvince]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [TProvince] CREATE TABLE [TProvince] ( [provID] [int] NOT NULL , [provName] [nvarchar] (20) NULL , [provIsOpen] [bit] NULL ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 1 , '北京市' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 2 , '天津市' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 3 , '河北省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 4 , '山西省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 5 , '内蒙古' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 6 , '辽宁省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 7 , '吉林省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 8 , '黑龙江' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 9 , '上海市' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 10 , '江苏省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 11 , '浙江省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 12 , '安徽省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 13 , '福建省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 14 , '江西省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 15 , '山东省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 16 , '河南省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 17 , '湖北省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 18 , '湖南省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 19 , '广东省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 20 , '广 西' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 21 , '海南省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 22 , '重庆市' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 23 , '四川省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 24 , '贵州省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 25 , '云南省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 26 , '西 藏' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 27 , '陕西省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 28 , '甘肃省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 29 , '青海省' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 30 , '宁 夏' , 0 ) INSERT [TProvince] ( [provID] , [provName] , [provIsOpen] ) VALUES ( 31 , '新 疆' , 0 ) if exists (select * from sysobjects where id = OBJECT_ID('[TCity]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [TCity] CREATE TABLE [TCity] ( [cityID] [int] NOT NULL , [provID] [int] NOT NULL , [cityName] [nvarchar] (20) NOT NULL , [phoneCode] [varchar] (50) NULL , [cityIsOpen] [bit] NULL ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 1 , 1 , '北京市' , '010' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 2 , 2 , '天津市' , '022' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 3 , 3 , '石家庄市' , '0311' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 4 , 3 , '唐山市' , '0315' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 5 , 3 , '秦皇岛市' , '0335' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 6 , 3 , '邯郸市' , '0310' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 7 , 3 , '邢台市' , '0319' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 8 , 3 , '保定市' , '0312' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 9 , 3 , '张家口市' , '0313' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 10 , 3 , '承德市' , '0314' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 11 , 3 , '沧州市' , '0317' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 12 , 3 , '廊坊市' , '0316' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 13 , 3 , '衡水市' , '0318' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 14 , 4 , '太原市' , '0351' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 15 , 4 , '大同市' , '0352' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 16 , 4 , '阳泉市' , '0353' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 17 , 4 , '长治市' , '0355' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 18 , 4 , '晋城市' , '0356' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 19 , 4 , '朔州市' , '0349' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 20 , 4 , '晋中市' , '0354' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 21 , 4 , '运城市' , '0359' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 22 , 4 , '忻州市' , '0350' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 23 , 4 , '临汾市' , '0357' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 24 , 4 , '吕梁市' , '0358' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 25 , 5 , '呼和浩特市' , '0471' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 26 , 5 , '包头市' , '0472' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 27 , 5 , '乌海市' , '0473' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 28 , 5 , '赤峰市' , '0476' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 29 , 5 , '通辽市' , '0475' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 30 , 5 , '鄂尔多斯市' , '0477' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 31 , 5 , '呼伦贝尔市' , '0470' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 32 , 5 , '巴彦淖尔市' , '0478' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 33 , 5 , '乌兰察布市' , '0474' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 34 , 5 , '兴安盟' , '0482' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 35 , 5 , '锡林郭勒盟' , '0479' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 36 , 5 , '阿拉善盟' , '0483' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 37 , 6 , '沈阳市' , '024' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 38 , 6 , '大连市' , '0411' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 39 , 6 , '鞍山市' , '0412' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 40 , 6 , '抚顺市' , '0413' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 41 , 6 , '本溪市' , '0414' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 42 , 6 , '丹东市' , '0415' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 43 , 6 , '锦州市' , '0416' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 44 , 6 , '营口市' , '0417' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 45 , 6 , '阜新市' , '0418' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 46 , 6 , '辽阳市' , '0419' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 47 , 6 , '盘锦市' , '0427' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 48 , 6 , '铁岭市' , '0410' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 49 , 6 , '朝阳市' , '0421' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 50 , 6 , '葫芦岛市' , '0429' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 51 , 7 , '长春市' , '0431' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 52 , 7 , '吉林市' , '0432' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 53 , 7 , '四平市' , '0434' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 54 , 7 , '辽源市' , '0437' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 55 , 7 , '通化市' , '0435' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 56 , 7 , '白山市' , '0439' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 57 , 7 , '松原市' , '0438' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 58 , 7 , '白城市' , '0436' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 59 , 7 , '延边朝鲜族自治州' , '0433' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 60 , 8 , '哈尔滨市' , '0451' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 61 , 8 , '齐齐哈尔市' , '0452' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 62 , 8 , '鸡西市' , '0467' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 63 , 8 , '鹤岗市' , '0468' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 64 , 8 , '双鸭山市' , '0469' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 65 , 8 , '大庆市' , '0459' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 66 , 8 , '伊春市' , '0458' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 67 , 8 , '佳木斯市' , '0454' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 68 , 8 , '七台河市' , '0464' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 69 , 8 , '牡丹江市' , '0453' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 70 , 8 , '黑河市' , '0456' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 71 , 8 , '绥化市' , '0455' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 72 , 8 , '大兴安岭地区' , '0457' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 73 , 9 , '上海市' , '021' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 75 , 10 , '南京市' , '025' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 76 , 10 , '无锡市' , '0510' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 77 , 10 , '徐州市' , '0516' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 78 , 10 , '常州市' , '0519' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 79 , 10 , '苏州市' , '0512' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 80 , 10 , '南通市' , '0513' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 81 , 10 , '连云港市' , '0518' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 82 , 10 , '淮安市' , '0517' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 83 , 10 , '盐城市' , '0515' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 84 , 10 , '扬州市' , '0514' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 85 , 10 , '镇江市' , '0511' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 86 , 10 , '泰州市' , '0523' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 87 , 10 , '宿迁市' , '0527' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 88 , 11 , '杭州市' , '0571' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 89 , 11 , '宁波市' , '0574' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 90 , 11 , '温州市' , '0577' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 91 , 11 , '嘉兴市' , '0573' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 92 , 11 , '湖州市' , '0572' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 93 , 11 , '绍兴市' , '0575' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 94 , 11 , '金华市' , '0579' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 95 , 11 , '衢州市' , '0570' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 96 , 11 , '舟山市' , '0580' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 97 , 11 , '台州市' , '0576' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 98 , 11 , '丽水市' , '0578' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 99 , 12 , '合肥市' , '0551' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 100 , 12 , '芜湖市' , '0553' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 101 , 12 , '蚌埠市' , '0552' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 102 , 12 , '淮南市' , '0554' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 103 , 12 , '马鞍山市' , '0555' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 104 , 12 , '淮北市' , '0561' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 105 , 12 , '铜陵市' , '0562' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 106 , 12 , '安庆市' , '0556' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 107 , 12 , '黄山市' , '0559' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 108 , 12 , '滁州市' , '0550' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 109 , 12 , '阜阳市' , '0558' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 110 , 12 , '宿州市' , '0557' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 111 , 12 , '巢湖市' , '0565' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 112 , 12 , '六安市' , '0564' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 113 , 12 , '亳州市' , '0558' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 114 , 12 , '池州市' , '0566' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 115 , 12 , '宣城市' , '0563' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 116 , 13 , '福州市' , '0591' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 117 , 13 , '厦门市' , '0592' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 118 , 13 , '莆田市' , '0594' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 119 , 13 , '三明市' , '0598' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 120 , 13 , '泉州市' , '0595' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 121 , 13 , '漳州市' , '0596' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 122 , 13 , '南平市' , '0599' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 123 , 13 , '龙岩市' , '0597' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 124 , 13 , '宁德市' , '0593' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 125 , 14 , '南昌市' , '0791' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 126 , 14 , '景德镇市' , '0798' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 127 , 14 , '萍乡市' , '0799' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 128 , 14 , '九江市' , '0792' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 129 , 14 , '新余市' , '0790' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 130 , 14 , '鹰潭市' , '0701' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 131 , 14 , '赣州市' , '0797' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 132 , 14 , '吉安市' , '0796' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 133 , 14 , '宜春市' , '0795' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 134 , 14 , '抚州市' , '0794' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 135 , 14 , '上饶市' , '0793' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 136 , 15 , '济南市' , '0531' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 137 , 15 , '青岛市' , '0532' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 138 , 15 , '淄博市' , '0533' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 139 , 15 , '枣庄市' , '0632' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 140 , 15 , '东营市' , '0546' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 141 , 15 , '烟台市' , '0535' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 142 , 15 , '潍坊市' , '0536' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 143 , 15 , '济宁市' , '0537' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 144 , 15 , '泰安市' , '0538' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 145 , 15 , '威海市' , '0631' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 146 , 15 , '日照市' , '0633' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 147 , 15 , '莱芜市' , '0634' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 148 , 15 , '临沂市' , '0539' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 149 , 15 , '德州市' , '0534' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 150 , 15 , '聊城市' , '0635' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 151 , 15 , '滨州市' , '0543' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 152 , 15 , '荷泽市' , '0530' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 153 , 16 , '郑州市' , '0371' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 154 , 16 , '开封市' , '0378' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 155 , 16 , '洛阳市' , '0379' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 156 , 16 , '平顶山市' , '0375' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 157 , 16 , '安阳市' , '0372' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 158 , 16 , '鹤壁市' , '0392' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 159 , 16 , '新乡市' , '0373' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 160 , 16 , '焦作市' , '0391' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 161 , 16 , '濮阳市' , '0393' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 162 , 16 , '许昌市' , '0374' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 163 , 16 , '漯河市' , '0395' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 164 , 16 , '三门峡市' , '0398' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 165 , 16 , '南阳市' , '0377' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 166 , 16 , '商丘市' , '0370' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 167 , 16 , '信阳市' , '0376' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 168 , 16 , '周口市' , '0394' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 169 , 16 , '驻马店市' , '0396' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 170 , 17 , '武汉市' , '027' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 171 , 17 , '黄石市' , '0714' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 172 , 17 , '十堰市' , '0719' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 173 , 17 , '宜昌市' , '0717' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 174 , 17 , '襄樊市' , '0710' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 175 , 17 , '鄂州市' , '0711' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 176 , 17 , '荆门市' , '0714' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 177 , 17 , '孝感市' , '0712' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 178 , 17 , '荆州市' , '0716' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 179 , 17 , '黄冈市' , '0713' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 180 , 17 , '咸宁市' , '0715' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 181 , 17 , '随州市' , '0722' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 182 , 17 , '恩施土家族苗族自治州' , '0718' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 184 , 18 , '长沙市' , '0731' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 185 , 18 , '株洲市' , '0733' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 186 , 18 , '湘潭市' , '0732' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 187 , 18 , '衡阳市' , '0734' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 188 , 18 , '邵阳市' , '0739' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 189 , 18 , '岳阳市' , '0730' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 190 , 18 , '常德市' , '0736' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 191 , 18 , '张家界市' , '0744' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 192 , 18 , '益阳市' , '0737' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 193 , 18 , '郴州市' , '0735' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 194 , 18 , '永州市' , '0746' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 195 , 18 , '怀化市' , '0745' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 196 , 18 , '娄底市' , '0738' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 197 , 18 , '湘西土家族苗族自治州' , '0743' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 198 , 19 , '广州市' , '020' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 199 , 19 , '韶关市' , '0751' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 200 , 19 , '深圳市' , '0755' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 201 , 19 , '珠海市' , '0756' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 202 , 19 , '汕头市' , '0754' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 203 , 19 , '佛山市' , '0757' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 204 , 19 , '江门市' , '0750' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 205 , 19 , '湛江市' , '0759' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 206 , 19 , '茂名市' , '0668' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 207 , 19 , '肇庆市' , '0758' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 208 , 19 , '惠州市' , '0752' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 209 , 19 , '梅州市' , '0753' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 210 , 19 , '汕尾市' , '0660' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 211 , 19 , '河源市' , '0762' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 212 , 19 , '阳江市' , '0662' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 213 , 19 , '清远市' , '0763' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 214 , 19 , '东莞市' , '0769' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 215 , 19 , '中山市' , '0760' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 216 , 19 , '潮州市' , '0768' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 217 , 19 , '揭阳市' , '0663' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 218 , 19 , '云浮市' , '0766' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 219 , 20 , '南宁市' , '0771' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 220 , 20 , '柳州市' , '0772' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 221 , 20 , '桂林市' , '0773' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 222 , 20 , '梧州市' , '0774' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 223 , 20 , '北海市' , '0779' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 224 , 20 , '防城港市' , '0770' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 225 , 20 , '钦州市' , '0777' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 226 , 20 , '贵港市' , '0775' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 227 , 20 , '玉林市' , '0775' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 229 , 20 , '百色市' , '0776' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 230 , 20 , '贺州市' , '0774' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 231 , 20 , '河池市' , '0778' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 232 , 20 , '来宾市' , '0772' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 233 , 20 , '崇左市' , '0771' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 234 , 21 , '海口市' , '0898' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 235 , 21 , '三亚市' , '0898' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 237 , 22 , '重庆市' , '023' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 240 , 23 , '成都市' , '028' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 241 , 23 , '自贡市' , '0813' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 242 , 23 , '攀枝花市' , '0812' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 243 , 23 , '泸州市' , '0830' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 244 , 23 , '德阳市' , '0838' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 245 , 23 , '绵阳市' , '0816' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 246 , 23 , '广元市' , '0839' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 247 , 23 , '遂宁市' , '0825' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 248 , 23 , '内江市' , '0832' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 249 , 23 , '乐山市' , '0833' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 250 , 23 , '南充市' , '0817' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 251 , 23 , '眉山市' , '028' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 252 , 23 , '宜宾市' , '0831' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 253 , 23 , '广安市' , '0826' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 254 , 23 , '达州市' , '0818' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 255 , 23 , '雅安市' , '0835' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 256 , 23 , '巴中市' , '0827' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 257 , 23 , '资阳市' , '028' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 258 , 23 , '阿坝藏族羌族自治州' , '0837' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 259 , 23 , '甘孜藏族自治州' , '0836' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 260 , 23 , '凉山彝族自治州' , '0834' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 261 , 24 , '贵阳市' , '0851' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 262 , 24 , '六盘水市' , '0858' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 263 , 24 , '遵义市' , '0852' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 264 , 24 , '安顺市' , '0853' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 265 , 24 , '铜仁地区' , '0856' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 266 , 24 , '黔西南布依族苗族自治' , '0859' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 267 , 24 , '毕节地区' , '0857' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 268 , 24 , '黔东南苗族侗族自治州' , '0855' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 269 , 24 , '黔南布依族苗族自治州' , '0854' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 270 , 25 , '昆明市' , '0871' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 271 , 25 , '曲靖市' , '0874' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 272 , 25 , '玉溪市' , '0877' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 273 , 25 , '保山市' , '0875' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 274 , 25 , '昭通市' , '0870' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 275 , 25 , '丽江市' , '0888' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 276 , 25 , '思茅市' , '0879' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 277 , 25 , '临沧市' , '0883' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 278 , 25 , '楚雄彝族自治州' , '0878' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 279 , 25 , '红河哈尼族彝族自治州' , '0873' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 280 , 25 , '文山壮族苗族自治州' , '0876' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 281 , 25 , '西双版纳傣族自治州' , '0691' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 282 , 25 , '大理白族自治州' , '0872' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 283 , 25 , '德宏傣族景颇族自治州' , '0692' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 284 , 25 , '怒江傈僳族自治州' , '0886' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 285 , 25 , '迪庆藏族自治州' , '0887' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 286 , 26 , '拉萨市' , '0891' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 287 , 26 , '昌都地区' , '0895' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 288 , 26 , '山南地区' , '0983' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 289 , 26 , '日喀则地区' , '0892' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 290 , 26 , '那曲地区' , '0896' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 291 , 26 , '阿里地区' , '0897' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 292 , 26 , '林芝地区' , '0894' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 293 , 27 , '西安市' , '029' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 294 , 27 , '铜川市' , '0919' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 295 , 27 , '宝鸡市' , '0917' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 296 , 27 , '咸阳市' , '0910' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 297 , 27 , '渭南市' , '0913' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 298 , 27 , '延安市' , '0911' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 299 , 27 , '汉中市' , '0916' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 300 , 27 , '榆林市' , '0912' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 301 , 27 , '安康市' , '0915' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 302 , 27 , '商洛市' , '0914' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 303 , 28 , '兰州市' , '0931' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 304 , 28 , '嘉峪关市' , '0937' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 305 , 28 , '金昌市' , '0935' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 306 , 28 , '白银市' , '0943' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 307 , 28 , '天水市' , '0938' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 308 , 28 , '武威市' , '0935' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 309 , 28 , '张掖市' , '0936' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 310 , 28 , '平凉市' , '0933' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 311 , 28 , '酒泉市' , '0937' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 312 , 28 , '庆阳市' , '0934' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 313 , 28 , '定西市' , '0932' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 314 , 28 , '陇南市' , '0939' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 315 , 28 , '临夏回族自治州' , '0930' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 316 , 28 , '甘南藏族自治州' , '0941' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 317 , 29 , '西宁市' , '0971' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 318 , 29 , '海东地区' , '0972' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 319 , 29 , '海北藏族自治州' , '0970' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 320 , 29 , '黄南藏族自治州' , '0973' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 321 , 29 , '海南藏族自治州' , '0974' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 322 , 29 , '果洛藏族自治州' , '0975' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 323 , 29 , '玉树藏族自治州' , '0976' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 324 , 29 , '海西蒙古族藏族自治州' , '0979' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 325 , 30 , '银川市' , '0951' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 326 , 30 , '石嘴山市' , '0952' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 327 , 30 , '吴忠市' , '0953' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 328 , 30 , '固原市' , '0954' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 329 , 30 , '中卫市' , '0955' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 330 , 31 , '乌鲁木齐市' , '0991' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 331 , 31 , '克拉玛依市' , '0990' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 332 , 31 , '吐鲁番地区' , '0995' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 333 , 31 , '哈密地区' , '0902' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 334 , 31 , '昌吉回族自治州' , '0994' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 335 , 31 , '博尔塔拉蒙古自治州' , '0909' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 336 , 31 , '巴音郭楞蒙古自治州' , '0996' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 337 , 31 , '阿克苏地区' , '0997' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 338 , 31 , '克孜勒苏柯尔克孜自治' , '0908' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 340 , 31 , '喀什地区' , '0998' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 341 , 31 , '和田地区' , '0903' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 342 , 31 , '伊犁哈萨克自治州' , '0999' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 343 , 31 , '塔城地区' , '0901' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 344 , 31 , '阿勒泰地区' , '0906' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 345 , 21 , '文昌市' , '0898' , 0 ) INSERT [TCity] ( [cityID] , [provID] , [cityName] , [phoneCode] , [cityIsOpen] ) VALUES ( 346 , 21 , '琼海市' , '0898' , 0 )
只需要把这些语句在数据库ProvCity中执行就可以生成两个表。
我使用Sql Server脚本导出器将sql server2005中的这两个表导出sql的。
2,新建一个asp.net网站，然后添加文件夹Model(存放数据模型),DTO(存放数据传输对象类),
DAL(存放数据访问层,分离的数据库对象上下文).
(1),在Model下面添加新建项，ado.net实体数据模型，如图：
选择刚才新建的数据库，然后就会生成数据模型，如下图：
(2)然后将这个model分离为实体类和对象上下文。在model文件夹下添加新建项，使用ado.net自跟踪实体生成器将model分离，如下图：
(3)然后在文件ProvCityEntity.tt和ProvCityEntity.Context.tt文件中分别找到
string inputFile = @"$edmxInputFile$";
将输入文件改为:string inputFile = @"ProvCityEntity.edmx";
这样就将实体类和对象上下文分离开了。
(4)将文件ProvCityEntity.edmx下面对应的ProvCityEntity.Designer.cs文件删除，因为这个文件已经被分离了。否则提示二义性问题(重复定义)。
(5)将文件ProvCityEntity.Context.tt剪切到文件夹DAL中，这样对象上下文就可以做为底层的数据以供访问。
但是需要修改一下路径，将ProvCityEntity.Context.tt的输入文件改为
string inputFile = @"..\\Model\\ProvCityEntity.edmx";因为剪切时改变了路径，这里是
返回上一层目录下的文件。可能还会出现一些错误提示，这个时候只要将文件ProvCityEntity.Context.tt下面对应的两个文件添加一下引用就行了。根据错误提示添加。
(6)在文件ProvCityEntity.Context.cs中的类ProvCityEntities中添加如下代码：
public static readonly string guid = Guid.NewGuid().ToString();//初始化一个唯一变量，标识上下文对象 #region 手动添加的代码 /// <summary> /// 返回唯一数据库上下文 /// </summary> /// <returns></returns> public static ProvCityEntities GetDataContext() { if (!HttpContext.Current.Items.Contains(guid)) //当前请求http内容中不含guid { HttpContext.Current.Items.Add(guid, new ProvCityEntities());//将guid和上下文绑定 } return HttpContext.Current.Items[guid] as ProvCityEntities;//返回唯一的上下文 } #endregion
然后只需要调用类ProvCityEntities的GetDataContext()方法就可以返回唯一的对象上下文.
3,下面开始写前台代码：
(1)下面是使用repeater绑定数据：
View Code
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script> <title>ajax,entity framwork,repeater综合运用</title> <script type="text/javascript"> //根据省份选择城市 function changecity(provid) { $.ajax({ type: "POST", url: "City.asmx/GetCity", data: "{provid:'" + provid + "'}", dataType: "json", contentType: "application/json", success: function (msg) { var list = eval("(" + msg.d + ")"); $city = $("#cityId"); $city.find("option").remove(); $.each(list, function (i) { $city.append("<option value=\""+list[i].cityID+"\">"+ list[i].cityName +"</option>"); }); } }) } </script> </head> <body> <form id="form1" runat="server"> <div> <span>所在城市</span> <select id="provId" name="provId" onclick="changecity(this.value)"> <asp:Repeater ID="repProv" runat="server"> <ItemTemplate> <option value='<%#Eval("provID") %>'> <%#Eval("provName") %> </option> </ItemTemplate> </asp:Repeater> </select> <select id="cityId" name="cityId"> <option value="-1">选择城市</option> <asp:Repeater ID="repCity" runat="server"> <ItemTemplate> <option value='<%#Eval("cityID") %>'> <%#Eval("cityName") %> </option> </ItemTemplate> </asp:Repeater> </select> </div> </form> </body> </html>
使用asp:Repeater控件绑定数据， 形式都是<%#Eval("provName") %>，其中provName是后台代码变量，或者是数据源中的字段。
(2)后台代码：
View Code
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WebApplication1 { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.repProv.DataSource = Common.GetProvList();//得到省的列表 this.repProv.DataBind(); this.repCity.DataSource = Common.GetCityList(3);//得到北京的各个城市 this.repCity.DataBind(); } } } }
绑定数据源。这两个方法都在Common类中。
(3)添加一个Common类：
View Code
using System; using System.Collections.Generic; using System.Linq; using System.Web; using WebApplication1.Model; using WebApplication1.DAL; using System.Runtime.Serialization.Json; using System.IO; using System.Text; using WebApplication1.DTO; namespace WebApplication1 { public class Common { public static List<TProvince> GetProvList() { List<TProvince> list = new List<TProvince>(); list = ProvCityEntities.GetDataContext().CreateObjectSet<TProvince>().ToList(); return list; } public static List<CityDTO> GetCityList(int provid) { List<CityDTO> list = new List<CityDTO>(); list = ProvCityEntities.GetDataContext().CreateObjectSet<TCity>().Where(c => c.provID == provid).Select(c => new CityDTO() { cityID = c.cityID, cityName = c.cityName }).ToList();//查询出所有provid下的城市 return list; } } public static class JsonClass { #region Json序列化 /// <summary> /// Json序列化,扩展类型必须在非泛型静态类中定义 /// </summary> public static string ToJson(this object item) { if (item == null) { return null; } DataContractJsonSerializer serializer = new DataContractJsonSerializer(item.GetType()); using (MemoryStream ms = new MemoryStream()) { serializer.WriteObject(ms, item); StringBuilder sb = new StringBuilder(); sb.Append(Encoding.UTF8.GetString(ms.ToArray())); return sb.ToString(); } } #endregion } }
本来这两个方法应该写到BLL层，然后调用DAL层，这里为方便就写在了common。
另外因为webservice返回的数据类型是json形式，因此需要对object扩展，于是就写了JsonClass类。
(4)添加web服务City.asmx
View Code
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; namespace WebApplication1 { /// <summary> /// City 的摘要说明 /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。 [System.Web.Script.Services.ScriptService] //这一句要取消注释 public class City : System.Web.Services.WebService { [WebMethod] public string GetCity(int provid) { return Common.GetCityList(provid).ToJson(); } } }
这个文件就是web服务文件，注意：// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
要把这句话下面的注释取消。
(5)在DTO下面添加一个类：CityDTO
View Code
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Runtime.Serialization; namespace WebApplication1.DTO { //DTO类，数据传输对象 [Serializable] [DataContract] public class CityDTO { [DataMember] public int cityID { get; set; } [DataMember] public string cityName { get; set; } } }
DTO类主要用来传输数据，因为entity framework不支持复杂类型，因此编写这个dto类来传输数据。
