private OracleType getOraType(myDbType dbtp)
{
OracleType ot = OracleType.VarChar;
switch (dbtp)
{
case myDbType.Int:
ot = OracleType.Int16;
break;
case myDbType.Varchar:
ot = OracleType.VarChar;
break;
case myDbType.NVarChar:
ot = OracleType.NVarChar;
break;
case myDbType.DateTime:
ot = OracleType.DateTime;
break;
case myDbType.Float:
ot = OracleType.Float;
break;
case myDbType.Numeric:
ot = OracleType.Number;
break;
}
return(ot);
}
/// <summary>
/// 数据参数类型
/// </summary>
/// <param name="dbtp"></param>
/// <returns></returns>
private SqlDbType getMsSqlType(myDbType dbtp)
{
SqlDbType ot = SqlDbType.VarChar;
switch (dbtp)
{
case myDbType.Int:
ot = SqlDbType.Int;
break;
case myDbType.Varchar:
ot = SqlDbType.VarChar;
break;
case myDbType.NVarChar:
ot = SqlDbType.NVarChar;
break;
case myDbType.DateTime:
ot = SqlDbType.DateTime;
break;
case myDbType.Float:
ot = SqlDbType.Float;
break;
case myDbType.Numeric:
ot = SqlDbType.Decimal;
break;
}
return(ot);
}
public IDbDataParameter getDBParameter <T>(string paraName, T paraValue, myDbType dbtp, int intLen, ParameterDirection pd)
{
return(myDB.getDBParameter(paraName, paraValue, dbtp, intLen, pd));
}
public IDbDataParameter getDBParameter <T>(string paraName, T paraValue, myDbType dbtp)
{
return(myDB.getDBParameter(paraName, paraValue, dbtp));
}
public override IDbDataParameter getDBParameter <T>(string paraName, T paraValue, myDbType dbtp, int intLen, ParameterDirection pd)
{
if (paraName.IndexOf('@') != 0)
{
paraName = "@" + paraName;
}
IDbDataParameter para = new SqlParameter(paraName, getMsSqlType(dbtp), intLen);
para.Value = paraValue;
para.Direction = pd;
return(para);
}
public override IDbDataParameter getDBParameter <T>(string paraName, T paraValue, myDbType dbtp)
{
return(getDBParameter(paraName, paraValue, dbtp, ParameterDirection.Input));
}
public override IDbDataParameter getDBParameter <T>(string paraName, T paraValue, myDbType dbtp, int intLen, ParameterDirection pd)
{
OracleParameter para = new OracleParameter(paraName, getOraType(dbtp), intLen);
para.Value = paraValue;
para.Direction = pd;
return(para);
}
public abstract IDbDataParameter getDBParameter <T>(string paraName, T paraValue, myDbType dbtp, int intLen, ParameterDirection pd);
public abstract IDbDataParameter getDBParameter <T>(string paraName, T paraValue, myDbType dbtp);
