在業務層中使用事務

在業務層中使用事務,很多專家稱之為輕量級事務,代碼如下,很簡單

 

   public class CompanyBusiness
    {
        private readonly CompanyDao dao = new CompanyDao();
       
        public bool Add(Company company,Rating rating,ref int companyId)
        {
            TransactionOptions options = new TransactionOptions();
            //可以在事務期間讀取可變資料，但是不可以修改。可以在事務期間添加新資料
            options.IsolationLevel = IsolationLevel.RepeatableRead;
            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,options))
            {
                try
                {
                    dao.Add(company, rating,ref companyId);
                    if (company.CategoryId != 0)
                    {
                        new ServiceCategoryBusiness().UpdateServiceCompanyNumber(company.CategoryId);
                    }
                    if (company.AddressId != 0)
                    {
                        new AreaBusiness().UpdateServiceCompanyNumber(company.AddressId);
                    }

                    //提交事務
                    scope.Complete();
                    return true;
                }
                catch(Exception ex)
                {
                    throw ex;
                }
               
            }
               
        }

   }

經測試,在失敗後會自動復原.