public void UpdateCompany(MebCompanyPrepay company, BusiLog busiLog) { using (SqlConnection conn = ConnectionPool.BorrowConnection()) { //conn.Open(); SqlTransaction trans = conn.BeginTransaction(); try { MebCompanyPrepayAccess.UpdateCompany(trans, company); //FillFeeAccess.AddFee(trans,fee); MemberAccess.UpdateMemberCompany(trans, company); BusiLogAccess.AddBusiLog(trans, busiLog); trans.Commit(); } catch (SqlException sex) { trans.Rollback(); throw sex; } catch (Exception ex) { trans.Rollback(); throw ex; } finally { ConnectionPool.ReturnConnection(conn); } } }