/// <summary> /// 提交事务 /// </summary> public static void SubmitTrans() { IDbTransaction transaction = HttpContextHelper.Get <IDbTransaction>(HttpContextHelper.DbTransaction); if (transaction != null) { transaction.Commit(); HttpContextHelper.Set(HttpContextHelper.DbTransaction, null); } }
/// <summary> /// 回滚事务 /// </summary> public static void RollBackTrans() { IDbTransaction transaction = HttpContextHelper.Get <IDbTransaction>(HttpContextHelper.DbTransaction); if (transaction != null) { transaction.Rollback(); HttpContextHelper.Set(HttpContextHelper.DbTransaction, null); } }
/// <summary> /// 获取当前上下文中的数据库连接, 要是没有, 则返回新的 /// </summary> /// <param name="create">如果为true会创建</param> /// <param name="type">如果为true会创建</param> /// <returns></returns> public static IDbConnection GetCurrentConnection(bool create = true) { IDbConnection conn = HttpContextHelper.Get <IDbConnection>(HttpContextHelper.DbConn); if (conn == null) { if (create) { return(GetNewConnection()); } return(null); } return(conn); }
/// <summary> /// 获取当前的事务(整个请求全局有效) /// </summary> /// <param name="createNew"></param> /// <param name="type"></param> /// <returns></returns> public static IDbTransaction GetCurrentTransaction(bool createNew = true) { IDbTransaction transaction = HttpContextHelper.Get <IDbTransaction>(HttpContextHelper.DbTransaction); if (transaction == null && createNew) { var conn = GetCurrentConnection(); if (conn.State != ConnectionState.Open) { conn.Open(); } transaction = conn.BeginTransaction(); HttpContextHelper.Set(HttpContextHelper.DbTransaction, transaction); } return(transaction); }