/// <summary>
/// 加载数据表
/// </summary>
/// <param name="connectionName"></param>
private void LoadTable(String connectionName)
{
// 加载数据库
nowConnectionName = connectionName;
var dal = new DbConnConfigDAL();
var model = dal.FindOne(connectionName);
this.nowDbSchema = DbSchemaFactory.Create(new MySqlDatabase(model.ConnectionString, MySqlClientFactory.Instance));
try
{
nowDb = this.nowDbSchema.GetDatabase(model.DefaultDb);
}
catch (Exception e1)
{
MsgBox.ShowErrorMessage("数据库打开失败:" + e1.Message);
return;
}
// 加载表
this.listBox1.Items.Clear();
this.listBox2.Items.Clear();
this.unSelectedTableList.Clear();
this.selectedTableList.Clear();
foreach (SOTable t in nowDb.TableList)
{
listBox1.Items.Add(t);
unSelectedTableList.Add(t);
}
}
/// <summary>
/// 加载连接
/// </summary>
private void LoadConnection()
{
var dal = new DbConnConfigDAL();
var connList = dal.FindAll().ToList();
cmbConnectionList.Items.Clear();
foreach (var item in connList)
{
cmbConnectionList.Items.Add(item.Name);
}
var tmpIndex = connList.FindIndex(tmp => tmp.Name == nowConnectionName);
if (tmpIndex >= 0)
{
cmbConnectionList.SelectedIndex = tmpIndex;
LoadTable(connList[tmpIndex].Name);
}
else
{
//清理相关数据
this.listBox1.Items.Clear();
this.listBox2.Items.Clear();
this.unSelectedTableList.Clear();
this.selectedTableList.Clear();
}
}
/// <summary>
/// 创建一个数据提供程序实例
/// </summary>
/// <param name="connectionStringName"></param>
/// <returns></returns>
public static Database Create(string connectionStringName)
{
CheckUtil.ArgumentNotNullOrEmpty(connectionStringName, "connectionStringName");
DbConnConfigDAL dal = new DbConnConfigDAL();
var model = dal.FindOne(connectionStringName);
if (model == null)
{
throw new Exception(string.Format(Resources.Data.ConnectionStringNameNotFound, connectionStringName));
}
string connectionString = model.ConnectionString;
string providerName = model.ProviderName;
Database db = new SqlServerDatabase(connectionString);
DbProviderFactory providerFactory = null;
if (string.IsNullOrEmpty(providerName))
{
return(db);
}
//if (css.ProviderName == "System.Data.OleDb")
//{
// providerFactory = OleDbFactory.Instance;
//}
//else
//{
// providerFactory = DbProviderFactories.GetFactory(css.ProviderName);
//}
//if (providerFactory == null) throw new Exception(string.Format(Resources.Data.DataProviderNotFound, css.ProviderName));
switch (providerName)
{
//case "System.Data.SqlClient":
// break;
case "System.Data.Odbc":
db = new OdbcDatabase(connectionString);
break;
case "System.Data.OleDb":
db = new OleDbDatabase(connectionString);
break;
case "System.Data.SQLite":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new SQLiteDatabase(connectionString, providerFactory);
break;
case "MySql.Data.MySqlClient":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new MySqlDatabase(connectionString, providerFactory);
break;
case "IBM.Data.DB2":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new DB2Database(connectionString, providerFactory);
break;
case "FirebirdSql.Data.FirebirdClient":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new FirebirdDatabase(connectionString, providerFactory);
break;
default:
break;
}
return(db);
}
