C# OracleDataReader.GetName方法代码示例

 public String ProcessNews()
 {
     using (Logger l = new Logger("PipeCatcher"))
     {
         OraCmd.CommandText = ProcName;
         OraCmd.CommandType = System.Data.CommandType.StoredProcedure;
         OraCmd.Parameters.Clear();
         //OraCmd.Parameters.Add(new OracleParameter("NRECID", OracleDbType.Decimal, System.Data.ParameterDirection.Input)).Value = RecId;
         OraCmd.Parameters.Add(new OracleParameter("REFCURSOR", OracleDbType.RefCursor, System.Data.ParameterDirection.Output));
         if (OraCmd.Connection.State != System.Data.ConnectionState.Closed)
         {
             OraCmd.Connection.Close();
         }
         OraCmd.Connection.Open();
         OraReader = OraCmd.ExecuteReader();
         var str = String.Format("\nCALL {0}", ProcName);
     //                var mainevt = new FlexEvent("PipeCatcher.Call." + ProcName);
     //                mainevt.Arguments.Add("@ProcName", ProcName);
         if (OraReader.HasRows)
         {
             var iRow = 0;
             FlexEvent evt = new FlexEvent("PipeCatcher.Call." + ProcName + ".Row." + (++iRow));
             str += "+++";
             while (OraReader.Read())
             {
                 for (int i = 0; i < OraReader.FieldCount; i++)
                 {
                     evt.Arguments.Add(OraReader.GetName(i), OraReader[i]);
                     str += "\n" + OraReader.GetName(i) + "\t: " + OraReader[i];
                 }
                 str += "\n********************";
     //                        mainevt.Arguments.Add(String.Format("Row{0}", ++iRow), evt);
                 Program.CoreGate.PushEvent(evt);
                 evt.Arguments.Clear();
             }
     //                    Program.CoreGate.PushEvent(mainevt);
         }
         else
         {
             str += "---";
         }
         OraReader.Close();
         l.msg(str);
         return str;
     }
 }

        void ShowResultSet(OracleDataReader reader, OracleCommand command)
        {
            //it is included dbms_output
            command.CommandText = "begin dbms_output.enable (32000); end;";
            command.CommandType = CommandType.Text;
            command.ExecuteNonQuery();

            bool headerPrinted = false;
            int count = 1;
            while (reader.Read())
            {
                if (!headerPrinted)
                {
                    Console.WriteLine(@"<table class=""sqloutput""><tbody><tr><th>&nbsp;&nbsp;</th>");
                    for (int i = 0; i < reader.FieldCount; i++)
                    {
                        string name = reader.GetName(i);
                        Console.WriteLine(@"<th>{0}</th>", string.IsNullOrEmpty(name) ? "(No column name)" : name);
                    }
                    Console.WriteLine("</tr>");
                    headerPrinted = true;
                }
                Console.WriteLine(@"<tr><td>{0}</td>", count++);
                for (int i = 0; i < reader.FieldCount; i++)
                {
                    if (reader[i] == DBNull.Value)
                    {
                        Console.WriteLine(@"<td><i>NULL</i></td>");
                    }
                    else
                    {
                        if (reader[i] as string == null && reader[i] as IEnumerable != null)
                        {
                            string res = "";
                            foreach (var a in (reader[i] as IEnumerable))
                                res += Convert.ToString(a);
                            Console.WriteLine(@"<td>{0}</td>", res);
                        }
                        else
                        {
                            Console.WriteLine(@"<td>{0}</td>", HttpUtility.HtmlEncode(reader[i]));
                        }
                    }
                }
                Console.WriteLine("</tr>");
            }
            if (headerPrinted)
                Console.WriteLine("</tbody></table>");

            // create parameter objects for the anonymous pl/sql block
            int NUM_TO_FETCH = 8;
            OracleParameter p_lines = new OracleParameter("", OracleDbType.Varchar2, NUM_TO_FETCH, "", ParameterDirection.Output);
            p_lines.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
            p_lines.ArrayBindSize = new int[NUM_TO_FETCH];
            // set the bind size value for each element
            for (int i = 0; i < NUM_TO_FETCH; i++)
            {
                p_lines.ArrayBindSize[i] = 32000;
            }

            // this is an input output parameter...
            // on input it holds the number of lines requested to be fetched from the buffer
            // on output it holds the number of lines actually fetched from the buffer
            OracleParameter p_numlines = new OracleParameter("", OracleDbType.Decimal, "", ParameterDirection.InputOutput);
            // set the number of lines to fetch
            p_numlines.Value = NUM_TO_FETCH;
            // set up command object and execute anonymous pl/sql block
            command.CommandText = "begin dbms_output.get_lines(:1, :2); end;";
            command.CommandType = CommandType.Text;
            command.Parameters.Add(p_lines);
            command.Parameters.Add(p_numlines);
            command.ExecuteNonQuery();

            // get the number of lines that were fetched (0 = no more lines in buffer)
            int numLinesFetched = ((OracleDecimal)p_numlines.Value).ToInt32();

            // as long as lines were fetched from the buffer...
            while (numLinesFetched > 0)
            {
                // write the text returned for each element in the pl/sql
                // associative array to the console window
                for (int i = 0; i < numLinesFetched; i++)
                {
                    string out_string = (string)(p_lines.Value as OracleString[])[i];
                    if (!string.IsNullOrEmpty(out_string))
                    {
                        Console.WriteLine(System.Web.HttpUtility.HtmlEncode(out_string));
                    }
                }

                // re-execute the command to fetch more lines (if any remain)
                command.ExecuteNonQuery();
                // get the number of lines that were fetched (0 = no more lines in buffer)
                numLinesFetched = ((OracleDecimal)p_numlines.Value).ToInt32();
            }
            // clean up

            p_numlines.Dispose();
            p_lines.Dispose();
        }

 public String ProcessNews()
 {
     using (Logger l = new Logger("PipeCatcher"))
     {
         OraCmd.CommandText = ProcName;
         OraCmd.CommandType = System.Data.CommandType.StoredProcedure;
         OraCmd.Parameters.Clear();
         OraCmd.Parameters.Add(new OracleParameter("NRECID", OracleDbType.Decimal, System.Data.ParameterDirection.Input)).Value = RecId;
         OraCmd.Parameters.Add(new OracleParameter("REFCURSOR", OracleDbType.RefCursor, System.Data.ParameterDirection.Output));
        // OraCmd.Parameters["NRECID"].Value = RecId;
         if (OraCmd.Connection.State != System.Data.ConnectionState.Closed)
         {
             OraCmd.Connection.Close();
         }
         OraCmd.Connection.Open();
         OraReader = OraCmd.ExecuteReader();
         var str = String.Format("\nCALL {0}({1})", ProcName, RecId);
         if (OraReader.HasRows)
         {
             var f = new FlexHelper("PipeCatcher.Call." + ProcName);
             str += "+++";
             OraReader.Read();
             f.AddArg("@ProcName", ProcName);
             for (int i = 0; i < OraReader.FieldCount; i++)
             {
                 f.AddArg(OraReader.GetName(i), OraReader[i]);
                 str += "\n" + OraReader.GetName(i) + "\t: " + OraReader[i];
             }
             f.Fire(Program.CoreGate);
         }
         else
         {
             str += "---";
         }
         OraReader.Close();
         return str;
     }
 }

        public IEnumerable<Dictionary<string, object>> Serialize(OracleDataReader reader)
        {
            var results = new List<Dictionary<string, object>>();
            var cols = new List<string>();
            for (var i = 0; i < reader.FieldCount; i++)
            {
                if (!cols.Contains(reader.GetName(i)))
                {
                    cols.Add(reader.GetName(i));
                }

            }

            while (reader.Read())
            {
                results.Add(SerializeRow(cols, reader));
            }

            return results;
        }