/// <summary>
        /// SQL语句执行方法。
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns></returns>
        public int ExecuteNonQuery(string strSQL)
        {
            int           val = 0;
            OracleCommand cmd = new OracleCommand();

            cmd.CommandType = CommandType.Text;
            cmd.CommandText = strSQL;
            using (OracleConnection conn = OracleConnHelper.getConn())
            {
                cmd.Connection = conn;
                try
                {
                    val = cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString(), "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    cmd.Dispose();
                    OracleConnHelper.closeConn(conn);
                }
                return(val);
            }
        }
        /// <summary>
        /// 存储过程执行方法,传入参数集合。
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="cmdParms"></param>
        /// <returns></returns>
        public int ExecuteNonQuery(string procName, OracleParameter[] cmdParms)
        {
            int           val = 0;
            OracleCommand cmd = new OracleCommand();

            cmd.CommandType = CommandType.StoredProcedure;
            using (OracleConnection conn = OracleConnHelper.getConn())
            {
                CreateCommand(cmd, conn, null, procName, cmdParms);
                try
                {
                    val = cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString(), "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    cmd.Parameters.Clear();
                    cmd.Dispose();
                    OracleConnHelper.closeConn(conn);
                }
                return(val);
            }
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="cmdParams"></param>
        /// <returns></returns>
        public DataTable getDT(string procName, OracleParameter[] cmdParams)
        {
            OracleCommand cmd = new OracleCommand();

            cmd.CommandType = CommandType.StoredProcedure;
            using (OracleConnection conn = OracleConnHelper.getConn()) {
                CreateCommand(cmd, conn, null, procName, cmdParams);
                try
                {
                    OracleDataReader odr = cmd.ExecuteReader();
                    DataTable        dt  = new DataTable();
                    dt.Load(odr);
                    return(dt);
                }
                catch (Exception ex)
                {
                    //MessageBox.Show(ex.ToString(), "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    cmd.Parameters.Clear();
                    cmd.Dispose();
                    OracleConnHelper.closeConn(conn);
                }
            }
        }