Asp.net 在三层架构中事务的使用(2)

 
DAL：
1 public bool test(int i,SqlTransaction tran)
2         {
3             string sql = "insert into [test]([item]) values(@i)";
4             SqlParameter[] paras=new SqlParameter[]{new SqlParameter("@i",i)};
5             return sqlhelper.ExecutenQuery(sql, paras, CommandType.Text, tran)>0;
6         }

BLL：
 1 UserDAO userdao = new UserDAO();
 2
 3
 4         public bool test()
 5         {
 6             using (SqlTransaction tran = SQLHelper.BeginTransaction())
 7             {
 8                 try
 9                 {
10                     userdao.test(2, tran);
11                     userdao.test(3, tran);
12                     tran.Commit(); return true;
13                 }
14                 catch
15                 {
16                    
17                     tran.Rollback();
18                     return false;
19                 }
20                 finally
21                 {