public override void Close() { if (myThread != null) { myThread.Abort(); } if (myDBConn != null) { myDBConn.Close(); } }
public static bool check_func(FbConnectionStringBuilder fc) { bool res_ = false; using (FbConnection fb = new FbConnection(fc.ConnectionString)) { try { fb.Open(); using (FbTransaction ft = fb.BeginTransaction()) { using (FbCommand fcon = new FbCommand(sql_func,fb,ft)) { using (FbDataReader fr = fcon.ExecuteReader()) { while (fr.Read()) { res_ = true; } fr.Dispose(); } fcon.Dispose(); } ft.Commit(); ft.Dispose(); } } catch { } finally { fb.Close(); } fb.Dispose(); } return res_; }
static int Main(string[] args) { int i = 0; int max = args.Length < 1 ? 1 : int.Parse(args[0]); while (i < max) { var connectionBuilder = new FbConnectionStringBuilder(); connectionBuilder.DataSource = "localhost"; connectionBuilder.Database = @"D:\db\Hoge2.FDB"; connectionBuilder.Charset = FbCharset.Utf8.ToString(); connectionBuilder.UserID = "SYSDBA"; connectionBuilder.Password = "******"; connectionBuilder.ServerType = FbServerType.Embedded; connectionBuilder.Pooling = false; using (var connection = new FbConnection(connectionBuilder.ConnectionString)) { connection.Open(); connection.Close(); } i++; } UnloadDll(Path.Combine(Path.GetDirectoryName(Assembly.GetEntryAssembly().Location), @"fbembed.dll")); return DateTime.Now.ToIntTime(); }
public Conexao_Banco(/*string _codigo*/) { InitializeComponent(); aux_codigo = tx_pesquisa.Text; //this.aux_codigo = _codigo; /*string caminho = @"C:\Sistema de Registro da Producao Ambulatorial\FBCADASTRO_AGENDA.FDB"; string conexao = "User=SYSDBA;" + "PassWord=masterkey;" + "DataBase=" + caminho;*/ //DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey; DBNAME=MyServer/3051:C:\database\myData.fdb; // @"DataSource=localhost; Database=C:\PastaFireBird\BANCOFIREBIRD.FDB;"; //User=SYSDBA; Password=masterkey; Database=D:\Meus Documentos\Faculdade - Esucri\Programação avançada I\Delphi com Banco\Banco\BANCO.FDB; DataSource=192.168.0.100;Dialect=3;PacketSize = 4096;" string conexao = @"User=SYSDBA;Password=masterkey;Database=C:\Sistema de Registro da Producao Ambulatorial\FBCADASTRO_AGENDA.FDB;DataSource=RECEPCAO;Port=3050;Dialect=3;PacketSize=4096"; _fbConexao = new FbConnection(conexao); try { _fbConexao.Open(); } catch (Exception erro) { MessageBox.Show(erro.ToString()); } dtgrd_view.DataSource = _dtTable; _fbConexao.Close(); }
internal override void LoadAll() { try { var cn = new FbConnection(_dbRoot.ConnectionString); cn.Open(); string dbName = cn.Database; cn.Close(); int index = dbName.LastIndexOfAny(new[] {'\\'}); if (index >= 0) { dbName = dbName.Substring(index + 1); } // We add our one and only Database var database = (FirebirdDatabase) dbRoot.ClassFactory.CreateDatabase(); database._name = dbName; database.dbRoot = dbRoot; database.Databases = this; _array.Add(database); } catch {} }
public List<belimpressao> BuscaDadosParaImpressao(List<belimpressao> objLista, FbConnection Conn) { try { for (int i = 0; i < objLista.Count; i++) { StringBuilder sQuery = new StringBuilder(); sQuery.Append("select nf.cd_verificacao_nfse, nf.cd_numero_nfse from nf "); sQuery.Append("where nf.cd_nfseq = '" + objLista[i].sNfSeq + "' and "); sQuery.Append("nf.cd_empresa = '" + belStatic.codEmpresaNFe + "'"); FbCommand Command = new FbCommand(sQuery.ToString(), Conn); if (Conn.State == System.Data.ConnectionState.Closed) { Conn.Open(); } FbDataReader dr = Command.ExecuteReader(); dr.Read(); objLista[i].sNota = dr["cd_numero_nfse"].ToString(); objLista[i].sVerificacao = dr["cd_verificacao_nfse"].ToString(); } if (Conn.State == System.Data.ConnectionState.Open) { Conn.Close(); } return objLista; } catch (Exception) { throw; } }
public DataTable RetornaNomeUsuarioCadastrado(string prontuario) { FbConnection conex = new FbConnection(conexao); string query = "SELECT * FROM TBUSUARIO WHERE CDUSUARIO = '"+prontuario+"'"; FbCommand comando = new FbCommand(query, conex); try { conex.Open(); FbDataAdapter datareader = new FbDataAdapter(comando); DataTable usuarios = new DataTable(); datareader.Fill(usuarios); return usuarios; } catch (Exception err) { throw err; } finally { conex.Close(); } }
override internal void LoadAll() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); string dbName = cn.Database; cn.Close(); int index = dbName.LastIndexOfAny(new char[] { '\\' }); if (index >= 0) { dbName = dbName.Substring(index + 1); } // We add our one and only Database FirebirdDatabase database = (FirebirdDatabase)this.dbRoot.ClassFactory.CreateDatabase(); database._name = dbName; database.dbRoot = this.dbRoot; database.Databases = this; this._array.Add(database); } catch {} }
public static bool ContratoTemItens(string contrato) { bool retorno = false; conn = AcessoDados.AcessoDados.getConn(); FbCommand comando = new FbCommand("select COUNT(*) as contador from sci_licitacao_contrato_itens lci where lci.ctrcod = @CONTRATO",conn); FbParameter IDCONTRATO = new FbParameter("@CONTRATO", FbDbType.Integer); IDCONTRATO.Value = contrato; comando.Parameters.Add(IDCONTRATO); conn.Open(); FbDataReader dr = comando.ExecuteReader(); while (dr.Read()) { if (Convert.ToInt16(dr["contador"]) > 0) { retorno = true; } else { retorno = false; } } conn.Close(); comando.Dispose(); return retorno; }
override internal void LoadForTable() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Columns", new string[] { null, null, this.Table.Name }); DataColumn c; if (!metaData.Columns.Contains("IS_AUTO_KEY")) { c = metaData.Columns.Add("IS_AUTO_KEY", typeof(Boolean)); c.DefaultValue = false; } if (!metaData.Columns.Contains("AUTO_KEY_SEED")) { c = metaData.Columns.Add("AUTO_KEY_SEED"); c.DefaultValue = 0; } if (!metaData.Columns.Contains("AUTO_KEY_INCREMENT")) { c = metaData.Columns.Add("AUTO_KEY_INCREMENT"); c.DefaultValue = 0; } if (!metaData.Columns.Contains("AUTO_KEY_SEQUENCE")) { c = metaData.Columns.Add("AUTO_KEY_SEQUENCE"); c.DefaultValue = string.Empty; } PopulateArray(metaData); LoadExtraData(cn, this.Table.Name, "T"); cn.Close(); } catch (Exception ex) { string m = ex.Message; } }
private FbOptions GetSettings(string connectionString) { if (string.IsNullOrWhiteSpace(connectionString)) { connectionString = Settings.Connection.ConnectionString; } if (ServerVersion != null) { return(this); } try { using (var connection = new Firebird.FbConnection(connectionString)) { connection.Open(); ServerVersion = Data.FbServerProperties.ParseServerVersion(connection.ServerVersion); using (var cmd = connection.CreateCommand()) { cmd.CommandText = "SELECT MON$SQL_DIALECT FROM MON$DATABASE"; IsLegacyDialect = Convert.ToInt32(cmd.ExecuteScalar()) == 1; } connection.Close(); } } catch (Exception) { throw; } return(this); }
public static bool ExecuteBatchScript( string connectionString, string pathToScriptFile) { FbScript script = new FbScript(pathToScriptFile); if (script.Parse() > 0) { using (FbConnection connection = new FbConnection(connectionString)) { connection.Open(); try { FbBatchExecution batch = new FbBatchExecution(connection, script); batch.Execute(true); } catch (FbException ex) { log.Error(ex); throw new Exception(pathToScriptFile, ex); } finally { connection.Close(); } } } return true; }
public void BeginTrasactionTest() { string connectionString = this.BuildConnectionString(); FbConnection conn01 = new FbConnection(connectionString); conn01.Open(); FbTransaction txn01 = conn01.BeginTransaction(IsolationLevel.Unspecified); txn01.Rollback(); conn01.Close(); FbConnection conn02 = new FbConnection(connectionString); conn02.Open(); FbTransaction txn02 = conn02.BeginTransaction(IsolationLevel.ReadCommitted); txn02.Rollback(); conn02.Close(); FbConnection conn03 = new FbConnection(connectionString); conn03.Open(); FbTransaction txn03 = conn03.BeginTransaction(IsolationLevel.ReadUncommitted); txn03.Rollback(); conn03.Close(); FbConnection conn04 = new FbConnection(connectionString); conn04.Open(); FbTransaction txn04 = conn04.BeginTransaction(IsolationLevel.RepeatableRead); txn04.Rollback(); conn04.Close(); FbConnection conn05 = new FbConnection(connectionString); conn05.Open(); FbTransaction txn05 = conn05.BeginTransaction(IsolationLevel.Serializable); txn05.Rollback(); conn05.Close(); }
private string NomeArqCte() { FbConnection con = null; try { string sNomeArq = ""; FbCommand cmd = new FbCommand(); con = new FbConnection(HlpDbFuncoesGeral.MontaStringConexao()); cmd.Connection = con; con.Open(); cmd.CommandText = "SP_CHAVEPRI"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add("@SNOMEGENERATOR", FbDbType.VarChar, 31).Value = "GEN_NOMEARQXML"; sNomeArq = cmd.ExecuteScalar().ToString(); return "Cte_" + sEmp + sNomeArq.PadLeft(15, '0') + ".xml"; } catch (Exception ex) { throw ex; } finally { con.Close(); } }
override internal void LoadAll() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); string dbName = cn.Database; cn.Close(); int index = dbName.LastIndexOfAny(new char[]{'\\'}); if (index >= 0) { dbName = dbName.Substring(index + 1); } // We add our one and only Database FirebirdDatabase database = (FirebirdDatabase)this.dbRoot.ClassFactory.CreateDatabase(); database._name = dbName; database.dbRoot = this.dbRoot; database.Databases = this; this._array.Add(database); } catch {} }
public tcDadosConstrucaoCivil RettcDadosConstrucaoCivil(FbConnection Conn, string sNota) { try { StringBuilder sQuery = new StringBuilder(); sQuery.Append("select coalesce(clifor.cd_art,'') Art, coalesce(clifor.cd_obra,'')CodigoObra {0}"); sQuery.Append("from nf inner join clifor on nf.cd_clifor = clifor.cd_clifor {0}"); sQuery.Append("where nf.cd_nfseq = '{1}' and nf.cd_empresa = '{2}' {0}"); string sQueryEnd = string.Format(sQuery.ToString(), Environment.NewLine, sNota, belStatic.codEmpresaNFe); FbCommand cmd = new FbCommand(sQueryEnd, Conn); Conn.Open(); FbDataReader dr = cmd.ExecuteReader(); objtcDadosConstrucaoCivil = new tcDadosConstrucaoCivil(); while (dr.Read()) { objtcDadosConstrucaoCivil.Art = dr["Art"].ToString(); objtcDadosConstrucaoCivil.CodigoObra = dr["CodigoObra"].ToString(); } } catch (Exception) { throw; } finally { Conn.Close(); } return objtcDadosConstrucaoCivil; }
public bool OpenConnection() { //// Set the ServerType to 1 for connect to the embedded server //string connectionString = //"User=SYSDBA;" + //"Password=masterkey;" + //"Database=C:/Users/ikhromov/Desktop/Domovoy_prj/4rmd.gdb;" + //"DataSource=localhost;" + //"Port=3050;" + //"Dialect=3;" + //"Charset=NONE;" + //"Role=;" + //"Connection lifetime=15;" + //"Pooling=true;" + //"MinPoolSize=0;" + //"MaxPoolSize=50;" + //"Packet Size=8192;" + //"ServerType=0"; try { string connectionString = ConfigurationManager.ConnectionStrings["domovoyDBConnection"].ConnectionString; fbConnection = new FbConnection(connectionString); // Open connection. fbConnection.Open(); fbConnection.Close(); return true; } catch (Exception e) { return false; } }
public override void execute(Options options, INIManager iniManager) { string AppKey = iniManager.IniReadValue("APP", "AppKey"); string AppSecret = iniManager.IniReadValue("APP", "AppSecret"); string TaobaoAsistantPath = iniManager.IniReadValue("淘宝助理", "安装目录"); string nick = options.Nick; string SessionKey = iniManager.IniReadValue(nick, "SessionKey"); string userId = iniManager.IniReadValue(nick, "UserId"); if (userId == null || userId.Trim().Equals("")) { userId = "1696293148"; } StreamWriter MovePicLogWriter; FileStream MovePicLog = new FileStream(Environment.CurrentDirectory + "\\" + "MovePic.log", FileMode.Append); MovePicLogWriter = new StreamWriter(MovePicLog, Encoding.Default); FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.Database = Path.Combine(TaobaoAsistantPath, "users\\" + nick + "\\APPITEM.DAT"); cs.Charset = "UTF8"; cs.UserID = "SYSDBA"; cs.Password = "******"; cs.ServerType = FbServerType.Embedded; FbConnection fbCon = new FbConnection(cs.ToString()); fbCon.Open(); FbCommand ItemsCommand = null; ItemsCommand = new FbCommand("SELECT * FROM ITEM WHERE OUTER_ID = @SearchString OR TITLE = @SearchString", fbCon); FbParameter SearchString = new FbParameter("@SearchString", FbDbType.VarChar); SearchString.Value = options.Item; ItemsCommand.Parameters.Add(SearchString); FbDataReader ItemsReader = ItemsCommand.ExecuteReader(); while (ItemsReader.Read()) { MovePicLogWriter.WriteLine("--------------------------------------------------------------------------------"); Console.WriteLine("--------------------------------------------------------------------------------"); string ClientID = ItemsReader["CLIENT_ID"].ToString(); string Title = ItemsReader["TITLE"].ToString(); Console.WriteLine("ClientID=" + ClientID); MovePicLogWriter.WriteLine("ClientID=" + ClientID); Console.WriteLine("TITLE=" + Title); MovePicLogWriter.WriteLine("TITLE=" + Title); FbTransaction myTransaction = fbCon.BeginTransaction(); FbCommand DeleteCommand = new FbCommand("UPDATE ITEM SET CLIENT_IS_DELETE = 1 WHERE CLIENT_ID = @ClientID", fbCon); FbParameter ParamID = new FbParameter("@ClientID", FbDbType.VarChar); ParamID.Value = ClientID; DeleteCommand.Parameters.Add(ParamID); DeleteCommand.Transaction = myTransaction; DeleteCommand.ExecuteNonQuery(); myTransaction.Commit(); } fbCon.Close(); MovePicLogWriter.Close(); MovePicLog.Close(); }
public static DataTable EleentsToDataTable(string command) { var dt = new DataTable(); FbConnection con = new FbConnection(ConStr.ConnectionString); con.Open(); FbDataAdapter da = new FbDataAdapter(command, con); da.Fill(dt); con.Close(); return dt; }
public static void DatabaseCommand(string command) { FbConnection con = new FbConnection(ConStr.ConnectionString); con.Open(); FbTransaction transaction = con.BeginTransaction(); FbCommand com = new FbCommand(command, con, transaction); com.ExecuteNonQuery(); transaction.Commit(); con.Close(); }
override internal void LoadAll() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Procedures", new string[] {this.Database.Name}); cn.Close(); PopulateArray(metaData); } catch(Exception ex) { string m = ex.Message; } }
internal override void LoadAll() { try { var cn = new FbConnection(_dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Procedures", new[] {Database.Name}); cn.Close(); PopulateArray(metaData); } catch (Exception ex) { string m = ex.Message; } }
override internal void LoadAll() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Procedures", new string[] { this.Database.Name }); cn.Close(); PopulateArray(metaData); } catch (Exception ex) { string m = ex.Message; } }
public PacienteFirebird() { FbConnection connex = new FbConnection(conexao); try { conexao = Datasource + DataBase + user + password; connex = new FbConnection(conexao); connex.Open(); } catch (Exception err) { connex.Close(); System.Windows.Forms.MessageBox.Show(err.Message); } }
public ConexaoFirebird() { FbConnection connex = new FbConnection(conexao); try { conexao = Datasource + DataBase + user + password; connex = new FbConnection(conexao); connex.Open(); } catch (Exception) { connex.Close(); throw; } }
override internal void LoadAll() { try { using (FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString)) { cn.Open(); DataTable idxMetaData = cn.GetSchema("Indexes", new string[] { null, null, this.Table.Name }); if (!idxMetaData.Columns.Contains("CARDINALITY")) { idxMetaData.Columns.Add("CARDINALITY"); } if (!idxMetaData.Columns.Contains("COLUMN_NAME")) { idxMetaData.Columns.Add("COLUMN_NAME"); } idxMetaData.Columns["IS_UNIQUE"].ColumnName = "UNIQUE"; idxMetaData.Columns["INDEX_TYPE"].ColumnName = "TYPE"; DataTable metaData = idxMetaData.Clone(); metaData.Clear(); foreach (DataRow row in idxMetaData.Rows) { string indexName = (string)row["INDEX_NAME"]; DataTable metaDataColumns = cn.GetSchema("IndexColumns", new string[] { null, null, null, indexName }); metaDataColumns.DefaultView.Sort = "ORDINAL_POSITION ASC"; foreach (DataRowView vrow in metaDataColumns.DefaultView) { DataRow newrow = metaData.Rows.Add(row.ItemArray); newrow["CARDINALITY"] = vrow["ORDINAL_POSITION"]; newrow["COLUMN_NAME"] = vrow["COLUMN_NAME"]; } } cn.Close(); PopulateArray(metaData); } } catch (Exception ex) { string m = ex.Message; } }
public static string GetOneElement(string command) { string element = ""; FbConnection con = new FbConnection(ConStr.ConnectionString); con.Open(); FbTransaction transaction = con.BeginTransaction(); FbCommand com = new FbCommand(command, con, transaction); com.ExecuteNonQuery(); FbDataReader datareader; datareader = com.ExecuteReader(); while (datareader.Read()) { element = datareader[0].ToString(); } con.Close(); return element; }
internal override void LoadForTable() { try { var cn = new FbConnection(_dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Columns", new[] {null, null, Table.Name}); PopulateArray(metaData); LoadExtraData(cn, Table.Name, "T"); cn.Close(); } catch (Exception ex) { string m = ex.Message; } }
override internal void LoadAll() { try { string type = this.dbRoot.ShowSystemData ? "SYSTEM TABLE" : "TABLE"; FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Tables", new string[] { null, null, null, type }); cn.Close(); PopulateArray(metaData); } catch (Exception ex) { string m = ex.Message; } }
override internal void LoadAll() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Views", new string[] {null, null, null}); cn.Close(); metaData.Columns["VIEW_NAME"].ColumnName = "TABLE_NAME"; PopulateArray(metaData); } catch(Exception ex) { string m = ex.Message; } }
override internal void LoadAll() { try { string type = this.dbRoot.ShowSystemData ? "SYSTEM TABLE" : "TABLE"; FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Tables", new string[] {null, null, null, type}); cn.Close(); PopulateArray(metaData); } catch(Exception ex) { string m = ex.Message; } }
internal override void LoadAll() { try { string type = dbRoot.ShowSystemData ? "SYSTEM TABLE" : "TABLE"; var cn = new FbConnection(_dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Tables", new[] {null, null, null, type}); cn.Close(); PopulateArray(metaData); } catch (Exception ex) { string m = ex.Message; } }
override internal void LoadForView() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Columns", new string[] { null, null, this.View.Name }); PopulateArray(metaData); LoadExtraData(cn, this.View.Name, "V"); cn.Close(); } catch (Exception ex) { string m = ex.Message; } }
override internal void LoadForView() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Columns", new string[] {null, null, this.View.Name}); PopulateArray(metaData); LoadExtraData(cn, this.View.Name, "V"); cn.Close(); } catch(Exception ex) { string m = ex.Message; } }
override internal void LoadAll() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Views", new string[] { null, null, null }); cn.Close(); metaData.Columns["VIEW_NAME"].ColumnName = "TABLE_NAME"; PopulateArray(metaData); } catch (Exception ex) { string m = ex.Message; } }
public static bool ExistsElement(string command) { string element = ""; FbConnection con = new FbConnection(ConStr.ConnectionString); con.Open(); FbTransaction transaction = con.BeginTransaction(); FbCommand com = new FbCommand(command, con, transaction); com.ExecuteNonQuery(); FbDataReader datareader; datareader = com.ExecuteReader(); while (datareader.Read()) { element = datareader[0].ToString(); } con.Close(); if (element != null && element != "") return true; return false; }
internal override void LoadAll() { try { var cn = new FbConnection(_dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Indexes", new[] {null, null, Table.Name}); cn.Close(); metaData.Columns["IS_UNIQUE"].ColumnName = "UNIQUE"; metaData.Columns["INDEX_TYPE"].ColumnName = "TYPE"; metaData.Columns["ORDINAL_POSITION"].ColumnName = "CARDINALITY"; PopulateArray(metaData); } catch (Exception ex) { string m = ex.Message; } }
public FbConnection MontaConexaoEscritor() { FbConnection Conn = new FbConnection(); try { Globais MontaStringConexao = new Globais(); StringBuilder sbConexao = new StringBuilder(); sbConexao.Append("User ="******"Usuario")); sbConexao.Append(";"); sbConexao.Append("Password="******"Senha")); sbConexao.Append(";"); sbConexao.Append("Database="); string sdatabase = MontaStringConexao.LeRegConfig("BancoEscritor"); sbConexao.Append(sdatabase); sbConexao.Append(";"); sbConexao.Append("DataSource="); sbConexao.Append(MontaStringConexao.LeRegConfig("ServidorEscritor")); sbConexao.Append(";"); sbConexao.Append("Port=3050;Dialect=1; Charset=NONE;Role=;Connection lifetime=15;Pooling=true; MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;"); Conn = new FbConnection(sbConexao.ToString()); Conn.Open(); return Conn; } catch (Exception ex) { throw new Exception(string.Format("Não foi possivel se conectar ao banco de dados do Escritor, Verifique as Configurações do Sistema, Erro.: {0}", ex.Message)); } finally { Conn.Close(); } return Conn; }
override internal void LoadAll() { try { using (FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString)) { cn.Open(); DataTable idxMetaData = cn.GetSchema("Indexes", new string[] { null, null, this.Table.Name }); if (!idxMetaData.Columns.Contains("CARDINALITY")) idxMetaData.Columns.Add("CARDINALITY"); if (!idxMetaData.Columns.Contains("COLUMN_NAME")) idxMetaData.Columns.Add("COLUMN_NAME"); idxMetaData.Columns["IS_UNIQUE"].ColumnName = "UNIQUE"; idxMetaData.Columns["INDEX_TYPE"].ColumnName = "TYPE"; DataTable metaData = idxMetaData.Clone(); metaData.Clear(); foreach (DataRow row in idxMetaData.Rows) { string indexName = (string)row["INDEX_NAME"]; DataTable metaDataColumns = cn.GetSchema("IndexColumns", new string[] { null, null, null, indexName }); metaDataColumns.DefaultView.Sort = "ORDINAL_POSITION ASC"; foreach (DataRowView vrow in metaDataColumns.DefaultView) { DataRow newrow = metaData.Rows.Add(row.ItemArray); newrow["CARDINALITY"] = vrow["ORDINAL_POSITION"]; newrow["COLUMN_NAME"] = vrow["COLUMN_NAME"]; } } cn.Close(); PopulateArray(metaData); } } catch(Exception ex) { string m = ex.Message; } }
override internal void LoadAll() { try { FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); DataTable metaData = cn.GetSchema("Domains", null); cn.Close(); if (metaData.Columns.Contains("DOMAIN_DATA_TYPE")) { metaData.Columns["DOMAIN_DATA_TYPE"].ColumnName = "DATA_TYPE"; } PopulateArray(metaData); LoadExtraData(cn); } catch (Exception ex) { string m = ex.Message; } }
private void FixupDataTypes(DataTable metaData) { FbConnection cn = null; try { int dialect = 1; cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString); cn.Open(); try { FbConnectionStringBuilder cnString = new FbConnectionStringBuilder(cn.ConnectionString); dialect = cnString.Dialect; } catch {} int count = this._array.Count; Parameter p = null; if (count > 0) { // Dimension Data string dimSelect = "select r.rdb$field_name AS Name , d.rdb$dimension as DIM, d.rdb$lower_bound as L, d.rdb$upper_bound as U from rdb$fields f, rdb$field_dimensions d, rdb$relation_fields r where r.rdb$relation_name='" + this.Procedure.Name + "' and f.rdb$field_name = d.rdb$field_name and f.rdb$field_name=r.rdb$field_source order by d.rdb$dimension;"; FbDataAdapter dimAdapter = new FbDataAdapter(dimSelect, cn); DataTable dimTable = new DataTable(); dimAdapter.Fill(dimTable); p = this._array[0] as Parameter; f_TypeName = new DataColumn("TYPE_NAME", typeof(string)); p._row.Table.Columns.Add(f_TypeName); f_TypeNameComplete = new DataColumn("TYPE_NAME_COMPLETE", typeof(string)); p._row.Table.Columns.Add(f_TypeNameComplete); short ftype = 0; short dim = 0; DataRowCollection rows = metaData.Rows; for (int index = 0; index < count; index++) { p = (Parameter)this[index]; if (p._row["NUMERIC_PRECISION"] == System.DBNull.Value) { p._row["NUMERIC_PRECISION"] = p._row["PARAMETER_SIZE"]; } p._row["PARAMETER_NAME"] = (p._row["PARAMETER_NAME"] as String).Trim(); int dir = (int)p._row["PARAMETER_TYPE"]; p._row["PARAMETER_TYPE"] = dir == 0 ? 1 : 3; // Step 1: DataTypeName ftype = (short)rows[index]["FIELD_TYPE"]; switch (ftype) { case 7: p._row["TYPE_NAME"] = "SMALLINT"; break; case 8: p._row["TYPE_NAME"] = "INTEGER"; break; case 9: p._row["TYPE_NAME"] = "QUAD"; break; case 10: p._row["TYPE_NAME"] = "FLOAT"; break; case 11: p._row["TYPE_NAME"] = "DOUBLE PRECISION"; break; case 12: p._row["TYPE_NAME"] = "DATE"; break; case 13: p._row["TYPE_NAME"] = "TIME"; break; case 14: p._row["TYPE_NAME"] = "CHAR"; break; case 16: if (p.NumericScale < 0) { p._row["TYPE_NAME"] = "NUMERIC"; } else { p._row["TYPE_NAME"] = "BIGINT"; } break; case 27: p._row["TYPE_NAME"] = "DOUBLE PRECISION"; break; case 35: if (dialect > 2) { p._row["TYPE_NAME"] = "TIMESTAMP"; } else { p._row["TYPE_NAME"] = "DATE"; } break; case 37: p._row["TYPE_NAME"] = "VARCHAR"; break; case 40: p._row["TYPE_NAME"] = "CSTRING"; break; case 261: short subtype = (short)rows[index]["PARAMETER_SUB_TYPE"]; switch (subtype) { case 0: p._row["TYPE_NAME"] = "BLOB(BINARY)"; break; case 1: p._row["TYPE_NAME"] = "BLOB(TEXT)"; break; default: p._row["TYPE_NAME"] = "BLOB(UNKNOWN)"; break; } break; } int scale = p.NumericScale; if (scale < 0) { p._row["TYPE_NAME"] = "NUMERIC"; p._row["NUMERIC_SCALE"] = Math.Abs(scale); } // Step 2: DataTypeNameComplete string s = p._row["TYPE_NAME"] as string; switch (s) { case "VARCHAR": case "CHAR": p._row["TYPE_NAME_COMPLETE"] = s + "(" + p.CharacterMaxLength + ")"; break; case "NUMERIC": switch ((int)p._row["PARAMETER_SIZE"]) { case 2: p._row["TYPE_NAME_COMPLETE"] = s + "(4, " + p.NumericScale.ToString() + ")"; break; case 4: p._row["TYPE_NAME_COMPLETE"] = s + "(9, " + p.NumericScale.ToString() + ")"; break; case 8: p._row["TYPE_NAME_COMPLETE"] = s + "(15, " + p.NumericScale.ToString() + ")"; break; default: p._row["TYPE_NAME_COMPLETE"] = "NUMERIC(18,0)"; break; } break; case "BLOB(TEXT)": case "BLOB(BINARY)": p._row["TYPE_NAME_COMPLETE"] = "BLOB"; break; default: p._row["TYPE_NAME_COMPLETE"] = s; break; } s = p._row["TYPE_NAME_COMPLETE"] as string; dim = 0; object o = rows[index]["DIM"]; if (o != DBNull.Value) { dim = (short)o; } if (dim > 0) { dimTable.DefaultView.RowFilter = "Name = '" + p.Name + "'"; dimTable.DefaultView.Sort = "DIM"; string a = "["; bool bFirst = true; foreach (DataRowView vrow in dimTable.DefaultView) { DataRow row = vrow.Row; if (!bFirst) { a += ","; } a += row["L"].ToString() + ":" + row["U"].ToString(); bFirst = false; } a += "]"; p._row["TYPE_NAME_COMPLETE"] = s + a; p._row["TYPE_NAME"] = p._row["TYPE_NAME"] + ":A"; } } } } catch (Exception ex) { string e = ex.Message; } if (cn != null) { cn.Close(); } }
override internal void LoadAll() { try { using (FbConnection cn = new FirebirdSql.Data.FirebirdClient.FbConnection(this._dbRoot.ConnectionString)) { cn.Open(); if (allFkData == null) { allFkData = cn.GetSchema("ForeignKeys"); allFkData.Columns.Add("COLUMN_NAME"); allFkData.Columns.Add("REFERENCED_COLUMN_NAME"); allFkData.Columns.Add("ORDINAL_POSITION"); allFkData.Columns.Add("DEFERRABILITY"); mappingHash = new NameValueCollection(); mappingHash["FK_TABLE_CATALOG"] = "TABLE_CATALOG"; mappingHash["FK_TABLE_SCHEMA"] = "TABLE_SCHEMA"; mappingHash["FK_TABLE_NAME"] = "TABLE_NAME"; mappingHash["PK_TABLE_CATALOG"] = "REFERENCED_TABLE_CATALOG"; mappingHash["PK_TABLE_SCHEMA"] = "REFERENCED_TABLE_SCHEMA"; mappingHash["PK_TABLE_NAME"] = "REFERENCED_TABLE_NAME"; mappingHash["ORDINAL"] = "ORDINAL_POSITION"; mappingHash["UPDATE_RULE"] = "UPDATE_RULE"; mappingHash["DELETE_RULE"] = "DELETE_RULE"; mappingHash["PK_NAME"] = "INDEX_NAME"; mappingHash["FK_NAME"] = "CONSTRAINT_NAME"; mappingHash["DEFERRABILITY"] = "DEFERRABILITY"; } DataTable metaData = allFkData.Clone(); metaData.Clear(); foreach (DataRow row in allFkData.Rows) { if ((this.Table.Name == (string)row["TABLE_NAME"]) || (this.Table.Name == (string)row["REFERENCED_TABLE_NAME"])) { string indexName = (string)row["INDEX_NAME"]; string refTableName = (string)row["REFERENCED_TABLE_NAME"]; string isDef = (string)row["IS_DEFERRABLE"]; string initDef = (string)row["INITIALLY_DEFERRED"]; row["DEFERRABILITY"] = (isDef == "NO" ? 3 : (initDef == "YES" ? 2 : 1)); DataTable metaDataColumns = cn.GetSchema("IndexColumns", new string[] { null, null, null, indexName }); metaDataColumns.DefaultView.Sort = "ORDINAL_POSITION ASC"; DataTable metaDataPKIndex = cn.GetSchema("Indexes", new string[] { null, null, refTableName }); metaDataPKIndex.DefaultView.RowFilter = "IS_PRIMARY = True"; string refPkIndexName = (string)metaDataPKIndex.DefaultView[0]["INDEX_NAME"]; DataTable metaDataColumnsRefPk = cn.GetSchema("IndexColumns", new string[] { null, null, null, refPkIndexName }); metaDataColumnsRefPk.DefaultView.Sort = "ORDINAL_POSITION ASC"; if (metaDataColumnsRefPk.Rows.Count == metaDataColumns.Rows.Count) { for (int i = 0; i < metaDataColumnsRefPk.Rows.Count; i++) { DataRow newrow = metaData.Rows.Add(row.ItemArray); newrow["ORDINAL_POSITION"] = metaDataColumnsRefPk.DefaultView[i]["ORDINAL_POSITION"]; newrow["COLUMN_NAME"] = metaDataColumns.DefaultView[i]["COLUMN_NAME"]; newrow["REFERENCED_COLUMN_NAME"] = metaDataColumnsRefPk.DefaultView[i]["COLUMN_NAME"]; } } } } cn.Close(); PopulateArrayNoHookup(metaData, mappingHash); ForeignKey key = null; string keyName = ""; foreach (DataRow row in metaData.Rows) { keyName = row["CONSTRAINT_NAME"] as string; key = this.GetByName(keyName); key.AddForeignColumn(null, null, (string)row["TABLE_NAME"], (string)row["COLUMN_NAME"], false); key.AddForeignColumn(null, null, (string)row["REFERENCED_TABLE_NAME"], (string)row["REFERENCED_COLUMN_NAME"], true); } } } catch (Exception ex) { string m = ex.Message; } }