protected override int ExecuteQuery()
{
int result = 0;
result = DbCommandObject.ExecuteNonQuery();
return(result);
}
/// <summary>
/// 执行一条指定命令类型(SQL语句或存储过程等)的SQL语句,返回所影响行数
/// </summary>
public int ExecNonQuery(string sqlText, CommandType cmdType, params DbParameter[] param)
{
try
{
SetCommandAndOpenConnect(sqlText, cmdType, param);
return(DbCommandObject.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnect();
}
}
/// <summary>
/// 获得DataReader对象
/// </summary>
public DbDataReader GetDataReader(string sqlText, CommandType cmdType, params DbParameter[] param)
{
try
{
SetCommandAndOpenConnect(sqlText, cmdType, param);
CommandBehavior cmdBehavior = CommandBehavior.CloseConnection;
if (_IsTrans)
{
cmdBehavior = CommandBehavior.Default;
}
DbDataReader dbReader = DbCommandObject.ExecuteReader(cmdBehavior);
return(dbReader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
//DataReader用dbReader对象来关闭
//CloseConnect();
}
}
