Beispiel #1
0
        // <summary>
        /// 执行多条SQL语句,实现数据库事务。
        /// </summary>
        /// <param name="p_ArrListSqls">多条SQL语句</param>
        /// <returns>是否成功</returns>
        public bool ExecuteSqlTran(ArrayList p_ArrListSqls)
        {
            try
            {
                switch (m_dbType)
                {
                case EnumDbType.DbOracle:
                    DbHelperOra.ExecuteSqlTran(p_ArrListSqls);
                    break;

                case EnumDbType.DbSqlServer:
                    DbHelperSql.ExecuteSqlTran(p_ArrListSqls);
                    break;

                case EnumDbType.DbOleDb:
                    DbHelperOledb.ExecuteSqlTran(p_ArrListSqls);
                    break;

                default:
                    DbHelperOra.ExecuteSqlTran(p_ArrListSqls);
                    break;
                }
            }
            catch (Exception exp)
            {
                m_strError = exp.Message;
                return(false);
            }
            return(true);
        }