private static libs.importOHLCV DoImportRow(LumenWorks.Framework.IO.Csv.CsvReader csv, libs.importStat importStat) { libs.importOHLCV data = new libs.importOHLCV(); if (csv[0] == null) return null; data.code = csv[0]; if (!common.dateTimeLibs.Str2Date(csv[1], importStat.dateFormat, out tmpDate)) return null; data.dateTime = tmpDate; if (!double.TryParse(csv[2], NumberStyles.Number, importStat.culture, out tmpVal)) return null; data.Open = tmpVal; if (!double.TryParse(csv[3], NumberStyles.Number, importStat.culture, out tmpVal)) return null; data.High = tmpVal; if (!double.TryParse(csv[4], NumberStyles.Number, importStat.culture, out tmpVal)) return null; data.Low = tmpVal; if (!double.TryParse(csv[5], NumberStyles.Number, importStat.culture, out tmpVal)) return null; data.Close = tmpVal; if (!double.TryParse(csv[6], NumberStyles.Number, importStat.culture, out tmpVal)) return null; data.Volume = tmpVal; return data; }
public CsvReader(TableInfo structure, LumenWorks.Framework.IO.Csv.CsvReader reader, DataFormatSettings dataFormat) : base(structure) { _reader = reader; _array = new string[structure.ColumnCount]; _dataFormat = dataFormat ?? new DataFormatSettings(); }
private TableInfo GetStructure(LumenWorks.Framework.IO.Csv.CsvReader reader) { var res = new TableInfo(null); if (HasHeaders) { foreach (string col in reader.GetFieldHeaders()) { res.Columns.Add(new ColumnInfo(res) {CommonType = new DbTypeString(), DataType = "nvarchar", Length = -1, Name = col}); } } else { for (int i = 1; i <= reader.FieldCount; i++) { res.Columns.Add(new ColumnInfo(res) { CommonType = new DbTypeString(), DataType = "nvarchar", Length = -1, Name = String.Format("#{0}", i) }); } } return res; }