/// <summary>
/// get shengfens
/// </summary>
/// <param name="guoJiaId">guojiaid</param>
/// <returns></returns>
IList <MSysProvince> GetShengFens(int guoJiaId)
{
IList <MSysProvince> items = new List <MSysProvince>();
DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetShengFens);
_db.AddInParameter(cmd, "GuoJiaId", DbType.AnsiStringFixedLength, guoJiaId);
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
while (rdr.Read())
{
var item = new MSysProvince();
item.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
item.Name = rdr["Name"].ToString();
items.Add(item);
}
}
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
item.Citys = GetChengShis(item.ProvinceId);
}
}
return(items);
}
///// <summary>
///// 获得国家,省份,城市,县区名称
///// </summary>
///// <param name="id">编号</param>
///// <param name="companyId">公司编号</param>
///// <param name="type">类型</param>
///// <returns>国家,省份,城市,县区名称Model</returns>
//public Model.ComStructure.MCPCC GetName(int id, string companyId, Model.EnumType.ComStructure.SelectNameType type)
//{
// Model.ComStructure.MCPCC model = new Model.ComStructure.MCPCC();
// IList<Model.SysStructure.MSysCountry> list=GetAllCity(companyId);
// if (list == null||id==0||string.IsNullOrEmpty(companyId))
// return model;
// int countryId = 0;
// int provinceId = 0;
// int cityId = 0;
// switch (type)
// {
// case Model.EnumType.ComStructure.SelectNameType.国家:
// model.CountryName=list.SingleOrDefault(item1 => item1.CountryId == id).Name;
// break;
// case Model.EnumType.ComStructure.SelectNameType.省份:
// countryId = list.SingleOrDefault(item1 => item1.Provinces.SingleOrDefault(item2 => item2.ProvinceId == id) != null).CountryId;
// model.CountryName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Name;
// model.ProvinceName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.ProvinceId == id).Name;
// break;
// case Model.EnumType.ComStructure.SelectNameType.城市:
// countryId = list.SingleOrDefault(item1 => item1.Provinces.SingleOrDefault(item2 => item2.Citys.SingleOrDefault(item3 => item3.CityId == id) != null) != null).CountryId;
// model.CountryName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Name;
// provinceId = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.Citys.SingleOrDefault(item3 => item3.CityId == id) != null).ProvinceId;
// model.ProvinceName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.Citys.SingleOrDefault(item3 => item3.CityId == id) != null).Name;
// model.CityName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.Citys.SingleOrDefault(item3 => item3.CityId == id) != null).Name;
// break;
// case Model.EnumType.ComStructure.SelectNameType.县区:
// countryId = list.SingleOrDefault(item1 => item1.Provinces.SingleOrDefault(item2 => item2.Citys.SingleOrDefault(item3 => item3.Districts.SingleOrDefault(item4 => item4.DistrictId == id) != null) != null) != null).CountryId;
// model.CountryName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Name;
// provinceId = list.SingleOrDefault(item1=>item1.CountryId==countryId).Provinces.SingleOrDefault(item2 => item2.Citys.SingleOrDefault(item3 => item3.Districts.SingleOrDefault(item4 => item4.DistrictId == id) != null) != null).ProvinceId;
// model.ProvinceName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.Citys.SingleOrDefault(item3 => item3.Districts.SingleOrDefault(item4 => item4.DistrictId == id) != null) != null).Name;
// cityId = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.ProvinceId == provinceId).Citys.SingleOrDefault(item3 => item3.Districts.SingleOrDefault(item4 => item4.DistrictId == id) != null).CityId;
// model.CityName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.ProvinceId == provinceId).Citys.SingleOrDefault(item3 => item3.Districts.SingleOrDefault(item4 => item4.DistrictId == id) != null).Name;
// model.CountyName = list.SingleOrDefault(item1 => item1.CountryId == countryId).Provinces.SingleOrDefault(item2 => item2.ProvinceId == provinceId).Citys.SingleOrDefault(item3=>item3.CityId==cityId).Districts.SingleOrDefault(item4=>item4.DistrictId==id).Name;
// break;
// }
// return model;
//}
/// <summary>
/// 获取国家省份城市县区名称
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="countryId">国家编号</param>
/// <param name="provinceId">省份编号</param>
/// <param name="cityId">城市编号</param>
/// <param name="districtId">县区编号</param>
/// <returns></returns>
public EyouSoft.Model.ComStructure.MCPCC GetCPCD(string companyId, int countryId, int provinceId, int cityId, int districtId)
{
var info = new Model.ComStructure.MCPCC();
if (string.IsNullOrEmpty(companyId))
{
return(info);
}
if (countryId <= 0 && provinceId <= 0 && cityId <= 0 && districtId <= 0)
{
return(info);
}
IList <Model.SysStructure.MSysCountry> items = GetAllCity(companyId);
if (items == null || items.Count == 0)
{
return(info);
}
MSysCountry countryinfo = null;
MSysProvince provinceinfo = null;
MSysCity cityinfo = null;
MSysDistrict districtinfo = null;
if (countryId > 0)
{
foreach (var item in items)
{
if (item.CountryId == countryId)
{
countryinfo = item;
break;
}
}
if (countryinfo == null)
{
return(info);
}
info.CountryName = countryinfo.Name;
}
if (provinceId > 0)
{
if (countryinfo != null && countryinfo.Provinces != null && countryinfo.Provinces.Count > 0)
{
foreach (var item in countryinfo.Provinces)
{
if (item.ProvinceId == provinceId)
{
provinceinfo = item;
break;
}
}
}
else
{
foreach (var item1 in items)
{
foreach (var item2 in item1.Provinces)
{
if (item2.ProvinceId == provinceId)
{
provinceinfo = item2; break;
}
}
if (provinceinfo != null)
{
countryinfo = item1; break;
}
}
}
if (provinceinfo == null)
{
return(info);
}
info.CountryName = countryinfo.Name;
info.ProvinceName = provinceinfo.Name;
}
if (cityId > 0)
{
if (provinceinfo != null && provinceinfo.Citys != null && provinceinfo.Citys.Count > 0)
{
foreach (var item in provinceinfo.Citys)
{
if (item.CityId == cityId)
{
cityinfo = item; break;
}
}
}
else
{
foreach (var item1 in items)
{
foreach (var item2 in item1.Provinces)
{
foreach (var item3 in item2.Citys)
{
if (item3.CityId == cityId)
{
cityinfo = item3; break;
}
}
if (cityinfo != null)
{
provinceinfo = item2; break;
}
}
if (provinceinfo != null)
{
countryinfo = item1; break;
}
}
}
if (cityinfo == null)
{
return(info);
}
info.CountryName = countryinfo.Name;
info.ProvinceName = provinceinfo.Name;
info.CityName = cityinfo.Name;
}
if (districtId > 0)
{
if (cityinfo != null && cityinfo.Districts != null && cityinfo.Districts.Count > 0)
{
foreach (var item in cityinfo.Districts)
{
if (item.DistrictId == districtId)
{
districtinfo = item; break;
}
}
}
else
{
foreach (var item1 in items)
{
foreach (var item2 in item1.Provinces)
{
foreach (var item3 in item2.Citys)
{
foreach (var item4 in item3.Districts)
{
if (item4.DistrictId == districtId)
{
districtinfo = item4; break;
}
}
if (districtinfo != null)
{
cityinfo = item3; break;
}
}
if (cityinfo != null)
{
provinceinfo = item2; break;
}
}
if (provinceinfo != null)
{
countryinfo = item1; break;
}
}
}
if (districtinfo == null)
{
return(info);
}
info.CountryName = countryinfo.Name;
info.ProvinceName = provinceinfo.Name;
info.CityName = cityinfo.Name;
info.CountyName = districtinfo.Name;
}
return(info);
}
