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