public static IDatabase GetDatabase(EnumDatabaseType sTypeConnection, string sConnectionString)
{
IDatabase oReturnDatabase = null;
switch (sTypeConnection)
{
case EnumDatabaseType.SqlServer:
oReturnDatabase = new DatabaseSqlServer(sConnectionString);
break;
case EnumDatabaseType.Oracle:
oReturnDatabase = new DatabaseOracle(sConnectionString);
break;
case EnumDatabaseType.MySQL:
oReturnDatabase = new DatabaseMySQL(sConnectionString);
break;
case EnumDatabaseType.SQLite:
oReturnDatabase = new DatabaseSQLite(sConnectionString);
break;
default:
oReturnDatabase = null;
break;
}
return(oReturnDatabase);
}
public static DBHelper GetDBHelper(EnumDatabaseType databaseType = EnumDatabaseType.SqlFile)
{
if (helper == null)
{
helper = new DBHelper(databaseType);
}
return(helper);
}
/// <summary>
/// Realiza consulta no banco de dados com apenas a querie passada por parametro e banco de dados selecionado.
/// Neste caso não será necessário passar alguns parametros, pois eles receberam os seguintes valores: Parametros=null, CommandTimeout=140, CommandType=Text
/// </summary>
/// <param name="stringConnection">String de conexão</param>
/// <param name="commandText">Querie a ser executada</param>
/// <param name="enumDatabaseType">Tipo de banco de dados que será realizada a consulta</param>
/// <param name="commandTimeout">Define o time out do comando a ser executado.</param>
public CommandSql(string stringConnection, string commandText, EnumDatabaseType enumDatabaseType, int commandTimeout = 140)
{
this._stringConnection = stringConnection;
this._commandText = commandText;
this._parametros = null;
this._commandType = CommandType.Text;
this._commandTimeout = commandTimeout;
this._enumDatabaseType = enumDatabaseType;
}
/// <summary>
/// Realiza consulta no banco de dados com apenas os seguintes parametros: querie, parametros e enumDatabaseType.
/// Neste caso os parametros internos recebem os seguintes valores: CommandTimeout=140, CommandType=Text
/// </summary>
/// <param name="stringConnection">String de conexão</param>
/// <param name="commandText">Querie a ser executada</param>
/// <param name="parametros">Parametros que foram adicionados a querie</param>
/// <param name="enumDatabaseType">Tipo de banco de dados que será realizada a consulta</param>
public CommandSql(string stringConnection, string commandText, List <DbParameter> parametros, EnumDatabaseType enumDatabaseType)
{
this._stringConnection = stringConnection;
this._commandText = commandText;
this._parametros = parametros;
this._commandType = CommandType.Text;
this._commandTimeout = 140;
this._enumDatabaseType = enumDatabaseType;
}
/// <summary>
/// 返回数据访问类实例
/// </summary>
/// <param name="connectionString">连接字符串</param>
/// <param name="databaseType">数据库类型，默认值为EnumDatabaseType.SQLServer</param>
/// <returns>IDataAccess实例</returns>
public static IDataAccess CreateInstance(string connectionString, EnumDatabaseType databaseType = EnumDatabaseType.SQLServer)
{
switch (databaseType)
{
case EnumDatabaseType.SQLServer:
return new SqlDataAccess(connectionString);
default:
return null;
}
}
private void cb_db_Type_SelectedIndexChanged(object sender, EventArgs e)
{
ConnectString = AES.GetDecryptConnectString(CommonConfigurationManager.GetAppConfig("ConnectString"));
string[] sqlStrArray = null;
if (ConnectString != null && ConnectString.Contains(";"))
{
sqlStrArray = ConnectString.Split(';');
}
if (cb_db_Type.Text == cb_db_Type.Items[0].ToString())
{
tlp_SQL_File.Visible = false;
tlp_SQL_Server.Visible = true;
DatabaseType = EnumDatabaseType.SqlServer;
if (sqlStrArray != null && sqlStrArray.All(str => !str.Contains("AttachDbFilename")))
{
string serverName = sqlStrArray.Where(cs => cs.Contains("Data Source")).FirstOrDefault();
if (serverName != null)
{
serverName = serverName.Substring(serverName.IndexOf('=') + 1);
tx_db_IP.Text = serverName.Trim();
}
}
}
else
{
tlp_SQL_File.Visible = true;
tlp_SQL_Server.Visible = false;
DatabaseType = EnumDatabaseType.SqlFile;
if (sqlStrArray != null)
{
string filePath = sqlStrArray.Where(cs => cs.Contains("AttachDbFilename")).FirstOrDefault();
if (filePath != null)
{
filePath = filePath.Substring(filePath.IndexOf('=') + 1);
tx_db_FilePath.Text = filePath.Trim();
}
}
}
if (sqlStrArray != null)
{
string userId = sqlStrArray.Where(cs => cs.Contains("User ID")).FirstOrDefault();
if (userId != null)
{
userId = userId.Substring(userId.IndexOf('=') + 1);
tx_db_UserName.Text = userId.Trim();
}
string password = sqlStrArray.Where(cs => cs.Contains("Password")).FirstOrDefault();
if (password != null)
{
password = password.Substring(password.IndexOf('=') + 1);
tx_db_Password.Text = password.Trim();
}
}
}
public static IDataAccess CreateDataAccess(EnumDatabaseType dbType, string connStr)
{
switch (dbType)
{
case EnumDatabaseType.SqlServer: return(new SqlServerDAL(connStr));
case EnumDatabaseType.Oracle: return(new OracleDAL(connStr));
default:
throw new Exception("不支持的类型！");
}
}
private DBHelper(EnumDatabaseType databaseType)
{
switch (databaseType)
{
case EnumDatabaseType.SqlFile:
connector = new SqlServerConnector();
break;
case EnumDatabaseType.SqlServer:
connector = new SqlServerConnector();
break;
}
}
/// <summary>
/// 登录验证
/// </summary>
/// <param name="connStr">连接字符串</param>
/// <param name="dbType">数据库类型</param>
/// <returns></returns>
public bool CheckLogin(string connStr, EnumDatabaseType dbType)
{
IDataAccess dataAccess = DataAccessFactory.CreateInstance(connStr, dbType);
try
{
object result = dataAccess.ExecuteScalar("SELECT 1");
if (result != null && (Convert.ToInt32(result) == 1))
{
return true;
}
return false;
}
catch (Exception)
{
return false;
}
}
public static AbstractDatabase CreateDatabase(EnumDatabaseType enumDatabaseType, string stringDeConexao)
{
Type database = null;
if (enumDatabaseType == EnumDatabaseType.SqlServer)
{
database = typeof(SqlServer);
}
else if (enumDatabaseType == EnumDatabaseType.MySql)
{
database = typeof(MySql);
}
else if (enumDatabaseType == EnumDatabaseType.Firebird)
{
database = typeof(Firebird);
}
try
{
// Obtém o construtor
ConstructorInfo constructor = database.GetConstructor(new Type[] { });
// Invova o construtor para retornar a instancia
AbstractDatabase createdObject = (AbstractDatabase)constructor.Invoke(null);
// Inicializa a propriedade ConnectionString para o banco de dados.
createdObject.connectionString = stringDeConexao;
// Retorna a intância com um banco de dados
return(createdObject);
}
catch (Exception excep)
{
throw new Exception("Erro ao instanciar o banco de dados. " + excep.Message);
}
}
public DataAccessService(EnumDatabaseType config)
{
_config = config;
}
public BasicDALImpl()
{
_tableName = typeof(T).Name;
_connStr = ConfigurationManager.ConnectionStrings["CommonStr"].ToString();
_dataBaseType = EnumDatabaseType.Oracle;
}
public DatabaseLog(string applicationName, string connectionString, EnumDatabaseType enumDatabaseType)
{
_connectionString = connectionString;
_applicationName = applicationName;
_enumDatabaseType = enumDatabaseType;
}
