예제 #1
0
 public static void Print(this DataTable dataTable, int top, ValueToStringHandler toString, params string[] columnNames)
 {
     Print(dataTable, false, top, toString, columnNames);
 }
예제 #2
0
        private static void PrintListRow(IEnumerable <DataRow> rows, DataColumn[] columns, object[] objects, string format, bool rowOrdinals, ValueToStringHandler toString, string ordinalColumnName)
        {
            if (rowOrdinals)
            {
                IEnumerable <int> ordinals = null;
                if (string.IsNullOrEmpty(ordinalColumnName))
                {
                    ordinals = rows.Select(row => row.Table.Rows.IndexOf(row));
                }
                else
                {
                    ordinals = rows.Select(row => (int)row[ordinalColumnName]);
                }

                objects[0] = "Ordinal";
                int k = 1;
                foreach (int ordinal in ordinals)
                {
                    objects[k++] = (ordinal > -1 ? ordinal : (int?)null);
                }
                WriteLine(format, objects);
            }

            for (int i = 0; i < columns.Length; i++)
            {
                objects[0] = columns[i].ColumnName;

                int k = 1;
                foreach (DataRow row in rows)
                {
                    object obj = row[columns[i]];

                    string str = null;
                    if (toString != null)
                    {
                        str = toString(obj, row, columns[i]);
                        if (str == null)
                        {
                            str = "null";
                        }
                    }
                    else
                    {
                        str = string.Format("{0}", (obj == DBNull.Value || obj == null ? "null" : obj));
                    }

                    objects[k++] = str;
                }

                WriteLine(format, objects);
            }
        }
예제 #3
0
 public static void Print(this DataTable dataTable, bool rowOrdinals, ValueToStringHandler toString, params string[] columnNames)
 {
     Print(dataTable, rowOrdinals, 0, toString, columnNames);
 }
