private bool LoadOptions()
{
_options.Clear();
switch (SourceType)
{
case JoinSourceType.Dbf:
_options = new List <string> {
Path.GetFileNameWithoutExtension(Filename)
};
break;
case JoinSourceType.Xls:
_options = XlsImportHelper.GetWorkbooks(Filename);
break;
case JoinSourceType.Csv:
//string options = ", (comma)", "| (vertical bar)", "; (semicolon)", ": (colon)", "- (hyphen)", "= (equals)", "\' (apostrophe)", "Tab"
_options = new List <string> {
",", "|", ";", ":", "-", "=", "\'", "Tab"
};
break;
default:
return(false);
}
if (Join != null)
{
RestoreSelectedOption(Join.Options);
}
return(_options.Any());
}
/// <summary>
/// Restores join on loading or after saving
/// </summary>
/// <param name="filename">Filename of the datasource to join</param>
/// <param name="fieldList">Csv list of fields</param>
/// <param name="joinOptions">Provider specific options</param>
/// <param name="joinSource">At table to be filled to data source and passed to the ocx</param>
public static void Table_OnUpdateJoin(string filename, string fieldList, string joinOptions, Table joinSource)
{
DataTable dt;
filename = filename.ToLower();
if (filename.EndsWith(".xls") || filename.EndsWith(".xlsx"))
{
dt = XlsImportHelper.GetData(filename, GetOption("workbook", joinOptions));
}
else if (filename.EndsWith(".csv"))
{
dt = CsvImportHelper.GetData(filename, GetOption("separator", joinOptions));
}
else
{
return;
}
DbfImportHelper.FillMapWinGisTable(dt, joinSource);
}
private bool ReloadExternal(IAttributeTable table)
{
switch (SourceType)
{
case JoinSourceType.Dbf:
if (!table.Open(Filename))
{
return(false);
}
break;
case JoinSourceType.Xls:
{
var dt = XlsImportHelper.GetData(Filename, SelectedOption);
if (dt == null)
{
return(false);
}
DbfImportHelper.FillMapWinGisTable(dt, table);
}
break;
case JoinSourceType.Csv:
{
var dt = CsvImportHelper.GetData(Filename, SelectedOption);
if (dt == null)
{
return(false);
}
DbfImportHelper.FillMapWinGisTable(dt, table);
}
break;
default:
return(false);
}
return(true);
}
