/// <summary> /// update unique for region /// </summary> public static void UpdateUniqueForRegion() { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var provinces = _context.provinces.ToList(); var citys = _context.citys.ToList(); var regions = _context.regions.ToList(); foreach (var province in provinces) { var provinceId = province.Id; var provinceIdStr = GetFullNumStr(provinceId); var currentCitys = citys.Where(l => l.ProvinceId == provinceId).OrderBy(l => l.Id).ToList(); foreach (var currentCity in currentCitys) { var cityUnique = currentCity.Unique; var cityIdStr = cityUnique.Substring(2, 2); var currentRegions = regions.Where(l => l.CityId == currentCity.Id).OrderBy(l => l.Id); int index = 0; foreach (var currentRegion in currentRegions) { Console.WriteLine(currentRegion.Name); index++; var regionIndexStr = GetFullNumStr(index); var regionUnique = provinceIdStr + cityIdStr + regionIndexStr; currentRegion.Unique = regionUnique; } } } _context.SaveChanges(); } }
public bool AddRegion(string regionName, string cityUnique, string provinceUnique) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var city = _context.citys.FirstOrDefault(l => l.Unique == cityUnique); if (city is null) { return(false); } var province = _context.provinces.FirstOrDefault(l => l.Unique == provinceUnique); if (province is null) { return(false); } var newUnique = GetNewRegionUnique(city); var newRegion = new regions() { CityId = city.Id, Name = regionName, Unique = newUnique }; _context.regions.Add(newRegion); _context.SaveChanges(); return(true); } }
public regions GetRegion(string regionUnique) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var region = _context.regions.ToList().FirstOrDefault(l => l.Unique == regionUnique); return(region); } }
public List <regions> GetRegionsByCityId(int cityId) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var regions = _context.regions.ToList().Where(l => l.CityId == cityId).OrderBy(l => l.Unique).ToList(); return(regions); } }
public provinces GetProvince(string provinceUnique) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var province = _context.provinces.ToList().FirstOrDefault(l => l.Unique == provinceUnique); return(province); } }
public List <provinces> GetProvinces() { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var provinces = _context.provinces.ToList().OrderBy(l => l.Unique).ToList(); return(provinces); } }
public List <citys> GetCitys() { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var citys = _context.citys.ToList().OrderBy(l => l.Unique).ToList(); return(citys); } }
public List <citys> GetCitysById(int id) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var citys = _context.citys.ToList().Where(l => l.ProvinceId == id).OrderBy(l => l.Unique).ToList(); return(citys); } }
public citys GetCitys(string cityUnique) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var city = _context.citys.FirstOrDefault(l => l.Unique == cityUnique); return(city); } }
public List <citys> GetCitysByProvinceUnique(string provinceUnique) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var province = _context.provinces.FirstOrDefault(l => l.Unique == provinceUnique); var citys = _context.citys.ToList().Where(l => l.ProvinceId == province.Id).OrderBy(l => l.Unique).ToList(); return(citys); } }
public List <regions> GetRegionsByCityUnique(string cityUnique) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var city = _context.citys.FirstOrDefault(l => l.Unique == cityUnique); var regions = _context.regions.ToList().Where(l => l.CityId == city.Id).OrderBy(l => l.Unique).ToList(); return(regions); } }
public bool DeleteCity(string unique) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var currentCity = _context.citys.FirstOrDefault(l => l.Unique == unique); if (currentCity is null) { return(false); } _context.citys.Remove(currentCity); _context.SaveChanges(); return(true); } }
public bool UpdateCityName(citys city) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var currentCity = _context.citys.FirstOrDefault(l => l.Unique == city.Unique); if (currentCity is null) { return(false); } currentCity.Name = city.Name; _context.SaveChanges(); return(true); } }
public bool UpdateProvinceName(provinces province) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var currentProvince = _context.provinces.FirstOrDefault(l => l.Unique == province.Unique); if (currentProvince is null) { return(false); } currentProvince.Name = province.Name; _context.SaveChanges(); return(true); } }
public bool UpdateRegionName(regions region) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var currentRegion = _context.regions.FirstOrDefault(l => l.Unique == region.Unique); if (currentRegion is null) { return(false); } currentRegion.Name = region.Name; _context.SaveChanges(); return(true); } }
/// <summary> /// update unique for province /// </summary> public static void UpdateUniqueForProvinces() { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var provinces = _context.provinces.ToList(); foreach (var province in provinces) { Console.WriteLine(province.Name); var provinceId = province.Id; var idStr = GetFullNumStr(provinceId); var unique = idStr + "0000"; province.Unique = unique; } _context.SaveChanges(); } }
public string GetNewRegionUnique(citys city) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var cityCodeSrt = city.Unique.Substring(0, 4); var newRegionCode = 1; var lastRegion = _context.regions.Where(l => l.CityId == city.Id).OrderByDescending(l => l.Id).FirstOrDefault(); if (lastRegion != null) { newRegionCode = Convert.ToInt32(lastRegion.Unique.Substring(4, 2)) + 1; } var newRegionCodeStr = newRegionCode.ToString(); if (newRegionCodeStr.Length == 1) { newRegionCodeStr = "0" + newRegionCodeStr; } var newUnique = cityCodeSrt + newRegionCodeStr; return(newUnique); } }
public bool AddCity(string provinceUnique, string cityName) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var province = _context.provinces.FirstOrDefault(l => l.Unique == provinceUnique); if (province is null) { return(false); } var cityUnique = GetNewCityUniqueCode(province); var newCity = new citys() { Unique = cityUnique, Name = cityName, ProvinceId = province.Id }; _context.citys.Add(newCity); _context.SaveChanges(); return(true); } }
public bool AddProvince(string provinceName) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var newProvince = new provinces() { Name = provinceName, }; _context.provinces.Add(newProvince); _context.SaveChanges(); var provinceId = newProvince.Id; var provinceCodeStr = provinceId.ToString(); if (provinceCodeStr.Length == 1) { provinceCodeStr = "0" + provinceCodeStr; } var province = _context.provinces.FirstOrDefault(l => l.Id == provinceId); province.Unique = provinceCodeStr + "0000"; _context.SaveChanges(); return(true); } }
public string GetNewCityUniqueCode(provinces province) { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var provinceUnique = province.Unique; var provinceCodeStr = province.Unique.Substring(0, 2); var newCityCode = 1; var lastCity = _context.citys.Where(l => l.ProvinceId == province.Id).OrderByDescending(l => l.Id).FirstOrDefault(); if (lastCity != null) { var lastCityUnique = lastCity.Unique; var cityCodeStr = lastCityUnique.Substring(2, 2); var cityCode = Convert.ToInt32(cityCodeStr); newCityCode = cityCode + 1; } var newUnique = newCityCode.ToString(); if (newUnique.Length == 1) { newUnique = "0" + newUnique; } newUnique = provinceCodeStr + newUnique + "00"; return(newUnique); } }
/// <summary> /// update unique for city /// </summary> public static void UpdateUniqueForCitys() { using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities()) { var provinces = _context.provinces.ToList(); var citys = _context.citys.ToList(); foreach (var province in provinces) { var provinceId = province.Id; var provinceIdStr = GetFullNumStr(provinceId); var currentCitys = citys.Where(c => c.ProvinceId == provinceId).OrderBy(c => c.Id).ToList(); int index = 0; foreach (var currentCity in currentCitys) { Console.WriteLine(currentCity.Name); index++; var cityIndexStr = GetFullNumStr(index); var cityUnique = provinceIdStr + cityIndexStr + "00"; currentCity.Unique = cityUnique; } } _context.SaveChanges(); } }