예제 #4
0
        private static void PrintListRows(DataTable dataTable, IEnumerable <DataRow> dataRows, bool rowOrdinals, int top, ValueToStringHandler toString, int repeatColumns, RepeatDirection repeatDirection, string delimiter, string[] columnNames, string ordinalColumnName = null)
        {
            if (dataTable != null && string.IsNullOrEmpty(dataTable.TableName) == false)
            {
                WriteLine("{0}:", dataTable.TableName);
            }

            if (dataRows.Count() == 0)
            {
                WriteLine("No rows were selected");
                WriteLine();
                return;
            }

            DataColumn[] columns = GetColumns(dataTable, columnNames, ordinalColumnName);
            if (columns.Length == 0)
            {
                WriteLine("No columns were selected");
                WriteLine();
                return;
            }

            if (top > 0)
            {
                dataRows = dataRows.Take(top);
            }

            int columnsLength = columns.Select(c => c.ColumnName.Length).Max();

            int[] lengths = new int[columns.Length];
            foreach (DataRow row in dataRows)
            {
                CalculateLengths(row, columns, lengths, toString);
            }
            int rowsLength = lengths.Max();

            if (rowOrdinals)
            {
                if (dataRows.Count() > 0)
                {
                    if (columnsLength < 7) // "Ordinal".Length
                    {
                        columnsLength = 7;
                    }

                    int maxRowOrdinal = 0;
                    if (string.IsNullOrEmpty(ordinalColumnName))
                    {
                        maxRowOrdinal = dataRows.Select(row => row.Table.Rows.IndexOf(row)).Max();
                    }
                    else
                    {
                        maxRowOrdinal = dataRows.Select(row => (int)row[ordinalColumnName]).Max();
                    }

                    if (maxRowOrdinal > -1)
                    {
                        int rowOrdinalsLength = maxRowOrdinal.ToString().Length;
                        if (rowsLength < rowOrdinalsLength)
                        {
                            rowsLength = rowOrdinalsLength;
                        }
                    }
                }
            }

            if (repeatColumns < 1)
            {
                repeatColumns = 1;
            }

            if (repeatColumns > dataRows.Count())
            {
                repeatColumns = dataRows.Count();
            }

            int lastRowFilledCellsCount = dataRows.Count() % repeatColumns;

            if (lastRowFilledCellsCount == 0)
            {
                lastRowFilledCellsCount = repeatColumns;
            }
            int lastRowEmptyCellsCount = repeatColumns - lastRowFilledCellsCount;
            int rowsCount = (dataRows.Count() / repeatColumns) + (dataRows.Count() % repeatColumns > 0 ? 1 : 0);

            if (delimiter == null)
            {
                delimiter = string.Empty;
            }

            string cellFormat = string.Format(" {{{{0,-{0}}}}}{1}{{{{{{0}},-{2}}}}} {3}", columnsLength, delimiter, rowsLength, Verticl_Bar);
            string horizontal = new String(Horizontal_Bar, columnsLength + delimiter.Length + rowsLength + 2);

            string header    = Top_Left.ToString();
            string separator = Middle_Left.ToString();
            string footer    = Bottom_Left.ToString();
            string format    = Verticl_Bar.ToString();

            int k = 0;

            for (; k < repeatColumns - 1; k++)
            {
                header    += horizontal + Top_Center;
                separator += horizontal + Middle_Center;
                footer    += horizontal + Bottom_Center;
                format    += string.Format(cellFormat, k + 1);
            }

            k = repeatColumns - 1;
            if (k >= 0)
            {
                header    += horizontal + Top_Right;
                separator += horizontal + Middle_Right;
                footer    += horizontal + Bottom_Right;
                format    += string.Format(cellFormat, k + 1);
            }

            string formatPartial = format;

            if (lastRowEmptyCellsCount > 0)
            {
                formatPartial = Verticl_Bar.ToString();
                for (int i = 0; i < lastRowFilledCellsCount; i++)
                {
                    formatPartial += string.Format(cellFormat, i + 1);
                }
                for (int i = 0; i < lastRowEmptyCellsCount; i++)
                {
                    formatPartial += new String(' ', columnsLength + delimiter.Length + rowsLength + 2) + Verticl_Bar;
                }
            }

            object[] objects = new object[repeatColumns + 1];

            if (repeatDirection == RepeatDirection.Horizontal)
            {
                for (int i = 0; i < rowsCount; i++)
                {
                    WriteLine(i == 0 ? header : separator);
                    var rows = dataRows.Skip(i * repeatColumns).Take(repeatColumns);
                    PrintListRow(rows, columns, objects, (i < rowsCount - 1 ? format : formatPartial), rowOrdinals, toString, ordinalColumnName);
                }
            }
            else if (repeatDirection == RepeatDirection.Vertical && lastRowEmptyCellsCount == 0)
            {
                for (int i = 0; i < rowsCount; i++)
                {
                    WriteLine(i == 0 ? header : separator);
                    var rows = dataRows.Where((r, n) => n % rowsCount == i);
                    PrintListRow(rows, columns, objects, (i < rowsCount - 1 ? format : formatPartial), rowOrdinals, toString, ordinalColumnName);
                }
            }
            else if (repeatDirection == RepeatDirection.Vertical && lastRowEmptyCellsCount > 0)
            {
                for (int i = 0; i < rowsCount; i++)
                {
                    WriteLine(i == 0 ? header : separator);
                    var rows = dataRows.Where((r, n) =>
                                              (n < lastRowFilledCellsCount * rowsCount && n % rowsCount == i) ||
                                              (n >= lastRowFilledCellsCount * rowsCount && (n - (lastRowFilledCellsCount * rowsCount)) % (rowsCount - 1) == i)
                                              );
                    PrintListRow(rows, columns, objects, (i < rowsCount - 1 ? format : formatPartial), rowOrdinals, toString, ordinalColumnName);
                }
            }

            WriteLine(footer);

            WriteLine();
        }
예제 #5
0
        private static void PrintListRows(DataView dataView, bool rowOrdinals, int top, ValueToStringHandler toString, int repeatColumns, RepeatDirection repeatDirection, string delimiter, string[] columnNames)
        {
            string    ordinalColumnName = null;
            DataTable dataTable         = GetTableFromView(dataView, rowOrdinals, top, ref ordinalColumnName);

            PrintListRows(dataTable, dataTable.AsEnumerable(), rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames, ordinalColumnName);
        }
