public override Object Net2DbmsGeo(GXType type, IGeographicNative geo)
{
Geospatial geos = geo as Geospatial;
if (geos != null)
{
return(geos.ToStringESQL());
}
else
{
return(geo.ToStringSQL());
}
}
private object GXTypeToIfxType(GXType type)
{
switch (type)
{
case GXType.Number: return(ClassLoader.GetEnumValue(IfxAssembly, InformixDbTypeEnum, "Decimal"));
case GXType.Int16: return(ClassLoader.GetEnumValue(IfxAssembly, InformixDbTypeEnum, "SmallInt"));
case GXType.Int32: return(ClassLoader.GetEnumValue(IfxAssembly, InformixDbTypeEnum, "Integer"));
case GXType.Int64: return(ClassLoader.GetEnumValue(IfxAssembly, InformixDbTypeEnum, "Int8"));
case GXType.LongVarChar: return(ClassLoader.GetEnumValue(IfxAssembly, InformixDbTypeEnum, "Text"));
default: return(ClassLoader.GetEnumValue(IfxAssembly, InformixDbTypeEnum, type.ToString()));
}
}
public static DbType GXTypeToDbType(GXType type)
{
switch (type)
{
case GXType.Number: return(DbType.Int32);
case GXType.Int16: return(DbType.Int16);
case GXType.Int32: return(DbType.Int32);
case GXType.Int64: return(DbType.Int64);
case GXType.Date: return(DbType.Date);
case GXType.DateTime: return(DbType.DateTime);
case GXType.DateTime2: return(DbType.DateTime2);
case GXType.Byte: return(DbType.Byte);
case GXType.NChar:
case GXType.NClob:
case GXType.NVarChar:
case GXType.Char:
case GXType.LongVarChar: return(DbType.String);
case GXType.Clob: return(DbType.Binary);
case GXType.VarChar: return(DbType.String);
case GXType.Raw:
return(DbType.Object);
case GXType.Blob:
return(DbType.Binary);
case GXType.Undefined:
default:
return(DbType.Object);
}
}
public override Object Net2DbmsGeo(GXType type, IGeographicNative geo)
{
string defaultValue;
switch (type)
{
case GXType.Geopoint:
defaultValue = Geospatial.ALT_EMPTY_POINT;
break;
case GXType.Geography:
defaultValue = Geospatial.EMPTY_GEOMETRY;
break;
case GXType.Geoline:
defaultValue = Geospatial.ALT_EMPTY_LINE;
break;
case GXType.Geopolygon:
defaultValue = Geospatial.ALT_EMPTY_POLY;
break;
case GXType.Undefined:
defaultValue = string.Empty;
break;
default:
defaultValue = Geospatial.EMPTY_GEOMETRY;
break;
}
if (!string.IsNullOrEmpty(defaultValue))
{
return(geo.ToStringSQL(defaultValue));
}
else
{
return(geo.ToStringSQL());
}
}
public VarValue(string name, GXType type, object value)
{
Name = name;
Value = value;
}
public override Object Net2DbmsGeo(GXType type, IGeographicNative geo)
{
return(geo.InnerValue);
}
