public bool altera(Fornecedor forn)
{
sql = "UPDATE fornecedor SET forn_cnpj='@2', forn_razaosocial='@3'," +
" forn_inscestadual='@4', forn_bairro='@5', forn_rua='@6', forn_num='@7', "+
"forn_cep='@8', forn_email='@9', forn_site='@A', forn_fone='@B', forn_cel='@C', forn_representante='@D', cid_cod='@E' "+
"WHERE forn_id = @1";
sql = sql.Replace("@2", forn.Cnpj);
sql = sql.Replace("@3", forn.RazaoS);
sql = sql.Replace("@4", forn.InscEst);
sql = sql.Replace("@5", forn.Bairro);
sql = sql.Replace("@6", forn.Rua);
sql = sql.Replace("@7", forn.Num);
sql = sql.Replace("@8", forn.Cep);
sql = sql.Replace("@9", forn.Email);
sql = sql.Replace("@A", forn.Site);
sql = sql.Replace("@B", forn.Fone);
sql = sql.Replace("@C", forn.Cel);
sql = sql.Replace("@D", forn.Representante);
sql = sql.Replace("@E", forn.CidCod);
sql = sql.Replace("@1", forn.Id);
bco.conecta();
result = bco.executeNonQuery(sql);
bco.desconecta();
return result;
}
public bool excluir(Fornecedor forn)
{
sql = "DELETE FROM fornecedor WHERE forn_id = @1";
sql = sql.Replace("@1", forn.Id);
bco.conecta();
result = bco.executeNonQuery(sql);
bco.desconecta();
return result;
}
public frmFornGerenciar(bool isBusca)
{
this.isBusca = isBusca;
InitializeComponent();
if (isBusca)
adaptaInterface();
forn = new Fornecedor();
lblTotForn.Text = forn.getTotal();
forn.RazaoS = "";
atualizaDtgv();
}
private void adaptaInterface()
{
ttbNome.Text = prod.Desc;
ttbEstAtual.Value = Convert.ToInt32(prod.EstoqueA);
ttbEstMin.Value = Convert.ToInt32(prod.EstoqueMin);
ttbValor.Text = prod.Valor;
forn = new Fornecedor();
forn.Id = prod.FornId;
forn = forn.getById();
ttbForn.Text = forn.RazaoS;
btnCadastrar.Image = imageList1.Images[0];
}
public frmFornNovo(String fornId)
{
InitializeComponent();
util = new Utils();
forn = new Fornecedor();
carregaCbb();
if (fornId != "") //atualiza
{
forn.Id = fornId;
forn = forn.getById();
adptaInterface();
}
else //cadastro
{
cbbEstado.SelectedIndex = cbbEstado.Items.Count - 2;
cbbCidade.SelectedValue = util.getCodCidade("Presidente Prudente");
primeiroLoadCidades = false;
}
}
public Fornecedor getById(String id)
{
Fornecedor forn = new Fornecedor();
sql = "SELECT * FROM fornecedor WHERE forn_id = @1";
sql = sql.Replace("@1", id);
bco.conecta();
bco.executeQuery(sql, out dt);
bco.desconecta();
forn.Id = id;
forn.InscEst = dt.Rows[0]["forn_inscestadual"].ToString();
forn.Num = dt.Rows[0]["forn_num"].ToString();
forn.RazaoS = dt.Rows[0]["forn_razaosocial"].ToString();
forn.Representante = dt.Rows[0]["forn_representante"].ToString();
forn.Rua = dt.Rows[0]["forn_rua"].ToString();
forn.Site = dt.Rows[0]["forn_site"].ToString();
forn.Bairro = dt.Rows[0]["forn_bairro"].ToString();
forn.Cel = dt.Rows[0]["forn_cel"].ToString();
forn.Cep = dt.Rows[0]["forn_cep"].ToString();
forn.CidCod = dt.Rows[0]["cid_cod"].ToString();
forn.Cnpj = dt.Rows[0]["forn_cnpj"].ToString();
forn.Email = dt.Rows[0]["forn_email"].ToString();
forn.Fone = dt.Rows[0]["forn_fone"].ToString();
return forn;
}
public bool novo(Fornecedor forn)
{
sql = "INSERT INTO fornecedor(forn_cnpj, forn_razaosocial, forn_inscestadual, forn_bairro, " +
"forn_rua, forn_num, forn_cep, forn_email, forn_site, forn_fone, " +
"forn_cel, forn_representante, cid_cod) " +
"VALUES ('@1', '@2', '@3', '@4', '@5', " +
"'@6', '@7', '@8', '@9', '@A', '@B', '@C', '@D')";
sql = sql.Replace("@1", forn.Cnpj);
sql = sql.Replace("@2", forn.RazaoS);
sql = sql.Replace("@3", forn.InscEst);
sql = sql.Replace("@4", forn.Bairro);
sql = sql.Replace("@5", forn.Rua);
sql = sql.Replace("@6", forn.Num);
sql = sql.Replace("@7", forn.Cep);
sql = sql.Replace("@8", forn.Email);
sql = sql.Replace("@9", forn.Site);
sql = sql.Replace("@A", forn.Fone);
sql = sql.Replace("@B", forn.Cel);
sql = sql.Replace("@C", forn.Representante);
sql = sql.Replace("@D", forn.CidCod);
bco.conecta();
result = bco.executeNonQuery(sql);
bco.desconecta();
return result;
}
private void btnForn_Click(object sender, EventArgs e)
{
ttbForn.BackColor = Color.White;
frmFornGerenciar frmForn = new frmFornGerenciar(true);
frmForn.ShowDialog();
if (frmForn.isBuscaConcluida())
{
String fornId = frmForn.getForn();
forn = new Fornecedor();
forn.Id = fornId;
forn = forn.getById();
ttbForn.Text = forn.RazaoS;
}
}
