/// <summary> /// 执行sql或者存储过程返回一个object对象+事务 /// </summary> /// <param name="cmd">cmd对象</param> /// <param name="t">事务执行操作</param> /// <returns></returns> public object ExecuteScalar(OleDbCommand cmd, AccessTrans t) { cmd.Connection.Close(); cmd.Connection = t.DbConnection; cmd.Transaction = t.DbTrans; object ret = cmd.ExecuteScalar(); return ret; }
/// <summary> /// 执行sql或者存储过程返回一个DbDataReader对象+事务 /// </summary> /// <param name="cmd">cmd对象</param> /// <param name="t">事务执行操作</param> /// <returns></returns> public OleDbDataReader ExecuteReader(OleDbCommand cmd, AccessTrans t) { cmd.Connection.Close(); cmd.Connection = t.DbConnection; cmd.Transaction = t.DbTrans; OleDbDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); return reader; }
/// <summary> /// 执行sql或者存储过程返回一个DataTable对象+事务 /// </summary> /// <param name="cmd">cmd对象</param> /// <param name="t">事务执行操作</param> /// <returns></returns> public DataTable ExecuteDataTable(OleDbCommand cmd, AccessTrans t) { cmd.Connection = t.DbConnection; cmd.Transaction = t.DbTrans; OleDbDataAdapter dbDataAdapter =new OleDbDataAdapter();// dbfactory.CreateDataAdapter(); dbDataAdapter.SelectCommand = cmd; DataTable dataTable = new DataTable(); dbDataAdapter.Fill(dataTable); return dataTable; }
/// <summary> /// 执行一条sql语句或者存储过程,返回受影响的行数+事务 /// </summary> /// <param name="cmd">cmd对象</param> /// <param name="t">事务执行操作</param> /// <returns></returns> public int ExecuteNonQuery(OleDbCommand cmd, AccessTrans t) { cmd.Connection.Close(); cmd.Connection = t.DbConnection; cmd.Transaction = t.DbTrans; int ret = cmd.ExecuteNonQuery(); return ret; }
/// <summary> /// 执行sql或者存储过程返回一个dataSet对象+事务 /// </summary> /// <param name="cmd">cmd对象</param> /// <param name="t">事务执行操作</param> /// <returns></returns> public DataSet ExecuteDataSet(OleDbCommand cmd, AccessTrans t) { cmd.Connection = t.DbConnection; cmd.Transaction = t.DbTrans; OleDbDataAdapter dbDataAdapter = new OleDbDataAdapter(); dbDataAdapter.SelectCommand = cmd; DataSet ds = new DataSet(); dbDataAdapter.Fill(ds); return ds; }