private byte[] EncodeSliceArray(Array sourceArray)
{
DbDataType dbType = DbDataType.Array;
Charset charset = _database.Charset;
int subType = (Descriptor.Scale < 0) ? 2 : 0;
int type = 0;
using (XdrStream xdr = new XdrStream(_database.Charset))
{
type = TypeHelper.GetSqlTypeFromBlrType(Descriptor.DataType);
dbType = TypeHelper.GetDbDataTypeFromBlrType(Descriptor.DataType, subType, Descriptor.Scale);
foreach (object source in sourceArray)
{
switch (dbType)
{
case DbDataType.Char:
byte[] buffer = charset.GetBytes(source.ToString());
xdr.WriteOpaque(buffer, Descriptor.Length);
break;
case DbDataType.VarChar:
xdr.Write((string)source);
break;
case DbDataType.SmallInt:
xdr.Write((short)source);
break;
case DbDataType.Integer:
xdr.Write((int)source);
break;
case DbDataType.BigInt:
xdr.Write((long)source);
break;
case DbDataType.Decimal:
case DbDataType.Numeric:
xdr.Write((decimal)source, type, Descriptor.Scale);
break;
case DbDataType.Float:
xdr.Write((float)source);
break;
case DbDataType.Double:
xdr.Write((double)source);
break;
case DbDataType.Date:
xdr.WriteDate(Convert.ToDateTime(source, CultureInfo.CurrentCulture.DateTimeFormat));
break;
case DbDataType.Time:
xdr.WriteTime((TimeSpan)source);
break;
case DbDataType.TimeStamp:
xdr.Write(Convert.ToDateTime(source, CultureInfo.CurrentCulture.DateTimeFormat));
break;
default:
throw TypeHelper.InvalidDataType((int)dbType);
}
}
return(xdr.ToArray());
}
}
protected void WriteRawParameter(XdrStream xdr, DbField field)
{
if (field.DbDataType != DbDataType.Null)
{
field.FixNull();
switch (field.DbDataType)
{
case DbDataType.Char:
if (field.Charset.IsOctetsCharset)
{
xdr.WriteOpaque(field.DbValue.GetBinary(), field.Length);
}
else
{
var svalue = field.DbValue.GetString();
if ((field.Length % field.Charset.BytesPerCharacter) == 0 &&
svalue.Length > field.CharCount)
{
throw IscException.ForErrorCodes(new[] { IscCodes.isc_arith_except, IscCodes.isc_string_truncation });
}
xdr.WriteOpaque(field.Charset.GetBytes(svalue), field.Length);
}
break;
case DbDataType.VarChar:
if (field.Charset.IsOctetsCharset)
{
xdr.WriteBuffer(field.DbValue.GetBinary());
}
else
{
var svalue = field.DbValue.GetString();
if ((field.Length % field.Charset.BytesPerCharacter) == 0 &&
svalue.Length > field.CharCount)
{
throw IscException.ForErrorCodes(new[] { IscCodes.isc_arith_except, IscCodes.isc_string_truncation });
}
xdr.WriteBuffer(field.Charset.GetBytes(svalue));
}
break;
case DbDataType.SmallInt:
xdr.Write(field.DbValue.GetInt16());
break;
case DbDataType.Integer:
xdr.Write(field.DbValue.GetInt32());
break;
case DbDataType.BigInt:
case DbDataType.Array:
case DbDataType.Binary:
case DbDataType.Text:
xdr.Write(field.DbValue.GetInt64());
break;
case DbDataType.Decimal:
case DbDataType.Numeric:
xdr.Write(field.DbValue.GetDecimal(), field.DataType, field.NumericScale);
break;
case DbDataType.Float:
xdr.Write(field.DbValue.GetFloat());
break;
case DbDataType.Guid:
xdr.Write(field.DbValue.GetGuid());
break;
case DbDataType.Double:
xdr.Write(field.DbValue.GetDouble());
break;
case DbDataType.Date:
xdr.Write(field.DbValue.GetDate());
break;
case DbDataType.Time:
xdr.Write(field.DbValue.GetTime());
break;
case DbDataType.TimeStamp:
xdr.Write(field.DbValue.GetDate());
xdr.Write(field.DbValue.GetTime());
break;
case DbDataType.Boolean:
xdr.Write(field.DbValue.GetBoolean());
break;
default:
throw IscException.ForStrParam($"Unknown SQL data type: {field.DataType}.");
}
}
}
private byte[] EncodeSliceArray(Array sourceArray)
{
DbDataType dbType = DbDataType.Array;
Charset charset = _database.Charset;
XdrStream xdr = new XdrStream(_database.Charset);
int subType = (Descriptor.Scale < 0) ? 2 : 0;
int type = 0;
type = TypeHelper.GetFbType(Descriptor.DataType);
dbType = TypeHelper.GetDbDataType(Descriptor.DataType, subType, Descriptor.Scale);
foreach (object source in sourceArray)
{
switch (dbType)
{
case DbDataType.Char:
byte[] buffer = charset.GetBytes(source.ToString());
xdr.WriteOpaque(buffer, Descriptor.Length);
break;
case DbDataType.VarChar:
xdr.Write((string)source);
break;
case DbDataType.SmallInt:
xdr.Write((short)source);
break;
case DbDataType.Integer:
xdr.Write((int)source);
break;
case DbDataType.BigInt:
xdr.Write((long)source);
break;
case DbDataType.Decimal:
case DbDataType.Numeric:
xdr.Write((decimal)source, type, Descriptor.Scale);
break;
case DbDataType.Float:
xdr.Write((float)source);
break;
case DbDataType.Double:
xdr.Write((double)source);
break;
case DbDataType.Date:
xdr.WriteDate(Convert.ToDateTime(source, CultureInfo.CurrentCulture.DateTimeFormat));
break;
case DbDataType.Time:
xdr.WriteTime((TimeSpan)source);
break;
case DbDataType.TimeStamp:
xdr.Write(Convert.ToDateTime(source, CultureInfo.CurrentCulture.DateTimeFormat));
break;
default:
throw new NotSupportedException("Unknown data type");
}
}
return xdr.ToArray();
}
public void WriteOpaque(byte[] buffer)
{
_outputStream.WriteOpaque(buffer);
}
