public void firebird()
{
//var connector = DataSources.Get("Results");
// List list = new List<KeyValuePair<string, string>>();
string con_string =
"User=SYSDBA;" +
"Password=masterkey;" +
"Database=C:\\Program Files (x86)\\Firebird\\Firebird_3_0\\examples\\empbuild\\employee.FDB;" +
"DataSource=localhost;" +
"Port=3050;" +
// "Dialect=3;" +
"Charset=NONE;" +
"Role=";
/*
* "Connection lifetime=15;" +
* "Pooling=true;" +
* "MinPoolSize=0;" +
* "MaxPoolSize=50;" +
* "Packet Size=8192;" +
* "ServerType=0";
*/
FirebirdSql.Data.FirebirdClient.FbConnection con = new FirebirdSql.Data.FirebirdClient.FbConnection(con_string);
con.Open();
Ranorex.Report.Info(con.ServerVersion.ToString());
string query = "SELECT a.COUNTRY, a.CURRENCY FROM COUNTRY a";
FirebirdSql.Data.FirebirdClient.FbCommand command = new FirebirdSql.Data.FirebirdClient.FbCommand(query, con);
FirebirdSql.Data.FirebirdClient.FbDataReader reader = command.ExecuteReader();
DataTable datatable = new DataTable();
datatable.Load(reader);
con.Close();
int rows = datatable.Rows.Count;
if (rows > 0)
{
for (int i = 0; i < rows; i++)
{
string[] stringData = Array.ConvertAll <object, string>(datatable.Rows[i].ItemArray.ToArray(), o => o.ToString());
Ranorex.Report.Info("Country: " + datatable.Rows[i][0] + " Currency: " + datatable.Rows[i][1]);
//list.add(new KeyValuePair<string, int>("A", 1));
}
}
}
public static string getIDbyNumeroProcesso(string procNumero)
{
string retorno = string.Empty;
string sql = "SELECT ID FROM webprocesso proc where proc.numero = " + procNumero;
FirebirdSql.Data.FirebirdClient.FbConnection conn = AcessoDados.AcessoDados.getConn();
FirebirdSql.Data.FirebirdClient.FbCommand comando = new FirebirdSql.Data.FirebirdClient.FbCommand(sql, conn);
conn.Open();
FirebirdSql.Data.FirebirdClient.FbDataReader dr = comando.ExecuteReader();
while (dr.Read())
{
retorno = dr["ID"].ToString();
}
conn.Close();
return retorno;
}
public virtual void PrepareListResponsaveis(ASPxGridViewHeaderFilterEventArgs e)
{
e.Values.Clear();
FirebirdSql.Data.FirebirdClient.FbConnection conn = AcessoDados.AcessoDados.getConn();
FirebirdSql.Data.FirebirdClient.FbCommand comando = new FirebirdSql.Data.FirebirdClient.FbCommand("Select * from sci_usuarios where usu_idundfuncional is not null", conn);
conn.Open();
FirebirdSql.Data.FirebirdClient.FbDataReader dr = comando.ExecuteReader();
while (dr.Read()) {
e.AddValue(dr["usu_nome"].ToString(), dr["usu_nome"].ToString());
}
conn.Close();
}
public virtual void PrepareListCentroCusto(ASPxGridViewHeaderFilterEventArgs e)
{
e.Values.Clear();
FirebirdSql.Data.FirebirdClient.FbConnection conn = AcessoDados.AcessoDados.getConn();
FirebirdSql.Data.FirebirdClient.FbCommand comando = new FirebirdSql.Data.FirebirdClient.FbCommand("Select cennome from centrocusto", conn);
conn.Open();
FirebirdSql.Data.FirebirdClient.FbDataReader dr = comando.ExecuteReader();
while (dr.Read())
{
e.AddValue(dr["cennome"].ToString(), dr["cennome"].ToString());
}
conn.Close();
}
private void xrLabel37_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
string sql = "Select first 1 liq_responsavel from webtramite tra join webprocesso proc on proc.id = tra.idprocesso where proc.numero = " + xrLabel4.Text +
" and liq_responsavel is not null";
string resp = string.Empty;
FirebirdSql.Data.FirebirdClient.FbConnection conn = Persist.GetConn.getConn();
FirebirdSql.Data.FirebirdClient.FbCommand cmd = new FirebirdSql.Data.FirebirdClient.FbCommand(sql, conn);
conn.Open();
FirebirdSql.Data.FirebirdClient.FbDataReader dr = cmd.ExecuteReader();
while (dr.Read()) {
if (!Convert.IsDBNull(dr["liq_responsavel"])) {
resp = dr["liq_responsavel"].ToString();
}
}
conn.Close();
if (!resp.Equals(string.Empty)) {
XRLabel l = (XRLabel)sender;
l.Text = resp;
}
}
private void xrLabel21_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
if (lbIdAssunto.Text == "1" || lbIdAssunto.Text == "2")
{
XRLabel l = (XRLabel)sender;
string sql = "select first 1 tra.data_liquidacao, (select ordenador from sp_fluxus_getordenadorbydata(did.didorgao||did.didunidade,tra.DATA_ACEITE_NF)) " +
"from webtramite tra join webprocesso proc on proc.id = tra.idprocesso " +
"join webdid did on did.numero = proc.numero " +
"where proc.numero = " + xrLabel4.Text + " and tra.idprocesso = proc.id and tra.data_liquidacao is not null and tra.val_liquidado is not null and tra.nf_liquidacao is not null order by tra.id DESC";
FirebirdSql.Data.FirebirdClient.FbConnection conn = Persist.GetConn.getConn();
FirebirdSql.Data.FirebirdClient.FbCommand cmd = new FirebirdSql.Data.FirebirdClient.FbCommand(sql, conn);
if (conn.State == System.Data.ConnectionState.Closed) {
conn.Open();
}
FirebirdSql.Data.FirebirdClient.FbDataReader dr = cmd.ExecuteReader();
while (dr.Read()) {
l.Text = dr["ORDENADOR"].ToString();
}
}
}
