public static string GetSXCode(TkDbContext context, double latitude, double longitude)
{
TkDebug.AssertArgumentNull(context, "context", null);
var result = MapUtil.GetAddress(latitude, longitude);
if (result.Status == 0 && !string.IsNullOrEmpty(result.Result.CityCode))
{
IParamBuilder builder = SqlParamBuilder.CreateEqualSql(context, "CODE_VALUE",
TkDataType.Int, result.Result.CityCode);
object value = DbUtil.ExecuteScalar("SELECT CODE_GB FROM CD_BAIDU_CITY", context, builder);
if (value == DBNull.Value)
{
return("000000");
}
return(value.ToString());
}
return("000000");
}
