Oracle 事務機制 大量新增,修改,更新

 ---------------------------------------------------------------------------------------------2011-12-14編輯-------------------------------------------------------------------------------------------------------------------

 using (OracleConnection oc = new OracleConnection(OracleHelper.ConnectionString))      {          oc.Open();          OracleTransaction trans = oc.BeginTransaction();//申明一個基於串連的事物並開始執行            try           {             Dtsc.Common.Upload.UploadHelper.DeleteResFile(model.ActivityId);             BizTsNeactivitys.Delete(model.ActivityId,trans);             trans.Commit();//提交事物               flg = true;            }           catch (Exception ex)           {             trans.Rollback();//復原事物               flg = false;             throw ex;                              }           finally            {              trans.Dispose();            }           return flg;      }

寫個方法，傳回型別是bool ，調用該方法

實際使用修改Dtsc.Common.Upload.UploadHelper.DeleteResFile(model.ActivityId); BizTsNeactivitys.Delete(model.ActivityId,trans);這2句就可以了。

例如：

public bool t_spSWJZ(TsNeactivitys model)        {            bool flg = false;            using (OracleConnection oc = new OracleConnection(OracleHelper.ConnectionString))            {                oc.Open();                OracleTransaction trans = oc.BeginTransaction();//申明一個基於串連的事物並開始執行                try                {                    Dtsc.Common.Upload.UploadHelper.DeleteResFile(model.ActivityId);                    BizTsNeactivitys.Delete(model.ActivityId,trans);                    trans.Commit();//提交事物                    flg = true;                }                catch (Exception ex)                {                    trans.Rollback();//復原事物                    flg = false;                    throw ex;                                   }                finally                {                    trans.Dispose();                }                return flg;            }        }