Ejemplo n.º 1
0
        private void ParseFile(string[] dataTypes, string[] fieldNames,
                               int lineIndexToBeginRead, string pattern)
        {
            if (debugOutput)
            {
                Console.WriteLine("reading " + this.Filename);
            }

            if (lines.Length <= 0 || lineIndexToBeginRead >= lines.Length)
            {
                return;
            }


            DataRow myDataRow;

            widths   = new int[dataTypes.Length];
            decimals = new int[dataTypes.Length];

            Debug.Assert(fieldNames.Length == dataTypes.Length,
                         "Error: in " + "'" + Filename + "'",
                         "line 1:" + lines[0] + "\n" + "line 2:" + lines[1]);
            int patternMatchFailureCount = 0;

            //int i;
            CreateColumns(dataTypes, fieldNames);

            int       col = 0;
            int       row = lineIndexToBeginRead;
            DataRowIO io  = new DataRowIO(true);

            try
            {
                for (; row < lines.Length; row++)
                {
                    if (lines[row].Trim() == "")
                    {
                        continue;
                    }
                    if (pattern != "" && !Regex.IsMatch(lines[row], pattern))
                    {
                        patternMatchFailureCount++;
                        continue;
                    }


                    string[] val = CsvFile.ParseCSV(lines[row]);

                    myDataRow = this.NewRow();


                    for (col = 0; col < fieldNames.Length; col++)
                    {
                        if (col >= val.Length)
                        {
                            myDataRow[col] = DBNull.Value;
                            continue;
                        }

                        switch (dataTypes[col])
                        {
                        case "System.Int32":
                            io.SaveInt(myDataRow, fieldNames[col], val[col]);
                            break;

                        case "System.Int16":
                            io.SaveInt(myDataRow, fieldNames[col], val[col]);
                            break;

                        case "System.Integer":
                            io.SaveInt(myDataRow, fieldNames[col], val[col]);
                            break;

                        case "System.Double":
                            io.SaveDouble(myDataRow, fieldNames[col], val[col]);
                            break;

                        case "System.Single":
                            io.SaveFloat(myDataRow, fieldNames[col], val[col]);
                            break;

                        case "System.String":
                            myDataRow[col] = val[col];
                            break;

                        case "System.DateTime":
                            myDataRow[col] = Convert.ToDateTime(val[col]);
                            break;

                        case "System.Boolean":
                            if (val[col].ToString() == "")
                            {
                                myDataRow[col] = DBNull.Value;
                            }
                            else
                            {
                                if (val[col].ToString() == "0")
                                {
                                    myDataRow[col] = false;
                                }
                                else if (val[col].ToString() == "1")
                                {
                                    myDataRow[col] = true;
                                }
                                else
                                {
                                    myDataRow[col] = Convert.ToBoolean(val[col]);
                                }
                            }
                            break;

                        default:
                            Console.WriteLine("Invalid selection : '" + dataTypes[col] + "'");
                            break;
                        }
                    }
                    this.Rows.Add(myDataRow);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                if (lines.Length < row)
                {
                    Console.WriteLine("'" + lines[row] + "'");
                }
                throw new Exception("Error reading data at row " + row + "  and column " + col + "  file name =  " + this.Filename);
            }

            if (patternMatchFailureCount > 0)
            {
                Logger.WriteLine(patternMatchFailureCount + " lines skipped that did not match pattern " + pattern);
            }
            if (io.Messages.Trim().Length > 0)
            {
                Logger.WriteLine(io.Messages);
            }
        }
Ejemplo n.º 2
0
        private void ParseFile(string[] dataTypes, string[] fieldNames, 
            int lineIndexToBeginRead, string pattern)
        {
            if (debugOutput)
                Console.WriteLine("reading " + this.Filename);

            if (lines.Length <= 0 || lineIndexToBeginRead >= lines.Length)
            {
                return;
            }

            DataRow myDataRow;

            widths = new int[dataTypes.Length];
            decimals = new int[dataTypes.Length];

            Debug.Assert(fieldNames.Length == dataTypes.Length,
                       "Error: in " + "'" + Filename + "'",
                       "line 1:" + lines[0] + "\n" + "line 2:" + lines[1]);
            int patternMatchFailureCount = 0;
            //int i;
            CreateColumns(dataTypes, fieldNames);

            int col = 0;
            int row = lineIndexToBeginRead;
            DataRowIO io = new DataRowIO(true);
            try
            {
                for (; row < lines.Length; row++)
                {

                    if (lines[row].Trim() == "")
                    {
                        continue;
                    }
                    if (pattern != "" && !Regex.IsMatch(lines[row], pattern))
                    {
                        patternMatchFailureCount++;
                        continue;
                    }

                    string[] val = CsvFile.ParseCSV(lines[row]);

                    myDataRow = this.NewRow();

                    for (col = 0; col < fieldNames.Length; col++)
                    {
                        if (col >= val.Length)
                        {
                            myDataRow[col] = DBNull.Value;
                            continue;
                        }

                        switch (dataTypes[col])
                        {
                            case "System.Int32":
                                io.SaveInt(myDataRow, fieldNames[col], val[col]);
                                break;
                            case "System.Int16":
                                io.SaveInt(myDataRow, fieldNames[col], val[col]);
                                break;
                            case "System.Integer":
                                io.SaveInt(myDataRow, fieldNames[col], val[col]);
                                break;
                            case "System.Double":
                                io.SaveDouble(myDataRow, fieldNames[col], val[col]);
                                break;
                            case "System.Single":
                                io.SaveFloat(myDataRow, fieldNames[col], val[col]);
                                break;
                            case "System.String":
                                myDataRow[col] = val[col];
                                break;
                            case "System.DateTime":
                                myDataRow[col] = Convert.ToDateTime(val[col]);
                                break;
                            case "System.Boolean":
                                if (val[col].ToString() == "")
                                    myDataRow[col] = DBNull.Value;
                                else
                                {
                                    if (val[col].ToString() == "0")
                                        myDataRow[col] = false;
                                    else if (val[col].ToString() == "1")
                                        myDataRow[col] = true;
                                    else
                                    myDataRow[col] = Convert.ToBoolean(val[col]);
                                }
                                break;
                            default:
                                Console.WriteLine("Invalid selection : '" + dataTypes[col] + "'");
                                break;
                        }
                    }
                    this.Rows.Add(myDataRow);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                if (lines.Length < row)
                {
                    Console.WriteLine("'" + lines[row] + "'");
                }
                throw new Exception("Error reading data at row " + row + "  and column " + col + "  file name =  " + this.Filename);
            }

            if (patternMatchFailureCount > 0)
            {
                Logger.WriteLine(patternMatchFailureCount + " lines skipped that did not match pattern " + pattern);
            }
            if( io.Messages.Trim().Length >0)
              Logger.WriteLine(io.Messages);
        }