public string GetRegionName(CasUserEntity userEntity)
{
DataAccessBroker broker = DataAccessFactory.Instance();
string sql = "SELECT CAS_REGION.REGION_NAME FROM CAS_CITY INNER JOIN CAS_REGION ON CAS_CITY.REGION_ID = CAS_REGION.REGION_ID WHERE CAS_CITY.CITY_CODE = '" + userEntity.CityCode + "'";
object result = broker.ExecuteSQLScalar(sql);
return(result == null ? "" : result.ToString());
}
public string GetCityName(CasUserEntity userEntity)
{
DataAccessBroker broker = DataAccessFactory.Instance();
string sql = "SELECT CITY_NAME FROM CAS_CITY WHERE CITY_CODE = '" + userEntity.CityCode + "'";
object result = broker.ExecuteSQLScalar(sql);
return(result == null ? "" : result.ToString());
}