/// <summary>
/// 按数据类型获取数据库访问实现类
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <returns>数据库访问实现类</returns>
public static string GetDbHelperClass(DbTypeName dbType)
{
string returnValue = "DotNet.Utilities.SqlHelper";
switch (dbType)
{
case DbTypeName.SqlServer:
returnValue = "DotNet.Utilities.SqlHelper";
break;
case DbTypeName.Oracle:
returnValue = "DotNet.Utilities.MSOracleHelper";
break;
case DbTypeName.Access:
returnValue = "DotNet.Utilities.OleDbHelper";
break;
case DbTypeName.MySql:
returnValue = "DotNet.Utilities.MySqlHelper";
break;
case DbTypeName.DB2:
returnValue = "DotNet.Utilities.DB2Helper";
break;
case DbTypeName.SQLite:
returnValue = "DotNet.Utilities.SqLiteHelper";
break;
}
return(returnValue);
}
static DataParameter()
{
foreach (string DbTypeName in System.Enum.GetNames(typeof(System.Data.DbType)))
{
DbTypeCollection.Add(DbTypeName.ToLower(), System.Enum.Parse(typeof(System.Data.DbType), DbTypeName));
}
}
public static IATranslator CreateInstance(DbTypeName dbType, IASTNodeFactory nodeFactory)
{
if (dbType == DbTypeName.Oracle)
{
return(new OracleTranslator(nodeFactory));
}
return(new SqlServerTranslator(nodeFactory));
}
/// <summary>
/// 数据库连接的类型判断
/// </summary>
/// <param name="dbType">数据库类型</param>
/// <returns>数据库类型</returns>
public static DbTypeName GetDbType(string dbType)
{
DbTypeName returnValue = DbTypeName.SqlServer;
foreach (DbTypeName currentDbType in Enum.GetValues(typeof(DbTypeName)))
{
if (currentDbType.ToString().Equals(dbType))
{
returnValue = currentDbType;
break;
}
}
return(returnValue);
}
/// <summary>
/// 获取指定的数据库连接
/// </summary>
/// <param name="dataBaseType">数据库类型（默认：SqlServer）</param>
/// <param name="connectionString">数据库连接串（默认：CenterDbConnection）</param>
/// <returns>数据库访问类</returns>
public static IDbHelper GetHelper(string connectionString, DbTypeName dbType = DbTypeName.SqlServer)
{
// 这里是每次都获取新的数据库连接,否则会有并发访问的问题存在
string dbHelperClass = GetDbHelperClass(dbType);
Assembly assembly = Assembly.Load("JSNet.DbUtilities");//JSNet.DbUtilities.SqlHelper
IDbHelper dbHelper = (IDbHelper)assembly.CreateInstance(dbHelperClass, true);
if (!string.IsNullOrEmpty(connectionString))
{
dbHelper.ConnectionString = connectionString;
}
else
{
throw new Exception("connectionString is null");
}
return(dbHelper);
}
public static IViewDefinition CreateInstance(DbTypeName dbType, string viewName, string selectStatement)
{
return(new ViewDefinition(dbType, viewName, selectStatement));
}
public static IViewDefinition CreateInstance(DbTypeName dbType)
{
return(CreateInstance(dbType, "", ""));
}
public ViewDefinition(DbTypeName dbType) : this(dbType, "", "")
{
}
public ViewDefinition(DbTypeName dbType, string viewName, string selectStatement)
{
DbType = dbType;
ViewName = viewName;
SelectStatement = selectStatement;
}
/// <summary>
/// 获取指定的数据库连接
/// </summary>
/// <param name="connectionString">数据库连接串</param>
/// <returns>数据库访问类</returns>
public static IDbHelper GetHelper(string connectionString)
{
DbTypeName dbType = DbTypeName.SqlServer;
return(GetHelper(connectionString, dbType));
}
