/// <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();
}
}
