// tableFields
public override List <schema_field> table_fields(string table, string nameField = "")
{
List <schema_field> result = new List <schema_field>();
bool alreadyFindAutoNumber = false; int i = 0;
foreach (DataRow row in schemaColumns(table, nameField).Rows)
{
System.Data.OleDb.OleDbType type = (System.Data.OleDb.OleDbType)Enum.Parse(typeof(System.Data.OleDb.OleDbType), row["DATA_TYPE"].ToString());
bool autonumber = false;
if (!alreadyFindAutoNumber)
{
if (type == System.Data.OleDb.OleDbType.BigInt || type == System.Data.OleDb.OleDbType.Integer ||
type == System.Data.OleDb.OleDbType.SmallInt || type == System.Data.OleDb.OleDbType.TinyInt ||
type == System.Data.OleDb.OleDbType.UnsignedBigInt || type == System.Data.OleDb.OleDbType.UnsignedInt ||
type == System.Data.OleDb.OleDbType.UnsignedSmallInt || type == System.Data.OleDb.OleDbType.UnsignedTinyInt)
{
autonumber = isAutoIncrement(table, row["COLUMN_NAME"].ToString());
}
if (autonumber)
{
alreadyFindAutoNumber = true;
}
}
result.Add(new schema_field(_dbType, row["COLUMN_NAME"].ToString(), type.ToString(), row["IS_NULLABLE"].ToString().ToUpper() == "FALSE" ? false : true
, row["CHARACTER_MAXIMUM_LENGTH"] != DBNull.Value ? int.Parse(row["CHARACTER_MAXIMUM_LENGTH"].ToString()) : (int?)null
, row["NUMERIC_PRECISION"] != DBNull.Value ? int.Parse(row["NUMERIC_PRECISION"].ToString()) : (int?)null
, row["NUMERIC_SCALE"] != DBNull.Value ? int.Parse(row["NUMERIC_SCALE"].ToString()) : (int?)null
, row["COLUMN_DEFAULT"] != DBNull.Value ? row["COLUMN_DEFAULT"].ToString() : "", autonumber, false, i++));
}
return(result);
}
[EditorBrowsableAttribute(EditorBrowsableState.Advanced)] // MDAC 69508
public OleDbParameter(string parameterName,
OleDbType dbType, int size,
ParameterDirection direction,
Byte precision, Byte scale,
string sourceColumn, DataRowVersion sourceVersion, bool sourceColumnNullMapping,
object value) : this() // V2.0 everything - round trip all browsable properties + precision/scale
{
ParameterName = parameterName;
OleDbType = dbType;
Size = size;
Direction = direction;
PrecisionInternal = precision;
ScaleInternal = scale;
SourceColumn = sourceColumn;
SourceVersion = sourceVersion;
SourceColumnNullMapping = sourceColumnNullMapping;
Value = value;
}
public OleDbParameter(string parameterName,
OleDbType dbType, int size,
ParameterDirection direction, bool isNullable,
byte precision, byte scale,
string srcColumn, DataRowVersion srcVersion,
object value) : this()
{ // V1.0 everything
ParameterName = parameterName;
OleDbType = dbType;
Size = size;
Direction = direction;
IsNullable = isNullable;
PrecisionInternal = precision;
ScaleInternal = scale;
SourceColumn = srcColumn;
SourceVersion = srcVersion;
Value = value;
}
public System.Data.OleDb.OleDbType GetOleDbType(string strSystemType)
{
System.Data.OleDb.OleDbType dbType = System.Data.OleDb.OleDbType.VarChar;
switch (strSystemType)
{
case "String":
dbType = System.Data.OleDb.OleDbType.VarChar;
break;
case "Int64":
dbType = System.Data.OleDb.OleDbType.Integer;
break;
case "Int32":
dbType = System.Data.OleDb.OleDbType.Integer;
break;
case "DateTime":
dbType = System.Data.OleDb.OleDbType.Date;
break;
case "Double":
dbType = System.Data.OleDb.OleDbType.Double;
break;
case "Boolean":
dbType = System.Data.OleDb.OleDbType.Boolean;
break;
case "Int16":
dbType = System.Data.OleDb.OleDbType.Integer;
break;
case "Decimal":
dbType = System.Data.OleDb.OleDbType.Decimal;
break;
}
return(dbType);
}
public OleDbParameter(String parameterName,
OleDbType dbType,
int size,
ParameterDirection direction,
bool isNullable,
byte precision,
byte scale,
String sourceColumn,
DataRowVersion sourceVersion,
Object value)
{
ParameterName = parameterName;
OleDbType = dbType;
Size = size;
Direction = direction;
IsNullable = isNullable;
Precision = precision;
Scale = scale;
SourceColumn = sourceColumn;
SourceVersion = sourceVersion;
Value = value;
}
public void ResetOleDbType()
{
oleDbType = GetOleDbType(Value);
dbType = OleDbTypeToDbType(oleDbType);
}
public OleDbParameter(string name, OleDbType dataType, int size) : this()
{
ParameterName = name;
OleDbType = dataType;
Size = size;
}
/// <include file='doc\OleDbParameter.uex' path='docs/doc[@for="OleDbParameter.OleDbParameter1"]/*' />
public OleDbParameter(string name, OleDbType dataType)
{
this.ParameterName = name;
this.OleDbType = dataType;
}
internal static Exception UninitializedParameters(int index, OleDbType dbtype)
{
return(ADP.InvalidOperation(SR.Format(SR.OleDb_UninitializedParameters, index.ToString(CultureInfo.InvariantCulture), dbtype.ToString())));
}
public OleDbParameter(string name, OleDbType dataType, int size)
: this(name, dataType)
{
this.size = size;
}
public OleDbParameter(String parameterName, OleDbType dbType, int size)
: this(parameterName, dbType, size, ParameterDirection.Input,
false, 0, 0, String.Empty, DataRowVersion.Current, null)
{
}
public OleDbParameter Add(string parameterName, OleDbType oleDbType, int size, string sourceColumn)
{
return(Add(new OleDbParameter(parameterName, oleDbType, size, sourceColumn)));
}
/// <summary>
/// 生成 ExOleDbParameter 实例
/// </summary>
/// <param name="paramemterName"></param>
/// <param name="dbType"></param>
public ExOleDbParameter(string paramemterName, System.Data.OleDb.OleDbType dbType)
{
_paramemterName = paramemterName;
_dbType = dbType;
}
internal static NativeDBType FromDataType(OleDbType enumOleDbType) =>
enumOleDbType switch
{
public OleDbParameter Add(string parameterName, OleDbType oleDbType, int size)
{
return(Add(new OleDbParameter(parameterName, oleDbType, size)));
}
public void CommandParameterAdd(string strKey, System.Data.OleDb.OleDbType Type, int Size, string strValue)
{
((System.Data.OleDb.OleDbParameter)comm.Parameters.Add(strKey, Type, Size)).Value = strValue;
}
internal static NativeDBType FromDataType(OleDbType enumOleDbType)
{
switch (enumOleDbType)
{
case OleDbType.Empty:
return(D_Empty);
case OleDbType.SmallInt:
return(D_SmallInt);
case OleDbType.Integer:
return(D_Integer);
case OleDbType.Single:
return(D_Single);
case OleDbType.Double:
return(D_Double);
case OleDbType.Currency:
return(D_Currency);
case OleDbType.Date:
return(D_Date);
case OleDbType.BSTR:
return(D_BSTR);
case OleDbType.IDispatch:
return(D_IDispatch);
case OleDbType.Error:
return(D_Error);
case OleDbType.Boolean:
return(D_Boolean);
case OleDbType.Variant:
return(D_Variant);
case OleDbType.IUnknown:
return(D_IUnknown);
case OleDbType.Decimal:
return(D_Decimal);
case OleDbType.TinyInt:
return(D_TinyInt);
case OleDbType.UnsignedTinyInt:
return(D_UnsignedTinyInt);
case OleDbType.UnsignedSmallInt:
return(D_UnsignedSmallInt);
case OleDbType.UnsignedInt:
return(D_UnsignedInt);
case OleDbType.BigInt:
return(D_BigInt);
case OleDbType.UnsignedBigInt:
return(D_UnsignedBigInt);
case OleDbType.Filetime:
return(D_Filetime);
case OleDbType.Binary:
return(D_Binary);
case OleDbType.Char:
return(D_Char);
case OleDbType.WChar:
return(D_WChar);
case OleDbType.Numeric:
return(D_Numeric);
case OleDbType.DBDate:
return(D_DBDate);
case OleDbType.DBTime:
return(D_DBTime);
case OleDbType.DBTimeStamp:
return(D_DBTimeStamp);
case OleDbType.PropVariant:
return(D_PropVariant);
case OleDbType.VarNumeric:
return(D_VarNumeric);
case OleDbType.Guid:
return(D_Guid);
case OleDbType.VarChar:
return(D_VarChar);
case OleDbType.LongVarChar:
return(D_LongVarChar);
case OleDbType.VarWChar:
return(D_VarWChar);
case OleDbType.LongVarWChar:
return(D_LongVarWChar);
case OleDbType.VarBinary:
return(D_VarBinary);
case OleDbType.LongVarBinary:
return(D_LongVarBinary);
}
throw ODB.InvalidOleDbType(enumOleDbType);
}
/// <include file='doc\OleDbParameter.uex' path='docs/doc[@for="OleDbParameter.OleDbParameter2"]/*' />
public OleDbParameter(string name, OleDbType dataType, int size)
{
this.ParameterName = name;
this.OleDbType = dataType;
this.Size = size;
}
private DbType OleDbTypeToDbType(OleDbType oleDbType)
{
switch (oleDbType)
{
case OleDbType.BigInt:
return(DbType.Int64);
case OleDbType.Binary:
return(DbType.Binary);
case OleDbType.Boolean:
return(DbType.Boolean);
case OleDbType.BSTR:
return(DbType.AnsiString);
case OleDbType.Char:
return(DbType.AnsiStringFixedLength);
case OleDbType.Currency:
return(DbType.Currency);
case OleDbType.Date:
return(DbType.DateTime);
case OleDbType.DBDate:
return(DbType.DateTime);
case OleDbType.DBTime:
throw new NotImplementedException();
case OleDbType.DBTimeStamp:
return(DbType.DateTime);
case OleDbType.Decimal:
return(DbType.Decimal);
case OleDbType.Double:
return(DbType.Double);
case OleDbType.Empty:
throw new NotImplementedException();
case OleDbType.Error:
throw new NotImplementedException();
case OleDbType.Filetime:
return(DbType.DateTime);
case OleDbType.Guid:
return(DbType.Guid);
case OleDbType.IDispatch:
return(DbType.Object);
case OleDbType.Integer:
return(DbType.Int32);
case OleDbType.IUnknown:
return(DbType.Object);
case OleDbType.LongVarBinary:
return(DbType.Binary);
case OleDbType.LongVarChar:
return(DbType.AnsiString);
case OleDbType.LongVarWChar:
return(DbType.String);
case OleDbType.Numeric:
return(DbType.Decimal);
case OleDbType.PropVariant:
return(DbType.Object);
case OleDbType.Single:
return(DbType.Single);
case OleDbType.SmallInt:
return(DbType.Int16);
case OleDbType.TinyInt:
return(DbType.SByte);
case OleDbType.UnsignedBigInt:
return(DbType.UInt64);
case OleDbType.UnsignedInt:
return(DbType.UInt32);
case OleDbType.UnsignedSmallInt:
return(DbType.UInt16);
case OleDbType.UnsignedTinyInt:
return(DbType.Byte);
case OleDbType.VarBinary:
return(DbType.Binary);
case OleDbType.VarChar:
return(DbType.AnsiString);
case OleDbType.Variant:
return(DbType.Object);
case OleDbType.VarNumeric:
return(DbType.VarNumeric);
case OleDbType.VarWChar:
return(DbType.StringFixedLength);
case OleDbType.WChar:
return(DbType.String);
}
return(DbType.Object);
}
public OleDbParameter Add(string parameterName, OleDbType sqlDbType, int size, string sourceColumn)
{
OleDbParameter param = new OleDbParameter(parameterName, sqlDbType, size, sourceColumn);
return(Add(param));
}
public OleDbParameter(string name, OleDbType dataType)
: this()
{
this.name = name;
OleDbType = dataType;
}
public OleDbParameter Add(string parameterName, OleDbType sqlDbType)
{
OleDbParameter param = new OleDbParameter(parameterName, sqlDbType);
return(Add(param));
}
public OleDbParameter(string name, OleDbType dataType, int size, string srcColumn)
: this(name, dataType, size)
{
this.sourceColumn = srcColumn;
}
public OleDbParameter(string?name, OleDbType dataType) : this()
{
ParameterName = name;
OleDbType = dataType;
}
public OleDbParameter(String parameterName, OleDbType dbType, int size,
String sourceColumn)
: this(parameterName, dbType, size, ParameterDirection.Input,
false, 0, 0, sourceColumn, DataRowVersion.Current, null)
{
}
public OleDbParameter Add(string name, OleDbType type)
{
return(Add(new OleDbParameter(name, type)));
}
// OleDbParameter
internal static Exception InvalidOleDbType(OleDbType value)
{
return(ADP.InvalidEnumerationValue(typeof(OleDbType), (int)value));
}
public OleDbParameter Add(string name, OleDbType type, int width, string src_col)
{
return(Add(new OleDbParameter(name, type, width, src_col)));
}
static internal NativeDBType FromDataType(OleDbType enumOleDbType)
{
switch (enumOleDbType)
{ // @perfnote: Enum.IsDefined
case OleDbType.Empty:
return(D_Empty); // 0
case OleDbType.SmallInt:
return(D_SmallInt); // 2
case OleDbType.Integer:
return(D_Integer); // 3
case OleDbType.Single:
return(D_Single); // 4
case OleDbType.Double:
return(D_Double); // 5
case OleDbType.Currency:
return(D_Currency); // 6
case OleDbType.Date:
return(D_Date); // 7
case OleDbType.BSTR:
return(D_BSTR); // 8
case OleDbType.IDispatch:
return(D_IDispatch); // 9
case OleDbType.Error:
return(D_Error); // 10
case OleDbType.Boolean:
return(D_Boolean); // 11
case OleDbType.Variant:
return(D_Variant); // 12
case OleDbType.IUnknown:
return(D_IUnknown); // 13
case OleDbType.Decimal:
return(D_Decimal); // 14
case OleDbType.TinyInt:
return(D_TinyInt); // 16
case OleDbType.UnsignedTinyInt:
return(D_UnsignedTinyInt); // 17
case OleDbType.UnsignedSmallInt:
return(D_UnsignedSmallInt); // 18
case OleDbType.UnsignedInt:
return(D_UnsignedInt); // 19
case OleDbType.BigInt:
return(D_BigInt); // 20
case OleDbType.UnsignedBigInt:
return(D_UnsignedBigInt); // 21
case OleDbType.Filetime:
return(D_Filetime); // 64
case OleDbType.Guid:
return(D_Guid); // 72
case OleDbType.Binary:
return(D_Binary); // 128
case OleDbType.Char:
return(D_Char); // 129
case OleDbType.WChar:
return(D_WChar); // 130
case OleDbType.Numeric:
return(D_Numeric); // 131
case OleDbType.DBDate:
return(D_DBDate); // 133
case OleDbType.DBTime:
return(D_DBTime); // 134
case OleDbType.DBTimeStamp:
return(D_DBTimeStamp); // 135
case OleDbType.PropVariant:
return(D_PropVariant); // 138
case OleDbType.VarNumeric:
return(D_VarNumeric); // 139
case OleDbType.VarChar:
return(D_VarChar); // 200
case OleDbType.LongVarChar:
return(D_LongVarChar); // 201
case OleDbType.VarWChar:
return(D_VarWChar); // 202: ORA-12704: character set mismatch
case OleDbType.LongVarWChar:
return(D_LongVarWChar); // 203
case OleDbType.VarBinary:
return(D_VarBinary); // 204
case OleDbType.LongVarBinary:
return(D_LongVarBinary); // 205
default:
throw ODB.InvalidOleDbType(enumOleDbType);
}
}
private DbType OleDBType2DBType(System.Data.OleDb.OleDbType oleDBType)
{
DbType dbType = DbType.Object;
switch (oleDBType)
{
case System.Data.OleDb.OleDbType.BigInt:
dbType = DbType.Int64;
break;
case System.Data.OleDb.OleDbType.Binary:
dbType = DbType.Binary;
break;
case System.Data.OleDb.OleDbType.Boolean:
dbType = DbType.Boolean;
break;
case System.Data.OleDb.OleDbType.BSTR:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.Char:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.Currency:
dbType = DbType.Currency;
break;
case System.Data.OleDb.OleDbType.Date:
dbType = DbType.Date;
break;
case System.Data.OleDb.OleDbType.DBDate:
dbType = DbType.Date;
break;
case System.Data.OleDb.OleDbType.DBTime:
dbType = DbType.Time;
break;
case System.Data.OleDb.OleDbType.DBTimeStamp:
dbType = DbType.Date;
break;
case System.Data.OleDb.OleDbType.Decimal:
dbType = DbType.Decimal;
break;
case System.Data.OleDb.OleDbType.Double:
dbType = DbType.Double;
break;
case System.Data.OleDb.OleDbType.Empty:
dbType = DbType.Object;
break;
case System.Data.OleDb.OleDbType.Error:
dbType = DbType.Object;
break;
case System.Data.OleDb.OleDbType.Filetime:
dbType = DbType.UInt64;
break;
case System.Data.OleDb.OleDbType.Guid:
dbType = DbType.Guid;
break;
case System.Data.OleDb.OleDbType.IDispatch:
dbType = DbType.Object;
break;
case System.Data.OleDb.OleDbType.Integer:
dbType = DbType.Int64;
break;
case System.Data.OleDb.OleDbType.IUnknown:
dbType = DbType.Object;
break;
case System.Data.OleDb.OleDbType.LongVarBinary:
dbType = DbType.Binary;
break;
case System.Data.OleDb.OleDbType.LongVarChar:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.LongVarWChar:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.Numeric:
dbType = DbType.VarNumeric;
break;
case System.Data.OleDb.OleDbType.PropVariant:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.Single:
dbType = DbType.Double;
break;
case System.Data.OleDb.OleDbType.SmallInt:
dbType = DbType.Int16;
break;
case System.Data.OleDb.OleDbType.TinyInt:
dbType = DbType.Int16;
break;
case System.Data.OleDb.OleDbType.UnsignedBigInt:
dbType = DbType.UInt64;
break;
case System.Data.OleDb.OleDbType.UnsignedInt:
dbType = DbType.UInt64;
break;
case System.Data.OleDb.OleDbType.UnsignedSmallInt:
dbType = DbType.UInt16;
break;
case System.Data.OleDb.OleDbType.UnsignedTinyInt:
dbType = DbType.Byte;
break;
case System.Data.OleDb.OleDbType.VarBinary:
dbType = DbType.Binary;
break;
case System.Data.OleDb.OleDbType.VarChar:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.Variant:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.VarNumeric:
dbType = DbType.UInt64;
break;
case System.Data.OleDb.OleDbType.VarWChar:
dbType = DbType.String;
break;
case System.Data.OleDb.OleDbType.WChar:
dbType = DbType.String;
break;
}
return(dbType);
}
