/// <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(); } }