/// <summary>
/// Bool = 1,
/// Date = 2,
/// Decimal = 3,
/// Int = 4,
/// NVarChar = 5,
/// VarChar = 6
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static OracleDbType GetType(LTCType type)
{
switch (((int)type))
{
case 1:
return(OracleDbType.Int16);
case 2:
return(OracleDbType.Date);
case 3:
return(OracleDbType.Decimal);
case 4:
return(OracleDbType.Int64);
case 5:
return(OracleDbType.NVarchar2);
case 6:
return(OracleDbType.Varchar2);
case 7:
return(OracleDbType.Blob);
}
throw new Exception();
}
public LTCParameter Add(string paraName, LTCType LtcType, int size, string sourceColumn)
{
LTCParameter parameter = null;
try
{
parameter = new LTCParameter(((OracleParameterCollection)this.paramCols).Add(paraName, LTCGetType.GetType(LtcType), size, sourceColumn));
}
catch
{
parameter = null;
}
return(parameter);
}
public LTCParameter Add(string paraName, LTCType LtcType, int size)
{
LTCParameter parameter = null;
try
{
parameter = new LTCParameter(((OracleParameterCollection)this.paramCols).Add(paraName, LTCGetType.GetType(LtcType), size));
}
catch //(LTCException exception)
{
parameter = null;
}
return(parameter);
}
