数据访问公共类(带事务的处理)

来源：互联网发布：淘宝两个月还申请售后编辑：程序博客网时间：2024/05/30 04:19
本人没有食言，将和网友分享数据访问公共类(带事务的处理)，以对上一篇Blog的补充
DataAccessWithTrans.cs
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
/****************************************************************************
   *  名称：数据访问公共模块                                                     
                     
   *  时间：2008-10-20                                                       
   *  作者                                                         
   *      姓名：  朱久长                                               
                                          
   *      E-Mail：wenchang4you@126.com                                                
   *  技术说明：              
          数据库访问类（带事务）
   *  
  ***************************************************************************/
namespace DAClass
{
    public class DataAccessWithTrans
    {
        private String connectionString = "";
        private OracleConnection conn = null;
        private OracleCommand comm = null;
        private OracleDataAdapter da = null;
        public DataAccessWithTrans()
        {
            connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            conn = new OracleConnection(connectionString);
        }
        public OracleConnection getConn()
        {
            conn.Open();
            return this.conn;
        }
        // 执行非查询语句,并返回受影响的记录行数 
        public int ExecuteCommandWithTrans(OracleConnection conn, string sql, OracleTransaction trans)
        {
            int result = 0;
            comm = new OracleCommand(sql, conn);
            comm.Transaction = trans;
            try
            {
                //conn.Open(); 
                result = comm.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return result;
        }
        public void close()
        {
            this.conn.Close();
        }
    }   
}