private static void TestConvertTable2CsvString() { ConvertCSV csv = new ConvertCSV(); foreach(string line in csv.ConvertTable2CsvString(makeTargetTable())){ Console.WriteLine("{0}", line); } }
public static void Main(string[] args) { string filename = FileName(args); Access acc = new Access(filename); // Lists tables = acc.Tables(); displayList(tables); string itemString = inputListNumbers("選択Table ==> "); Console.WriteLine("選択された値 ===>> {0}", itemString); Lists ll = selectedList(tables, itemString); // if(ll.Count == 0) return; Dictionary<string, Lists> dicColumns = new Dictionary<string, Lists>(); Dictionary<string, string> dicSelectedItem = new Dictionary<string, string>(); // foreach(string table in ll){ acc.TableName = table; List<string> items = acc.Columns(); displayList(items); dicColumns[table] = items; dicSelectedItem[table] = inputListNumbers("選択するItems ==> "); Console.WriteLine(dicSelectedItem[table]); } foreach(string table in dicColumns.Keys){ ConvertCSV csv = new ConvertCSV(); Lists list = csv.ConvertTable2CsvString( acc.getDataTable(filename, table, selectedList(dicColumns[table], dicSelectedItem[table]))); selectedList(dicColumns[table], dicSelectedItem[table]).ForEach( delegate(string name){ Console.WriteLine(name); } ); ExportFile file = new ExportFile(table+".csv", list); Thread th = new Thread(new ThreadStart(file.ExportList)); th.Start(); } }