/// <summary> /// Gets the city info. /// 从数据库中选一个省或城市 /// </summary> /// <param name="province">The province.</param> /// <param name="city">The city.</param> /// <returns></returns> public iPow.Domain.Dto.Sys_CityInfoDto GetCityByName(string province, string city) { iPow.Infrastructure.Data.DataSys.Sys_CityInfo ci = null; List <iPow.Infrastructure.Data.DataSys.Sys_CityInfo> tempCityInfo = null; if (!string.IsNullOrEmpty(province) && string.IsNullOrEmpty(city)) { tempCityInfo = (from e in cityInfoRepository.GetList() where e.ProvincePy == province orderby e.id select e).Distinct().ToList(); } else if (string.IsNullOrEmpty(province) && !string.IsNullOrEmpty(city)) { tempCityInfo = (from e in cityInfoRepository.GetList() where e.pinyin == city orderby e.id select e).Distinct().ToList(); } else { tempCityInfo = (from e in cityInfoRepository.GetList() where e.ProvincePy == province && e.pinyin == city orderby e.id select e).Distinct().ToList(); } if (tempCityInfo != null && tempCityInfo.Count > 0) { ci = tempCityInfo[0]; } return(ci.ToDto()); }
//根据城市拼音查取中文 public iPow.Domain.Dto.Sys_CityInfoDto GetCityByPinYin(string city) { iPow.Infrastructure.Data.DataSys.Sys_CityInfo ci = null; List <iPow.Infrastructure.Data.DataSys.Sys_CityInfo> tempCityInfo = null; tempCityInfo = (from e in cityInfoRepository.GetList() where e.pinyin == city orderby e.id select e).Distinct().ToList(); if (tempCityInfo != null && tempCityInfo.Count > 0) { ci = tempCityInfo[0]; } return(ci.ToDto()); }