private void dbTabsControl_SelectedIndexChanged(Object sender, EventArgs e)
{
string tabName = ((TabControl)sender).SelectedTab.Name;
sqliteLibrary = (SQLiteLibrary)((ArrayList)tabsPointers[tabName])[1];
this.dbFilePath = (string)((ArrayList)tabsPointers[tabName])[2];
this.journalFilePath = (string)((ArrayList)tabsPointers[tabName])[3];
if ((bool)((ArrayList)tabsPointers[tabName])[0])
{
unallocatedResult = (Dictionary <string, ArrayList>)((ArrayList)tabsPointers[tabName])[4];
journalResult = (Dictionary <string, ArrayList>)((ArrayList)tabsPointers[tabName])[5];
}
else
{
showButton = (Button)((TabControl)sender).SelectedTab.Controls["propertisesGroupBox"].Controls["showButton"];
showButton.Enabled = false;
BackgroundWorker worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.ProgressChanged += new ProgressChangedEventHandler(worker_ProgressChanged);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted);
if (worker.IsBusy == false)
{
worker.RunWorkerAsync((ArrayList)tabsPointers[tabName]);
}
}
}
private SQLiteLibrary buildSqliteConnection(string dbFilePath, string dbName)
{
string dbDirName = dbName.Split(new char[] { '.' })[0];
SQLiteLibrary sqlite = new SQLiteLibrary(@"..\workspace\" + dbDirName, dbFilePath, dbName);
return(sqlite);
}
public void CreateDB()
{
try
{
string location = @System.AppDomain.CurrentDomain.BaseDirectory + "database";
/*SQLiteLibrary.CreateDB(location, "peoplemanage.sqlite");*/
System.Data.DataTable dataTable = SQLiteLibrary.selectDataBySql(location, "peoplemanage.sqlite", "select * from OS_ZB_PURCHASE_PROJECT_INFO");
Console.WriteLine("---");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void BuildingRecoverDataTabs(string dbFilePath, string journalFilePath, bool first)
{
string tabName = dbFilePath.Substring(dbFilePath.LastIndexOf(@"\")).Replace(@"\", "");
SQLiteLibrary sqlite = buildSqliteConnection(dbFilePath, tabName);
TabPage tab = BuildNewTabForDBData(tabName, sqlite.getAllTableNames());
ArrayList items = new ArrayList();
items.Add(false);
items.Add(sqlite);
items.Add(dbFilePath);
items.Add(journalFilePath);
tabsPointers.Add(tabName, items);
this.dbTabsControl.SelectedIndexChanged += new EventHandler(dbTabsControl_SelectedIndexChanged);
this.dbTabsControl.Controls.Add(tab);
if (first)
{
dbTabsControl_SelectedIndexChanged(dbTabsControl, null);
}
}
