/// <summary>
/// 生成oracle参数
/// </summary>
/// <param name="ParamName">字段名</param>
/// <param name="otype">数据类型</param>
/// <param name="size">数据大小</param>
/// <param name="Value">值</param>
/// <returns></returns>
public static OracleParameter MakeParam(string ParamName, System.Data.OracleClient.OracleType otype, int size, Object Value)
{
OracleParameter para = new OracleParameter(ParamName, Value);
para.OracleType = otype;
para.Size = size;
return(para);
}
public System.Data.OracleClient.OracleType GetOracleDBType(string strSystemType)
{
System.Data.OracleClient.OracleType dbType = System.Data.OracleClient.OracleType.VarChar;
switch (strSystemType)
{
case "String":
dbType = System.Data.OracleClient.OracleType.VarChar;
break;
case "Int64":
dbType = System.Data.OracleClient.OracleType.Int32;
break;
case "Int32":
dbType = System.Data.OracleClient.OracleType.Int32;
break;
case "DateTime":
dbType = System.Data.OracleClient.OracleType.DateTime;
break;
case "Double":
dbType = System.Data.OracleClient.OracleType.Double;
break;
case "Boolean":
dbType = System.Data.OracleClient.OracleType.Blob;
break;
case "Int16":
dbType = System.Data.OracleClient.OracleType.Int16;
break;
case "Decimal":
dbType = System.Data.OracleClient.OracleType.Double;
break;
case "Cursor":
dbType = System.Data.OracleClient.OracleType.Cursor;
break;
}
return(dbType);
}
public static void GetoType(string key, DataTable dt, out System.Data.OracleClient.OracleType otype, out int size)
{
DataView dv = dt.DefaultView;
dv.RowFilter = "column_name='" + key + "'";
string fType = dv[0]["data_type"].ToString().ToUpper();
switch (fType)
{
case "DATE":
otype = OracleType.DateTime;
size = int.Parse(dv[0]["data_length"].ToString());
break;
case "CHAR":
otype = OracleType.Char;
size = int.Parse(dv[0]["data_length"].ToString());
break;
case "LONG":
otype = OracleType.Double;
size = int.Parse(dv[0]["data_length"].ToString());
break;
case "NVARCHAR2":
otype = OracleType.NVarChar;
size = int.Parse(dv[0]["data_length"].ToString());
break;
case "VARCHAR2":
otype = OracleType.NVarChar;
size = int.Parse(dv[0]["data_length"].ToString());
break;
default:
otype = OracleType.NVarChar;
size = 100;
break;
}
}
public OracleDBMapping(string first, string second, System.Data.OracleClient.OracleType dbType, int size)
: base(first, second, DbType.String, size)
{
this._type = System.Data.OracleClient.OracleType.VarChar;
this._type = dbType;
}
public OracleDBMapping(string first, string second)
: base(first, second)
{
this._type = System.Data.OracleClient.OracleType.VarChar;
}
OracleDataAccessClient.OracleDbType ConvertOracleType(System.Data.OracleClient.OracleType type)
{
switch (type)
{
case System.Data.OracleClient.OracleType.Int16:
case System.Data.OracleClient.OracleType.UInt16:
return(global::Oracle.DataAccess.Client.OracleDbType.Int16);
case System.Data.OracleClient.OracleType.Int32:
case System.Data.OracleClient.OracleType.UInt32:
return(global::Oracle.DataAccess.Client.OracleDbType.Int32);
case System.Data.OracleClient.OracleType.Double:
return(global::Oracle.DataAccess.Client.OracleDbType.Double);
case System.Data.OracleClient.OracleType.Float:
return(global::Oracle.DataAccess.Client.OracleDbType.Double);
case System.Data.OracleClient.OracleType.Byte:
return(global::Oracle.DataAccess.Client.OracleDbType.Byte);
case System.Data.OracleClient.OracleType.Char:
return(global::Oracle.DataAccess.Client.OracleDbType.Char);
case System.Data.OracleClient.OracleType.Blob:
return(global::Oracle.DataAccess.Client.OracleDbType.Blob);
case System.Data.OracleClient.OracleType.BFile:
return(global::Oracle.DataAccess.Client.OracleDbType.BFile);
case System.Data.OracleClient.OracleType.Clob:
return(global::Oracle.DataAccess.Client.OracleDbType.Clob);
case System.Data.OracleClient.OracleType.Cursor:
return(global::Oracle.DataAccess.Client.OracleDbType.RefCursor);
case System.Data.OracleClient.OracleType.DateTime:
return(global::Oracle.DataAccess.Client.OracleDbType.Date);
case System.Data.OracleClient.OracleType.LongRaw:
return(global::Oracle.DataAccess.Client.OracleDbType.LongRaw);
case System.Data.OracleClient.OracleType.LongVarChar:
return(global::Oracle.DataAccess.Client.OracleDbType.Long);
case System.Data.OracleClient.OracleType.NChar:
return(global::Oracle.DataAccess.Client.OracleDbType.NChar);
case System.Data.OracleClient.OracleType.NClob:
return(global::Oracle.DataAccess.Client.OracleDbType.NClob);
case System.Data.OracleClient.OracleType.Number:
return(global::Oracle.DataAccess.Client.OracleDbType.Decimal);
case System.Data.OracleClient.OracleType.NVarChar:
return(global::Oracle.DataAccess.Client.OracleDbType.NVarchar2);
case System.Data.OracleClient.OracleType.Raw:
return(global::Oracle.DataAccess.Client.OracleDbType.Raw);
case System.Data.OracleClient.OracleType.RowId:
return(global::Oracle.DataAccess.Client.OracleDbType.NVarchar2);
case System.Data.OracleClient.OracleType.Timestamp:
return(global::Oracle.DataAccess.Client.OracleDbType.TimeStamp);
case System.Data.OracleClient.OracleType.VarChar:
return(global::Oracle.DataAccess.Client.OracleDbType.Varchar2);
default:
throw new NotSupportedException();
}
}
