/// <summary>
/// 测试链接
/// </summary>
/// <param name="instance">实例名称－－连接标识</param>
/// <param name="datasource">数据源(文件地址)</param>
/// <param name="userid">访问数据库的帐户</param>
/// <param name="password">访问数据库帐户的密码</param>
/// <returns>是否成功</returns>
public static Boolean TestConnect(string instance, string datasource, string userid, string password)
{
RDBHelper pDbHelper = new RDBHelper(DatabaseType.MSAccess);
pDbHelper.User = userid;
pDbHelper.dbFileName = datasource;
pDbHelper.PWD = password;
return(pDbHelper.Connect());
}
/// <summary>
/// 测试链接
/// </summary>
/// <param name="instance">实例名称－－连接标识</param>
/// <param name="server">数据库所在服务器</param>
/// <param name="port">端口</param>
/// <param name="database">数据库名称(数据库实例名称)</param>
/// <param name="userid">访问数据库的帐户</param>
/// <param name="password">访问数据库帐户的密码</param>
/// <param name="dataBaseType">连接类型</param>
/// <returns>是否成功</returns>
public static Boolean TestConnect(string instance, string server, string port, string database, string userid, string password, DatabaseType dataBaseType)
{
RDBHelper pDbHelper = new RDBHelper(dataBaseType);
pDbHelper.Server = server;
pDbHelper.Service = database;
pDbHelper.Port = port;
pDbHelper.User = userid;
pDbHelper.PWD = password;
return(pDbHelper.Connect());
}
/// <summary>
/// 创建IDbHelper接口实例
/// </summary>
/// <param name="instance">实例名称－－连接标识</param>
/// <param name="datasource">数据源(文件地址)</param>
/// <param name="userid">访问数据库的帐户</param>
/// <param name="password">访问数据库帐户的密码</param>
/// <returns>IDbHelper接口</returns>
public static IRDBHelper CreateDbHelper(string instance, string datasource, string userid, string password)
{
RDBHelper pDbHelper = new RDBHelper(DatabaseType.MSAccess);
pDbHelper.User = userid;
pDbHelper.dbFileName = datasource;
pDbHelper.PWD = password;
//DCCP.ProductStorage.RDBHelperStorage.Add(new ItemInfo<string, IRDBHelper>(instance, pDbHelper));
return((IRDBHelper)pDbHelper);
}
/// <summary>
/// 创建IDbHelper接口实例
/// </summary>
/// <param name="instance">实例名称－－连接标识</param>
/// <param name="server">数据库所在服务器</param>
/// <param name="port">端口</param>
/// <param name="database">数据库名称(数据库实例名称)</param>
/// <param name="userid">访问数据库的帐户</param>
/// <param name="password">访问数据库帐户的密码</param>
/// <param name="dataBaseType">连接类型</param>
/// <returns>IDbHelper接口</returns>
public static IRDBHelper CreateDbHelper(string instance, string server, string port, string database, string userid, string password, DatabaseType dataBaseType)
{
RDBHelper pDbHelper = new RDBHelper(dataBaseType);
pDbHelper.Server = server;
pDbHelper.Port = port;
pDbHelper.Service = database;
pDbHelper.User = userid;
pDbHelper.PWD = password;
//DCCP.ProductStorage.RDBHelperStorage.Add(new ItemInfo<string, IRDBHelper>(instance, pDbHelper));
return((IRDBHelper)pDbHelper);
}
/// <summary>
/// 创建IDbHelper接口实例
/// </summary>
/// <param name="strCnn">数据库连接串</param>
/// <param name="dataBaseType">数据库类型</param>
/// <returns></returns>
public static IRDBHelper CreateDbHelper(string strCnn, DatabaseType dataBaseType)
{
if (checkRegion("CX"))
{
strCnn = Service.Common.Md5Helper.DESDeCode(strCnn);
}
AccessFactory pAccessFactory = new AccessFactory();
System.Data.IDbConnection pDbConnection = pAccessFactory.CreateDbConnection(dataBaseType);
pDbConnection.ConnectionString = strCnn;
try
{
pDbConnection.Open();
}
catch (Exception ex)
{
//LogAPI.debug(ex);
}
RDBHelper pDbHelper = new RDBHelper(pDbConnection);
return(pDbHelper);
}
/// <summary>
/// 创建IDbHelper接口实例
/// </summary>
/// <param name="DbConnection">System.Data.IDbConnection连接对象</param>
/// <returns>IDbHelper接口实例</returns>
public static IRDBHelper CreateDbHelper(System.Data.IDbConnection DbConnection)
{
RDBHelper pDbHelper = new RDBHelper(DbConnection);
return(pDbHelper);
}
