Ejemplo n.º 1
0
        /// <summary>
        /// 有返回值的 访问数据库方法
        /// </summary>
        /// <typeparam name="TReturn">返回类型</typeparam>
        /// <param name="delegate">数据库方法</param>
        /// <param name="beginTrans">是否开启事务,默认不开启</param>
        /// <param name="connConfigName">配置连接字符串的Name</param>
        /// <returns>方法返回值</returns>
        protected TReturn BeginDb <TReturn>(DbDelegate <TReturn> @delegate)
        {
            using IDbConnection conn = GetConnection;
            DbHelper dbhelper = new DbHelper(conn);
            TDAL     dal      = Activator.CreateInstance(typeof(TDAL), dbhelper) as TDAL;

            try
            {
                return(@delegate.Invoke(dal));
            }
            catch (Exception)
            {
                dbhelper.RollbackTrans();
                dbhelper.Dispose();
                throw;
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 没有返回值的 访问数据库方法
        /// </summary>
        /// <param name="delegate">数据库方法</param>
        /// <param name="beginTrans">是否开启事务,默认不开启</param>
        /// <param name="connConfigName">配置连接字符串的Name</param>
        protected void BeginDb(DbDelegate @delegate)
        {
            using IDbConnection conn = GetConnection;
            DbHelper dbhelper = new DbHelper(conn);
            TDAL     dal      = Activator.CreateInstance(typeof(TDAL), dbhelper) as TDAL;

            try
            {
                @delegate?.Invoke(dal);
            }
            catch (Exception ex)
            {
                dbhelper.RollbackTrans();
                dbhelper.Dispose();
                throw;
            }
        }