public virtual DataTable GetSchema(FbConnection connection, object[] restrictions)
{
restrictions = this.ParseRestrictions(restrictions);
FbCommand command = this.BuildCommand(connection, restrictions);
FbDataAdapter adapter = new FbDataAdapter(command);
DataSet dataSet = new DataSet(this.schemaName);
try
{
adapter.Fill(dataSet, this.schemaName);
}
catch (Exception ex)
{
throw new FbException(ex.Message);
}
finally
{
adapter.Dispose();
command.Dispose();
}
TrimStringFields(dataSet.Tables[this.schemaName]);
return this.ProcessResult(dataSet.Tables[this.schemaName]);
}
public void FillMultipleTest()
{
FbTransaction transaction = this.Connection.BeginTransaction();
FbCommand command = new FbCommand("select * from TEST", Connection, transaction);
FbDataAdapter adapter = new FbDataAdapter(command);
FbCommandBuilder builder = new FbCommandBuilder(adapter);
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
adapter.Fill(ds1, "TEST");
adapter.Fill(ds2, "TEST");
Assert.AreEqual(100, ds1.Tables["TEST"].Rows.Count, "Incorrect row count (ds1)");
Assert.AreEqual(100, ds2.Tables["TEST"].Rows.Count, "Incorrect row count (ds2)");
adapter.Dispose();
builder.Dispose();
command.Dispose();
transaction.Commit();
}
public void SelectComandaAtual()
{
conn.ConnectionString = Properties.Settings.Default.Firebird;
FbCommand cmd = new FbCommand("SELECT * FROM teste WHERE num =" + CodigoComanda, conn);
FbDataAdapter DA = new FbDataAdapter(cmd);
DataSet DS = new DataSet();
conn.Open();
DA.Fill(DS, "teste");
conn.Close();
Data = DS.Tables["teste"].Rows[0][1].ToString();
conn.Close();
}
public void FillMultipleWithImplicitTransactionTest()
{
FbCommand command = new FbCommand("select * from TEST", Connection);
FbDataAdapter adapter = new FbDataAdapter(command);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
FbCommandBuilder builder = new FbCommandBuilder(adapter);
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
adapter.Fill(ds1, "TEST");
adapter.Fill(ds2, "TEST");
Assert.AreEqual(100, ds1.Tables["TEST"].Rows.Count, "Incorrect row count (ds1)");
Assert.AreEqual(100, ds2.Tables["TEST"].Rows.Count, "Incorrect row count (ds2)");
adapter.Dispose();
builder.Dispose();
command.Dispose();
}
private void button4_Click(object sender, EventArgs e)
{
FbConnection conn = DBConnect.GetConnection();
DataTable table = new DataTable();
string myQuery = "Select * from USERS";
FbCommand command = new FbCommand(myQuery, conn);
FbDataAdapter adapter = new FbDataAdapter(command);
adapter.SelectCommand = command;
adapter.Fill(table);
dataGridView1.DataSource = table;
table.ExportToExcel(@"..\source\repos\warehouse\warehouse\bin\Debug\users.xlsx");
}
public void InserirDataGrid()
{
conn = new FbConnection(strConn);
FbCommand cmd = new FbCommand("SELECT VI.id_produto, P.descricao, VI.quantidade, VI.valor_unitario, VI.total FROM VENDA_COMANDA_ITEM VI JOIN PRODUTOS P ON P.ID=VI.id_produto WHERE VI.id_venda_comanda = 1", conn);
FbDataAdapter DA = new FbDataAdapter(cmd);
DataSet DS = new DataSet();
conn.Open();
DA.Fill(DS);
dataGridView1.DataSource = DS;
dataGridView1.DataMember = DS.Tables[0].TableName;
conn.Close();
}
private void buttonLogin_Click(object sender, EventArgs e)
{
FbConnection conn = DBConnect.GetConnection();
String LoginUser = LoginField.Text;
String passUser = passField.Text;
DataTable table = new DataTable();
string myQuery = "Select * from USERS WHERE LOGIN = @ul AND PASSWORD = @up";
FbCommand command = new FbCommand(myQuery, conn);
command.Parameters.Add("@ul", FbDbType.VarChar).Value = LoginUser;
command.Parameters.Add("@up", FbDbType.VarChar).Value = passUser;
FbDataAdapter adapter = new FbDataAdapter(command);
adapter.SelectCommand = command;
adapter.Fill(table);
dataGridView1.DataSource = table;
if (table.Rows.Count > 0)
{
switch (dataGridView1[1, 0].Value.ToString())
{
case "1":
_f2 = new Storekeeper();
_f2.Show(this);
this.Hide();
break;
case "2":
_f3 = new Manager();
_f3.Show(this);
this.Hide();
break;
case "3":
_f3 = new Manager();
_f3.Show(this);
this.Hide();
break;
case "4":
_f4 = new Accountant();
_f4.Show(this);
this.Hide();
break;
}
}
else
{
MessageBox.Show("Такий користувач не зараєстрований в базі даних");
}
}
private DataTable SelectToDataTable(string sql)
{
var dataTable = new DataTable();
using (var conn = ConnectionProvider.CreateConnection() as FbConnection)
{
using (var adapter = new FbDataAdapter(sql, conn))
{
adapter.Fill(dataTable);
}
}
return(dataTable);
}
private void btnlistar_Click(object sender, EventArgs e)
{
FbCommand cmd = new FbCommand("SELECT id, usuario, '********' as senha FROM tblogin", conn); //executa o SQL
FbDataAdapter DA = new FbDataAdapter(cmd); //cria uma variavel para coletar o resultado
DataSet DS = new DataSet(); //cria uma variavel DATASET para distribuir o resultado
conn.Open(); // abre conexao
//jogar os resultados no grid.
DA.Fill(DS, "tblogin"); //Diz para o DATASET qual a tabela
dataGridView1.DataSource = DS; // Linca o GRID com o DATASET
dataGridView1.DataMember = "tblogin"; //especifica nome da base para grid
btnlimpar_Click(btnlimpar, e);
conn.Close(); //fecha conecxao
}
public DataSet FbGetData(string strProcedure)
{
DataSet dsData = new DataSet();
_Comand = new FbCommand();
_Comand.Connection = _Conect;
_Comand.CommandType = CommandType.StoredProcedure;
_Comand.CommandText = strProcedure;
FbDataAdapter fbdtAdapter = new FbDataAdapter(_Comand);
fbdtAdapter.Fill(dsData);
return(dsData);
}
public static bool CreateSubGrupoSysPDV()
{
try
{
connectionModel.Open();
using (FbCommand commandModel = new FbCommand("select secao_id, grupo_id, subgrupo_id, descricao from subgrupo", connectionModel))
{
using (FbDataAdapter fbData = new FbDataAdapter(commandModel))
{
using (DataTable dt = new DataTable())
{
fbData.Fill(dt);
if (dt.Rows.Count > 0)
{
connectionSysPDV.Open();
using (FbCommand insertSecaoSysPDV = new FbCommand("insert into subgrupo (seccod, grpcod, sgrcod, sgrdes) values (@seccod, @grpcod, @sgrcod, @sgrdes)", connectionSysPDV))
{
insertSecaoSysPDV.Parameters.Add("seccod", FbDbType.Char).Value = "";
insertSecaoSysPDV.Parameters.Add("grpcod", FbDbType.VarChar).Value = "";
insertSecaoSysPDV.Parameters.Add("sgrcod", FbDbType.VarChar).Value = "";
insertSecaoSysPDV.Parameters.Add("sgrdes", FbDbType.VarChar).Value = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
insertSecaoSysPDV.Parameters["seccod"].Value = dt.Rows[i]["secao_id"].ToString();
insertSecaoSysPDV.Parameters["grpcod"].Value = dt.Rows[i]["grupo_id"].ToString();
insertSecaoSysPDV.Parameters["sgrcod"].Value = dt.Rows[i]["subgrupo_id"].ToString();
insertSecaoSysPDV.Parameters["sgrdes"].Value = dt.Rows[i]["descricao"].ToString();
insertSecaoSysPDV.ExecuteNonQuery();
}
}
}
}
}
}
}
catch (FbException error)
{
throw error;
}
catch (Exception error)
{
throw error;
}
finally
{
connectionModel.Close();
connectionSysPDV.Close();
}
return(true);
}
public static List <Produto> GetListProdutosSysPDV(List <Produto> products)
{
List <Produto> produtos = new List <Produto>();
try
{
connectionSysPDV.Open();
FbCommand fbCommand = new FbCommand(@"select P.PROCOD as CODIGO, PA.PROCODAUX as EAN, P.PRODES as DESCRICAO, P.PRODESRDZ as REDUZIDA, " +
"S.SECDES as SECAO, P.SECCOD as SECCOD, G.GRPDES as GRUPO, P.GRPCOD as GRPCOD, SG.SGRDES as SUBGRUPO, P.SGRCOD as SGRCOD, P.PRONCM as NCM, " +
"P.PROCEST as CEST from PRODUTO P left outer join PRODUTOAUX PA on PA.PROCOD=P.PROCOD " +
"left outer join SECAO S on S.SECCOD=P.SECCOD " +
"left outer join GRUPO G on G.SECCOD = P.SECCOD and G.GRPCOD = P.GRPCOD " +
"left outer join SUBGRUPO SG on SG.SECCOD = P.SECCOD and SG.GRPCOD = P.GRPCOD AND SG.SGRCOD = P.SGRCOD " +
"order by PA.PROCODAUX", connectionSysPDV);
using (FbDataAdapter fbDataAdapter = new FbDataAdapter(fbCommand))
{
using (DataTable dataTable = new DataTable())
{
fbDataAdapter.Fill(dataTable);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
produtos.Add(new Produto()
{
Codigo = dataTable.Rows[i]["CODIGO"].ToString(),
Ean = dataTable.Rows[i]["EAN"].ToString().Trim(' '),
Descricao = dataTable.Rows[i]["DESCRICAO"].ToString(),
Reduzida = dataTable.Rows[i]["REDUZIDA"].ToString(),
Secao = dataTable.Rows[i]["SECAO"].ToString(),
Seccod = dataTable.Rows[i]["SECCOD"].ToString(),
Grupo = dataTable.Rows[i]["GRUPO"].ToString(),
Grpcod = dataTable.Rows[i]["GRPCOD"].ToString(),
Subgrupo = dataTable.Rows[i]["SUBGRUPO"].ToString(),
Sgrcod = dataTable.Rows[i]["SGRCOD"].ToString(),
NCM = dataTable.Rows[i]["NCM"].ToString(),
CEST = dataTable.Rows[i]["CEST"].ToString(),
});
}
}
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
connectionSysPDV.Close();
}
return(produtos.Intersect(products, new ProdutoEanComparer()).ToList());
}
// Connects to PostalMates Database and querys all the table names
private void fillPostalMate()
{
string connectionString = "User=SYSDBA; Password=3k7rur9e; Database=PCS; DataSource=localhost; Port=3050;";
using (FbConnection con = new FbConnection(connectionString))
{
var Query = "SELECT rdb$relation_name AS PostalMate FROM rdb$relations WHERE rdb$view_blr is null AND (rdb$system_flag is null or rdb$system_flag = 0) ORDER BY rdb$relation_name ASC ";
var dataAdapter = new FbDataAdapter(Query, con);
var commandBuilder = new FbCommandBuilder(dataAdapter);
DataTable dt = new DataTable();
dataAdapter.Fill(dt);
dataGrid1.ItemsSource = dt.DefaultView;
}
}
private void UcitajDTIzboraRobe()
{
using (FbConnection con = new FbConnection(M.Baza.connectionKomercijalno2018))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT ROBA.ROBAID, ROBA.KATBR, ROBA.KATBRPRO, ROBA.NAZIV, ROBAUMAGACINU.STANJE FROM ROBAUMAGACINU INNER JOIN ROBA ON ROBAUMAGACINU.ROBAID = ROBA.ROBAID WHERE ROBAUMAGACINU.MAGACINID = @MagacinID AND ROBA.VRSTA = 1", con))
{
da.SelectCommand.Parameters.AddWithValue("@MagacinID", 12);
da.Fill(izborRobeDT);
}
con.Close();
}
}
private void UcitajBaze()
{
try
{
using (FbConnection con = new FbConnection(M.Baza.connectionKomercijalno2018))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT PPID, NAZIV, PIB FROM PARTNER ORDER BY PPID ASCENDING", con))
{
da.Fill(Partneri_2018);
}
con.Close();
}
using (FbConnection con = new FbConnection(M.Baza.connectionKomercijalno2017))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT PPID, NAZIV, PIB FROM PARTNER ORDER BY PPID ASCENDING", con))
{
da.Fill(Partneri_2017);
}
con.Close();
}
using (FbConnection con = new FbConnection(M.Baza.connectionKomercijalno2016))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT PPID, NAZIV, PIB FROM PARTNER ORDER BY PPID ASCENDING", con))
{
da.Fill(Partneri_2016);
}
con.Close();
}
using (FbConnection con = new FbConnection(M.Baza.connectionKomercijalno2015))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT PPID, NAZIV, PIB FROM PARTNER ORDER BY PPID ASCENDING", con))
{
da.Fill(Partneri_2015);
}
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
uporedi_btn.Enabled = true;
}
public async Task FillMultipleTest()
{
await using (var transaction = await Connection.BeginTransactionAsync())
{
await using (var command = new FbCommand("select * from TEST", Connection, transaction))
{
using (var adapter = new FbDataAdapter(command))
{
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
using (var ds1 = new DataSet())
using (var ds2 = new DataSet())
{
adapter.Fill(ds1, "TEST");
adapter.Fill(ds2, "TEST");
Assert.AreEqual(100, ds1.Tables["TEST"].Rows.Count, "Incorrect row count (ds1)");
Assert.AreEqual(100, ds2.Tables["TEST"].Rows.Count, "Incorrect row count (ds2)");
}
}
}
await transaction.CommitAsync();
}
}
public void FiltraProdutos()
{
string sql = "SELECT P.ID, P.CODIGO_BARRA, P.DESCRICAO, P.PRECO_VAREJO FROM PRODUTOS P WHERE P.DESCRICAO LIKE '" + (txtConsultaProduto.Text).ToUpper() + "%'";
cmd = new FbCommand(sql, conn);
DA = new FbDataAdapter(cmd);
DS = new DataSet();
conn.Open();
DA.Fill(DS);
dgvConsultaProdutos.DataSource = DS;
dgvConsultaProdutos.DataMember = DS.Tables[0].TableName;
conn.Close();
ConfigurarDataGrid();
}
public void PreencherGrid()
{
using (FbConnection connection = DaoBanco.GetInstancia().getConexao())
{
try
{
string mSQL = "SELECT * FROM fornecedores";
FbCommand cmd = new FbCommand(mSQL, connection);
FbDataAdapter da = new FbDataAdapter(cmd);
dtCliente = new DataTable();
da.Fill(dtCliente);
this.gdFornecedor.DataSource = dtCliente;
this.gdFornecedor.Columns["ID_FORNECEDOR"].HeaderText = "Código";
this.gdFornecedor.Columns["ID_FORNECEDOR"].Width = 50;
this.gdFornecedor.Columns["NOME_FANT"].HeaderText = "Razão Social";
this.gdFornecedor.Columns["NOME_FANT"].Width = 280;
this.gdFornecedor.Columns["RG_INSC"].HeaderText = "CPF/CNPJ";
this.gdFornecedor.Columns["RG_INSC"].Width = 280;
this.gdFornecedor.Columns["CPF_CNPJ"].HeaderText = "CPF/CNPJ";
this.gdFornecedor.Columns["FONEF"].HeaderText = "Telefone";
this.gdFornecedor.Columns["FONEC"].HeaderText = "Celular";
this.gdFornecedor.Columns["CIDADE"].HeaderText = "Cidade";
this.gdFornecedor.Columns["CIDADE"].Width = 150;
this.gdFornecedor.Columns["EMAIL"].HeaderText = "E-mail";
this.gdFornecedor.Columns["EMAIL"].Width = 150;
this.gdFornecedor.Columns["PESSOA"].Visible = false;
this.gdFornecedor.Columns["RAZAO"].Visible = false;
this.gdFornecedor.Columns["NASC_FUNDA"].Visible = false;
this.gdFornecedor.Columns["ENDERECO"].Visible = false;
this.gdFornecedor.Columns["NUMERO"].Visible = false;
this.gdFornecedor.Columns["CEP"].Visible = false;
this.gdFornecedor.Columns["BAIRRO"].Visible = false;
this.gdFornecedor.Columns["UF"].Visible = false;
this.gdFornecedor.Columns["FONEX"].Visible = false;
this.gdFornecedor.Columns["OBS"].Visible = false;
}
catch (FbException fbex)
{
MessageBox.Show("Erro de acesso a dados do cliente : " + fbex.Message, "Erro");
}
finally
{
}
}
}
public DataTable ExecuteQueryResult(string command)
{
DataTable dataTable = new DataTable();
using (FbConnection connection = new FbConnection(DataBaseManger.connectionString))
{
connection.Open();
FbDataAdapter fbDataAdapter = new FbDataAdapter(new FbCommand(command, connection));
DataSet dataSet = new DataSet();
fbDataAdapter.Fill(dataSet);
dataTable = dataSet.Tables[0];
}
return(dataTable);
}
public void Carrega(DataGridView grid)
{
FbDataAdapter adapter = new FbDataAdapter();
DataTable table = new DataTable();
adapter.SelectCommand = new FbCommand("select COD_ESTADO,NOM_ESTADO " +
"from ESTADOS " +
"order by COD_ESTADO",
Globais.bd);
adapter.Fill(table);
table.Columns[0].ColumnName = "Código";
table.Columns[1].ColumnName = "Nome";
grid.DataSource = table;
}
public static DataTable UcitajRobuKomercijalnog(string connString)
{
DataTable dt = new DataTable();
using (FbConnection con = new FbConnection(connString))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT ROBAID, NAZIV, KATBR, KATBRPRO, STANJE FROM ROBA", con))
{
da.Fill(dt);
}
con.Close();
}
return(dt);
}
private void data_print()
{
Column1.Visible = false;
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[6].Visible = false;
ds.Tables[0].Columns[4].ColumnName = "Дата";
ds.Tables[0].Columns[3].ColumnName = "Квартира";
ds.Tables[0].Columns[2].ColumnName = "Адрес";
ds.Tables[0].Columns[1].ColumnName = "Площаль";
ds.Tables[0].Columns[0].ColumnName = "Цена";
myTxn.Commit();
myConn.Close();
}
/// <summary>
/// Creates a DataSet by running the stored procedure and placing
/// the results of the query/proc into the given tablename.
/// </summary>
public DataSet RunProcedure(
String storedProcName,
IDataParameter[] parameters,
String tableName)
{
DataSet myDataSet = new DataSet();
openConnection();
FbDataAdapter FbDA = new FbDataAdapter();
FbDA.SelectCommand = BuildQueryCommand(storedProcName, parameters);
FbDA.Fill(myDataSet, tableName);
closeConnection();
return(myDataSet);
}
public static DataTable UcitajPitanja()
{
DataTable dt = new DataTable();;
using (FbConnection con = new FbConnection(M.Baza.connectionString))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT * FROM KVIZ_PITANJA", con))
{
da.Fill(dt);
}
con.Close();
}
return(dt);
}
public void UpdateTimeStampTest()
{
var sql = "select * from TEST where int_field = @int_field";
var transaction = Connection.BeginTransaction();
var command = new FbCommand(sql, Connection, transaction);
var adapter = new FbDataAdapter(command);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.SelectCommand.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
var builder = new FbCommandBuilder(adapter);
var ds = new DataSet();
adapter.Fill(ds, "TEST");
Assert.AreEqual(1, ds.Tables["TEST"].Rows.Count, "Incorrect row count");
var dtValue = DateTime.Now;
ds.Tables["TEST"].Rows[0]["TIMESTAMP_FIELD"] = dtValue;
adapter.Update(ds, "TEST");
adapter.Dispose();
builder.Dispose();
command.Dispose();
transaction.Commit();
transaction = Connection.BeginTransaction();
sql = "SELECT timestamp_field FROM TEST WHERE int_field = @int_field";
command = new FbCommand(sql, Connection, transaction);
command.Parameters.Add("@int_field", FbDbType.Integer).Value = 1;
var val = (DateTime)command.ExecuteScalar();
transaction.Commit();
Assert.AreEqual(dtValue.Day, val.Day, "timestamp_field has not correct day");
Assert.AreEqual(dtValue.Month, val.Month, "timestamp_field has not correct month");
Assert.AreEqual(dtValue.Year, val.Year, "timestamp_field has not correct year");
Assert.AreEqual(dtValue.Hour, val.Hour, "timestamp_field has not correct hour");
Assert.AreEqual(dtValue.Minute, val.Minute, "timestamp_field has not correct minute");
Assert.AreEqual(dtValue.Second, val.Second, "timestamp_field has not correct second");
}
public DataSet Otvori(string upit, Hashtable parametri)
{
bool uTransakciji;
FbTransaction tran;
DataSet ds = null;
if (Transaction == null)
{
izuzeci.Clear();
tran = Connection.BeginTransaction();
uTransakciji = false;
}
else
{
tran = Transaction;
uTransakciji = true;
}
try
{
FbCommand Command = new FbCommand(upit, Connection, tran);
if (parametri != null)
{
NapuniParametre(Command, parametri);
}
FbDataAdapter da = new FbDataAdapter(Command);
ds = new DataSet();
da.Fill(ds);
if (!uTransakciji)
{
tran.Commit();
tran.Dispose();
}
}
catch (Exception ex)
{
izuzeci.Add(ex);
if (!uTransakciji)
{
tran.Rollback();
tran.Dispose();
}
else
{
throw ex;
}
}
return(ds);
}
public void Carrega(DataGridView grid)
{
FbDataAdapter adapter = new FbDataAdapter();
DataTable table = new DataTable();
adapter.SelectCommand = new FbCommand("select cod_funcionario," +
" nom_funcionario," +
" des_logradouro," +
" nro_endereco," +
" des_complemento," +
" nom_bairro," +
" nom_cidade," +
" cod_estado," +
" nro_cep," +
" nro_fone1," +
" nro_fone2," +
" nro_fone3," +
" cod_cargo," +
" des_email," +
" idt_ativo," +
" DAT_NASCIMENTO," +
" nro_identidade," +
" nro_cpf " +
"from funcionarios " +
"order by cod_funcionario",
Globais.bd);
adapter.Fill(table);
table.Columns[0].ColumnName = "Código";
table.Columns[1].ColumnName = "Nome";
table.Columns[12].ColumnName = "Cargo";
grid.DataSource = table;
grid.Columns[2].Visible = false; // logradouro
grid.Columns[3].Visible = false; // nro
grid.Columns[4].Visible = false; // complemento
grid.Columns[5].Visible = false; // bairro
grid.Columns[6].Visible = false; // cidade
grid.Columns[7].Visible = false; // estado
grid.Columns[8].Visible = false; // cep
grid.Columns[9].Visible = false; // fone1
grid.Columns[10].Visible = false; // fone2
grid.Columns[11].Visible = false; // fone3
//grid.Columns[12].Visible = false; // cargo
grid.Columns[13].Visible = false; // email
grid.Columns[14].Visible = false; // idt ativo
grid.Columns[15].Visible = false; // nascimento
grid.Columns[16].Visible = false; // identidade
grid.Columns[17].Visible = false; // cpf
}
private void UcitajStavke()
{
DataTable dt1 = new DataTable();
DataTable dt_Komercijalno = Komercijalno.robaTable.Clone();
using (FbConnection con = new FbConnection(M.Baza.connectionString))
{
con.Open();
using (FbDataAdapter da = new FbDataAdapter("SELECT ROBAID, POPUST, KOLICINA, MAX_KOLICINA, TRSTANJE FROM LISTASTAVKE WHERE LISTAID = @ListaID", con))
{
da.SelectCommand.Parameters.AddWithValue("@ListaID", M.Podesavanja.ListeID.RobaAkcije);
da.Fill(dt1);
}
}
foreach (DataRow dr in dt1.Rows)
{
DataRow dataRow = Komercijalno.robaTable.Select(String.Format("ROBAID = {0}", dr.Field <int>("ROBAID"))).FirstOrDefault();
dt_Komercijalno.Rows.Add(dataRow.ItemArray);
}
dt1.PrimaryKey = new DataColumn[] { dt1.Columns["ROBAID"] };
dt_Komercijalno.PrimaryKey = new DataColumn[] { dt_Komercijalno.Columns["ROBAID"] };
dt1.Merge(dt_Komercijalno);
dataGridView1.DataSource = dt1;
dataGridView1.Columns["NAZIV"].DisplayIndex = 0;
dataGridView1.Columns["NAZIV"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns["NAZIV"].ReadOnly = true;
dataGridView1.Columns["KATBR"].ReadOnly = true;
dataGridView1.Columns["ROBAID"].Visible = false;
dataGridView1.Columns["STANJE"].Visible = false;
dataGridView1.Columns["KATBRPRO"].Visible = false;
dataGridView1.Columns["KOLICINA"].DisplayIndex = 2;
dataGridView1.Columns["KOLICINA"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns["POPUST"].DisplayIndex = 3;
dataGridView1.Columns["POPUST"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns["KATBR"].DisplayIndex = 1;
dataGridView1.Columns["KATBR"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns["POPUST"].DefaultCellStyle.BackColor = Color.LightYellow;
dataGridView1.Columns["KOLICINA"].DefaultCellStyle.BackColor = Color.LightYellow;
dataGridView1.Columns["MAX_KOLICINA"].DefaultCellStyle.BackColor = Color.LightYellow;
dataGridView1.Columns["MAX_KOLICINA"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView1.Columns["TRSTANJE"].DefaultCellStyle.BackColor = Color.LightYellow;
dataGridView1.Columns["TRSTANJE"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
public static List <Produto> GetListProdutosModel()
{
List <Produto> produtos = new List <Produto>();
try
{
connectionModel.Open();
FbCommand fbCommand = new FbCommand(@"select P.CODIGO as EAN, P.DESCRICAO as DESCRICAO, P.REDUZIDA as REDUZIDA, " +
"S.DESCRICAO as SECAO, P.SECAO_ID as SECCOD, G.DESCRICAO as GRUPO, P.GRUPO_ID as GRPCOD, SG.DESCRICAO as SUBGRUPO, P.SUBGRUPO_ID as SGRCOD, P.NCM as NCM, " +
"P.CEST as CEST from PRODUCTS P " +
"left outer join SECAO S on S.SECAO_ID = P.SECAO_ID " +
"left outer join GRUPO G on G.SECAO_ID = P.SECAO_ID and G.GRUPO_ID = P.GRUPO_ID " +
"left outer join SUBGRUPO SG on SG.SECAO_ID = P.SECAO_ID and SG.GRUPO_ID = P.GRUPO_ID AND SG.SUBGRUPO_ID = P.SUBGRUPO_ID order by P.CODIGO", connectionModel);
using (FbDataAdapter fbDataAdapter = new FbDataAdapter(fbCommand))
{
using (DataTable dataTable = new DataTable())
{
fbDataAdapter.Fill(dataTable);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
produtos.Add(new Produto()
{
Ean = dataTable.Rows[i]["EAN"].ToString(),
Descricao = dataTable.Rows[i]["DESCRICAO"].ToString(),
Reduzida = dataTable.Rows[i]["REDUZIDA"].ToString(),
Secao = dataTable.Rows[i]["SECAO"].ToString(),
Seccod = dataTable.Rows[i]["SECCOD"].ToString(),
Grupo = dataTable.Rows[i]["GRUPO"].ToString(),
Grpcod = dataTable.Rows[i]["GRPCOD"].ToString(),
Subgrupo = dataTable.Rows[i]["SUBGRUPO"].ToString(),
Sgrcod = dataTable.Rows[i]["SGRCOD"].ToString(),
NCM = dataTable.Rows[i]["NCM"].ToString(),
CEST = dataTable.Rows[i]["CEST"].ToString(),
});
}
}
}
}
catch (FbException erro)
{
throw erro;
}
finally
{
connectionModel.Close();
}
return(produtos);
}
public void Carrega(DataGridView grid)
{
FbDataAdapter adapter = new FbDataAdapter();
DataTable table = new DataTable();
adapter.SelectCommand = new FbCommand("select COD_TERMO, " +
" DES_TERMO " +
"from TERMOS_APROVACAO " +
"order by COD_TERMO",
Globais.bd);
adapter.Fill(table);
table.Columns[0].ColumnName = "Código";
table.Columns[1].ColumnName = "Descrição";
grid.DataSource = table;
grid.Columns["Descrição"].Visible = false;
}
private void LoadEndereco()
{
Conexao.Active(true);
try {
DataTable dt = new DataTable();
FbDataAdapter da = new FbDataAdapter("SELECT ENDCEP,ENDENDE,BAINOME FROM ENDERECO E left join BAIRRO B on E.BAICODI = B.BAICODI", Conexao.FbCnn);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
dgvendereco.DataSource = dt;
}
}
finally {
Conexao.Active(false);
}
}
