private static SybaseHelper dbOper_Sybase; //access ���ݿ������
#endregion Fields
#region Methods
/// <summary>
/// ���� IES�� �������
/// </summary>
public static void CloseAllCacheIESConn()
{
if (dbOper_Custom_Hashtable != null)
{
foreach (DictionaryEntry obj in dbOper_Custom_Hashtable)
{
IDataBaseOper idb = (IDataBaseOper)obj.Value;
idb.ConnClose();
idb = null;
}
}
dbOper_Custom_Hashtable = null;
if (dbOper_Custom != null)
{
try
{
dbOper_Custom.ConnClose();
dbOper_Custom = null;
}
catch
{
;
}
}
}
/// <summary>
/// 销毁 IES中 所有的连接
/// </summary>
public static void CloseAllCacheIESConn()
{
if (dbOper_Custom_Hashtable != null)
{
foreach (DictionaryEntry obj in dbOper_Custom_Hashtable)
{
IDataBaseOper idb = (IDataBaseOper)obj.Value;
idb.ConnClose();
idb = null;
}
}
dbOper_Custom_Hashtable = null;
if (dbOper_Custom != null)
{
try
{
dbOper_Custom.ConnClose();
dbOper_Custom = null;
}
catch
{
;
}
}
}
/// <summary>
/// ���� isNew ���жϣ��Զ��������Ƿ���Ҫ����һ���µ����ӣ�
/// </summary>
/// <param name="isNew">�Ƿ����µ�����</param>
/// <param name="at">���ݿ���������</param>
/// <param name="ServerName">������ ���� DNS������ ODBC����ʱ</param>
/// <param name="DataBaseName">���ݿ����� ODBC����ʱ Ϊ�� ����</param>
/// <param name="UserIdName">�û�</param>
/// <param name="Password">����</param>
/// <returns></returns>
public static IDataBaseOper GetDataBaseOper_BySybaseOleDB(bool isNew, eDBType at, string ServerName, string DataBaseName, string UserIdName, string Password)
{
switch (at)
{
case eDBType.Access:
if (isNew)
{
dbOper_Custom = new AccessHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper == null)
{
dbOper_Custom = new AccessHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return dbOper_Custom;
break;
case eDBType.Sybase:
if (isNew)
{
dbOper_Custom = new SybaseHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper_Custom == null)
{
dbOper_Custom = new SybaseHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return dbOper_Custom;
break;
case eDBType.Oracle:
if (isNew)
{
dbOper_Custom = new OracleHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper_Custom == null)
{
dbOper_Custom = new OracleHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return dbOper_Custom;
break;
case eDBType.SqlServer:
if (isNew)
{
dbOper_Custom = new SqlServerHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper_Custom == null)
{
dbOper_Custom = new SqlServerHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return dbOper_Custom;
break;
default: //Ĭ���DZ��ؿ�
break;
}
return null;
}
/// <summary>
/// 根据 isNew 来判断，自定义连接是否需要开启一个新的连接，
/// </summary>
/// <param name="isNew">是否是新的连接</param>
/// <param name="at">数据库连接类型</param>
/// <param name="ServerName">服务名 或是 DNS服务名 ODBC连接时</param>
/// <param name="DataBaseName">数据库名称 ODBC连接时 为空 “”</param>
/// <param name="UserIdName">用户</param>
/// <param name="Password">密码</param>
/// <returns></returns>
public static IDataBaseOper GetDataBaseOper_BySybaseOleDB(bool isNew, eDBType at, string ServerName, string DataBaseName, string UserIdName, string Password)
{
switch (at)
{
case eDBType.Access:
if (isNew)
{
dbOper_Custom = new AccessHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper == null)
{
dbOper_Custom = new AccessHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return(dbOper_Custom);
break;
case eDBType.Sybase:
if (isNew)
{
dbOper_Custom = new SybaseHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper_Custom == null)
{
dbOper_Custom = new SybaseHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return(dbOper_Custom);
break;
case eDBType.Oracle:
if (isNew)
{
dbOper_Custom = new OracleHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper_Custom == null)
{
dbOper_Custom = new OracleHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return(dbOper_Custom);
break;
case eDBType.SqlServer:
if (isNew)
{
dbOper_Custom = new SqlServerHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
else
{
if (dbOper_Custom == null)
{
dbOper_Custom = new SqlServerHelper(at, ServerName, DataBaseName, UserIdName, Password);
}
}
return(dbOper_Custom);
break;
default: //默认是本地库
break;
}
return(null);
}
