public DbField(string fieldName, GFXDType fieldType, int length, bool isNullable)
{
FieldName = fieldName;
FieldType = fieldType;
Length = length;
IsNullable = isNullable;
}
public static String GetJdbcTypeFromGFXDType(GFXDType esqlType, int length)
{
String jdbcType = GFXDToJdbcMap[esqlType];
String subType = jdbcType.Split(new char[] { ' ' })[0].ToUpper();
if (length > 0)
{
if (subType == "DECIMAL")
{
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0},2)", length + 2));
}
else if (subType == "VARCHAR" || subType == "CHAR")
{
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0})", length));
}
}
else if (length <= 0)
{
if (subType == "DECIMAL")
{
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0},2)", 9));
}
else if (subType == "VARCHAR")
{
jdbcType = jdbcType.Insert(0, String.Format("LONG ", length));
}
else if (subType == "CHAR")
{
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0}) ", 32));
}
}
return(jdbcType);
}
public DbField(string fieldName, GFXDType fieldType, int length, bool isNullable)
{
FieldName = fieldName;
FieldType = fieldType;
Length = length;
IsNullable = isNullable;
}
public static String GetGFXDType(GFXDType type, int length)
{
String sqlType = typeMaps[type];
if(length > 0)
{
if (sqlType.StartsWith("VARCHAR"))
sqlType = sqlType.Insert("VARCHAR".Length, String.Format("({0})", length));
else if (sqlType.StartsWith("CHAR"))
sqlType = sqlType.Insert("CHAR".Length, String.Format("({0})", length));
else if (sqlType.StartsWith("DECIMAL"))
sqlType = sqlType.Insert("DECIMAL".Length, String.Format("({0},2)", length + 2));
}
return sqlType;
}
public static String GetGFXDType(GFXDType type, int length)
{
String sqlType = typeMaps[type];
if (length > 0)
{
if (sqlType.StartsWith("VARCHAR"))
{
sqlType = sqlType.Insert("VARCHAR".Length, String.Format("({0})", length));
}
else if (sqlType.StartsWith("CHAR"))
{
sqlType = sqlType.Insert("CHAR".Length, String.Format("({0})", length));
}
else if (sqlType.StartsWith("DECIMAL"))
{
sqlType = sqlType.Insert("DECIMAL".Length, String.Format("({0},2)", length + 2));
}
}
return(sqlType);
}
public DbField(string fieldName, GFXDType fieldType, bool isNullable)
: this(fieldName, fieldType, 0, isNullable)
{
}
public DbField(string fieldName, GFXDType fieldType, int length)
{
FieldName = fieldName;
FieldType = fieldType;
Length = length;
}
public DbField(string fieldName, GFXDType fieldType)
: this(fieldName, fieldType, 0)
{
}
public DbField(string fieldName, GFXDType fieldType, int length)
{
FieldName = fieldName;
FieldType = fieldType;
Length = length;
}
public DbField(string fieldName, GFXDType fieldType)
: this(fieldName, fieldType, 0)
{
}
private static object FormatFieldData(GFXDType type, object data)
{
if (data.GetType() == typeof(DBNull))
{
return(DBNull.Value);
}
switch (type)
{
case GFXDType.Binary:
case GFXDType.Blob:
case GFXDType.VarBinary:
case GFXDType.LongVarBinary:
return(ConvertToBytes(data.ToString()));
case GFXDType.Clob:
case GFXDType.Char:
case GFXDType.LongVarChar:
case GFXDType.VarChar:
return(data.ToString());
case GFXDType.Date:
return(DateTime.Parse(data.ToString()).ToShortDateString());
case GFXDType.Time:
return(DateTime.Parse(data.ToString()).ToShortTimeString());
case GFXDType.TimeStamp:
return(DateTime.Parse(data.ToString()));
case GFXDType.Decimal:
return(Convert.ToDecimal(data));
case GFXDType.Double:
case GFXDType.Float:
return(Convert.ToDouble(data));
case GFXDType.Short:
return(Convert.ToInt16(data));
case GFXDType.Integer:
return(Convert.ToInt32(data));
case GFXDType.Long:
return(Convert.ToInt64(data));
case GFXDType.Numeric:
return(Convert.ToInt64(data));
case GFXDType.Real:
return(Convert.ToDecimal(data));
case GFXDType.Boolean:
return(Convert.ToBoolean(data));
case GFXDType.Null:
return(Convert.DBNull);
case GFXDType.JavaObject:
case GFXDType.Other:
default:
return(new object());
}
}
public static String GetJdbcTypeFromGFXDType(GFXDType esqlType, int length)
{
String jdbcType = GFXDToJdbcMap[esqlType];
String subType = jdbcType.Split(new char[] { ' ' })[0].ToUpper();
if (length > 0)
{
if (subType == "DECIMAL")
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0},2)", length + 2));
else if (subType == "VARCHAR" || subType == "CHAR")
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0})", length));
}
else if (length <= 0)
{
if (subType == "DECIMAL")
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0},2)", 9));
else if (subType == "VARCHAR")
jdbcType = jdbcType.Insert(0, String.Format("LONG ", length));
else if (subType == "CHAR")
jdbcType = jdbcType.Insert(subType.Length, String.Format("({0}) ", 32));
}
return jdbcType;
}
private static object FormatFieldData(GFXDType type, object data)
{
if (data.GetType() == typeof(DBNull))
return DBNull.Value;
switch (type)
{
case GFXDType.Binary:
case GFXDType.Blob:
case GFXDType.VarBinary:
case GFXDType.LongVarBinary:
return ConvertToBytes(data.ToString());
case GFXDType.Clob:
case GFXDType.Char:
case GFXDType.LongVarChar:
case GFXDType.VarChar:
return data.ToString();
case GFXDType.Date:
return DateTime.Parse(data.ToString()).ToShortDateString();
case GFXDType.Time:
return DateTime.Parse(data.ToString()).ToShortTimeString();
case GFXDType.TimeStamp:
return DateTime.Parse(data.ToString());
case GFXDType.Decimal:
return Convert.ToDecimal(data);
case GFXDType.Double:
case GFXDType.Float:
return Convert.ToDouble(data);
case GFXDType.Short:
return Convert.ToInt16(data);
case GFXDType.Integer:
return Convert.ToInt32(data);
case GFXDType.Long:
return Convert.ToInt64(data);
case GFXDType.Numeric:
return Convert.ToInt64(data);
case GFXDType.Real:
return Convert.ToDecimal(data);
case GFXDType.Boolean:
return Convert.ToBoolean(data);
case GFXDType.Null:
return Convert.DBNull;
case GFXDType.JavaObject:
case GFXDType.Other:
default:
return new object();
}
}
public DbField(string fieldName, GFXDType fieldType, bool isNullable)
: this(fieldName, fieldType, 0, isNullable)
{
}
