数据库事务使用范例

传入实体执行（可添加 修改 删除）事务。

  IDbHelper dbHelper = new   OracleHelper(ConfigHelper.GetConfigString( "BusinessDbConnection" ));

       bool   result = true ;

        try

        {

             dbHelper.BeginTransaction();

  //主表

             TE_AREAManager manager = new   TE_AREAManager(dbHelper, userInfo);

             TE_AREAEntity tE_AREAEntity = manager.GetObject(dbHelper.SqlSafe(eatxtAREA_ID));

             manager.Delete(tE_AREAEntity);

//子表

             TE_AREA_SUBManager submanager = new   TE_AREA_SUBManager(dbHelper, userInfo);

             TE_AREA_SUBEntity tE_AREA_SUBEntity = submanager.GetObject(dbHelper.SqlSafe(eatxtAREA_ID));

             submanager.Delete(tE_AREA_SUBEntity);

//事务提交　

             dbHelper.CommitTransaction();

        }

        catch (Exception ex)

        {

//事务回滚

            dbHelper.RollbackTransaction();

            result= false ;

        }

 

可以传入sql语句执行事务

IDbHelper dbHelper = new   OracleHelper(ConfigHelper.GetConfigString( "BusinessDbConnection" ));

                     bool   result = true ;

                     try

                     {

                          dbHelper.BeginTransaction();

                          string     commandText = " DELETE FROM TE_AREA WHERE ID="   + dbHelper.SqlSafe(id);

                          dbHelper.ExecuteNonQuery(sqlString);

 

                          commandText = " DELETE FROM TE_AREA_SUB WHERE ID="   + dbHelper.SqlSafe(id);

                          dbHelper.ExecuteNonQuery(commandText);

 

                          dbHelper.CommitTransaction();

                     }

                     catch (Exception ex)

                     {

                         dbHelper.RollbackTransaction();

                         result= false ;

                     }

 还可以同时传入实体，SQL语句

IDbHelper dbHelper = new   OracleHelper(ConfigHelper.GetConfigString( "BusinessDbConnection" ));

                    bool   result = true ;

                    try

                    {

                         dbHelper.BeginTransaction();

　　　　　　　　　　　　　　 //主表

                         TE_AREAManager manager = new   TE_AREAManager(dbHelper, userInfo);

                         TE_AREAEntity tE_AREAEntity = manager.GetObject(dbHelper.SqlSafe(eatxtAREA_ID));

                         manager.Delete(tE_AREAEntity);

　　　　　　　　　　　　　　 //子表

                         TE_AREA_SUBManager submanager = new   TE_AREA_SUBManager(dbHelper, userInfo);

                         TE_AREA_SUBEntity tE_AREA_SUBEntity = submanager.GetObject(dbHelper.SqlSafe(eatxtAREA_ID));

                         submanager.Delete(tE_AREA_SUBEntity);

　　　　　　　　　　　　　　

　　　　　　　　　　　　　 //执行SQL语句

　　　　　　　　　　　　 　 string   commandText = " DELETE FROM JINTIANDA WHERE ID="   + dbHelper.SqlSafe(id);

　　　　　　　　　　　　　 dbHelper.ExecuteNonQuery(commandText);

 

　　　　　　　　　　　　　　 //事务提交　

                         dbHelper.CommitTransaction();

                    }

                    catch (Exception ex)

                    {

　　　　　　　　　　　　　 //事务回滚

                        dbHelper.RollbackTransaction();

                        result= false ;

                    }