public MetaType(byte precision, byte scale, int fixedLength, bool isFixed, bool isLong, bool isPlp, byte tdsType, byte nullableTdsType, string typeName, Type classType, Type sqlType, System.Data.SqlDbType sqldbType, System.Data.DbType dbType, byte propBytes)
{
this.Precision = precision;
this.Scale = scale;
this.FixedLength = fixedLength;
this.IsFixed = isFixed;
this.IsLong = isLong;
this.IsPlp = isPlp;
this.TDSType = tdsType;
this.NullableType = nullableTdsType;
this.TypeName = typeName;
this.SqlDbType = sqldbType;
this.DbType = dbType;
this.ClassType = classType;
this.SqlType = sqlType;
this.PropBytes = propBytes;
this.IsAnsiType = _IsAnsiType(sqldbType);
this.IsBinType = _IsBinType(sqldbType);
this.IsCharType = _IsCharType(sqldbType);
this.IsNCharType = _IsNCharType(sqldbType);
this.IsSizeInCharacters = _IsSizeInCharacters(this.SqlDbType);
this.Is70Supported = _Is70Supported(this.SqlDbType);
this.Is80Supported = _Is80Supported(this.SqlDbType);
this.Is90Supported = _Is90Supported(this.SqlDbType);
this.Is100Supported = _Is100Supported(this.SqlDbType);
}
/// <summary>
/// 添加查询参数
/// </summary>
/// <param name="ParamName">参数名称</param>
/// <param name="DbType">数据类型</param>
/// <returns></returns>
public static IDbDataParameter MakeParam(string ParamName, System.Data.DbType DbType)
{
IDbDataParameter param = DBFactory.CreateParameter(ParamName, DbType);
param.Direction = ParameterDirection.Input;
return(param);
}
public void AddParam(string name, System.Data.DbType dbType, ParameterDirection direction)
{
try
{
if (!IsConnected && !Connect())
{
return;
}
command.Parameters.Add(new SqlParameter()
{
ParameterName = name, DbType = dbType, Direction = direction
});
}
catch (SqlException dbexc)
{
message = dbexc.Message;
Logger.E(dbexc);
}
catch (Exception exc)
{
message = exc.Message;
Logger.E(exc);
}
}
public int ExecSQL(string SQL, object[] ParaValue)
{
System.Data.DbType[] ParaType = new System.Data.DbType[ParaValue.Length];
for (int i = 0; i < ParaValue.Length; i++)
{
ParaType[i] = (System.Data.DbType)DynamicUpdateSqlite.htDataType[ParaValue[i] == null ? typeof(string) : ParaValue[i].GetType()];
}
return ExecSQL(SQL, ParaType, ParaValue);
}
public DbAccessParameter()
{
this._DbType = System.Data.DbType.String;
this._ProvideType = -1;
this._Direction = ParameterDirection.Input;
this._ParameterName = string.Empty;
this._Size = 0;
this._Value = null;
this._IsNullable = false;
this._SourceColumn = string.Empty;
this._SourceColumnNullMapping = false;
this._SourceVersion = DataRowVersion.Current;
this._Precision = 0;
this._Scale = 0;
this.Properties = new bool[12];
}
public ParameterItem(Parameter p)
{
this._name = p.Name;
this._dbType = p.DbType;
this._type = p.Type;
this._defaultValue = p.DefaultValue;
}
internal DataType (
string typeName,
VirtDbType vdbType,
System.Data.DbType dbType,
CLI.SqlType sqlType,
BufferType bufferType,
bool isLong)
{
this.typeName = typeName;
this.vdbType = vdbType;
this.dbType = dbType;
this.sqlType = sqlType;
this.bufferType = bufferType;
this.isLong = isLong;
}
public int[] ExecSQL(string[] SQL, object[][] ParaValues)
{
System.Data.DbType[][] ParaTypes = new System.Data.DbType[ParaValues.Length][];
for (int i = 0; i < ParaValues.Length; i++)
{
ParaTypes[i] = new System.Data.DbType[ParaValues[i].Length];
for (int j = 0; j < ParaValues[i].Length; j++)
{
ParaTypes[i][j] = (System.Data.DbType)DynamicUpdateSqlite.htDataType[ParaValues[i][j] == null ? typeof(string) : ParaValues[i][j].GetType()];
}
}
return ExecSQL(SQL, ParaTypes, ParaValues);
}
public System.Data.DataSet GetDatas(string[] MappingTables, string[] SQLs, object[][] ParaValues)
{
System.Data.DbType[][] ParaTypes = new System.Data.DbType[ParaValues.Length][];
for (int i = 0; i < ParaValues.Length; i++)
{
ParaTypes[i] = new System.Data.DbType[ParaValues[i].Length];
for (int j = 0; j < ParaValues[i].Length; j++)
{
ParaTypes[i][j] = (System.Data.DbType)DynamicUpdateSqlite.htDataType[ParaValues[i][j] == null ? typeof(string) : ParaValues[i][j].GetType()];
}
}
return GetDatas(MappingTables, SQLs, ParaTypes, ParaValues);
}
public System.Data.DataSet GetData(string MappingTable, string SQL, object[] ParaValue)
{
System.Data.DbType[] ParaType = new System.Data.DbType[ParaValue.Length];
for (int i = 0; i < ParaValue.Length; i++)
{
ParaType[i] = (System.Data.DbType)DynamicUpdateSqlite.htDataType[ParaValue[i] == null ? typeof(string) : ParaValue[i].GetType()];
}
return GetData(MappingTable, SQL, ParaType, ParaValue);
}
public Field(object parent, string name, string canonicalidentifiername, System.Data.DbType dbtype, bool _readonly)
{
this.Parent = parent;
this.Name = name;
this.CanonicalIdentifierName = canonicalidentifiername;
this.DbType = dbtype;
this.ReadOnly = _readonly;
}
/// <summary>
/// Contructor con la definicion de los parametros
/// </summary>
public TipoParametro()
{
_TipoParametroCadena = System.Data.DbType.String;
_TipoParametroEntero = System.Data.DbType.Int32;
_TipoParametroFecha = System.Data.DbType.DateTime;
_TipoParametroDecimal = System.Data.DbType.Decimal;
_TipoParametroBinario = System.Data.DbType.Binary;
_TipoParametroXml = System.Data.DbType.Xml;
_TipoParametroObjeto = System.Data.DbType.Object;
_TipoParametroByte = System.Data.DbType.Byte;
}
private void SetMySqlDbType(GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType mysql_dbtype) {
this.mySqlDbType = mysql_dbtype;
switch (this.mySqlDbType) {
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Decimal:
this.dbType = System.Data.DbType.Decimal;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Byte:
this.dbType = System.Data.DbType.SByte;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int16:
this.dbType = System.Data.DbType.Int16;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int32:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int24:
this.dbType = System.Data.DbType.Int32;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Float:
this.dbType = System.Data.DbType.Single;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Double:
this.dbType = System.Data.DbType.Double;
return;
case (GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Float | GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int16):
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.VarString:
case ((GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType)0x1f8):
case ((GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType)0x1f9):
case ((GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType)0x1fa):
case ((GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType)0x1fb):
break;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Timestamp:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.DateTime:
this.dbType = System.Data.DbType.DateTime;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int64:
this.dbType = System.Data.DbType.Int64;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Date:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Year:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Newdate:
this.dbType = System.Data.DbType.Date;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Time:
this.dbType = System.Data.DbType.Time;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Bit:
this.dbType = System.Data.DbType.UInt64;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Enum:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Set:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.VarChar:
this.dbType = System.Data.DbType.String;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.TinyBlob:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.MediumBlob:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.LongBlob:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Blob:
this.dbType = System.Data.DbType.Object;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.String:
this.dbType = System.Data.DbType.StringFixedLength;
break;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UByte:
this.dbType = System.Data.DbType.Byte;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UInt16:
this.dbType = System.Data.DbType.UInt16;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UInt32:
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UInt24:
this.dbType = System.Data.DbType.UInt32;
return;
case GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UInt64:
this.dbType = System.Data.DbType.UInt64;
return;
default:
return;
}
}
private void SetDbType(System.Data.DbType db_type) {
this.dbType = db_type;
switch (this.dbType) {
case System.Data.DbType.AnsiString:
case System.Data.DbType.Guid:
case System.Data.DbType.String:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.VarChar;
return;
case System.Data.DbType.Byte:
case System.Data.DbType.Boolean:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UByte;
return;
case System.Data.DbType.Currency:
case System.Data.DbType.Decimal:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Decimal;
return;
case System.Data.DbType.Date:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Date;
return;
case System.Data.DbType.DateTime:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.DateTime;
return;
case System.Data.DbType.Double:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Double;
return;
case System.Data.DbType.Int16:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int16;
return;
case System.Data.DbType.Int32:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int32;
return;
case System.Data.DbType.Int64:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Int64;
return;
case System.Data.DbType.SByte:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Byte;
return;
case System.Data.DbType.Single:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Float;
return;
case System.Data.DbType.Time:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Time;
return;
case System.Data.DbType.UInt16:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UInt16;
return;
case System.Data.DbType.UInt32:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UInt32;
return;
case System.Data.DbType.UInt64:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.UInt64;
return;
case System.Data.DbType.AnsiStringFixedLength:
case System.Data.DbType.StringFixedLength:
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.String;
return;
}
this.mySqlDbType = GodLesZ.Library.MySql.Data.MySqlClient.MySqlDbType.Blob;
}
public MetaType(System.Data.DbType dbType, System.Data.OracleClient.OracleType oracleType, OCI.DATATYPE ociType, string dataTypeName, Type convertToType, Type noConvertType, int bindSize, int maxBindSize, bool usesNationalCharacterSet)
{
this._dbType = dbType;
this._oracleType = oracleType;
this._ociType = ociType;
this._convertToType = convertToType;
this._noConvertType = noConvertType;
this._bindSize = bindSize;
this._maxBindSize = maxBindSize;
this._dataTypeName = dataTypeName;
this._usesNationalCharacterSet = usesNationalCharacterSet;
switch (oracleType)
{
case System.Data.OracleClient.OracleType.Char:
case System.Data.OracleClient.OracleType.Clob:
case System.Data.OracleClient.OracleType.LongVarChar:
case System.Data.OracleClient.OracleType.NChar:
case System.Data.OracleClient.OracleType.NClob:
case System.Data.OracleClient.OracleType.NVarChar:
case System.Data.OracleClient.OracleType.VarChar:
this._isCharacterType = true;
break;
}
switch (oracleType)
{
case System.Data.OracleClient.OracleType.LongRaw:
case System.Data.OracleClient.OracleType.LongVarChar:
this._isLong = true;
break;
}
switch (oracleType)
{
case System.Data.OracleClient.OracleType.BFile:
case System.Data.OracleClient.OracleType.Blob:
case System.Data.OracleClient.OracleType.Clob:
case System.Data.OracleClient.OracleType.NClob:
this._isLob = true;
break;
case System.Data.OracleClient.OracleType.Char:
break;
default:
return;
}
}