public ActionResult Login(LoginModel model, string returnUrl)
{
if (ModelState.IsValid)
{
string realName = model.UserName;
//判断输入的用户名是否邮箱
if (new System.ComponentModel.DataAnnotations.EmailAddressAttribute().IsValid(model.UserName))
{
//从数据库查找用户名
using (var db = new MKContext())
{
var user = db.UserProfiles.Where(u => u.Email == model.UserName).FirstOrDefault();
if (user != null)
{
realName = user.UserName;
}
}
}
if (WebSecurity.Login(realName, model.Password, persistCookie: model.RememberMe))
{
return(RedirectToLocal(returnUrl));
}
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
ViewBag.ErrorMessage = "Username or password error";
ModelState.AddModelError("", ViewBag.ErrorMessage);
return(View(model));
}
public ActionResult DeleteAddress(int id, string returnUrl)
{
using (var db = new MKContext())
{
var user = db.GetUserProfile(User.Identity.Name);
var address = db.AddressBooks.Find(id);
if (address == null)
{
return(HttpNotFound());
}
if (!user.AddressBooks.Any(i => i.Id == id))
{
return(HttpNotFound());
}
db.AddressBooks.Remove(address);
db.SaveChanges();
if (user.DefaultAddressId == id)
{
if (db.AddressBooks.Count() != 0)
{
user.DefaultAddressId = db.AddressBooks.First().Id;
}
else
{
user.DefaultAddressId = null;
}
db.SaveChanges();
}
}
return(RedirectToLocal(returnUrl));
}
public ActionResult DeleteCard(int id, string returnUrl)
{
using (var db = new MKContext())
{
var user = db.GetUserProfile(User.Identity.Name);
var card = db.CardDetailsSet.Find(id);
if (card == null)
{
return(HttpNotFound());
}
if (!user.CardDetailsSet.Any(i => i.Id == id))
{
return(HttpNotFound());
}
db.CardDetailsSet.Remove(card);
db.SaveChanges();
if (user.DefaultCardId == id)
{
if (db.CardDetailsSet.Count() != 0)
{
user.DefaultCardId = db.CardDetailsSet.First().Id;
}
else
{
user.DefaultCardId = null;
}
db.SaveChanges();
}
}
return(RedirectToLocal(returnUrl));
}
//-----------------------------
public ActionResult AddCard(string returnUrl)
{
ViewBag.ReturnUrl = returnUrl;
using (var db = new MKContext())
{
return(View());
}
}
public ActionResult Overall()
{
using (var db = new MKContext())
{
var user = db.UserProfiles.Include(p => p.CardDetailsSet).Include(p => p.AddressBooks).Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
return(View(user));
}
}
//-----------------------------
public ActionResult ModifyAvatar(string returnUrl)
{
ViewBag.ReturnUrl = returnUrl;
using (var db = new MKContext())
{
ViewBag.AvatarUrl = db.GetUserProfile(User.Identity.Name).AvatarUrl;
return(View());
}
}
public ActionResult ModifyAddress(AddressBook model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new MKContext())
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToLocal(returnUrl));
}
public DatabaseInitializer()
{
try
{
using (var context = new MKContext())
{
if (context.GetUserProfile("meno") == null)
{
var user = new UserProfile(context)
{
Email = "*****@*****.**", UserName = "******"
};
context.SaveChanges();
if (!WebSecurity.Initialized)
{
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "Id", "UserName", autoCreateTables: true);
}
WebSecurity.CreateAccount(user.UserName, "111111");
Roles.CreateRole("Admin");
Roles.CreateRole("Master");
Roles.AddUserToRoles(user.UserName, Roles.GetAllRoles());
user = new UserProfile(context)
{
Email = "*****@*****.**", UserName = "******"
};
context.SaveChanges();
WebSecurity.CreateAccount(user.UserName, "111111");
Roles.AddUserToRole(user.UserName, "admin");
}
if (!context.Database.Exists())
{
// 创建不包含 Entity Framework 迁移架构的 SimpleMembership 数据库
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
if (!WebSecurity.Initialized)
{
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "Id", "UserName", autoCreateTables: true);
}
}
catch (Exception ex)
{
throw new InvalidOperationException("无法初始化 ASP.NET 数据库。有关详细信息，请参阅 http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
public ActionResult ModifyAvatar(HttpPostedFileBase image, string returnUrl)
{
if (image.Empty())
{
ViewBag.ErrorMessage = "No image upload.";
ModelState.AddModelError("", ViewBag.ErrorMessage);
return(ModifyAvatar(returnUrl));
}
//保存图片
using (var db = new MKContext())
{
this.SaveFile(image, db.GetUserProfile(User.Identity.Name).Id, "Image/Avatar");
}
return(RedirectToLocal(returnUrl));
}
public ActionResult ModifyAddress(int id, string returnUrl)
{
ViewBag.ReturnUrl = returnUrl;
using (var db = new MKContext())
{
var address = db.AddressBooks.Find(id);
if (address == null)
{
return(HttpNotFound());
}
//非法访问
if (!db.GetUserProfile(User.Identity.Name).AddressBooks.Any(i => i.Id == id))
{
return(HttpNotFound());
}
return(View(address));
}
}
public ActionResult SetDefaultCard(int id, string returnUrl)
{
using (var db = new MKContext())
{
var card = db.CardDetailsSet.Find(id);
if (card == null)
{
return(HttpNotFound());
}
var user = db.GetUserProfile(User.Identity.Name);
//非法访问
if (!user.CardDetailsSet.Any(i => i.Id == id))
{
return(HttpNotFound());
}
user.DefaultCardId = card.Id;
db.SaveChanges();
}
return(RedirectToLocal(returnUrl));
}
public ActionResult SetDefaultAddress(int id, string returnUrl)
{
using (var db = new MKContext())
{
var address = db.AddressBooks.Find(id);
if (address == null)
{
return(HttpNotFound());
}
var user = db.GetUserProfile(User.Identity.Name);
//非法访问
if (!user.AddressBooks.Any(i => i.Id == id))
{
return(HttpNotFound());
}
user.DefaultAddressId = address.Id;
db.SaveChanges();
}
return(RedirectToLocal(returnUrl));
}
public ActionResult AddCard(CardDetails model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new MKContext())
{
var user = db.GetUserProfile(User.Identity.Name);
user.CardDetailsSet.Add(model);
model.UserProfile = user;
//先保存数据，model的Id会进行更改
db.SaveChanges();
if (user.DefaultCard == null)
{
user.DefaultCardId = model.Id;
}
db.SaveChanges();
}
return(RedirectToLocal(returnUrl));
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
while (true)
{
using (var db = new MKContext())
{
var user = db.UserProfiles.Where(u => u.UserName == model.UserName || u.Email == model.Email).FirstOrDefault();
if (user != null)
{
ViewBag.ErrorMessage = "Email or username is already exist";
ModelState.AddModelError("", ViewBag.ErrorMessage);
break;
}
model.AddUserProfile(db);
db.SaveChanges();
}
// 尝试注册用户
try
{
WebSecurity.CreateAccount(model.UserName, model.Password);
WebSecurity.Login(model.UserName, model.Password);
return(RedirectToAction("Index", "Home"));
}
catch (MembershipCreateUserException e)
{
ViewBag.ErrorMessage = ErrorCodeToString(e.StatusCode);
ModelState.AddModelError("", ViewBag.ErrorMessage);
}
}
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
return(View(model));
}
public HomeController(MKContext mkContext)
{
_mkContext = mkContext;
Trace.TraceError("TRACING ERROR!");
}
public static void Initialize(MKContext db)
{
//INSERT INTO Country ([Name]) VALUES (N'')
db.Database.ExecuteSqlCommand(@"
INSERT INTO Country ([Name]) VALUES (N'中国')
INSERT INTO Country ([Name]) VALUES (N'阿尔巴尼亚')
INSERT INTO Country ([Name]) VALUES (N'阿尔及利亚')
INSERT INTO Country ([Name]) VALUES (N'阿富汗')
INSERT INTO Country ([Name]) VALUES (N'阿根廷')
INSERT INTO Country ([Name]) VALUES (N'阿拉伯联合酋长国')
INSERT INTO Country ([Name]) VALUES (N'阿鲁巴')
INSERT INTO Country ([Name]) VALUES (N'阿曼')
INSERT INTO Country ([Name]) VALUES ('阿塞拜疆')
INSERT INTO Country ([Name]) VALUES ('阿森松岛')
INSERT INTO Country ([Name]) VALUES ('埃及')
INSERT INTO Country ([Name]) VALUES ('埃塞俄比亚')
INSERT INTO Country ([Name]) VALUES ('爱尔兰')
INSERT INTO Country ([Name]) VALUES ('爱沙尼亚')
INSERT INTO Country ([Name]) VALUES ('安道尔')
INSERT INTO Country ([Name]) VALUES ('安哥拉')
INSERT INTO Country ([Name]) VALUES ('安圭拉')
INSERT INTO Country ([Name]) VALUES ('安提瓜岛和巴布达')
INSERT INTO Country ([Name]) VALUES ('奥地利')
INSERT INTO Country ([Name]) VALUES ('奥兰群岛')
INSERT INTO Country ([Name]) VALUES ('澳大利亚')
INSERT INTO Country ([Name]) VALUES ('巴巴多斯岛')
INSERT INTO Country ([Name]) VALUES ('巴布亚新几内亚')
INSERT INTO Country ([Name]) VALUES ('巴哈马')
INSERT INTO Country ([Name]) VALUES ('巴基斯坦')
INSERT INTO Country ([Name]) VALUES ('巴拉圭')
INSERT INTO Country ([Name]) VALUES ('巴勒斯坦')
INSERT INTO Country ([Name]) VALUES ('巴林')
INSERT INTO Country ([Name]) VALUES ('巴拿马')
INSERT INTO Country ([Name]) VALUES ('巴西')
INSERT INTO Country ([Name]) VALUES ('白俄罗斯')
INSERT INTO Country ([Name]) VALUES ('百慕大')
INSERT INTO Country ([Name]) VALUES ('保加利亚')
INSERT INTO Country ([Name]) VALUES ('北马里亚纳群岛')
INSERT INTO Country ([Name]) VALUES ('贝宁')
INSERT INTO Country ([Name]) VALUES ('比利时')
INSERT INTO Country ([Name]) VALUES ('冰岛')
INSERT INTO Country ([Name]) VALUES ('波多黎各')
INSERT INTO Country ([Name]) VALUES ('波兰')
INSERT INTO Country ([Name]) VALUES ('波斯尼亚和黑塞哥维那')
INSERT INTO Country ([Name]) VALUES ('玻利维亚')
INSERT INTO Country ([Name]) VALUES ('伯利兹')
INSERT INTO Country ([Name]) VALUES ('博茨瓦纳')
INSERT INTO Country ([Name]) VALUES ('不丹')
INSERT INTO Country ([Name]) VALUES ('布基纳法索')
INSERT INTO Country ([Name]) VALUES ('布隆迪')
INSERT INTO Country ([Name]) VALUES ('布韦岛')
INSERT INTO Country ([Name]) VALUES ('朝鲜')
INSERT INTO Country ([Name]) VALUES ('丹麦')
INSERT INTO Country ([Name]) VALUES ('德国')
INSERT INTO Country ([Name]) VALUES ('东帝汶')
INSERT INTO Country ([Name]) VALUES ('多哥')
INSERT INTO Country ([Name]) VALUES ('多米尼加')
INSERT INTO Country ([Name]) VALUES ('多米尼加共和国')
INSERT INTO Country ([Name]) VALUES ('俄罗斯')
INSERT INTO Country ([Name]) VALUES ('厄瓜多尔')
INSERT INTO Country ([Name]) VALUES ('厄立特里亚')
INSERT INTO Country ([Name]) VALUES ('法国')
INSERT INTO Country ([Name]) VALUES ('法罗群岛')
INSERT INTO Country ([Name]) VALUES ('法属波利尼西亚')
INSERT INTO Country ([Name]) VALUES ('法属圭亚那')
INSERT INTO Country ([Name]) VALUES ('法属南部领地')
INSERT INTO Country ([Name]) VALUES ('梵蒂冈')
INSERT INTO Country ([Name]) VALUES ('菲律宾')
INSERT INTO Country ([Name]) VALUES ('斐济')
INSERT INTO Country ([Name]) VALUES ('芬兰')
INSERT INTO Country ([Name]) VALUES ('佛得角')
INSERT INTO Country ([Name]) VALUES ('弗兰克群岛')
INSERT INTO Country ([Name]) VALUES ('冈比亚')
INSERT INTO Country ([Name]) VALUES ('刚果')
INSERT INTO Country ([Name]) VALUES ('刚果民主共和国')
INSERT INTO Country ([Name]) VALUES ('哥伦比亚')
INSERT INTO Country ([Name]) VALUES ('哥斯达黎加')
INSERT INTO Country ([Name]) VALUES ('格恩西岛')
INSERT INTO Country ([Name]) VALUES ('格林纳达')
INSERT INTO Country ([Name]) VALUES ('格陵兰')
INSERT INTO Country ([Name]) VALUES ('古巴')
INSERT INTO Country ([Name]) VALUES ('瓜德罗普')
INSERT INTO Country ([Name]) VALUES ('关岛')
INSERT INTO Country ([Name]) VALUES ('圭亚那')
INSERT INTO Country ([Name]) VALUES ('哈萨克斯坦')
INSERT INTO Country ([Name]) VALUES ('海地')
INSERT INTO Country ([Name]) VALUES ('韩国')
INSERT INTO Country ([Name]) VALUES ('荷兰')
INSERT INTO Country ([Name]) VALUES ('荷属安地列斯')
INSERT INTO Country ([Name]) VALUES ('赫德和麦克唐纳群岛')
INSERT INTO Country ([Name]) VALUES ('洪都拉斯')
INSERT INTO Country ([Name]) VALUES ('基里巴斯')
INSERT INTO Country ([Name]) VALUES ('吉布提')
INSERT INTO Country ([Name]) VALUES ('吉尔吉斯斯坦')
INSERT INTO Country ([Name]) VALUES ('几内亚')
INSERT INTO Country ([Name]) VALUES ('几内亚比绍')
INSERT INTO Country ([Name]) VALUES ('加拿大')
INSERT INTO Country ([Name]) VALUES ('加纳')
INSERT INTO Country ([Name]) VALUES ('加蓬')
INSERT INTO Country ([Name]) VALUES ('柬埔寨')
INSERT INTO Country ([Name]) VALUES ('捷克共和国')
INSERT INTO Country ([Name]) VALUES ('津巴布韦')
INSERT INTO Country ([Name]) VALUES ('喀麦隆')
INSERT INTO Country ([Name]) VALUES ('卡塔尔')
INSERT INTO Country ([Name]) VALUES ('开曼群岛')
INSERT INTO Country ([Name]) VALUES ('科科斯群岛')
INSERT INTO Country ([Name]) VALUES ('科摩罗')
INSERT INTO Country ([Name]) VALUES ('科特迪瓦')
INSERT INTO Country ([Name]) VALUES ('科威特')
INSERT INTO Country ([Name]) VALUES ('克罗地亚')
INSERT INTO Country ([Name]) VALUES ('肯尼亚')
INSERT INTO Country ([Name]) VALUES ('库克群岛')
INSERT INTO Country ([Name]) VALUES ('拉脱维亚')
INSERT INTO Country ([Name]) VALUES ('莱索托')
INSERT INTO Country ([Name]) VALUES ('老挝')
INSERT INTO Country ([Name]) VALUES ('黎巴嫩')
INSERT INTO Country ([Name]) VALUES ('立陶宛')
INSERT INTO Country ([Name]) VALUES ('利比里亚')
INSERT INTO Country ([Name]) VALUES ('利比亚')
INSERT INTO Country ([Name]) VALUES ('列支敦士登')
INSERT INTO Country ([Name]) VALUES ('留尼旺岛')
INSERT INTO Country ([Name]) VALUES ('卢森堡')
INSERT INTO Country ([Name]) VALUES ('卢旺达')
INSERT INTO Country ([Name]) VALUES ('罗马尼亚')
INSERT INTO Country ([Name]) VALUES ('马达加斯加')
INSERT INTO Country ([Name]) VALUES ('马尔代夫')
INSERT INTO Country ([Name]) VALUES ('马耳他')
INSERT INTO Country ([Name]) VALUES ('马拉维')
INSERT INTO Country ([Name]) VALUES ('马来西亚')
INSERT INTO Country ([Name]) VALUES ('马里')
INSERT INTO Country ([Name]) VALUES ('马其顿')
INSERT INTO Country ([Name]) VALUES ('马绍尔群岛')
INSERT INTO Country ([Name]) VALUES ('马提尼克')
INSERT INTO Country ([Name]) VALUES ('马约特岛')
INSERT INTO Country ([Name]) VALUES ('曼岛')
INSERT INTO Country ([Name]) VALUES ('毛里求斯')
INSERT INTO Country ([Name]) VALUES ('毛里塔尼亚')
INSERT INTO Country ([Name]) VALUES ('美国')
INSERT INTO Country ([Name]) VALUES ('美属萨摩亚')
INSERT INTO Country ([Name]) VALUES ('美属外岛')
INSERT INTO Country ([Name]) VALUES ('蒙古')
INSERT INTO Country ([Name]) VALUES ('蒙特塞拉特')
INSERT INTO Country ([Name]) VALUES ('孟加拉')
INSERT INTO Country ([Name]) VALUES ('秘鲁')
INSERT INTO Country ([Name]) VALUES ('密克罗尼西亚')
INSERT INTO Country ([Name]) VALUES ('缅甸')
INSERT INTO Country ([Name]) VALUES ('摩尔多瓦')
INSERT INTO Country ([Name]) VALUES ('摩洛哥')
INSERT INTO Country ([Name]) VALUES ('摩纳哥')
INSERT INTO Country ([Name]) VALUES ('莫桑比克')
INSERT INTO Country ([Name]) VALUES ('墨西哥')
INSERT INTO Country ([Name]) VALUES ('纳米比亚')
INSERT INTO Country ([Name]) VALUES ('南非')
INSERT INTO Country ([Name]) VALUES ('南极洲')
INSERT INTO Country ([Name]) VALUES ('南乔治亚和南桑德威奇群岛')
INSERT INTO Country ([Name]) VALUES ('瑙鲁')
INSERT INTO Country ([Name]) VALUES ('尼泊尔')
INSERT INTO Country ([Name]) VALUES ('尼加拉瓜')
INSERT INTO Country ([Name]) VALUES ('尼日尔')
INSERT INTO Country ([Name]) VALUES ('尼日利亚')
INSERT INTO Country ([Name]) VALUES ('纽埃')
INSERT INTO Country ([Name]) VALUES ('挪威')
INSERT INTO Country ([Name]) VALUES ('诺福克')
INSERT INTO Country ([Name]) VALUES ('帕劳群岛')
INSERT INTO Country ([Name]) VALUES ('皮特凯恩')
INSERT INTO Country ([Name]) VALUES ('葡萄牙')
INSERT INTO Country ([Name]) VALUES ('乔治亚')
INSERT INTO Country ([Name]) VALUES ('日本')
INSERT INTO Country ([Name]) VALUES ('瑞典')
INSERT INTO Country ([Name]) VALUES ('瑞士')
INSERT INTO Country ([Name]) VALUES ('萨尔瓦多')
INSERT INTO Country ([Name]) VALUES ('萨摩亚')
INSERT INTO Country ([Name]) VALUES ('塞尔维亚,黑山N')
INSERT INTO Country ([Name]) VALUES ('塞拉利昂')
INSERT INTO Country ([Name]) VALUES ('塞内加尔')
INSERT INTO Country ([Name]) VALUES ('塞浦路斯')
INSERT INTO Country ([Name]) VALUES ('塞舌尔')
INSERT INTO Country ([Name]) VALUES ('沙特阿拉伯')
INSERT INTO Country ([Name]) VALUES ('圣诞岛')
INSERT INTO Country ([Name]) VALUES ('圣多美和普林西比')
INSERT INTO Country ([Name]) VALUES ('圣赫勒拿')
INSERT INTO Country ([Name]) VALUES ('圣基茨和尼维斯')
INSERT INTO Country ([Name]) VALUES ('圣卢西亚')
INSERT INTO Country ([Name]) VALUES ('圣马力诺')
INSERT INTO Country ([Name]) VALUES ('圣皮埃尔和米克隆群岛')
INSERT INTO Country ([Name]) VALUES ('圣文森特和格林纳丁斯')
INSERT INTO Country ([Name]) VALUES ('斯里兰卡')
INSERT INTO Country ([Name]) VALUES ('斯洛伐克')
INSERT INTO Country ([Name]) VALUES ('斯洛文尼亚')
INSERT INTO Country ([Name]) VALUES ('斯瓦尔巴和扬马廷')
INSERT INTO Country ([Name]) VALUES ('斯威士兰')
INSERT INTO Country ([Name]) VALUES ('苏丹')
INSERT INTO Country ([Name]) VALUES ('苏里南')
INSERT INTO Country ([Name]) VALUES ('所罗门群岛')
INSERT INTO Country ([Name]) VALUES ('索马里')
INSERT INTO Country ([Name]) VALUES ('塔吉克斯坦')
INSERT INTO Country ([Name]) VALUES ('泰国')
INSERT INTO Country ([Name]) VALUES ('坦桑尼亚')
INSERT INTO Country ([Name]) VALUES ('汤加')
INSERT INTO Country ([Name]) VALUES ('特克斯和凯克特斯群岛')
INSERT INTO Country ([Name]) VALUES ('特里斯坦达昆哈')
INSERT INTO Country ([Name]) VALUES ('特立尼达和多巴哥')
INSERT INTO Country ([Name]) VALUES ('突尼斯')
INSERT INTO Country ([Name]) VALUES ('图瓦卢')
INSERT INTO Country ([Name]) VALUES ('土耳其')
INSERT INTO Country ([Name]) VALUES ('土库曼斯坦')
INSERT INTO Country ([Name]) VALUES ('托克劳')
INSERT INTO Country ([Name]) VALUES ('瓦利斯和福图纳')
INSERT INTO Country ([Name]) VALUES ('瓦努阿图')
INSERT INTO Country ([Name]) VALUES ('危地马拉')
INSERT INTO Country ([Name]) VALUES ('维尔京群岛，美属')
INSERT INTO Country ([Name]) VALUES ('维尔京群岛，英属')
INSERT INTO Country ([Name]) VALUES ('委内瑞拉')
INSERT INTO Country ([Name]) VALUES ('文莱')
INSERT INTO Country ([Name]) VALUES ('乌干达')
INSERT INTO Country ([Name]) VALUES ('乌克兰')
INSERT INTO Country ([Name]) VALUES ('乌拉圭')
INSERT INTO Country ([Name]) VALUES ('乌兹别克斯坦')
INSERT INTO Country ([Name]) VALUES ('西班牙')
INSERT INTO Country ([Name]) VALUES ('希腊')
INSERT INTO Country ([Name]) VALUES ('新加坡')
INSERT INTO Country ([Name]) VALUES ('新喀里多尼亚')
INSERT INTO Country ([Name]) VALUES ('新西兰')
INSERT INTO Country ([Name]) VALUES ('匈牙利')
INSERT INTO Country ([Name]) VALUES ('叙利亚')
INSERT INTO Country ([Name]) VALUES ('牙买加')
INSERT INTO Country ([Name]) VALUES ('亚美尼亚')
INSERT INTO Country ([Name]) VALUES ('也门')
INSERT INTO Country ([Name]) VALUES ('伊拉克')
INSERT INTO Country ([Name]) VALUES ('伊朗')
INSERT INTO Country ([Name]) VALUES ('以色列')
INSERT INTO Country ([Name]) VALUES ('意大利')
INSERT INTO Country ([Name]) VALUES ('印度')
INSERT INTO Country ([Name]) VALUES ('印度尼西亚')
INSERT INTO Country ([Name]) VALUES ('英国')
INSERT INTO Country ([Name]) VALUES ('英属印度洋领地')
INSERT INTO Country ([Name]) VALUES ('约旦')
INSERT INTO Country ([Name]) VALUES ('越南')
INSERT INTO Country ([Name]) VALUES ('赞比亚')
INSERT INTO Country ([Name]) VALUES ('泽西岛')
INSERT INTO Country ([Name]) VALUES ('乍得')
INSERT INTO Country ([Name]) VALUES ('直布罗陀')
INSERT INTO Country ([Name]) VALUES ('智利')
INSERT INTO Country ([Name]) VALUES ('中非共和国')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'北京市', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'天津市', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'上海市', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'重庆市', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'河北省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'山西省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'台湾省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'辽宁省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'吉林省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'黑龙江省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'江苏省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'浙江省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'安徽省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'福建省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'江西省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'山东省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'河南省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'湖北省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'湖南省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'广东省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'甘肃省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'四川省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'贵州省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'海南省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'云南省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'青海省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'陕西省', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'广西壮族自治区', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'西藏自治区', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'宁夏回族自治区', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'新疆维吾尔自治区', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'内蒙古自治区', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'澳门特别行政区', '1')
INSERT INTO Province ([Name],[CountryId]) VALUES (N'香港特别行政区', '1')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'北京市', '1')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'天津市', '2')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'上海市', '3')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'重庆市', '4')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'石家庄市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'唐山市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'秦皇岛市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'邯郸市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'邢台市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'保定市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'张家口市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'承德市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'沧州市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'廊坊市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'衡水市', '5')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'太原市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'大同市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阳泉市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'长治市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'晋城市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'朔州市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'晋中市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'运城市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'忻州市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'临汾市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'吕梁市', '6')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台北市', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'高雄市', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'基隆市', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台中市', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台南市', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'新竹市', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'嘉义市', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台北县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宜兰县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'桃园县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'新竹县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'苗栗县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台中县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'彰化县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南投县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'云林县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'嘉义县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台南县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'高雄县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'屏东县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'澎湖县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台东县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'花莲县', '7')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'沈阳市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'大连市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'鞍山市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'抚顺市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'本溪市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'丹东市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'锦州市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'营口市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阜新市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'辽阳市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'盘锦市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'铁岭市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'朝阳市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'葫芦岛市', '8')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'长春市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'吉林市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'四平市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'辽源市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'通化市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'白山市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'松原市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'白城市', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'延边朝鲜族自治州', '9')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'哈尔滨市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'齐齐哈尔市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'鹤岗市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'双鸭山市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'鸡西市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'大庆市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'伊春市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'牡丹江市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'佳木斯市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'七台河市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黑河市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'绥化市', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'大兴安岭地区', '10')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南京市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'无锡市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'徐州市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'常州市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'苏州市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南通市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'连云港市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'淮安市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'盐城市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'扬州市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'镇江市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'泰州市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宿迁市', '11')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'杭州市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宁波市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'温州市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'嘉兴市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'湖州市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'绍兴市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'金华市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'衢州市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'舟山市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'台州市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'丽水市', '12')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'合肥市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'芜湖市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'蚌埠市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'淮南市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'马鞍山市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'淮北市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'铜陵市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'安庆市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黄山市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'滁州市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阜阳市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宿州市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'巢湖市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'六安市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'亳州市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'池州市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宣城市', '13')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'福州市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'厦门市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'莆田市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'三明市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'泉州市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'漳州市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南平市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'龙岩市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宁德市', '14')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南昌市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'景德镇市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'萍乡市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'九江市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'新余市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'鹰潭市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'赣州市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'吉安市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宜春市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'抚州市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'上饶市', '15')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'济南市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'青岛市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'淄博市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'枣庄市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'东营市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'烟台市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'潍坊市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'济宁市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'泰安市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'威海市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'日照市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'莱芜市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'临沂市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'德州市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'聊城市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'滨州市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'菏泽市', '16')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'郑州市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'开封市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'洛阳市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'平顶山市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'安阳市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'鹤壁市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'新乡市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'焦作市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'濮阳市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'许昌市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'漯河市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'三门峡市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南阳市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'商丘市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'信阳市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'周口市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'驻马店市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'济源市', '17')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'武汉市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黄石市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'十堰市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'荆州市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宜昌市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'襄樊市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'鄂州市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'荆门市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'孝感市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黄冈市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'咸宁市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'随州市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'仙桃市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'天门市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'潜江市', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'神农架林区', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'恩施土家族苗族自治州', '18')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'长沙市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'株洲市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'湘潭市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'衡阳市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'邵阳市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'岳阳市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'常德市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'张家界市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'益阳市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'郴州市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'永州市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'怀化市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'娄底市', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'湘西土家族苗族自治州', '19')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'广州市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'深圳市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'珠海市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'汕头市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'韶关市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'佛山市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'江门市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'湛江市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'茂名市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'肇庆市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'惠州市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'梅州市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'汕尾市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'河源市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阳江市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'清远市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'东莞市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'中山市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'潮州市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'揭阳市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'云浮市', '20')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'兰州市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'金昌市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'白银市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'天水市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'嘉峪关市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'武威市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'张掖市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'平凉市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'酒泉市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'庆阳市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'定西市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'陇南市', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'临夏回族自治州', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'甘南藏族自治州', '21')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'成都市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'自贡市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'攀枝花市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'泸州市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'德阳市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'绵阳市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'广元市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'遂宁市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'内江市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'乐山市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南充市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'眉山市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宜宾市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'广安市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'达州市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'雅安市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'巴中市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'资阳市', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阿坝藏族羌族自治州', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'甘孜藏族自治州', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'凉山彝族自治州', '22')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'贵阳市', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'六盘水市', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'遵义市', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'安顺市', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'铜仁地区', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'毕节地区', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黔西南布依族苗族自治州', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黔东南苗族侗族自治州', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黔南布依族苗族自治州', '23')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'海口市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'三亚市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'五指山市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'琼海市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'儋州市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'文昌市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'万宁市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'东方市', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'澄迈县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'定安县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'屯昌县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'临高县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'白沙黎族自治县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'昌江黎族自治县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'乐东黎族自治县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'陵水黎族自治县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'保亭黎族苗族自治县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'琼中黎族苗族自治县', '24')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'昆明市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'曲靖市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'玉溪市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'保山市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'昭通市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'丽江市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'思茅市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'临沧市', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'文山壮族苗族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'红河哈尼族彝族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'西双版纳傣族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'楚雄彝族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'大理白族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'德宏傣族景颇族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'怒江傈傈族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'迪庆藏族自治州', '25')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'西宁市', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'海东地区', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'海北藏族自治州', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'黄南藏族自治州', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'海南藏族自治州', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'果洛藏族自治州', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'玉树藏族自治州', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'海西蒙古族藏族自治州', '26')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'西安市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'铜川市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'宝鸡市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'咸阳市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'渭南市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'延安市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'汉中市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'榆林市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'安康市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'商洛市', '27')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'南宁市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'柳州市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'桂林市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'梧州市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'北海市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'防城港市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'钦州市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'贵港市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'玉林市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'百色市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'贺州市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'河池市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'来宾市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'崇左市', '28')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'拉萨市', '29')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'那曲地区', '29')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'昌都地区', '29')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'山南地区', '29')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'日喀则地区', '29')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阿里地区', '29')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'林芝地区', '29')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'银川市', '30')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'石嘴山市', '30')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'吴忠市', '30')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'固原市', '30')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'中卫市', '30')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'乌鲁木齐市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'克拉玛依市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'石河子市 ', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阿拉尔市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'图木舒克市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'五家渠市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'吐鲁番市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阿克苏市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'喀什市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'哈密市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'和田市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阿图什市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'库尔勒市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'昌吉市 ', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阜康市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'米泉市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'博乐市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'伊宁市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'奎屯市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'塔城市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'乌苏市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阿勒泰市', '31')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'呼和浩特市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'包头市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'乌海市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'赤峰市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'通辽市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'鄂尔多斯市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'呼伦贝尔市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'巴彦淖尔市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'乌兰察布市', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'锡林郭勒盟', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'兴安盟', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'阿拉善盟', '32')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'澳门特别行政区', '33')
INSERT INTO City ([Name],[ProvinceId]) VALUES (N'香港特别行政区', '34')
");
}
