public static Manager CreareManagerUseAccess(string fileName, string password)
{
AccessDataProvider p = new AccessDataProvider();
p.FileName = fileName;
p.Password = password;
return(new Manager(p));
}
private static IEnumerable <object[]> getAccessData()
{
AccessDataProvider testdata = new AccessDataProvider();
//Iterate through retrieved table rows
foreach (Hashtable row in testdata.getAccesslData())
{
yield return(new object[] { row });
}
}
static DataProvider()
{
DataProvider dataProvider;
if (FrameWork.Common.GetDBType == "MsSql")
dataProvider = new SqlDataProvider();
else if (FrameWork.Common.GetDBType == "Access")
dataProvider = new AccessDataProvider();
else
throw new ApplicationException("数据库配置不对！");
_defaultInstance = dataProvider;
}
static DataProvider()
{
DataProvider dataProvider;
if (Common.GetDBType == "MsSql")
{
dataProvider = new SqlDataProvider();
}
else if (Common.GetDBType == "Access")
{
dataProvider = new AccessDataProvider();
}
else if (Common.GetDBType == "Oracle")
{
dataProvider = new OracleDataProvider();
}
else
{
throw new ApplicationException("数据库配置不对！");
}
_defaultInstance = dataProvider;
}
/// <summary>
/// Get connection string of EA database
/// </summary>
/// <param name="rep"></param>
/// <param name="provider"></param>
/// <returns></returns>
/// string dsnName = "DSN=MySqlEa;Trusted_Connection=Yes;";
// dsnName = "DSN=MySqlEa;";
public static string GetConnectionString(EA.Repository rep, out IDataProvider provider)
{
provider = null;
var(connectionString, dbType) = GetConnectionStringFromRepository(rep);
string dsnConnectionString;
// EAP file
// Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\hoData\Work.eap;"
switch (dbType)
{
case "JET":
provider = new AccessDataProvider();
dsnConnectionString = GetConnectionStringForDsn(connectionString);
if (dsnConnectionString != "")
{
return(dsnConnectionString);
}
if (connectionString.ToLower().EndsWith(".eap") || connectionString.ToLower().EndsWith(".eapx"))
{
return($"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={connectionString};");
}
break;
case @"SQLSVR":
provider = new SqlServerDataProvider("", SqlServerVersion.v2012);
dsnConnectionString = GetConnectionStringForDsn(connectionString);
if (dsnConnectionString != "")
{
return(dsnConnectionString);
}
return(FilterConnectionString(connectionString));
case "MYSQL":
provider = new MySqlDataProvider();
dsnConnectionString = GetConnectionStringForDsn(connectionString);
if (dsnConnectionString != "")
{
return(dsnConnectionString);
}
return(FilterConnectionString(connectionString));
case "ACCESS2007":
provider = new AccessDataProvider();
dsnConnectionString = GetConnectionStringForDsn(connectionString);
if (dsnConnectionString != "")
{
return(dsnConnectionString);
}
return(FilterConnectionString(connectionString));
case "ASA":
provider = new SybaseDataProvider();
dsnConnectionString = GetConnectionStringForDsn(connectionString);
if (dsnConnectionString != "")
{
return(dsnConnectionString);
}
return(FilterConnectionString(connectionString));
case "ORACLE":
provider = new OracleDataProvider();
dsnConnectionString = GetConnectionStringForDsn(connectionString);
if (dsnConnectionString != "")
{
return(dsnConnectionString);
}
return(FilterConnectionString(connectionString));
case "POSTGRES":
provider = new PostgreSQLDataProvider();
dsnConnectionString = GetConnectionStringForDsn(connectionString);
if (dsnConnectionString != "")
{
return(dsnConnectionString);
}
return(FilterConnectionString(connectionString));
}
MessageBox.Show($"Database: {rep.RepositoryType()}\r\nConnectionString:{connectionString} ", "DataBase not supported, only Access (*.eap/*.eapx), SqlServer and MySQL");
return("");
}
