/// <summary>
/// 转换Oracle参数
/// </summary>
/// <param name="Name">参数名</param>
/// <param name="Type">Oracle数据类型</param>
/// <param name="Value">参数值</param>
/// <returns>返回Oracle参数</returns>
public static OracleDBO.OracleCmdParam Param(string Name, OracleDbType Type, object Value)
{
OracleDBO.OracleCmdParam param = new OracleCmdParam();
try
{
if (Type == OracleDbType.Date)
{
DateTime 日期 = DateTime.Now;
if (!DateTime.TryParse(Convert.ToString(Value), out 日期))
{
Value = null;
}
else
{
Value = 日期;
}
}
param.Name = ":" + Name;
param.Type = Type;
param.Value = Value;
}
catch (Exception ex)
{
throw ex;
}
return(param);
}
/// <summary>
/// 新建Oracle参数.
/// </summary>
/// <param name="ParamName">参数名</param>
/// <param name="ParamType">Oracle参数类型</param>
/// <param name="Value">参数值</param>
/// <returns>Oracle参数</returns>
public OracleCmdParam CreateNewParam(string ParamName, OracleDbType ParamType, object Value)
{
OracleCmdParam MyParam = new OracleCmdParam();
MyParam.Name = ParamName;
MyParam.Type = ParamType;
MyParam.Value = Value;
return(MyParam);
}
/// <summary>
/// 转换Oracle参数【常见类型】
/// </summary>
/// <param name="Name">参数名</param>
/// <param name="Value">参数值</param>
/// <returns>返回Oracle参数</returns>
public static OracleDBO.OracleCmdParam Param(string Name, object Value)
{
OracleDBO.OracleCmdParam param = new OracleCmdParam();
try
{
param.Name = ":" + Name;
Type DataType = Value.GetType();
switch (DataType.Name)
{
case "String":
param.Type = OracleDbType.Varchar2;
break;
case "Double":
param.Type = OracleDbType.Double;
break;
case "Single": //Float
param.Type = OracleDbType.Single;
break;
case "Int32":
param.Type = OracleDbType.Int32;
break;
case "DateTime":
param.Type = OracleDbType.Date;
break;
default:
param.Type = OracleDbType.Varchar2;
break;
}
param.Value = Value;
}
catch (Exception ex)
{
throw ex;
}
return(param);
}