예제 #6
0
 public static void Print(this DataSet dataSet, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames)
 {
     foreach (DataTable dataTable in dataSet.Tables)
     {
         Print(dataTable, rowOrdinals, top, toString, columnNames);
     }
 }
예제 #7
0
 public static void PrintList(this DataRow[] dataRows, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, int repeatColumns = 2, RepeatDirection repeatDirection = RepeatDirection.Vertical, string delimiter = ": ", params string[] columnNames)
 {
     PrintListRows((dataRows.Length != 0 ? dataRows[0].Table : null), dataRows, rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames);
 }
예제 #8
0
 public static void PrintList(this DataSet dataSet, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, int repeatColumns = 2, RepeatDirection repeatDirection = RepeatDirection.Vertical, string delimiter = ": ", params string[] columnNames)
 {
     foreach (DataTable dataTable in dataSet.Tables)
     {
         PrintList(dataTable, rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames);
     }
 }
예제 #9
0
 public static void PrintList(this DataRow[] dataRows, bool rowOrdinals, ValueToStringHandler toString, params string[] columnNames)
 {
     PrintList(dataRows, rowOrdinals, 0, toString, columnNames: columnNames);
 }
예제 #10
0
 public static void PrintList(this DataView dataView, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, int repeatColumns = 2, RepeatDirection repeatDirection = RepeatDirection.Vertical, string delimiter = ": ", params string[] columnNames)
 {
     PrintListRows(dataView, rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames);
 }
예제 #11
0
 public static void PrintList(this DataSet dataSet, ValueToStringHandler toString, params string[] columnNames)
 {
     PrintList(dataSet, false, 0, toString, columnNames: columnNames);
 }
예제 #12
0
        private static void CalculateLengths(DataRow row, DataColumn[] columns, int[] lengths, ValueToStringHandler toString)
        {
            for (int i = 0; i < columns.Length; i++)
            {
                object obj = row[columns[i]];

                string str = null;
                if (toString != null)
                {
                    str = toString(obj, row, columns[i]);
                    if (str == null)
                    {
                        str = "null";
                    }
                }
                else
                {
                    str = string.Format("{0}", (obj == DBNull.Value || obj == null ? "null" : obj));
                }

                if (lengths[i] < str.Length)
                {
                    lengths[i] = str.Length;
                }
            }
        }
