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();
}
}
private static void TestConvertTable2CsvStringBuilder()
{
ConvertCSV csv = new ConvertCSV();
Console.Write("{0}", csv.ConvertTable2CsvStringBuilder(makeTargetTable()).ToString());
}
