/// <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());
}
public bool Modify(iPow.Infrastructure.Data.DataSys.Sys_CityInfo entity, iPow.Infrastructure.Data.DataSys.Sys_AdminUser operUser)
{
var res = false;
if (entity != null && entity.id > 0)
{
try
{
cityInfoRepository.Modify(entity);
res = true;
}
catch (Exception ex)
{
}
}
return(res);
}
public bool DeleteTrue(iPow.Infrastructure.Data.DataSys.Sys_CityInfo entity, iPow.Infrastructure.Data.DataSys.Sys_AdminUser operUser)
{
var res = false;
if (entity != null)
{
try
{
cityInfoRepository.Delete(entity);
cityInfoRepository.Uow.Commit();
res = true;
}
catch (Exception ex)
{
}
}
return(res);
}
public bool Delete(iPow.Infrastructure.Data.DataSys.Sys_CityInfo entity, iPow.Infrastructure.Data.DataSys.Sys_AdminUser operUser)
{
throw new NotImplementedException();
}
