/// <summary> /// 添加参数 /// </summary> /// <param name="command"></param> /// <param name="parameter"></param> protected override void AddParameter(DbCommand command, DataAccessParameter parameter) { SqlCommand comm = command as SqlCommand; comm.CommandTimeout = 3600; if (comm != null) { comm.Parameters.AddWithValue(parameter.ParameterName, parameter.ParameterValue); comm.Parameters[parameter.ParameterName].Direction = parameter.Direction; //comm.Parameters[parameter.ParameterName].DbType = parameter.DbType; } }
/// <summary> /// 添加参数 /// </summary> /// <param name="command"></param> /// <param name="parameter"></param> protected override void AddParameter(DbCommand command, DataAccessParameter parameter) { OracleCommand comm = command as OracleCommand; if (comm != null) { comm.Parameters.AddWithValue(parameter.ParameterName, parameter.ParameterValue); comm.Parameters[parameter.ParameterName].Direction = parameter.Direction; comm.Parameters[parameter.ParameterName].Size = parameter.Size; //Lucas 2011-01-04 执行oracle存储过程时参数必须要设置大小 //comm.Parameters[parameter.ParameterName].DbType = parameter.DbType; } }
/// <summary> /// 由子类创建Parameter /// </summary> /// <param name="command"></param> /// <param name="parameter"></param> protected abstract void AddParameter(DbCommand command, DataAccessParameter parameter);