/// <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); }