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

本人没有食言，将和网友分享数据访问公共类(带事务的处理)，以对上一篇Blog的补充

DataAccessWithTrans.cs

1. using System;
2. using System.Data;
3. using System.Configuration;
4. using System.Web;
5. using System.Web.Security;
6. using System.Web.UI;
7. using System.Web.UI.WebControls;
8. using System.Web.UI.WebControls.WebParts;
9. using System.Web.UI.HtmlControls;
10. using System.Data.OracleClient;
12. /****************************************************************************
13.    *  名称：数据访问公共模块                                                     
14.                      
15.    *  时间：2008-10-20                                                       
16.    *  作者                                                         
17.    *      姓名：  朱久长                                               
18.                                           
19.    *      E-Mail：wenchang4you@126.com                                                
20.    *  技术说明：              
21.           数据库访问类（带事务）
22.    *  
23.   ***************************************************************************/
25. namespace DAClass
26. {
27.     public class DataAccessWithTrans
28.     {
29.         private String connectionString = "";
30.         private OracleConnection conn = null;
31.         private OracleCommand comm = null;
32.         private OracleDataAdapter da = null;
34.         public DataAccessWithTrans()
35.         {
36.             connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
37.             conn = new OracleConnection(connectionString);
38.         }
40.         public OracleConnection getConn()
41.         {
42.             conn.Open();
43.             return this.conn;
44.         }
46.         // 执行非查询语句,并返回受影响的记录行数
47.         public int ExecuteCommandWithTrans(OracleConnection conn, string sql, OracleTransaction trans)
48.         {
49.             int result = 0;
50.             comm = new OracleCommand(sql, conn);
51.             comm.Transaction = trans;
52.             try
53.             {
54.                 //conn.Open();
55.                 result = comm.ExecuteNonQuery();
56.             }
57.             catch (Exception ex)
58.             {
59.                 throw ex;
60.             }
61.             return result;
62.         }
64.         public void close()
65.         {
66.             this.conn.Close();
67.         }
68.     }   
69. }