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