省份的数据库脚本
1 省份 2 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 CREATE TABLE [dbo].[Province]( 8 [ProvinceId] [bigint] IDENTITY(1,1) NOT NULL, 9 [ProvinceName] [nvarchar](50) NULL, 10 [AreasId] [int] NULL, 11 [IsDel] [int] NULL, 12 CONSTRAINT [PK_Province] PRIMARY KEY CLUSTERED 13 ( 14 [ProvinceId] ASC 15 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 16 ) ON [PRIMARY] 17 GO 18 SET IDENTITY_INSERT [dbo].[Province] ON 19 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (1, N'北京市', 1, NULL) 20 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (2, N'天津市', 1, NULL) 21 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (3, N'河北省', 1, NULL) 22 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (4, N'山西省', 1, NULL) 23 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (5, N'内蒙古自治区', 1, NULL) 24 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (6, N'辽宁省', 2, NULL) 25 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (7, N'吉林省', 2, NULL) 26 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (8, N'黑龙江省', 2, NULL) 27 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (9, N'上海市', 7, NULL) 28 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (10, N'江苏省', 7, NULL) 29 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (11, N'浙江省', 7, NULL) 30 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (12, N'安徽省', 3, NULL) 31 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (13, N'福建省', 7, NULL) 32 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (14, N'江西省', 3, NULL) 33 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (15, N'山东省', 3, NULL) 34 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (16, N'河南省', 4, NULL) 35 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (17, N'湖北省', 4, NULL) 36 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (18, N'湖南省', 4, NULL) 37 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (19, N'广东省', 4, NULL) 38 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (20, N'广西壮族自治区', 4, NULL) 39 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (21, N'海南省', 4, NULL) 40 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (22, N'重庆市', 5, NULL) 41 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (23, N'四川省', 5, NULL) 42 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (24, N'贵州省', 5, NULL) 43 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (25, N'云南省', 5, NULL) 44 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (26, N'西藏自治区', 5, NULL) 45 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (27, N'陕西省', 6, NULL) 46 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (28, N'甘肃省', 6, NULL) 47 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (29, N'青海省', 6, NULL) 48 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (30, N'宁夏回族自治区', 6, NULL) 49 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (31, N'新疆维吾尔自治区', 6, NULL) 50 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (32, N'香港特别行政区', 8, NULL) 51 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (33, N'澳门特别行政区', 8, NULL) 52 INSERT [dbo].[Province] ([ProvinceId], [ProvinceName], [AreasId], [IsDel]) VALUES (34, N'台湾省', 7, NULL) 53 SET IDENTITY_INSERT [dbo].[Province] OFF
城市的数据库脚本
1 /****** 2 城市 3 ******/ 4 SET ANSI_NULLS ON 5 GO 6 SET QUOTED_IDENTIFIER ON 7 GO 8 CREATE TABLE [dbo].[City]( 9 [CityId] [bigint] IDENTITY(1,1) NOT NULL, 10 [CityName] [nvarchar](50) NULL, 11 [ZipCode] [nvarchar](50) NULL, 12 [ProvinceID] [bigint] NULL, 13 [IsDel] [int] NULL, 14 CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED 15 ( 16 [CityId] ASC 17 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 18 ) ON [PRIMARY] 19 GO 20 SET IDENTITY_INSERT [dbo].[City] ON 21 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (1, N'北京市', N'100000', 1, NULL) 22 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (2, N'天津市', N'100000', 2, NULL) 23 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (3, N'石家庄市', N'050000', 3, NULL) 24 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (4, N'唐山市', N'063000', 3, NULL) 25 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (5, N'秦皇岛市', N'066000', 3, NULL) 26 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (6, N'邯郸市', N'056000', 3, NULL) 27 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (7, N'邢台市', N'054000', 3, NULL) 28 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (8, N'保定市', N'071000', 3, NULL) 29 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (9, N'张家口市', N'075000', 3, NULL) 30 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (10, N'承德市', N'067000', 3, NULL) 31 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (11, N'沧州市', N'061000', 3, NULL) 32 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (12, N'廊坊市', N'065000', 3, NULL) 33 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (13, N'衡水市', N'053000', 3, NULL) 34 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (14, N'太原市', N'030000', 4, NULL) 35 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (15, N'大同市', N'037000', 4, NULL) 36 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (16, N'阳泉市', N'045000', 4, NULL) 37 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (17, N'长治市', N'046000', 4, NULL) 38 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (18, N'晋城市', N'048000', 4, NULL) 39 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (19, N'朔州市', N'036000', 4, NULL) 40 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (20, N'晋中市', N'030600', 4, NULL) 41 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (21, N'运城市', N'044000', 4, NULL) 42 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (22, N'忻州市', N'034000', 4, NULL) 43 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (23, N'临汾市', N'041000', 4, NULL) 44 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (24, N'吕梁市', N'030500', 4, NULL) 45 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (25, N'呼和浩特市', N'010000', 5, NULL) 46 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (26, N'包头市', N'014000', 5, NULL) 47 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (27, N'乌海市', N'016000', 5, NULL) 48 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (28, N'赤峰市', N'024000', 5, NULL) 49 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (29, N'通辽市', N'028000', 5, NULL) 50 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (30, N'鄂尔多斯市', N'010300', 5, NULL) 51 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (31, N'呼伦贝尔市', N'021000', 5, NULL) 52 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (32, N'巴彦淖尔市', N'014400', 5, NULL) 53 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (33, N'乌兰察布市', N'011800', 5, NULL) 54 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (34, N'兴安盟', N'137500', 5, NULL) 55 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (35, N'锡林郭勒盟', N'011100', 5, NULL) 56 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (36, N'阿拉善盟', N'016000', 5, NULL) 57 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (37, N'沈阳市', N'110000', 6, NULL) 58 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (38, N'大连市', N'116000', 6, NULL) 59 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (39, N'鞍山市', N'114000', 6, NULL) 60 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (40, N'抚顺市', N'113000', 6, NULL) 61 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (41, N'本溪市', N'117000', 6, NULL) 62 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (42, N'丹东市', N'118000', 6, NULL) 63 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (43, N'锦州市', N'121000', 6, NULL) 64 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (44, N'营口市', N'115000', 6, NULL) 65 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (45, N'阜新市', N'123000', 6, NULL) 66 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (46, N'辽阳市', N'111000', 6, NULL) 67 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (47, N'盘锦市', N'124000', 6, NULL) 68 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (48, N'铁岭市', N'112000', 6, NULL) 69 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (49, N'朝阳市', N'122000', 6, NULL) 70 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (50, N'葫芦岛市', N'125000', 6, NULL) 71 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (51, N'长春市', N'130000', 7, NULL) 72 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (52, N'吉林市', N'132000', 7, NULL) 73 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (53, N'四平市', N'136000', 7, NULL) 74 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (54, N'辽源市', N'136200', 7, NULL) 75 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (55, N'通化市', N'134000', 7, NULL) 76 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (56, N'白山市', N'134300', 7, NULL) 77 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (57, N'松原市', N'131100', 7, NULL) 78 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (58, N'白城市', N'137000', 7, NULL) 79 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (59, N'延边朝鲜族自治州', N'133000', 7, NULL) 80 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (60, N'哈尔滨市', N'150000', 8, NULL) 81 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (61, N'齐齐哈尔市', N'161000', 8, NULL) 82 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (62, N'鸡西市', N'158100', 8, NULL) 83 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (63, N'鹤岗市', N'154100', 8, NULL) 84 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (64, N'双鸭山市', N'155100', 8, NULL) 85 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (65, N'大庆市', N'163000', 8, NULL) 86 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (66, N'伊春市', N'152300', 8, NULL) 87 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (67, N'佳木斯市', N'154000', 8, NULL) 88 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (68, N'七台河市', N'154600', 8, NULL) 89 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (69, N'牡丹江市', N'157000', 8, NULL) 90 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (70, N'黑河市', N'164300', 8, NULL) 91 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (71, N'绥化市', N'152000', 8, NULL) 92 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (72, N'大兴安岭地区', N'165000', 8, NULL) 93 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (73, N'上海市', N'200000', 9, NULL) 94 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (74, N'南京市', N'210000', 10, NULL) 95 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (75, N'无锡市', N'214000', 10, NULL) 96 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (76, N'徐州市', N'221000', 10, NULL) 97 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (77, N'常州市', N'213000', 10, NULL) 98 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (78, N'苏州市', N'215000', 10, NULL) 99 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (79, N'南通市', N'226000', 10, NULL) 100 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (80, N'连云港市', N'222000', 10, NULL) 101 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (81, N'淮安市', N'223200', 10, NULL) 102 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (82, N'盐城市', N'224000', 10, NULL) 103 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (83, N'扬州市', N'225000', 10, NULL) 104 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (84, N'镇江市', N'212000', 10, NULL) 105 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (85, N'泰州市', N'225300', 10, NULL) 106 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (86, N'宿迁市', N'223800', 10, NULL) 107 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (87, N'杭州市', N'310000', 11, NULL) 108 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (88, N'宁波市', N'315000', 11, NULL) 109 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (89, N'温州市', N'325000', 11, NULL) 110 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (90, N'嘉兴市', N'314000', 11, NULL) 111 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (91, N'湖州市', N'313000', 11, NULL) 112 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (92, N'绍兴市', N'312000', 11, NULL) 113 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (93, N'金华市', N'321000', 11, NULL) 114 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (94, N'衢州市', N'324000', 11, NULL) 115 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (95, N'舟山市', N'316000', 11, NULL) 116 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (96, N'台州市', N'318000', 11, NULL) 117 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (97, N'丽水市', N'323000', 11, NULL) 118 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (98, N'合肥市', N'230000', 12, NULL) 119 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (99, N'芜湖市', N'241000', 12, NULL) 120 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (100, N'蚌埠市', N'233000', 12, NULL) 121 GO 122 print 'Processed 100 total records' 123 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (101, N'淮南市', N'232000', 12, NULL) 124 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (102, N'马鞍山市', N'243000', 12, NULL) 125 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (103, N'淮北市', N'235000', 12, NULL) 126 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (104, N'铜陵市', N'244000', 12, NULL) 127 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (105, N'安庆市', N'246000', 12, NULL) 128 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (106, N'黄山市', N'242700', 12, NULL) 129 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (107, N'滁州市', N'239000', 12, NULL) 130 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (108, N'阜阳市', N'236100', 12, NULL) 131 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (109, N'宿州市', N'234100', 12, NULL) 132 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (111, N'六安市', N'237000', 12, NULL) 133 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (112, N'亳州市', N'236800', 12, NULL) 134 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (113, N'池州市', N'247100', 12, NULL) 135 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (114, N'宣城市', N'366000', 12, NULL) 136 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (115, N'福州市', N'350000', 13, NULL) 137 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (116, N'厦门市', N'361000', 13, NULL) 138 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (117, N'莆田市', N'351100', 13, NULL) 139 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (118, N'三明市', N'365000', 13, NULL) 140 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (119, N'泉州市', N'362000', 13, NULL) 141 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (120, N'漳州市', N'363000', 13, NULL) 142 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (121, N'南平市', N'353000', 13, NULL) 143 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (122, N'龙岩市', N'364000', 13, NULL) 144 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (123, N'宁德市', N'352100', 13, NULL) 145 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (124, N'南昌市', N'330000', 14, NULL) 146 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (125, N'景德镇市', N'333000', 14, NULL) 147 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (126, N'萍乡市', N'337000', 14, NULL) 148 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (127, N'九江市', N'332000', 14, NULL) 149 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (128, N'新余市', N'338000', 14, NULL) 150 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (129, N'鹰潭市', N'335000', 14, NULL) 151 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (130, N'赣州市', N'341000', 14, NULL) 152 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (131, N'吉安市', N'343000', 14, NULL) 153 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (132, N'宜春市', N'336000', 14, NULL) 154 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (133, N'抚州市', N'332900', 14, NULL) 155 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (134, N'上饶市', N'334000', 14, NULL) 156 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (135, N'济南市', N'250000', 15, NULL) 157 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (136, N'青岛市', N'266000', 15, NULL) 158 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (137, N'淄博市', N'255000', 15, NULL) 159 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (138, N'枣庄市', N'277100', 15, NULL) 160 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (139, N'东营市', N'257000', 15, NULL) 161 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (140, N'烟台市', N'264000', 15, NULL) 162 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (141, N'潍坊市', N'261000', 15, NULL) 163 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (142, N'济宁市', N'272100', 15, NULL) 164 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (143, N'泰安市', N'271000', 15, NULL) 165 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (144, N'威海市', N'265700', 15, NULL) 166 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (145, N'日照市', N'276800', 15, NULL) 167 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (146, N'莱芜市', N'271100', 15, NULL) 168 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (147, N'临沂市', N'276000', 15, NULL) 169 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (148, N'德州市', N'253000', 15, NULL) 170 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (149, N'聊城市', N'252000', 15, NULL) 171 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (150, N'滨州市', N'256600', 15, NULL) 172 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (151, N'荷泽市', N'255000', 15, NULL) 173 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (152, N'郑州市', N'450000', 16, NULL) 174 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (153, N'开封市', N'475000', 16, NULL) 175 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (154, N'洛阳市', N'471000', 16, NULL) 176 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (155, N'平顶山市', N'467000', 16, NULL) 177 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (156, N'安阳市', N'454900', 16, NULL) 178 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (157, N'鹤壁市', N'456600', 16, NULL) 179 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (158, N'新乡市', N'453000', 16, NULL) 180 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (159, N'焦作市', N'454100', 16, NULL) 181 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (160, N'濮阳市', N'457000', 16, NULL) 182 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (161, N'许昌市', N'461000', 16, NULL) 183 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (162, N'漯河市', N'462000', 16, NULL) 184 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (163, N'三门峡市', N'472000', 16, NULL) 185 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (164, N'南阳市', N'473000', 16, NULL) 186 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (165, N'商丘市', N'476000', 16, NULL) 187 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (166, N'信阳市', N'464000', 16, NULL) 188 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (167, N'周口市', N'466000', 16, NULL) 189 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (168, N'驻马店市', N'463000', 16, NULL) 190 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (169, N'武汉市', N'430000', 17, NULL) 191 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (170, N'黄石市', N'435000', 17, NULL) 192 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (171, N'十堰市', N'442000', 17, NULL) 193 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (172, N'宜昌市', N'443000', 17, NULL) 194 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (173, N'襄阳市', N'441000', 17, NULL) 195 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (174, N'鄂州市', N'436000', 17, NULL) 196 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (175, N'荆门市', N'448000', 17, NULL) 197 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (176, N'孝感市', N'432100', 17, NULL) 198 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (177, N'荆州市', N'434000', 17, NULL) 199 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (178, N'黄冈市', N'438000', 17, NULL) 200 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (179, N'咸宁市', N'437000', 17, NULL) 201 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (180, N'随州市', N'441300', 17, NULL) 202 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (181, N'恩施土家族苗族自治州', N'445000', 17, NULL) 203 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (182, N'神农架', N'442400', 17, NULL) 204 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (183, N'长沙市', N'410000', 18, NULL) 205 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (184, N'株洲市', N'412000', 18, NULL) 206 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (185, N'湘潭市', N'411100', 18, NULL) 207 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (186, N'衡阳市', N'421000', 18, NULL) 208 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (187, N'邵阳市', N'422000', 18, NULL) 209 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (188, N'岳阳市', N'414000', 18, NULL) 210 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (189, N'常德市', N'415000', 18, NULL) 211 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (190, N'张家界市', N'427000', 18, NULL) 212 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (191, N'益阳市', N'413000', 18, NULL) 213 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (192, N'郴州市', N'423000', 18, NULL) 214 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (193, N'永州市', N'425000', 18, NULL) 215 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (194, N'怀化市', N'418000', 18, NULL) 216 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (195, N'娄底市', N'417000', 18, NULL) 217 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (196, N'湘西土家族苗族自治州', N'416000', 18, NULL) 218 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (197, N'广州市', N'510000', 19, NULL) 219 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (198, N'韶关市', N'521000', 19, NULL) 220 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (199, N'深圳市', N'518000', 19, NULL) 221 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (200, N'珠海市', N'519000', 19, NULL) 222 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (201, N'汕头市', N'515000', 19, NULL) 223 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (202, N'佛山市', N'528000', 19, NULL) 224 GO 225 print 'Processed 200 total records' 226 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (203, N'江门市', N'529000', 19, NULL) 227 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (204, N'湛江市', N'524000', 19, NULL) 228 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (205, N'茂名市', N'525000', 19, NULL) 229 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (206, N'肇庆市', N'526000', 19, NULL) 230 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (207, N'惠州市', N'516000', 19, NULL) 231 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (208, N'梅州市', N'514000', 19, NULL) 232 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (209, N'汕尾市', N'516600', 19, NULL) 233 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (210, N'河源市', N'517000', 19, NULL) 234 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (211, N'阳江市', N'529500', 19, NULL) 235 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (212, N'清远市', N'511500', 19, NULL) 236 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (213, N'东莞市', N'511700', 19, NULL) 237 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (214, N'中山市', N'528400', 19, NULL) 238 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (215, N'潮州市', N'515600', 19, NULL) 239 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (216, N'揭阳市', N'522000', 19, NULL) 240 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (217, N'云浮市', N'527300', 19, NULL) 241 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (218, N'南宁市', N'530000', 20, NULL) 242 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (219, N'柳州市', N'545000', 20, NULL) 243 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (220, N'桂林市', N'541000', 20, NULL) 244 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (221, N'梧州市', N'543000', 20, NULL) 245 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (222, N'北海市', N'536000', 20, NULL) 246 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (223, N'防城港市', N'538000', 20, NULL) 247 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (224, N'钦州市', N'535000', 20, NULL) 248 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (225, N'贵港市', N'537100', 20, NULL) 249 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (226, N'玉林市', N'537000', 20, NULL) 250 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (227, N'百色市', N'533000', 20, NULL) 251 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (228, N'贺州市', N'542800', 20, NULL) 252 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (229, N'河池市', N'547000', 20, NULL) 253 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (230, N'来宾市', N'546100', 20, NULL) 254 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (231, N'崇左市', N'532200', 20, NULL) 255 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (232, N'海口市', N'570000', 21, NULL) 256 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (233, N'三沙市', N'572000', 21, NULL) 257 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (234, N'重庆市', N'400000', 22, NULL) 258 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (235, N'成都市', N'610000', 23, NULL) 259 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (236, N'自贡市', N'643000', 23, NULL) 260 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (237, N'攀枝花市', N'617000', 23, NULL) 261 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (238, N'泸州市', N'646100', 23, NULL) 262 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (239, N'德阳市', N'618000', 23, NULL) 263 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (240, N'绵阳市', N'621000', 23, NULL) 264 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (241, N'广元市', N'628000', 23, NULL) 265 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (242, N'遂宁市', N'629000', 23, NULL) 266 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (243, N'内江市', N'641000', 23, NULL) 267 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (244, N'乐山市', N'614000', 23, NULL) 268 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (245, N'南充市', N'637000', 23, NULL) 269 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (246, N'眉山市', N'612100', 23, NULL) 270 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (247, N'宜宾市', N'644000', 23, NULL) 271 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (248, N'广安市', N'638000', 23, NULL) 272 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (249, N'达州市', N'635000', 23, NULL) 273 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (250, N'雅安市', N'625000', 23, NULL) 274 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (251, N'巴中市', N'635500', 23, NULL) 275 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (252, N'资阳市', N'641300', 23, NULL) 276 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (253, N'阿坝藏族羌族自治州', N'624600', 23, NULL) 277 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (254, N'甘孜藏族自治州', N'626000', 23, NULL) 278 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (255, N'凉山彝族自治州', N'615000', 23, NULL) 279 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (256, N'贵阳市', N'55000', 24, NULL) 280 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (257, N'六盘水市', N'553000', 24, NULL) 281 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (258, N'遵义市', N'563000', 24, NULL) 282 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (259, N'安顺市', N'561000', 24, NULL) 283 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (260, N'铜仁市', N'554300', 24, NULL) 284 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (261, N'黔西南布依族苗族自治州', N'551500', 24, NULL) 285 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (262, N'毕节市', N'551700', 24, NULL) 286 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (263, N'黔东南苗族侗族自治州', N'551500', 24, NULL) 287 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (264, N'黔南布依族苗族自治州', N'550100', 24, NULL) 288 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (265, N'昆明市', N'650000', 25, NULL) 289 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (266, N'曲靖市', N'655000', 25, NULL) 290 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (267, N'玉溪市', N'653100', 25, NULL) 291 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (268, N'保山市', N'678000', 25, NULL) 292 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (269, N'昭通市', N'657000', 25, NULL) 293 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (270, N'丽江市', N'674100', 25, NULL) 294 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (271, N'普洱市', N'665000', 25, NULL) 295 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (272, N'临沧市', N'677000', 25, NULL) 296 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (273, N'楚雄彝族自治州', N'675000', 25, NULL) 297 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (274, N'红河哈尼族彝族自治州', N'654400', 25, NULL) 298 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (275, N'文山壮族苗族自治州', N'663000', 25, NULL) 299 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (276, N'西双版纳傣族自治州', N'666200', 25, NULL) 300 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (277, N'大理白族自治州', N'671000', 25, NULL) 301 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (278, N'德宏傣族景颇族自治州', N'678400', 25, NULL) 302 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (279, N'怒江傈僳族自治州', N'671400', 25, NULL) 303 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (280, N'迪庆藏族自治州', N'674400', 25, NULL) 304 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (281, N'拉萨市', N'850000', 26, NULL) 305 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (282, N'昌都地区', N'854000', 26, NULL) 306 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (283, N'山南地区', N'856000', 26, NULL) 307 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (284, N'日喀则地区', N'857000', 26, NULL) 308 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (285, N'那曲地区', N'852000', 26, NULL) 309 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (286, N'阿里地区', N'859100', 26, NULL) 310 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (287, N'林芝地区', N'860100', 26, NULL) 311 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (288, N'西安市', N'710000', 27, NULL) 312 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (289, N'铜川市', N'727000', 27, NULL) 313 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (290, N'宝鸡市', N'721000', 27, NULL) 314 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (291, N'咸阳市', N'712000', 27, NULL) 315 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (292, N'渭南市', N'714000', 27, NULL) 316 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (293, N'延安市', N'716000', 27, NULL) 317 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (294, N'汉中市', N'723000', 27, NULL) 318 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (295, N'榆林市', N'719000', 27, NULL) 319 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (296, N'安康市', N'725000', 27, NULL) 320 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (297, N'商洛市', N'711500', 27, NULL) 321 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (298, N'兰州市', N'730000', 28, NULL) 322 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (300, N'嘉峪关市', N'737100', 28, NULL) 323 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (301, N'白银市', N'730900', 28, NULL) 324 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (302, N'天水市', N'741000', 28, NULL) 325 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (303, N'武威市', N'733000', 28, NULL) 326 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (304, N'张掖市', N'734000', 28, NULL) 327 GO 328 print 'Processed 300 total records' 329 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (305, N'平凉市', N'744000', 28, NULL) 330 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (306, N'酒泉市', N'735000', 28, NULL) 331 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (307, N'庆阳市', N'744500', 28, NULL) 332 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (308, N'定西市', N'743000', 28, NULL) 333 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (309, N'陇南市', N'742100', 28, NULL) 334 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (310, N'临夏回族自治州', N'731100', 28, NULL) 335 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (311, N'甘南藏族自治州', N'747000', 28, NULL) 336 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (312, N'西宁市', N'810000', 29, NULL) 337 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (313, N'海东地区', N'810600', 29, NULL) 338 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (314, N'海北藏族自治州', N'810300', 29, NULL) 339 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (315, N'黄南藏族自治州', N'811300', 29, NULL) 340 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (316, N'海南藏族自治州', N'813000', 29, NULL) 341 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (317, N'果洛藏族自治州', N'814000', 29, NULL) 342 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (318, N'玉树藏族自治州', N'815000', 29, NULL) 343 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (319, N'海西蒙古族藏族自治州', N'817000', 29, NULL) 344 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (320, N'银川市', N'750000', 30, NULL) 345 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (321, N'石嘴山市', N'753000', 30, NULL) 346 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (322, N'吴忠市', N'751100', 30, NULL) 347 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (323, N'固原市', N'756000', 30, NULL) 348 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (324, N'中卫市', N'751700', 30, NULL) 349 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (325, N'乌鲁木齐市', N'830000', 31, NULL) 350 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (326, N'克拉玛依市', N'834000', 31, NULL) 351 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (327, N'吐鲁番地区', N'838000', 31, NULL) 352 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (328, N'哈密地区', N'839000', 31, NULL) 353 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (329, N'昌吉回族自治州', N'831100', 31, NULL) 354 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (330, N'博尔塔拉蒙古自治州', N'833400', 31, NULL) 355 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (331, N'巴音郭楞蒙古自治州', N'841000', 31, NULL) 356 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (332, N'阿克苏地区', N'843000', 31, NULL) 357 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (333, N'克孜勒苏柯尔克孜自治州', N'835600', 31, NULL) 358 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (334, N'喀什地区', N'844000', 31, NULL) 359 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (335, N'和田地区', N'848000', 31, NULL) 360 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (336, N'伊犁哈萨克自治州', N'833200', 31, NULL) 361 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (337, N'塔城地区', N'834700', 31, NULL) 362 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (338, N'阿勒泰地区', N'836500', 31, NULL) 363 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (339, N'石河子市', N'832000', 31, NULL) 364 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (340, N'阿拉尔市', N'843300', 31, NULL) 365 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (341, N'图木舒克市', N'843900', 31, NULL) 366 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (342, N'五家渠市', N'831300', 31, NULL) 367 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (343, N'香港特别行政区', N'000000', 32, NULL) 368 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (344, N'澳门特别行政区', N'000000', 33, NULL) 369 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (345, N'台湾省', N'000000', 34, NULL) 370 INSERT [dbo].[City] ([CityId], [CityName], [ZipCode], [ProvinceID], [IsDel]) VALUES (346, N'三亚市', NULL, 21, NULL) 371 SET IDENTITY_INSERT [dbo].[City] OFF
下面将介绍关于省市联动的详细分析
前台代码jqury代码展示
1 <script type="text/javascript"> 2 $(function () { 3 initProvinceSelect(); 4 5 }); 6 //初始化省的标签 7 function initProvinceSelect() { 8 9 $.get("Province.ashx", "", function (data) { 10 $("#Pro").html(data); 11 bindProvinceChange(); 12 $("#Pro").change(); 13 }); 14 } 15 //绑定省份的change事件 16 function bindProvinceChange() { 17 18 $("#Pro").change(function () { 19 var pid = $(this).val(); 20 alert(pid); 21 22 var p = $("#Pro").find("option:selected").text(); 23 alert(p); 24 $.get("City.ashx", { pid: pid }, function (data) { 25 $("#City").html(data); 26 27 }); 28 }); 29 } 30 </script>
前台代码展示
1 <form id="form1" runat="server"> 2 <div> 3 <select id="Pro"> 4 5 </select> 6 <select id="City"> 7 8 </select> 9 </div> 10 </form>
这里是使用一般处理程序对省市之间通过索引建立关联
省份的一般处理程序
1 public void ProcessRequest(HttpContext context) 2 { 3 context.Response.ContentType = "text/plain"; 4 //context.Response.Write("Hello World"); 5 BLL.Province bll = new BLL.Province(); 6 DataSet ds = new DataSet(); 7 DataTable dt=new DataTable(); 8 ds = bll.GetAllList(); 9 dt=ds.Tables[0]; 10 StringBuilder sb = new StringBuilder(); 11 foreach (DataRow row in dt.Rows) 12 { 13 //for (int i = 0; i < dt.Rows.Count; i++) { 14 // string a= row["ProvinceId"].ToString(); 15 //} 16 sb.AppendFormat("<option value='{0}'>{1}</option>", row["ProvinceId"].ToString(), row["ProvinceName"].ToString()); 17 } 18 context.Response.Write(sb.ToString()); 19 }
城市的一般处理程序
1 public void ProcessRequest(HttpContext context) 2 { 3 context.Response.ContentType = "text/plain"; 4 // context.Response.Write("Hello World"); 5 BLL.City bll = new BLL.City(); 6 int pid=int.Parse(context.Request["pid"]??"0"); 7 DataSet ds = new DataSet(); 8 DataTable dt = new DataTable(); 9 ds=bll.GetListById(pid); 10 dt=ds.Tables[0]; 11 StringBuilder sb = new StringBuilder(); 12 foreach (DataRow row in dt.Rows) 13 { 14 sb.AppendFormat("<option value='{0}'>{1}</option>", row["CityId"].ToString(), row["CityName"].ToString()); 15 } 16 context.Response.Write(sb.ToString()); 17 }