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