예제 #13
0
        private static void PrintRows(DataTable dataTable, IEnumerable <DataRow> dataRows, bool rowOrdinals, int top, ValueToStringHandler toString, string[] columnNames, string ordinalColumnName = null)
        {
            if (dataTable == null && dataRows.Count() == 0)
            {
                WriteLine("No rows were selected");
                WriteLine();
                return;
            }

            if (dataTable != null && string.IsNullOrEmpty(dataTable.TableName) == false)
            {
                WriteLine("{0}:", dataTable.TableName);
            }

            DataColumn[] columns = GetColumns(dataTable, columnNames, ordinalColumnName);
            if (columns.Length == 0)
            {
                WriteLine("No columns were selected");
                WriteLine();
                return;
            }

            if (top > 0)
            {
                dataRows = dataRows.Take(top);
            }

            int[] lengths = columns.Select(c => c.ColumnName.Length).ToArray();
            foreach (DataRow row in dataRows)
            {
                CalculateLengths(row, columns, lengths, toString);
            }

            int rowOrdinalsLength = 0;

            if (rowOrdinals)
            {
                if (dataRows.Count() > 0)
                {
                    int maxRowOrdinal = 0;
                    if (string.IsNullOrEmpty(ordinalColumnName))
                    {
                        maxRowOrdinal = dataRows.Select(row => row.Table.Rows.IndexOf(row)).Max();
                    }
                    else
                    {
                        maxRowOrdinal = dataRows.Select(row => (int)row[ordinalColumnName]).Max();
                    }

                    if (maxRowOrdinal > -1)
                    {
                        rowOrdinalsLength = maxRowOrdinal.ToString().Length;
                    }
                }
            }

            string header        = Top_Left.ToString();
            string separator     = Middle_Left.ToString();
            string footer        = Bottom_Left.ToString();
            string formatHeaders = Verticl_Bar.ToString();
            string format        = Verticl_Bar.ToString();

            if (rowOrdinals)
            {
                string horizontal = new String(Horizontal_Bar, rowOrdinalsLength + 2);
                header        += horizontal + Top_Center;
                separator     += horizontal + Middle_Center;
                footer        += horizontal + Bottom_Center;
                formatHeaders += string.Format(" {{0,-{0}}} {1}", rowOrdinalsLength, Verticl_Bar);
                format        += string.Format(" {{0,{0}}} {1}", rowOrdinalsLength, Verticl_Bar);
            }

            int k = 0;

            for (; k < columns.Length - 1; k++)
            {
                string horizontal = new String(Horizontal_Bar, lengths[k] + 2);
                header    += horizontal + Top_Center;
                separator += horizontal + Middle_Center;
                footer    += horizontal + Bottom_Center;

                string cellFormat = string.Format(" {{{0},-{1}}} {2}", k + 1, lengths[k], Verticl_Bar);
                formatHeaders += cellFormat;
                format        += cellFormat;
            }

            k = columns.Length - 1;
            if (k >= 0)
            {
                string horizontal = new String(Horizontal_Bar, lengths[k] + 2);
                header    += horizontal + Top_Right;
                separator += horizontal + Middle_Right;
                footer    += horizontal + Bottom_Right;

                string cellFormat = string.Format(" {{{0},-{1}}} {2}", k + 1, lengths[k], Verticl_Bar);
                formatHeaders += cellFormat;
                format        += cellFormat;
            }

            object[] objects = new object[columns.Length + 1];

            WriteLine(header);

            objects[0] = string.Empty;
            for (int i = 0; i < columns.Length; i++)
            {
                objects[i + 1] = columns[i];
            }
            WriteLine(formatHeaders, objects);

            WriteLine(separator);

            foreach (DataRow row in dataRows)
            {
                if (rowOrdinals)
                {
                    int ordinal = 0;
                    if (string.IsNullOrEmpty(ordinalColumnName))
                    {
                        ordinal = row.Table.Rows.IndexOf(row);
                    }
                    else
                    {
                        ordinal = (int)row[ordinalColumnName];
                    }
                    objects[0] = (ordinal > -1 ? ordinal : (int?)null);
                }

                for (int i = 0; i < columns.Length; i++)
                {
                    object obj = row[columns[i]];

                    string str = null;
                    if (toString != null)
                    {
                        str = toString(obj, row, columns[i]);
                        if (str == null)
                        {
                            str = "null";
                        }
                    }
                    else
                    {
                        str = string.Format("{0}", (obj == DBNull.Value || obj == null ? "null" : obj));
                    }

                    objects[i + 1] = str;
                }

                WriteLine(format, objects);
            }

            WriteLine(footer);

            WriteLine();
        }
예제 #14
0
 public static void Print(this DataRow[] dataRows, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames)
 {
     PrintRows((dataRows.Length != 0 ? dataRows[0].Table : null), dataRows, rowOrdinals, top, toString, columnNames);
 }
예제 #15
0
 public static void Print(this DataTable dataTable, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames)
 {
     PrintRows(dataTable, dataTable.AsEnumerable(), rowOrdinals, top, toString, columnNames);
 }
예제 #16
0
 public static void PrintList(this DataRow[] dataRows, int top, ValueToStringHandler toString, params string[] columnNames)
 {
     PrintList(dataRows, false, top, toString, columnNames: columnNames);
 }
예제 #17
0
 public static void Print(this DataView dataView, ValueToStringHandler toString, params string[] columnNames)
 {
     Print(dataView, false, 0, toString, columnNames);
 }
예제 #18
0
 public static void Print(this DataView dataView, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames)
 {
     PrintRows(dataView, rowOrdinals, top, toString, columnNames);
 }